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
|
statement = connection.prepareStatement("UPDATE Versement SET Nom_projet=?,N°_loge=?,prix_loge=?,Verse_total=?,Nom=?,Prenom=? WHERE Nom=? ");
statement.setString(1, comboBox_2.getSelectedItem().toString());
statement.setString(2, n.getText());
statement.setString(3, textField.getText());
statement.setString(4, t1);
statement.setString(5, nom.getText());
statement.setString(6, prenom.getText());
statement.setString(7, comboBox.getSelectedItem().toString());
statement.executeUpdate();
statement.close();
statement = connection.prepareStatement("UPDATE Liste SET Nom_projet=? ,Type=?,Etage=?,Surface=?,N°_loge=?,Bloc=?,prix_loge=?,Verse_restant=?,Nom=?,Prenom=? WHERE Nom=? ");
statement.setString(1, comboBox_2.getSelectedItem().toString());
statement.setString(2, comboBox_3.getSelectedItem().toString());
statement.setString(3, comboBox_4.getSelectedItem().toString());
statement.setString(4, surf.getText());
statement.setString(5, n.getText());
statement.setString(6, idbloc.getText());
statement.setString(7, textField.getText());
statement.setString(8, t1);
statement.setString(9, nom.getText());
statement.setString(10, prenom.getText());
statement.setString(11, comboBox.getSelectedItem().toString());
statement.executeUpdate();
statement.close();
statement = connection.prepareStatement("UPDATE Client SET Nom_projet=? ,N°_loge=?, prix_loge=? ,Verse_restant=?,Nom=?,Prenom=? WHERE Nom=? ");
statement.setString(1, comboBox_2.getSelectedItem().toString());
statement.setString(2, n.getText());
statement.setString(3, textField.getText());
statement.setString(4, t1);
statement.setString(5, nom.getText());
statement.setString(6, prenom.getText());
statement.setString(7, comboBox.getSelectedItem().toString());
statement.executeUpdate();
JOptionPane.showMessageDialog(null, "Modifié avec succé");
statement.close(); |
Partager