1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| public static void requeteLibre(String requete) {
if(con == null)
getConnection();
String resultat = "";
try{
ResultSet rs = stmt.executeQuery(requete);
ResultSetMetaData rsmd = rs.getMetaData();
int nbCol = rsmd.getColumnCount();
if(rs.next()){
resultat += nbCol + " colonnes";
for(int i = 1; i <= nbCol; i++)
resultat += "\nNom de colonne: " + rsmd.getColumnName(i) + " | Type: " + rsmd.getColumnTypeName(i);
}else{
System.out.println(rs.getStatement().getUpdateCount() + " lignes modifiées");
}
System.out.println(resultat);
}catch(SQLException e){
System.err.println("SQLException: " + e.getMessage());
}
} |