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);
} |
Partager