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
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
| public class FenetrePers extends JFrame {
private JTextField rechNomField;
private JTextField rechPrenField;
private JTextField rechemailField;
private JTextField rechtelephField;
private JButton btnNewButton_2;
AjoutPers ajpers;
Connection cnx =null;
PreparedStatement prepared=null;
ResultSet resultat=null;
private JScrollPane scrollPane;
private JTable table;
private JButton editButton;
private JButton deleteButton;
public FenetrePers() {
cnx=ConnectionSql.ConnexionDB();
this.setExtendedState(this.MAXIMIZED_BOTH);
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
getContentPane().setLayout(null);
JLabel lblNewLabel = new JLabel(" Gestion du personnel");
lblNewLabel.setFont(new Font("Tahoma", Font.BOLD, 14));
lblNewLabel.setForeground(Color.BLACK);
lblNewLabel.setBounds(10, 23, 181, 21);
getContentPane().add(lblNewLabel);
rechNomField = new JTextField();
rechNomField.setBounds(27, 84, 175, 32);
getContentPane().add(rechNomField);
rechNomField.setColumns(10);
rechPrenField = new JTextField();
rechPrenField.setBounds(298, 84, 163, 32);
getContentPane().add(rechPrenField);
rechPrenField.setColumns(10);
rechemailField = new JTextField();
rechemailField.setBounds(587, 84, 163, 32);
getContentPane().add(rechemailField);
rechemailField.setColumns(10);
rechtelephField = new JTextField();
rechtelephField.setBounds(844, 84, 157, 32);
getContentPane().add(rechtelephField);
rechtelephField.setColumns(10);
JButton FindButton = new JButton("find");
FindButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
try {
UpdateTableSearch();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
});
FindButton.setBounds(1034, 89, 66, 27);
getContentPane().add(FindButton);
JButton btnNewButton_1 = new JButton("reset");
btnNewButton_1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
String nomS=rechNomField.getText().toString();
String prenomS=rechPrenField.getText().toString();
String emailS=rechemailField.getText().toString();
String telephS=rechtelephField.getText().toString();
if(!nomS.equals("")|| !prenomS.equals("")|| !emailS.equals("")||!telephS.equals("")) {
rechNomField.setText("");
rechPrenField.setText("");
rechemailField.setText("");
rechtelephField.setText("");
UpdateTable();
}}
});
btnNewButton_1.setBounds(1110, 89, 66, 27);
getContentPane().add(btnNewButton_1);
btnNewButton_2 = new JButton("Ajouter personnel");
btnNewButton_2.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
ajpers = new AjoutPers(FenetrePers.this);
UpdateTable();
}
});
btnNewButton_2.setBounds(1034, 24, 142, 32);
getContentPane().add(btnNewButton_2);
scrollPane = new JScrollPane();
scrollPane.setBounds(27, 150, 985, 308);
getContentPane().add(scrollPane);
table = new JTable();
table.addMouseListener(new MouseAdapter() {
@Override
public void mouseClicked(MouseEvent arg0) {
}
});
scrollPane.setViewportView(table); |
