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
| private void jTxtMatrFocusLost(){
PreparedStatement ps1,ps2;
Connection conn = Connect.ConnectDB();
try {
String SQL1 = "SELECT * FROM Signaletique where Matricule = ?";
affiche("hhh 1") ;
ps1 = conn.prepareStatement(SQL1);
ps1.setString(1,jTxtMatr.getText());
ResultSet rs1 = ps1.executeQuery();
String SQL2 = "SELECT * FROM Decisions where Matr = ?";
ps2 = conn.prepareStatement(SQL2);
ps2.setString(1,jTxtMatr.getText());
ResultSet rs2 = ps2.executeQuery();
affiche("Matr Sql2:"+jTxtMatr.getText()) ;
while ( rs1.next()) {
jTxtNomPrenom.setText(rs1.getString(3));
jTxtMatr2.setText(rs1.getString(3));
while ( rs2.next()) {
textArea2.setText(rs2.getString(3));
System.out.print("Last Name :"+rs1.getString(3) );
System.out.print( rs1.getString(4) );
System.out.print(" => "+rs2.getString(2));
System.out.print(" - "+rs2.getString(3));
System.out.print(" - "+rs2.getString(4));
System.out.print(" - "+rs2.getString(5));
System.out.print(" - "+rs2.getString(6));
System.out.print(" - "+rs2.getString(7));
System.out.print(" - "+rs2.getString(8));
System.out.print(" - "+rs2.getString(9));
System.out.print(" - "+rs2.getString(10));
System.out.print(" - "+rs2.getString(11));
System.out.print(" - "+rs2.getString(12));
System.out.print(" - "+rs2.getString(13));
System.out.print(" - "+rs2.getString(14));
System.out.println(" ");
ps.close();
}
}
}catch(SQLException e){
JOptionPane.showMessageDialog(null, e);
}
}
private void toggleButton1ActionPerformed(ActionEvent e) {
// TODO add your code here
jLabel3.setText("Matricule No ");
}
private void toggleButton2ActionPerformed(ActionEvent e) {
// TODO add your code here
jLabel3.setText("Stamnummer");
}
public final void FilljCboTypeAbsence() {
try{
String sql = "SELECT Type FROM Typedossier";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()){
jCboTypeAbsence.addItem(rs.getString("Type"));
}
} catch(SQLException e) {
JOptionPane.showMessageDialog(null, e);
}
} |
