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
| public void tableau_recap(){
recup_truc();
JFrame frame = new JFrame("Tableau Recapitulatif");
JPanel panel = new JPanel();
String data[][] = {{nom,date_d,etat_e,couverture_d,"65"}};
String col[] = {"Nom","Date","Semis","Couverture","Semé Semaine"};
JTable table = new JTable(data,col);
table.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
JTableHeader header = table.getTableHeader();
header.setBackground(Color.green);
JScrollPane pane = new JScrollPane(table);
panel.add(pane);
frame.add(panel);
frame.setBounds(150,150,0,0);
frame.setSize(500,470);
frame.setUndecorated(true);
frame.getRootPane().setWindowDecorationStyle(JRootPane.PLAIN_DIALOG);
frame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
frame.setVisible(true);
}
// TESTTTTTTTT/////////////////////////////////////////////////////////////////////////////////////////
public void recup_truc(){
try {
connection_mysql();
String SQL19 = "SELECT * FROM parcelle ";
ResultSet res5 = dbStatement.executeQuery(SQL19);
while (!res5.isLast())
{
res5.next();
nom = res5.getString("nom");
date_d = res5.getString("date");
etat_e = res5.getString("etat");
couverture_d = res5.getString("couverture");
System.out.println(nom);
System.out.println(date_d);
System.out.println(etat_e);
System.out.println(couverture_d);
}
dbConnect.close();
} catch (InstantiationException ex) {
Logger.getLogger(ParcelleEtu2V2.class.getName()).log(Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
Logger.getLogger(ParcelleEtu2V2.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(ParcelleEtu2V2.class.getName()).log(Level.SEVERE, null, ex);
} catch (ClassNotFoundException ex) {
Logger.getLogger(ParcelleEtu2V2.class.getName()).log(Level.SEVERE, null, ex);
} |
