| 12
 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