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
| 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; //date debut
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; //date fin
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);
}
String query1 = "select SUM (paiement) from Achat WHERE Achat.date between '" + (date) + "' and '" + (date1) + "'";
ResultSet rsltSet = null;
try {
rsltSet = stmt.executeQuery(query1);
rsltSetMeta = rsltSet.getMetaData();
} catch (SQLException ex) {
Logger.getLogger(Paiement.class.getName()).log(Level.SEVERE, null, ex);
}
try {
while (rsltSet.next()) {
System.out.println(" ffffffffff " + rsltSet.getMetaData().getColumnCount());
for (int i = 1; i <= rsltSetMeta.getColumnCount(); i++) {
System.out.println(" " + rsltSet.getObject(1).toString());
this.c.setText(rsltSet.getObject(1).toString()); //ecriture dans mon interface
}
}
} catch (SQLException ex) {
Logger.getLogger(Paiement.class.getName()).log(Level.SEVERE, null, ex);
}
c.setVisible(true);
c.setEditable(false);
da.setVisible(true); |
Partager