Code : Sélectionner tout - Visualiser dans une fenêtre à part
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 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((int)(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=? ) 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(); }
erreur: java.lang.String cannot be cast to java.lang.Integer dans la ligne : if((int)(comboBox_4.getSelectedItem())==2)
Partager