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
| private void EnregistrerClient() throws ClassNotFoundException {
boutonenregistrer=new JButton();
boutonenregistrer.addActionListener(this);
Connection conn = null;
PreparedStatement stmt = null;
String data ="jdbc:odbc:vraiconnexion";
Class.forName("org.postgresql.Driver");
System.out.println("DRIVER OK ! ");
String url = "jdbc:postgresql://localhost:5433/tabclient";
String user = "postgres";
String passwd = "anissa39";
try {
conn = DriverManager.getConnection(data);
stmt= conn.prepareStatement("INSERT INTO tebclients (ID,NOM,PRENOM,ADRESSE,TELEPHONE) VALUES (?,?,?,?,?)");
stmt.setString(1,saisieIdclient.getText());
stmt.setString(2,saisieNom.getText());
stmt.setString(3,saisiePrenom.getText());
stmt.setString(4,saisieAdresse.getText());
stmt.setString(5,saisieTelephone.getText());
stmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if( stmt != null ) {
stmt.close();
}
if( conn != null ) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
} |
Partager