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