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
| try {
SimpleDateFormat simple= new SimpleDateFormat("dd/MM/yyyy");
Date d1 ,d2 ;
String dateD = JOptionPane.showInputDialog(null, "Veuillez entrer la date début (mm/jj/aaaa) !", "Date début!",JOptionPane.QUESTION_MESSAGE);
if(!dateD.isEmpty()){
String dateF = JOptionPane.showInputDialog(null, "Veuillez entrer la date fin (mm/jj/aaaa) !", "Date fin!",JOptionPane.QUESTION_MESSAGE);
if(!dateF.isEmpty()){
d1 = simple.parse(dateD);
d2=simple.parse(dateF);
connect con=new connect();
System.out.println(dateD); System.out.println(dateF);
Statement stm=con.getStatement();
ResultSet resultc;
String[] titres = {"N°FACTURE","Date Facture","VALEUR DEV","FRNS","N°DOSSIER","observation","Categorier","Palette","Nombre de colis","Poids Brut","Poids Net","Montant"};
resultc = stm.executeQuery("SELECT Count(DETAIL_FACTURE_IMPORT.[N° FACTURE]) FROM FACTURE_IMPORT INNER JOIN DETAIL_FACTURE_IMPORT ON FACTURE_IMPORT.[N°FACTURE] = DETAIL_FACTURE_IMPORT.[N° FACTURE] WHERE (((FACTURE_IMPORT.[DTE FACTURE]) Between #"+simple.format(d1)+"# And #"+simple.format(d2)+"#));");
resultc.next();
int i=resultc.getInt(1);
System.out.println(i);
Object[][] data= new Object[i][12] ;
String Sql= "SELECT FACTURE_IMPORT.[N°FACTURE], FACTURE_IMPORT.[DTE FACTURE], FACTURE_IMPORT.[VALEUR DEV], FACTURE_IMPORT.FRNS, FACTURE_IMPORT.[N°DOSSIER], FACTURE_IMPORT.observation, DETAIL_FACTURE_IMPORT.CATEGORIE, DETAIL_FACTURE_IMPORT.Palette, DETAIL_FACTURE_IMPORT.Colis, DETAIL_FACTURE_IMPORT.[Poids Brut], DETAIL_FACTURE_IMPORT.[Poids Net], DETAIL_FACTURE_IMPORT.Montant " +
"FROM FACTURE_IMPORT INNER JOIN DETAIL_FACTURE_IMPORT ON FACTURE_IMPORT.[N°FACTURE] = DETAIL_FACTURE_IMPORT.[N° FACTURE] WHERE (((FACTURE_IMPORT.[DTE FACTURE]) Between #"+simple.format(d1)+"# And #"+simple.format(d2)+"#));";
ResultSet res=stm.executeQuery(Sql);
int j=0;
while(res.next()) {
data[j][0] = res.getString(1);
data[j][1] = res.getDate(2);
data[j][2] = res.getFloat(3);
data[j][3] = res.getString(4);
data[j][4] = res.getString(5);
data[j][5] = res.getString(6);
data[j][6] = res.getString(7);
data[j][7] = res.getInt(8);
data[j][8] = res.getInt(9);
data[j][9] = res.getFloat(10);
data[j][10] = res.getFloat(11);
data[j][11] = res.getFloat(12);
j++;
}
JTable table=new JTable(data,titres);
table.setPreferredScrollableViewportSize(new Dimension(1990, 990));
table.setFillsViewportHeight(true);
JScrollPane scroll=new JScrollPane(table);
JFrame f=new JFrame("Toutes les Factures Import");
f.add(scroll);
f.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
f.setSize(2000,1000);
f.setVisible(true);
}}
}catch(Exception ex){System.err.println(ex.getMessage());}
} |
JTable et connexion avec BD Access
Répondre avec citation
Partager