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
|
/******************BDD connection**********/
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url= "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:\\Travail_Perso\\01_Java\\Verifikator\\test.accdb";
try {
Connection connection = DriverManager.getConnection(url);
ResultSet resultats = null;
Statement stmt = null;
String requete = "SELECT [RegistreDeFiltres].[Nom_Filtre], [RegistreDeFiltres].[Filtre], [RegistreDeFiltres].[Programme], [RegistreDeFiltres].[Createur], [RegistreDeFiltres].[Date_De_Creation] FROM [RegistreDeFiltres]";
String n1 = "";
try {
stmt = connection.createStatement();
resultats = stmt.executeQuery(requete);
} catch (SQLException e) {
JOptionPane.showMessageDialog(frame, "erreur de requête");
}
while (resultats.next()) {
n1 = resultats.getString(1);
//unFiltre = new Filtre(nom_Filtre, leFiltre, programme, createur, dateDeCreation)
//collection_Filtre.add(unFiltre);
JOptionPane.showMessageDialog(frame, resultats.getString(1) + resultats.getString(2) + resultats.getString(3) + resultats.getString(4) + resultats.getString(5));
}
connection.close();
} catch (SQLException e) {
JOptionPane.showMessageDialog(frame, e.getMessage());
e.printStackTrace();
} |
Partager