FAQ JDBCConsultez toutes les FAQ

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
String sql = "..."; 
PreparedStatement statement = connection.prepareStatement(sql); 
ParameterMetaData metadata = statement.getParameterMetaData(); 
for(int i=0; i<metadata.getParameterCount(); i++){ 
   String classe = metadata.getParameterClassName(i);  
   int mode = metadata.getParameterMode(i); 
   String sMode = ""; 
   switch(mode){ 
     case ParameterMetaData.parameterModeIn: 
        sMode = "IN"; 
        break; 
     case ParameterMetaData.parameterModeOut: 
        sMode = "OUT"; 
        break;    
     case ParameterMetaData.parameterModeInOut: 
        sMode = "INOUT"; 
        break;    
     case ParameterMetaData.parameterModeUnknown: 
        sMode = "inconnu"; 
        break;    
     default : sMode = "bug!!!";break;    
   } 
   int type = metadata.getParameterType(i);  
   String sType = metadata.getParameterTypeName(i);  
   int precision = metadata.getPrecision(i);  
   int scale = metadata.getScale(i);  
   int nullable = metadata.isNullable(i);  
   String sNullable = ""; 
   switch(nullable){ 
     case ParameterMetaData.parameterNoNulls: 
        sNullable = "ne peux pas être NULL"; 
        break; 
     case ParameterMetaData.parameterNullable: 
        sNullable = "peux être NULL"; 
        break;    
     case ParameterMetaData.parameterNullableUnknown: 
        sNullable = "inconnu"; 
        break;    
     default : sNullable = "bug!!!";break;    
   } 
   boolean sign = metadata.isSigned(i); 
   System.out.println("INFORMATIONS SUR LE PARAMETRE D'INDEX "+i); 
   System.out.println("Classe java = "+classe); 
   System.out.println("Mode = "+mode+" : "+sMode); 
   System.out.println("Type dans java.sql.Types = "+type); 
   System.out.println("Nom du type = "+sType); 
   System.out.println("Précision = "+precision); 
   System.out.println("Scale = "+scale); 
   System.out.println("Nullable = "+nullable+" : "+sNullable); 
   System.out.println("Signé = "+sign); 
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
public static Connection createMysqlDatabase(Connection factice, String user,  
                                             String pass, String nomBase)  
                                             throws SQLException{ 
   Connection connection = null; 
   Statement statement = null; 
   try{ 
      statement = factice.createStatement(); 
      statement.execute("CREATE DATABASE "+nomBase); 
      String url = factice.getMetaData().getURL(); 
      url = url.substring(0,url.lastIndexOf("/")); 
      url += "/"+nomBase; 
      connection = DriverManager.getConnection(url,user,pass); 
   }catch(SQLException e){ 
      SQLException sqle = new SQLException("Création de la base impossible"); 
      sqle.setNextException(e); 
      throw sqle; 
   }finally{ 
      try{statement.close();}catch(Exception e){} 
   } 
   return connection; 
}

1
2
3
4
5
6
7
8
9
10
Class.forName("com.mysql.jdbc.Driver"); 
String url = "jdbc:mysql://host/baseLien"; 
String user = "user"; 
String pass = "password"; 
// on commence par se connecter à la base factice 
Connection factice = DriverManager.getConnection(url,user,pass); 
// on crée la base et on récupère une Connection 
Connection connection = createMysqlDatabase(factice,user,pass,"NouvelleBase"); 
// on peut finalement fermer notre Connection factice qui ne nous sert plus à rien 
factice.close();

jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=labase.mdb;

1
2
3
4
5
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
String url= "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:/temp/thebase.mdb"; 
String user = "user"; 
String pass = "pass"; 
Connection connection = DriverManager.getConnection(url,user,pass);