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
|
private JButton getJButton() {
if (jButton == null) {
jButton = new JButton();
jButton.setBounds(new Rectangle(56, 43, 112, 40));
jButton.setText("entrer");
jButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
try
{
//connecter la bdd
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url= "jdbc:odbc:ODBC1";
String user = "user";
String pass = "pass";
Connection connection = DriverManager.getConnection (url, user, pass);
Statement instruction = connection.createStatement();
String sql = " select * from GPM ";
ResultSet resultat = instruction.executeQuery(sql);
while (resultat.next()){
String nom = resultat.getString("nom");
String prenom= resultat.getString("prenom");
}
}
catch
(Exception ex) {
System.out.println("jjjjjjjjjjj "+ex.getMessage());
ex.printStackTrace() ;
}
}
});
}
return jButton; |
Partager