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 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
| String s,s1; String J,M,A,A1; String date,date1;
J=jj.getSelectedItem().toString();
M=mm.getSelectedItem().toString();
A=aa.getSelectedItem().toString();
String t[]=A.split("");
String aa;
aa=""+t[2]+""+t[3];
date=J+"/"+M+"/"+aa;
J=jj1.getSelectedItem().toString();
M=mm1.getSelectedItem().toString();
A1=aa1.getSelectedItem().toString();
String t2[]=A1.split("");
String aa1;
aa1=""+t2[2]+""+t2[3];
date1=J+"/"+M+"/"+aa1;
System.out.println("1 "+date+" 2 "+date1);
String url = "jdbc:h2:./src/BD/BDH22";
String login = "root";
String password = "";
Connection connection = null;
Statement stmt = null;
ResultSetMetaData rsltSetMeta = null;
try {
connection = DriverManager.getConnection(url,login,password);
} catch (SQLException ex) {
Logger.getLogger(Paiement.class.getName()).log(Level.SEVERE, null, ex);
}
System.out.println("c connecté pour ouvrir dossier");
try {
stmt = connection.createStatement();
} catch (SQLException ex) {
Logger.getLogger(Paiement.class.getName()).log(Level.SEVERE, null, ex);
JOptionPane.showMessageDialog(null, ex.getMessage());
}
String query1 = "select SUM (paiement) AS mon_total from Achat WHERE Achat.date between '"+( date )+"' and '"+( date1 )+"'";
System.out.println(query1 );
ResultSet rsltSet = null ;
try {
rsltSet = stmt.executeQuery(query1);
rsltSetMeta = rsltSet.getMetaData();
System.out.println("je ss ds le try");
} catch (SQLException ex) {
Logger.getLogger(Paiement.class.getName()).log(Level.SEVERE, null, ex);
JOptionPane.showMessageDialog(null, ex.getMessage());
}
try {
System.out.println("je ss ds le try de while");
if(rsltSet.next()) {
System.out.println(rsltSet.getObject(1).toString());
this.c.setText(rsltSet.getObject(1).toString()); }
else{
this.c.setText("0 DA");
}
} catch (SQLException ex) {
Logger.getLogger(Paiement.class.getName()).log(Level.SEVERE, null, ex);
}
c.setVisible(true);
c.setEditable(false);
da.setVisible(true); |
Partager