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 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82
|
try {
Connection laConnection = DriverManager.getConnection("jdbc:mysql://10.8.0.1:3306/gvi_test","sullivan","sullivan");
Statement transmission = laConnection.createStatement();
ResultSet leResultat = transmission.executeQuery("select nom, prenom, adr_courriel, num_tel from conseillers" );
final DefaultTableModel model = new DefaultTableModel();
model.addColumn("Nom");
model.addColumn("Prenom");
model.addColumn("Email");
model.addColumn("N°tel");
model.addColumn("Lancé?");
while(leResultat.next()){
model.addRow(new Object[]{
leResultat.getObject("nom"),
leResultat.getObject("prenom"),
leResultat.getObject("adr_courriel"),
leResultat.getObject("num_tel"),
});
}
final JTable table = new JTable( model );
table.moveColumn(4, 0);
table.getColumn("Lancé?").setCellRenderer(new MonTableCellRenderer());
final JScrollPane pane = new JScrollPane(table);
getContentPane().add(pane);
javax.swing.Timer t = new javax.swing.Timer(1000, new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
Connection laConnection = DriverManager.getConnection("jdbc:mysql://10.8.0.1:3306/gvi_test","sullivan","sullivan");
Statement transmission = laConnection.createStatement();
ResultSet leResultat = transmission.executeQuery("select nom, prenom, adr_courriel, num_tel from conseillers" );
model.fireTableDataChanged();
table.setModel(model);
table.updateUI();
table.revalidate();
table.repaint();
System.out.println(table.getValueAt(0, 2));
}
catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
});
t.start();
//t.stop();
}
catch (SQLException e) {
e.printStackTrace();
}
} |
Partager