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
| private void listeReservationActionPerformed(ActionEvent evt) {
try {
Statement stmt = Connexion.getStatement();
ResultSet reservation = stmt.executeQuery("SELECT ... FROM ... ;");
String col[] = {"Date de début", ...};
String cont[][];
cont = new String[50][8];
int i = 0;
while (reservation.next()) {
String dateDeb = reservation.getString("dateDebut");
...
cont[i][0] = dateDeb;
cont[i][1] = dateFin;
...
i++;
}
DefaultTableModel model = new DefaultTableModel(cont, col);
JTable table = new JTable(model);
(table.getColumnModel().getColumn(0)).setPreferredWidth(140);// largeur des colonnes
(table.getColumnModel().getColumn(1)).setPreferredWidth(140);
(table.getColumnModel().getColumn(2)).setPreferredWidth(140);
(table.getColumnModel().getColumn(3)).setPreferredWidth(140);
(table.getColumnModel().getColumn(4)).setPreferredWidth(140);
(table.getColumnModel().getColumn(5)).setPreferredWidth(120);
(table.getColumnModel().getColumn(6)).setPreferredWidth(120);
(table.getColumnModel().getColumn(7)).setPreferredWidth(180);
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);// pour le scroll horizontal
table.setShowGrid(true);
table.setShowVerticalLines(true);
JScrollPane pane = new JScrollPane(table);
panelListeReservation.add(pane);
panelAjoutModMachine.setVisible(false);
this.add(panelListeReservation);
this.setVisible(true);
} catch (SQLException ex) {
}
} |
Partager