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
| try {
DefaultTableModel model=(DefaultTableModel)jTable1.getModel();
model.setRowCount(0);
SimpleDateFormat f=new SimpleDateFormat("dd/MM/yyyy");//pour definer le format
String datecl=f.format( spinner.getValue());//
Connection cn=class_connexion.connectdb();
Statement st=cn.createStatement();
String t[]= new String[5];
ResultSet rs=st.executeQuery("select * from Client where date='"+datecl+"' ");
while (rs.next()) {
SimpleDateFormat ff=new SimpleDateFormat("dd/MM/yyyy");
Date dd=(rs.getDate("daterep"));
String d=ff.format(dd);
System.out.print(d);
for(int i=0;i<t.lenght();i++{
t[i]=rs.getString(i+1);
}
model.addRow(t);
}
jTable1.setModel(model);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e.getMessage());
} |
Partager