Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- public class BDDconnect {
- public static void main(String[] args)throws Exception {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- System.out.println("Pilote chargé");
- System.out.println();
- String url = "jdbc:oracle:thin:mvanzal/The619619@oracle.iut-orsay.fr:1521:etudom";
- Connection maConnexion = DriverManager.getConnection(url);
- Statement monInstruction = maConnexion.createStatement();
- ResultSet monResultat = monInstruction
- .executeQuery("SELECT numFilm, titre FROM ENS2004.Film WHERE rownum<=10");
- // 1
- System.out.println("Question 1");
- System.out.println();
- String T;
- int nF;
- while (monResultat.next()) {
- nF = monResultat.getInt("numFilm");
- T = monResultat.getString("titre");
- System.out.println(nF + "\t" + T);
- }
- System.out.println();
- // 2
- System.out.println("Question 2");
- System.out.println();
- ResultSetMetaData metadata = monResultat.getMetaData();
- for (int i = 0; i < metadata.getColumnCount(); i++) {
- int index = i + 1;
- int typeSQL = metadata.getColumnType(index);
- String nomTypeSQL = metadata.getColumnTypeName(index);
- String typeJava = metadata.getColumnClassName(index);
- System.out.println("INFORMATIONS SUR LA COLONNE D'INDEX " + index);
- System.out.println("Type SQL dans java.sql.Types : " + typeSQL);
- System.out.println("Nom du type SQL : " + nomTypeSQL);
- System.out.println("Classe java correspondante : " + typeJava);
- }
- System.out.println();
- // 3
- System.out.println("Question 3");
- System.out.println();
- PreparedStatement nbrFilms = maConnexion.prepareStatement("SELECT COUNT(*) FROM ENS2004.FILMS WHERE realisateur = ?");
- System.out.format("%-11s\t%-8s\n","NumIndividu","COUNT(*)");
- System.out.format("%-11s\t%-8s\n","-----------","--------");
- // 6
- System.out.println("Question 6");
- System.out.println();
- String nomTable = "ENS2004.Exemplaire";
- ResultSet monResultat2 = monInstruction.executeQuery("SELECT * FROM " + nomTable);
- ResultSetMetaData metadata2 = monResultat2.getMetaData();
- System.out.println("Index" + "\t" + "Name" + "\t\t" + "Null" + "\t\t" + "Type");
- System.out.println("-----" + "\t" + "-------------" + "\t" + "--------" + "\t" + "------------");
- for (int i = 0; i < metadata.getColumnCount(); i++) {
- int index = i + 1;
- int typeSQL = metadata.getColumnType(index);
- String nomCol = metadata.getColumnName(index);
- String nomTypeSQL = metadata.getColumnTypeName(index);
- int isNull = metadata.isNullable(index);
- String txtNull = "";
- if(isNull == 0)
- txtNull = "NOT NULL";
- //System.out.println(index + "\t" + nomTypeSQL + "\t\t" + txtNull + "\t\t" + typeSQL);
- String type = nomTypeSQL + "(" + typeSQL + ")";
- System.out.format("%-5d\t%-13s\t%-8s\t%-12s\n", index, nomCol, txtNull, type);
- }
- System.out.println();
- maConnexion.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement