incompatibilité entre String et int
Code:
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)