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 44 45 46 47 48 49 50 51 52 53 54
|
statement=connection.prepareStatement("SELECT prix_loge FROM Liste WHERE Nom=? AND Prenom=?");
statement.setString(1, comboBox_1.getSelectedItem().toString());
statement.setString(2, comboBox_2.getSelectedItem().toString());
ResultSet rs=statement.executeQuery();
prix.setText(rs.getString("prix_loge"));
prix.getText();
statement.close();
statement=connection.prepareStatement("SELECT Verse_total FROM Versement WHERE Nom=? AND Prenom=?");
statement.setString(1, comboBox_1.getSelectedItem().toString());
statement.setString(2, comboBox_2.getSelectedItem().toString());
ResultSet rs1=statement.executeQuery();
somme.setText(rs1.getString("Verse_total"));
somme.getText();
statement.close();
DecimalFormatSymbols symbols = new DecimalFormatSymbols(Locale.getDefault());
symbols.setGroupingSeparator('.');//simple space
DecimalFormat df = new DecimalFormat("#,###.00", symbols);
double one = df.parse(prix.getText()).doubleValue();
double two= df.parse(somme.getText()).doubleValue();
double tree =df.parse(verse.getText()).doubleValue();
double r=two+tree;
String r1= String.valueOf(r);
BigDecimal r2=new BigDecimal(r1);
String str = df.format(r2);
String t=str.replace(",", ",").replaceAll(" ", " ");
double r11= one-(two+tree);
String r22= String.valueOf(r11);
BigDecimal r21=new BigDecimal(r22);
String str1 = df.format(r21);
String t1=str1.replace(",", ",").replaceAll(" ", " ");
statement = connection.prepareStatement("INSERT INTO Versement ( Nom , Prenom, Date , Somme_versee,Prix_loge, Nom_projet, Verse_total, Verse_restant,id_verse) VALUES(?,?,?,'"+verse.getText()+"','" + prix.getText() +"', (SELECT Nom_projet From Client WHERE Nom= ? AND Prenom= ?), (?) , (?),?) ");
statement.setString(1, comboBox_1.getSelectedItem().toString());
statement.setString(2, comboBox_2.getSelectedItem().toString());
statement.setString(3, date.getText());
statement.setString(4, comboBox_1.getSelectedItem().toString());
statement.setString(5, comboBox_2.getSelectedItem().toString());
statement.setString(6, t);
statement.setString(7, t1);
statement.setString(8, comboBox_4.getSelectedItem().toString());
statement.executeUpdate(); |
Partager