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
|
statement= connection.prepareStatement("DELETE FROM Versement WHERE Nom=?AND Prenom=?AND Date=? AND Somme_versee=? AND id_verse=?" );
statement.setString(1,(String) comboBox_1.getSelectedItem() );
statement.setString(2, comboBox_2.getSelectedItem().toString());
statement.setString(3, date.getText());
statement.setString(4, verse.getText());
statement.setString(5,(comboBox_4.getSelectedItem().toString()));
statement.executeUpdate();
if(Integer.valueOf((String) comboBox_4.getSelectedItem()) == (2) ) {
statement= connection.prepareStatement(" UPDATE Client SET Verse_restant=(SELECT (Prix_du_loge - SUM(Somme_versee)) FROM Versement WHERE Nom=? AND Prenom=?), Verse_total=(SELECT (SUM(Somme_versee)) FROM Versement WHERE Nom=? AND Prenom=? ) , Verse_2=0 WHERE Nom=? AND Prenom=?");
statement.setString(1,(String) comboBox_1.getSelectedItem() );
statement.setString(2, comboBox_2.getSelectedItem().toString());
statement.setString(3,(String) comboBox_1.getSelectedItem() );
statement.setString(4, comboBox_2.getSelectedItem().toString());
statement.setString(5,(String) comboBox_1.getSelectedItem() );
statement.setString(6, comboBox_2.getSelectedItem().toString());
statement.executeUpdate();
JOptionPane.showMessageDialog(null, " Versement Annulé ");
statement.close();
statement.close();
statement.close();
statement.close();
}
if(Integer.valueOf((String) comboBox_4.getSelectedItem()) == (3) ) {
statement= connection.prepareStatement(" UPDATE Client SET Verse_restant=(SELECT (Prix_du_loge - SUM(Somme_versee)) FROM Versement WHERE Nom=? AND Prenom=?), Verse_total=(SELECT (SUM(Somme_versee)) FROM Versement WHERE Nom=? AND Prenom=? ) , Verse_3=0 WHERE Nom=? AND Prenom=?");
statement.setString(1,(String) comboBox_1.getSelectedItem() );
statement.setString(2, comboBox_2.getSelectedItem().toString());
statement.setString(3,(String) comboBox_1.getSelectedItem() );
statement.setString(4, comboBox_2.getSelectedItem().toString());
statement.setString(5,(String) comboBox_1.getSelectedItem() );
statement.setString(6, comboBox_2.getSelectedItem().toString());
statement.executeUpdate();
JOptionPane.showMessageDialog(null, " Versement Annulé ");
statement.close();
statement.close();
statement.close();
statement.close();
} |
Partager