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 40 41 42 43
| private void jTextField3ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
adr=jTextField3.getText();
}
private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {
nom=jTextFiled1.getText();
}
//pareil pr le reste des JTextFiled
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
//bouton valider
Acceuil a=new Acceuil();
this.setVisible(false);
a.setVisible(true);
Client c=new Client(num,nm,prn,adr,num,pc,sx,am,ic,nf);
try {
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost:5432/Hotel";
String user = "postgres";
String passwd = "*****";
Connection conn = DriverManager.getConnection(url, user,
passwd);
String queryz = c._insert();
int r = 0;
Statement stmt=null;
try{
stmt = conn.createStatement();
r = stmt.executeUpdate(queryz);
}
catch(Exception e){
// JOptionPane.showMessageDialog(null,"exception due a la requete");
}
//Création d'un objet Statement pr laffichage
Statement state = conn.createStatement();
//L'objet ResultSet contient le résultat de la requête SQL
ResultSet result = state.executeQuery("SELECT * FROM clnt"); |