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
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
|
import javax.swing.*;
import java.awt.*;
import java.sql.*;
import java.awt.event.*;
public class App extends JFrame{
private JPanel ButtonPanel;
private JPanel TitrePanel;
private JPanel ResultPanel;
private JPanel RechPanel;
private JPanel BodyPanel;
private JLabel RechTitre = new JLabel("Recherche");
private JLabel ResultLabel= new JLabel("Resultat");
private JLabel RechLabel= new JLabel("Vous Cherchez :");
private JLabel GSMLabel= new JLabel("GSM");
private JLabel LigneLabel= new JLabel("Ligne");
private JLabel NomLabel= new JLabel("Nom");
private JLabel PosteLabel= new JLabel("Poste");
private JLabel PrenomLabel= new JLabel("Prenom");
private JLabel ServiceLabel= new JLabel("Service");
private JLabel TitleLabel= new JLabel("Centre Hospitalier Universitaire Ibn Rochd");
private JComboBox ChoixBox;
private JButton NextButton;
private JButton ValiderRech;
private JButton BeforeButton;
private JTextField GSMField;
private JTextField LigneField;
private JTextField PosteField;
private JTextField PrenomField;
private JTextField NomField;
private JTextField RechField;
private JTextField ServiceField;
private JSeparator jSeparator1;
public App(){
this.setTitle("Centre Hospitalier Universitaire Ibn Rochd");
this.setSize(500, 300);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setLocationRelativeTo(null);
this.setLayout(new BorderLayout());
this.getContentPane().add(TitrePanel,BorderLayout.NORTH);
this.getContentPane().add(BodyPanel, BorderLayout.CENTER);
// BodyPanel.add(RechPanel,BorderLayout.NORTH);
// BodyPanel.add(ResultPanel,BorderLayout.SOUTH);
this.getContentPane().add(ButtonPanel,BorderLayout.SOUTH);
this.setVisible(true);
ValiderRech.setText("Valider");
NextButton.setText("Suivant");
BeforeButton.setText("Précédent");
ChoixBox.setModel(new DefaultComboBoxModel(new String[] { "Nom", "Service", "Poste", "GSM" }));
add(TitrePanel,BorderLayout.NORTH);
add(BodyPanel, BorderLayout.CENTER);
BodyPanel.add(RechPanel,BorderLayout.NORTH);
BodyPanel.add(ResultPanel,BorderLayout.SOUTH);
add(ButtonPanel,BorderLayout.SOUTH);
TitrePanel.add(TitleLabel);
TitrePanel.setBackground(new Color(255, 255, 255));
TitleLabel.setHorizontalAlignment(SwingConstants.CENTER);
RechPanel.add(RechTitre);
RechPanel.add(RechLabel);
RechPanel.add(RechField);
RechPanel.add(ChoixBox);
RechPanel.add(ValiderRech);
RechPanel.add(jSeparator1);
RechTitre.setHorizontalAlignment(SwingConstants.CENTER);
ResultPanel.add(ResultLabel);
ResultPanel.add(NomLabel);
ResultPanel.add(NomField);
ResultPanel.add(PrenomLabel);
ResultPanel.add(PrenomField);
ResultPanel.add(ServiceLabel);
ResultPanel.add(ServiceField);
ResultPanel.add(PosteLabel);
ResultPanel.add(PosteField);
ResultPanel.add(LigneLabel);
ResultPanel.add(LigneField);
ResultPanel.add(GSMLabel);
ResultPanel.add(GSMField);
ResultLabel.setHorizontalAlignment(SwingConstants.CENTER);
ButtonPanel.add(NextButton);
ButtonPanel.add(BeforeButton);
ChoixBox.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
ChoixBoxActionPerformed(evt);
}
});
ValiderRech.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
ChoixBoxActionPerformed(evt);
}
});
NextButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
ChoixBoxActionPerformed(evt);
}
});
BeforeButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
ChoixBoxActionPerformed(evt);
}
});
}
private void ChoixBoxActionPerformed(ActionEvent evt) {
}
private void ValiderRechActionPerformed (ActionEvent evt)
{
String choix = String.valueOf(ChoixBox.getSelectedItem());
String Rech = RechField.getText();
String query;
if (choix.equals("Nom"))
{
query = " Select * from Personnel where Nom = upper("+Rech+")/";
// requete
}
else if (choix.equals("Service"))
{
// requete
query = " Select * from Personnel where idService = ( select Idser from Services where NomSer = upper("+Rech+")/";
}
else if (choix.equals("Poste"))
{
//requete
query = " Select * from Personnel where poste = "+Rech+"/";
}
else if (choix.equals("Ligne"))
{
//requete
query = " Select * from Personnel where Ligne = "+Rech+"/";
}
else
{
// requete
query = " Select * from Personnel where GSM = "+Rech+"/";
}
}
private void NextButtonActionPerformed(ActionEvent evt)
{
}
private void BeforeButtonActionPerformed(ActionEvent evt)
{
}
public static void main(String[] args) {
App Fenetre = new App();
}
} |
Erreur at java.awt.Container.addImpl(Unknown Source)
Répondre avec citation
Partager