FAQ JDBCConsultez toutes les FAQ

1
2
3
4
5
6
7
8
9
10
11
12
Connection connection = DriverManager.getConnection(url,user,password); 
  
//on récupère les métadonnées à partir de la connexion 
DatabaseMetaData dmd = connection.getMetaData(); 
  
//récupération des informations 
String nomBase = dmd.getDatabaseProductName(); 
String versionBase = dmd.getDatabaseProductVersion(); 
  
//affichage des informations 
System.out.println("Nom de la base = "+nomBase); 
System.out.println("Version de la base = "+versionBase);

1
2
3
4
5
6
7
8
9
10
11
12
Connection connection = DriverManager.getConnection(url,user,password); 
//on récupère les métadonnées à partir de Connection 
DatabaseMetaData dmd = connection.getMetaData(); 
//récupération des informations 
String catalogTerm = dmd.getCatalogTerm(); 
ResultSet resultat = dmd.getCatalogs(); 
//affichage des informations 
System.out.println("Terme du SGBD pour catalogue = "+catalogTerm); 
while(resultat.next()){ 
   String nomCatalog = resultat.getString("TABLE_CAT"); 
   System.out.println(catalogTerm+" "+resultat.getRow()+ " = "+nomCatalog); 
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
public void getInformationsSQL(Connection connection) throws SQLException{ 
   DatabaseMetaData dmd = connection.getMetaData(); 
   System.out.println("Supporte la norme ANSI92 (niveau d'entrée) = " 
                               +dmd.supportsANSI92EntryLevelSQL()); 
   System.out.println("Supporte la norme ANSI92 (niveau intermédiaire) = " 
                               +dmd.supportsANSI92IntermediateSQL()); 
   System.out.println("Supporte complètement la norme ANSI92 = " 
                               +dmd.supportsANSI92FullSQL()); 
   System.out.println("Supporte la grammaire SQL ODBC minimum = " 
                               +dmd.supportsMinimumSQLGrammar()); 
   System.out.println("Supporte la grammaire SQL ODBC = " 
                               +dmd.supportsCoreSQLGrammar()); 
   System.out.println("Supporte la grammaire SQL ODBC étendue = " 
                               +dmd.supportsExtendedSQLGrammar()); 
   System.out.println("Supporte GROUP BY = " 
                               +dmd.supportsGroupBy()); 
   System.out.println("Supporte SELECT FOR UPDATE = " 
                               +dmd.supportsSelectForUpdate()); 
}

1
2
3
4
5
6
7
8
9
10
11
Connection connection = DriverManager.getConnection(url,user,password); 
DatabaseMetaData dmd = connection.getMetaData(); 
ResultSet types = dmd.getTypeInfo(); 
while(types.next()){ 
   System.out.println("###################################"); 
   for(int i=0; i<types.getMetaData().getColumnCount();i++){ 
      String nomColonne = types.getMetaData().getColumnName(i+1); 
      Object valeurColonne = types.getObject(i+1); 
      System.out.println(nomColonne+" = "+valeurColonne); 
   } 
}

1
2
3
4
5
6
7
Connection connection = DriverManager.getConnection(url,user,password); 
DatabaseMetaData dmd = connection.getMetaData(); 
ResultSet types = dmd.getTypeInfo(); 
while(types.next()){ 
   String nomType = types.getString("TYPE_NAME"); 
   System.out.print(nomType+" "); 
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
public static String[] getMotsNonStandard(Connection connection) throws SQLException{ 
   DatabaseMetaData dmd = connection.getMetaData(); 
   return dmd.getSQLKeywords().split(","); 
} 
public static void main(String[] args){ 
   try{ 
      String driver = args[0]; 
      Class.forName(driver); 
      String url = args[1]; 
      String user = args[2]; 
      String password = args[3]; 
      Connection connection = DriverManager.getConnection(url,user,password); 
      String[] mots = getMotsNonStandard(connection); 
      for(int i=0;i<mots.length;i++){ 
          System.out.println(mots[i]); 
      } 
   }catch(SQLException sqle){ 
      //... 
   }catch(Exception e){ 
      //... 
   } 
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
AUTO_INCREMENT 
BINARY 
BLOB 
ENUM 
INFILE 
LOAD 
MEDIUMINT 
OPTION 
OUTFILE 
REPLACE 
SET 
TEXT 
UNSIGNED 
ZEROFILL

1
2
3
4
5
6
7
8
9
10
11
12
13
public static ArrayList getAllFunctions(Connection connection) throws SQLException{ 
   ArrayList liste = new ArrayList(); 
   DatabaseMetaData dmd = connection.getMetaData(); 
   String[] tab = dmd.getStringFunctions().split(","); 
   liste.addAll(Arrays.asList(tab)); 
   tab = dmd.getNumericFunctions().split(","); 
   liste.addAll(Arrays.asList(tab)); 
   tab = dmd.getSystemFunctions().split(","); 
   liste.addAll(Arrays.asList(tab)); 
   tab = dmd.getTimeDateFunctions().split(","); 
   liste.addAll(Arrays.asList(tab)); 
   return liste; 
}

1
2
3
4
5
Connection connection = DriverManager.getConnection(url,user,password); 
ArrayList liste = getAllFunctions(connection); 
for(Iterator it = liste.iterator();it.hasNext();){ 
   System.out.println(it.next()); 
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Connection connection = DriverManager.getConnection(url,user,password); 
DatabaseMetaData dmd = connection.getMetaData(); 
ResultSet procedures = dmd.getProcedures(connection.getCatalog(),null,"%"); 
while(procedures.next()){ 
   System.out.println("######################################"); 
   String nom = procedures.getString("PROCEDURE_NAME"); 
   int type = procedures.getInt("PROCEDURE_TYPE"); 
   String sType = ""; 
   switch(type){ 
      case DatabaseMetaData.procedureResultUnknown : 
         sType = "peux renvoyer un résultat"; 
         break; 
      case DatabaseMetaData.procedureNoResult : 
          sType = "ne renvoie pas de résultat"; 
          break; 
      case DatabaseMetaData.procedureReturnsResult : 
          sType = "retourne obligatoirement un résultat"; 
          break; 
      default : sType = "type inconnu";break; 
   } 
   System.out.println("Nom ("+dmd.getProcedureTerm()+") = "+nom); 
   System.out.println("Type = "+sType); 
}

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
public static void main(String[] args){ 
   try{ 
      Class.forName("nom.du.Driver").newInstance(); 
      String url = "jdbc:..."; 
      String user = "user"; 
      String password = "pass"; 
      Connection connection = DriverManager.getConnection(url,user,password); 
      //recherche d'informations sur tous les paramètres de la procèdure "hello" 
      getInformations(connection, "hello"); 
   }catch(SQLException sqle){ 
      //etc. 
   } 
} 
public static void getInformations(Connection connection, String nomProcedure) throws SQLException{ 
DatabaseMetaData dmd = connection.getMetaData(); 
ResultSet infos = dmd.getProcedureColumns(connection.getCatalog(), 
                              null,nomProcedure,"%"); 
    while(infos.next()){ 
       System.out.println("##############"); 
       System.out.println("Nom parametre = "+infos.getString("COLUMN_NAME")); 
       System.out.println("Type paramètre = "+getType(infos.getInt("COLUMN_TYPE"))); 
       System.out.println("Type SQL = "+infos.getString("TYPE_NAME")); 
    } 
infos.close(); 
} 
public static String getType(int type){ 
   String sType = ""; 
   switch(type){ 
      case DatabaseMetaData.procedureColumnUnknown : 
         sType = "inconnu"; 
         break; 
      case DatabaseMetaData.procedureColumnIn : 
         sType = "IN"; 
         break;  
      case DatabaseMetaData.procedureColumnInOut : 
         sType = "INOUT"; 
         break; 
      case DatabaseMetaData.procedureColumnOut : 
         sType = "OUT"; 
         break; 
      case DatabaseMetaData.procedureColumnReturn : 
         sType = "valeur de retour"; 
         break; 
      case DatabaseMetaData.procedureColumnResult : 
         sType = "résultat de la requête"; 
         break; 
      default : sType = "";break;  
   } 
   return sType; 
}

1
2
3
4
5
6
7
8
9
10
11
12
public static void getMaximumsDonnees(Connection connection) throws SQLException{ 
   DatabaseMetaData dmd = connection.getMetaData(); 
   System.out.println("Maximum de colonnes dans une table = " 
                               +dmd.getMaxColumnsInTable()); 
   System.out.println("Taille max. d'un index = " 
                               +dmd.getMaxIndexLength()); 
   System.out.println("Taille max. d'une ligne = " 
                               +dmd.getMaxRowSize()+ 
                               " (blobs inclus = "+dmd.doesMaxRowSizeIncludeBlobs()+")"); 
   System.out.println("Taille max. d'une chaîne de caractères = " 
                               +dmd.getMaxCharLiteralLength()); 
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Connection connection = DriverManager.getConnection(url,user,password); 
  
//on récupère les métadonnées à partir de la connexion 
DatabaseMetaData dmd = connection.getMetaData(); 
  
//récupération des informations 
String nomDriver = dmd.getDriverName(); 
String versionDriver = dmd.getDriverVersion(); 
String vMajeureJDBC = dmd.getJDBCMajorVersion(); 
String vMineureJDBC = dmd.getJDBCMinorVersion(); 
  
//affichage des informations 
System.out.println("Nom du driver utilisé = "+nomDriver); 
System.out.println("Version du driver = "+versionDriver); 
System.out.println("Version JDBC supportée par le driver = "+vMajeureJDBC+"."+vMineureJDBC);