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 83 84 85
| package fenetre;
import MPJ.MyConnexion;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
/**
*
* @author Tarek
*/
public class Consultation extends javax.swing.JFrame {
TableModel ft;
MyConnexion c = new MyConnexion();
Connection cn = c.getConnection();
/** Creates new form Consultation */
public Consultation() throws ClassNotFoundException, Exception {
initComponents();
getEnseignants();
}
public void getEnseignants() {
try {
ResultSet rs = c.getResultat("select * from enseignant");
int j = 1;
while (rs.next()) {
j++;
}
Object vals[][] = new Object[j][5];
rs = c.getResultat("select * from enseignant");
int i = 0;
while (rs.next()) {
vals[i][0] = rs.getString(1);
vals[i][1] = rs.getString(2);
vals[i][2] = rs.getString(3);
vals[i][3] = rs.getString(4);
vals[i][4] = rs.getString(5);
i++;
}
String[] head = new String[]{"Nom", "Prenom", "Date de Naissance", "Années Expérience", "Certification"};
ft = new DefaultTableModel(vals, head);
jTable1.setModel(ft);
} catch (Exception ex) {
Logger.getLogger(Consultation.class.getName()).log(Level.SEVERE, null, ex);
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
try {
new Consultation().setVisible(true);
} catch (ClassNotFoundException ex) {
Logger.getLogger(Consultation.class.getName()).log(Level.SEVERE, null, ex);
} catch (Exception ex) {
Logger.getLogger(Consultation.class.getName()).log(Level.SEVERE, null, ex);
}
}
});
}
// Variables declaration - do not modify
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
// End of variables declaration
} |
Partager