S37W0Heh

1package packagecx;
2
3import java.sql.*;
4
5public class Langas extends javax.swing.JFrame {
6    
7    public Langas() {
8        initComponents();
9    }
10
11    /**
12     * This method is called from within the constructor to initialize the form.
13     * WARNING: Do NOT modify this code. The content of this method is always
14     * regenerated by the Form Editor.
15     */
16    @SuppressWarnings("unchecked")
17    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
18    private void initComponents() {
19
20        jTabbedPane1 = new javax.swing.JTabbedPane();
21        jPanel1 = new javax.swing.JPanel();
22        jPasswordField1 = new javax.swing.JPasswordField();
23        jLabel1 = new javax.swing.JLabel();
24        jLabel2 = new javax.swing.JLabel();
25        jTextField1 = new javax.swing.JTextField();
26        jLabel3 = new javax.swing.JLabel();
27        jTextField2 = new javax.swing.JTextField();
28        jButton1 = new javax.swing.JButton();
29        jButton2 = new javax.swing.JButton();
30        jLabel4 = new javax.swing.JLabel();
31        jButton3 = new javax.swing.JButton();
32        jTabbedPane2 = new javax.swing.JTabbedPane();
33        jPanel10 = new javax.swing.JPanel();
34        jLabel47 = new javax.swing.JLabel();
35        jTextField43 = new javax.swing.JTextField();
36        jTextField44 = new javax.swing.JTextField();
37        jTextField45 = new javax.swing.JTextField();
38        jLabel48 = new javax.swing.JLabel();
39        jLabel49 = new javax.swing.JLabel();
40        jLabel50 = new javax.swing.JLabel();
41        jButton21 = new javax.swing.JButton();
42        jTextField46 = new javax.swing.JTextField();
43        jLabel51 = new javax.swing.JLabel();
44        jLabel52 = new javax.swing.JLabel();
45        jTextField47 = new javax.swing.JTextField();
46        jTextField48 = new javax.swing.JTextField();
47        jPanel7 = new javax.swing.JPanel();
48        jLabel31 = new javax.swing.JLabel();
49        jLabel32 = new javax.swing.JLabel();
50        jLabel33 = new javax.swing.JLabel();
51        jLabel34 = new javax.swing.JLabel();
52        jLabel35 = new javax.swing.JLabel();
53        jTextField27 = new javax.swing.JTextField();
54        jTextField28 = new javax.swing.JTextField();
55        jTextField29 = new javax.swing.JTextField();
56        jTextField30 = new javax.swing.JTextField();
57        jTextField31 = new javax.swing.JTextField();
58        jButton15 = new javax.swing.JButton();
59        jPanel8 = new javax.swing.JPanel();
60        jLabel36 = new javax.swing.JLabel();
61        jLabel37 = new javax.swing.JLabel();
62        jLabel38 = new javax.swing.JLabel();
63        jLabel39 = new javax.swing.JLabel();
64        jLabel40 = new javax.swing.JLabel();
65        jTextField32 = new javax.swing.JTextField();
66        jTextField33 = new javax.swing.JTextField();
67        jTextField34 = new javax.swing.JTextField();
68        jTextField35 = new javax.swing.JTextField();
69        jTextField36 = new javax.swing.JTextField();
70        jButton17 = new javax.swing.JButton();
71        jPanel9 = new javax.swing.JPanel();
72        jLabel41 = new javax.swing.JLabel();
73        jLabel42 = new javax.swing.JLabel();
74        jLabel43 = new javax.swing.JLabel();
75        jTextField37 = new javax.swing.JTextField();
76        jTextField38 = new javax.swing.JTextField();
77        jTextField39 = new javax.swing.JTextField();
78        jLabel44 = new javax.swing.JLabel();
79        jLabel45 = new javax.swing.JLabel();
80        jLabel46 = new javax.swing.JLabel();
81        jTextField40 = new javax.swing.JTextField();
82        jTextField41 = new javax.swing.JTextField();
83        jTextField42 = new javax.swing.JTextField();
84        jButton19 = new javax.swing.JButton();
85        jTabbedPane3 = new javax.swing.JTabbedPane();
86        jPanel11 = new javax.swing.JPanel();
87        jLabel53 = new javax.swing.JLabel();
88        jTextField49 = new javax.swing.JTextField();
89        jTextField50 = new javax.swing.JTextField();
90        jTextField51 = new javax.swing.JTextField();
91        jLabel54 = new javax.swing.JLabel();
92        jLabel55 = new javax.swing.JLabel();
93        jLabel56 = new javax.swing.JLabel();
94        jButton23 = new javax.swing.JButton();
95        jTextField52 = new javax.swing.JTextField();
96        jLabel57 = new javax.swing.JLabel();
97        jLabel58 = new javax.swing.JLabel();
98        jTextField53 = new javax.swing.JTextField();
99        jTextField54 = new javax.swing.JTextField();
100        jPanel12 = new javax.swing.JPanel();
101        jLabel59 = new javax.swing.JLabel();
102        jLabel60 = new javax.swing.JLabel();
103        jLabel61 = new javax.swing.JLabel();
104        jLabel62 = new javax.swing.JLabel();
105        jLabel63 = new javax.swing.JLabel();
106        jTextField55 = new javax.swing.JTextField();
107        jTextField56 = new javax.swing.JTextField();
108        jTextField57 = new javax.swing.JTextField();
109        jTextField58 = new javax.swing.JTextField();
110        jTextField59 = new javax.swing.JTextField();
111        jButton24 = new javax.swing.JButton();
112        jPanel13 = new javax.swing.JPanel();
113        jLabel64 = new javax.swing.JLabel();
114        jLabel65 = new javax.swing.JLabel();
115        jLabel66 = new javax.swing.JLabel();
116        jLabel67 = new javax.swing.JLabel();
117        jLabel68 = new javax.swing.JLabel();
118        jTextField60 = new javax.swing.JTextField();
119        jTextField61 = new javax.swing.JTextField();
120        jTextField62 = new javax.swing.JTextField();
121        jTextField63 = new javax.swing.JTextField();
122        jTextField64 = new javax.swing.JTextField();
123        jButton25 = new javax.swing.JButton();
124        jPanel14 = new javax.swing.JPanel();
125        jLabel69 = new javax.swing.JLabel();
126        jLabel70 = new javax.swing.JLabel();
127        jLabel71 = new javax.swing.JLabel();
128        jTextField65 = new javax.swing.JTextField();
129        jTextField66 = new javax.swing.JTextField();
130        jTextField67 = new javax.swing.JTextField();
131        jLabel72 = new javax.swing.JLabel();
132        jLabel73 = new javax.swing.JLabel();
133        jLabel74 = new javax.swing.JLabel();
134        jTextField68 = new javax.swing.JTextField();
135        jTextField69 = new javax.swing.JTextField();
136        jTextField70 = new javax.swing.JTextField();
137        jButton26 = new javax.swing.JButton();
138        jPanel3 = new javax.swing.JPanel();
139        jButton4 = new javax.swing.JButton();
140        jButton5 = new javax.swing.JButton();
141        jButton6 = new javax.swing.JButton();
142        jButton7 = new javax.swing.JButton();
143        jTextField3 = new javax.swing.JTextField();
144        jLabel5 = new javax.swing.JLabel();
145        jScrollPane1 = new javax.swing.JScrollPane();
146        jTextArea1 = new javax.swing.JTextArea();
147        jPanel2 = new javax.swing.JPanel();
148        jButton8 = new javax.swing.JButton();
149        jButton9 = new javax.swing.JButton();
150        jButton10 = new javax.swing.JButton();
151        jButton11 = new javax.swing.JButton();
152        jLabel6 = new javax.swing.JLabel();
153
154        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
155
156        jPasswordField1.setColumns(15);
157        jPasswordField1.addActionListener(new java.awt.event.ActionListener() {
158            public void actionPerformed(java.awt.event.ActionEvent evt) {
159                jPasswordField1ActionPerformed(evt);
160            }
161        });
162
163        jLabel1.setText("Vardas");
164
165        jLabel2.setText("Slaptažodis");
166
167        jTextField1.setColumns(12);
168        jTextField1.setText("root");
169        jTextField1.addActionListener(new java.awt.event.ActionListener() {
170            public void actionPerformed(java.awt.event.ActionEvent evt) {
171                jTextField1ActionPerformed(evt);
172            }
173        });
174
175        jLabel3.setText("Adresas iki DB");
176
177        jTextField2.setColumns(50);
178        jTextField2.setText("localhost:3306/test1");
179        jTextField2.addActionListener(new java.awt.event.ActionListener() {
180            public void actionPerformed(java.awt.event.ActionEvent evt) {
181                jTextField2ActionPerformed(evt);
182            }
183        });
184
185        jButton1.setText("Tikrinti ryšį");
186        jButton1.addActionListener(new java.awt.event.ActionListener() {
187            public void actionPerformed(java.awt.event.ActionEvent evt) {
188                jButton1ActionPerformed(evt);
189            }
190        });
191
192        jButton2.setText("Sukurti lenteles (jei jų nėra)");
193        jButton2.addActionListener(new java.awt.event.ActionListener() {
194            public void actionPerformed(java.awt.event.ActionEvent evt) {
195                jButton2ActionPerformed(evt);
196            }
197        });
198
199        jButton3.setText("Atsijunk");
200        jButton3.addActionListener(new java.awt.event.ActionListener() {
201            public void actionPerformed(java.awt.event.ActionEvent evt) {
202                jButton3ActionPerformed(evt);
203            }
204        });
205
206        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
207        jPanel1.setLayout(jPanel1Layout);
208        jPanel1Layout.setHorizontalGroup(
209            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
210            .addGroup(jPanel1Layout.createSequentialGroup()
211                .addContainerGap()
212                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
213                    .addGroup(jPanel1Layout.createSequentialGroup()
214                        .addComponent(jLabel3)
215                        .addGap(141, 141, 141)
216                        .addComponent(jLabel4))
217                    .addGroup(jPanel1Layout.createSequentialGroup()
218                        .addComponent(jButton1)
219                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
220                        .addComponent(jButton2)
221                        .addGap(18, 18, 18)
222                        .addComponent(jButton3))
223                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
224                        .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()
225                            .addComponent(jLabel1)
226                            .addGap(18, 18, 18)
227                            .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
228                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
229                            .addComponent(jLabel2)
230                            .addGap(18, 18, 18)
231                            .addComponent(jPasswordField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
232                        .addComponent(jTextField2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
233                .addContainerGap(459, Short.MAX_VALUE))
234        );
235        jPanel1Layout.setVerticalGroup(
236            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
237            .addGroup(jPanel1Layout.createSequentialGroup()
238                .addContainerGap()
239                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
240                    .addComponent(jPasswordField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
241                    .addComponent(jLabel1)
242                    .addComponent(jLabel2)
243                    .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
244                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
245                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
246                    .addComponent(jLabel3)
247                    .addComponent(jLabel4))
248                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
249                .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
250                .addGap(18, 18, 18)
251                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
252                    .addComponent(jButton1)
253                    .addComponent(jButton2)
254                    .addComponent(jButton3))
255                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
256        );
257
258        jTabbedPane1.addTab("Prisijungimo duomenys", jPanel1);
259
260        jLabel47.setText("ID");
261
262        jTextField43.setColumns(10);
263
264        jTextField44.setColumns(10);
265
266        jTextField45.setColumns(10);
267
268        jLabel48.setText("Vardas");
269
270        jLabel49.setText("PavardÄ—");
271
272        jLabel50.setText("Adresas");
273
274        jButton21.setText("Ivesti");
275        jButton21.addActionListener(new java.awt.event.ActionListener() {
276            public void actionPerformed(java.awt.event.ActionEvent evt) {
277                jButton21ActionPerformed(evt);
278            }
279        });
280
281        jTextField46.setColumns(10);
282
283        jLabel51.setText("Atlyginimas");
284
285        jLabel52.setText("Telefonas");
286
287        jTextField47.setColumns(10);
288
289        jTextField48.setColumns(10);
290
291        javax.swing.GroupLayout jPanel10Layout = new javax.swing.GroupLayout(jPanel10);
292        jPanel10.setLayout(jPanel10Layout);
293        jPanel10Layout.setHorizontalGroup(
294            jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
295            .addGroup(jPanel10Layout.createSequentialGroup()
296                .addGap(28, 28, 28)
297                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
298                    .addGroup(jPanel10Layout.createSequentialGroup()
299                        .addComponent(jLabel49)
300                        .addGap(63, 63, 63)
301                        .addComponent(jTextField45, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
302                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel10Layout.createSequentialGroup()
303                        .addComponent(jLabel47)
304                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
305                        .addComponent(jTextField43, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
306                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel10Layout.createSequentialGroup()
307                        .addComponent(jLabel48)
308                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
309                        .addComponent(jTextField44, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
310                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 15, Short.MAX_VALUE)
311                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
312                    .addComponent(jLabel52)
313                    .addComponent(jLabel51)
314                    .addComponent(jLabel50))
315                .addGap(37, 37, 37)
316                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
317                    .addComponent(jTextField46, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
318                    .addGroup(jPanel10Layout.createSequentialGroup()
319                        .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
320                            .addComponent(jTextField47, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
321                            .addComponent(jTextField48, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
322                        .addGap(60, 60, 60)
323                        .addComponent(jButton21, javax.swing.GroupLayout.PREFERRED_SIZE, 129, javax.swing.GroupLayout.PREFERRED_SIZE)))
324                .addGap(275, 275, 275))
325        );
326        jPanel10Layout.setVerticalGroup(
327            jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
328            .addGroup(jPanel10Layout.createSequentialGroup()
329                .addGap(25, 25, 25)
330                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
331                    .addComponent(jLabel47)
332                    .addComponent(jTextField43, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
333                    .addComponent(jLabel51)
334                    .addComponent(jTextField47, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
335                .addGap(17, 17, 17)
336                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
337                    .addComponent(jLabel48)
338                    .addComponent(jTextField44, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
339                    .addComponent(jLabel52)
340                    .addComponent(jTextField48, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
341                    .addComponent(jButton21))
342                .addGap(15, 15, 15)
343                .addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
344                    .addComponent(jTextField45, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
345                    .addComponent(jLabel50)
346                    .addComponent(jTextField46, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
347                    .addComponent(jLabel49))
348                .addContainerGap(46, Short.MAX_VALUE))
349        );
350
351        jTabbedPane2.addTab("Naujas darbuotojas", jPanel10);
352
353        jLabel31.setText("ID");
354
355        jLabel32.setText("Vardas");
356
357        jLabel33.setText("Pavarde");
358
359        jLabel34.setText("Adresas");
360
361        jLabel35.setText("Telefonas");
362
363        jTextField27.setColumns(10);
364
365        jTextField28.setColumns(10);
366
367        jTextField29.setColumns(10);
368
369        jTextField30.setColumns(10);
370
371        jTextField31.setColumns(10);
372
373        jButton15.setText("Ivesti");
374        jButton15.addActionListener(new java.awt.event.ActionListener() {
375            public void actionPerformed(java.awt.event.ActionEvent evt) {
376                jButton15ActionPerformed(evt);
377            }
378        });
379
380        javax.swing.GroupLayout jPanel7Layout = new javax.swing.GroupLayout(jPanel7);
381        jPanel7.setLayout(jPanel7Layout);
382        jPanel7Layout.setHorizontalGroup(
383            jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
384            .addGroup(jPanel7Layout.createSequentialGroup()
385                .addGap(28, 28, 28)
386                .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
387                    .addComponent(jLabel31)
388                    .addComponent(jLabel33)
389                    .addComponent(jLabel32))
390                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 50, Short.MAX_VALUE)
391                .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
392                    .addComponent(jTextField29, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
393                    .addComponent(jTextField28, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
394                    .addComponent(jTextField27, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
395                .addGap(39, 39, 39)
396                .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
397                    .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel7Layout.createSequentialGroup()
398                        .addComponent(jLabel35)
399                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
400                        .addComponent(jTextField31, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
401                    .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel7Layout.createSequentialGroup()
402                        .addComponent(jLabel34)
403                        .addGap(47, 47, 47)
404                        .addComponent(jTextField30, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
405                .addGap(55, 55, 55)
406                .addComponent(jButton15, javax.swing.GroupLayout.PREFERRED_SIZE, 109, javax.swing.GroupLayout.PREFERRED_SIZE)
407                .addGap(292, 292, 292))
408        );
409        jPanel7Layout.setVerticalGroup(
410            jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
411            .addGroup(jPanel7Layout.createSequentialGroup()
412                .addGap(26, 26, 26)
413                .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
414                    .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
415                        .addComponent(jLabel34)
416                        .addComponent(jTextField30, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
417                    .addGroup(jPanel7Layout.createSequentialGroup()
418                        .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
419                            .addComponent(jLabel31)
420                            .addComponent(jTextField27, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
421                        .addGap(18, 18, 18)
422                        .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
423                            .addComponent(jLabel32)
424                            .addComponent(jTextField28, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
425                            .addComponent(jLabel35)
426                            .addComponent(jTextField31, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
427                            .addComponent(jButton15))
428                        .addGap(18, 18, 18)
429                        .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
430                            .addComponent(jLabel33)
431                            .addComponent(jTextField29, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
432                .addContainerGap(41, Short.MAX_VALUE))
433        );
434
435        jTabbedPane2.addTab("Naujas klientas", jPanel7);
436
437        jLabel36.setText("ID");
438
439        jLabel37.setText("Marke");
440
441        jLabel38.setText("Modelis");
442
443        jLabel39.setText("Metai");
444
445        jLabel40.setText("KlientoID");
446
447        jTextField32.setColumns(10);
448
449        jTextField33.setColumns(10);
450
451        jTextField34.setColumns(10);
452
453        jTextField35.setColumns(10);
454
455        jTextField36.setColumns(10);
456
457        jButton17.setText("Ivesti");
458        jButton17.addActionListener(new java.awt.event.ActionListener() {
459            public void actionPerformed(java.awt.event.ActionEvent evt) {
460                jButton17ActionPerformed(evt);
461            }
462        });
463
464        javax.swing.GroupLayout jPanel8Layout = new javax.swing.GroupLayout(jPanel8);
465        jPanel8.setLayout(jPanel8Layout);
466        jPanel8Layout.setHorizontalGroup(
467            jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
468            .addGroup(jPanel8Layout.createSequentialGroup()
469                .addGap(29, 29, 29)
470                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
471                    .addGroup(jPanel8Layout.createSequentialGroup()
472                        .addComponent(jLabel38)
473                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 34, Short.MAX_VALUE)
474                        .addComponent(jTextField34, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
475                    .addGroup(jPanel8Layout.createSequentialGroup()
476                        .addComponent(jLabel37)
477                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 41, Short.MAX_VALUE)
478                        .addComponent(jTextField33, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
479                    .addGroup(jPanel8Layout.createSequentialGroup()
480                        .addComponent(jLabel36)
481                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
482                        .addComponent(jTextField32, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
483                .addGap(26, 26, 26)
484                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
485                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel8Layout.createSequentialGroup()
486                        .addComponent(jLabel40)
487                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
488                        .addComponent(jTextField36, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
489                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel8Layout.createSequentialGroup()
490                        .addComponent(jLabel39)
491                        .addGap(34, 34, 34)
492                        .addComponent(jTextField35, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
493                .addGap(107, 107, 107)
494                .addComponent(jButton17, javax.swing.GroupLayout.PREFERRED_SIZE, 132, javax.swing.GroupLayout.PREFERRED_SIZE)
495                .addContainerGap(279, Short.MAX_VALUE))
496        );
497        jPanel8Layout.setVerticalGroup(
498            jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
499            .addGroup(jPanel8Layout.createSequentialGroup()
500                .addGap(21, 21, 21)
501                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
502                    .addComponent(jLabel36)
503                    .addComponent(jLabel39)
504                    .addComponent(jTextField32, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
505                    .addComponent(jTextField35, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
506                .addGap(19, 19, 19)
507                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
508                    .addComponent(jLabel37)
509                    .addComponent(jLabel40)
510                    .addComponent(jTextField33, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
511                    .addComponent(jTextField36, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
512                    .addComponent(jButton17))
513                .addGap(18, 18, 18)
514                .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
515                    .addComponent(jLabel38)
516                    .addComponent(jTextField34, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
517                .addContainerGap(45, Short.MAX_VALUE))
518        );
519
520        jTabbedPane2.addTab("Naujas automobilis", jPanel8);
521
522        jLabel41.setText("UzsakymoNr");
523
524        jLabel42.setText("DarbuotojoID");
525
526        jLabel43.setText("Data");
527
528        jTextField37.setColumns(10);
529
530        jTextField38.setColumns(10);
531
532        jTextField39.setColumns(10);
533
534        jLabel44.setText("Aprasymas");
535
536        jLabel45.setText("Kaina");
537
538        jLabel46.setText("AutomobilioID");
539
540        jTextField40.setColumns(10);
541
542        jTextField41.setColumns(10);
543
544        jTextField42.setColumns(10);
545
546        jButton19.setText("Ivesti");
547        jButton19.addActionListener(new java.awt.event.ActionListener() {
548            public void actionPerformed(java.awt.event.ActionEvent evt) {
549                jButton19ActionPerformed(evt);
550            }
551        });
552
553        javax.swing.GroupLayout jPanel9Layout = new javax.swing.GroupLayout(jPanel9);
554        jPanel9.setLayout(jPanel9Layout);
555        jPanel9Layout.setHorizontalGroup(
556            jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
557            .addGroup(jPanel9Layout.createSequentialGroup()
558                .addGap(23, 23, 23)
559                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
560                    .addComponent(jLabel41)
561                    .addComponent(jLabel42)
562                    .addComponent(jLabel43))
563                .addGap(45, 45, 45)
564                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
565                    .addGroup(jPanel9Layout.createSequentialGroup()
566                        .addComponent(jTextField39, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
567                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
568                        .addComponent(jLabel46))
569                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel9Layout.createSequentialGroup()
570                        .addComponent(jTextField38, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
571                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
572                        .addComponent(jLabel45))
573                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel9Layout.createSequentialGroup()
574                        .addComponent(jTextField37, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
575                        .addGap(63, 63, 63)
576                        .addComponent(jLabel44)))
577                .addGap(52, 52, 52)
578                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
579                    .addComponent(jTextField42, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
580                    .addGroup(jPanel9Layout.createSequentialGroup()
581                        .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
582                            .addComponent(jTextField40, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
583                            .addComponent(jTextField41, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
584                        .addGap(99, 99, 99)
585                        .addComponent(jButton19, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE)))
586                .addContainerGap(197, Short.MAX_VALUE))
587        );
588        jPanel9Layout.setVerticalGroup(
589            jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
590            .addGroup(jPanel9Layout.createSequentialGroup()
591                .addGap(27, 27, 27)
592                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
593                    .addComponent(jLabel41)
594                    .addComponent(jTextField37, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
595                    .addComponent(jLabel44)
596                    .addComponent(jTextField40, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
597                .addGap(18, 18, 18)
598                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
599                    .addComponent(jLabel42)
600                    .addComponent(jTextField38, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
601                    .addComponent(jLabel45)
602                    .addComponent(jTextField41, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
603                    .addComponent(jButton19))
604                .addGap(18, 18, 18)
605                .addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
606                    .addComponent(jLabel43)
607                    .addComponent(jTextField39, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
608                    .addComponent(jLabel46)
609                    .addComponent(jTextField42, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
610                .addContainerGap(40, Short.MAX_VALUE))
611        );
612
613        jTabbedPane2.addTab("Naujas uzsakymas", jPanel9);
614
615        jTabbedPane1.addTab("Nauji duomenys", jTabbedPane2);
616
617        jLabel53.setText("ID");
618
619        jTextField49.setColumns(10);
620
621        jTextField50.setColumns(10);
622
623        jTextField51.setColumns(10);
624
625        jLabel54.setText("Vardas");
626
627        jLabel55.setText("PavardÄ—");
628
629        jLabel56.setText("Adresas");
630
631        jButton23.setText("Atnaujinti");
632        jButton23.addActionListener(new java.awt.event.ActionListener() {
633            public void actionPerformed(java.awt.event.ActionEvent evt) {
634                jButton23ActionPerformed(evt);
635            }
636        });
637
638        jTextField52.setColumns(10);
639
640        jLabel57.setText("Atlyginimas");
641
642        jLabel58.setText("Telefonas");
643
644        jTextField53.setColumns(10);
645
646        jTextField54.setColumns(10);
647
648        javax.swing.GroupLayout jPanel11Layout = new javax.swing.GroupLayout(jPanel11);
649        jPanel11.setLayout(jPanel11Layout);
650        jPanel11Layout.setHorizontalGroup(
651            jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
652            .addGroup(jPanel11Layout.createSequentialGroup()
653                .addGap(28, 28, 28)
654                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
655                    .addGroup(jPanel11Layout.createSequentialGroup()
656                        .addComponent(jLabel55)
657                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
658                        .addComponent(jTextField51))
659                    .addGroup(jPanel11Layout.createSequentialGroup()
660                        .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
661                            .addComponent(jLabel54)
662                            .addComponent(jLabel53))
663                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
664                        .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
665                            .addComponent(jTextField49, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
666                            .addComponent(jTextField50, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
667                .addGap(47, 47, 47)
668                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
669                    .addComponent(jLabel58)
670                    .addComponent(jLabel57)
671                    .addComponent(jLabel56))
672                .addGap(37, 37, 37)
673                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
674                    .addGroup(jPanel11Layout.createSequentialGroup()
675                        .addComponent(jTextField53, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
676                        .addGap(62, 62, 62)
677                        .addComponent(jButton23, javax.swing.GroupLayout.PREFERRED_SIZE, 129, javax.swing.GroupLayout.PREFERRED_SIZE))
678                    .addComponent(jTextField52, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
679                    .addComponent(jTextField54, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
680                .addContainerGap(290, Short.MAX_VALUE))
681        );
682        jPanel11Layout.setVerticalGroup(
683            jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
684            .addGroup(jPanel11Layout.createSequentialGroup()
685                .addGap(25, 25, 25)
686                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
687                    .addComponent(jLabel53)
688                    .addComponent(jTextField49, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
689                    .addComponent(jLabel57)
690                    .addComponent(jTextField52, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
691                .addGap(17, 17, 17)
692                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
693                    .addComponent(jLabel54)
694                    .addComponent(jTextField50, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
695                    .addComponent(jLabel58)
696                    .addComponent(jButton23)
697                    .addComponent(jTextField53, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
698                .addGap(18, 18, 18)
699                .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
700                    .addComponent(jTextField51, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
701                    .addComponent(jLabel56)
702                    .addComponent(jLabel55)
703                    .addComponent(jTextField54, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
704                .addContainerGap(43, Short.MAX_VALUE))
705        );
706
707        jTabbedPane3.addTab("Darbuotojas", jPanel11);
708
709        jLabel59.setText("ID");
710
711        jLabel60.setText("Vardas");
712
713        jLabel61.setText("Pavarde");
714
715        jLabel62.setText("Adresas");
716
717        jLabel63.setText("Telefonas");
718
719        jTextField55.setColumns(10);
720
721        jTextField56.setColumns(10);
722
723        jTextField57.setColumns(10);
724
725        jTextField58.setColumns(10);
726
727        jTextField59.setColumns(10);
728
729        jButton24.setText("Atnaujinti");
730        jButton24.addActionListener(new java.awt.event.ActionListener() {
731            public void actionPerformed(java.awt.event.ActionEvent evt) {
732                jButton24ActionPerformed(evt);
733            }
734        });
735
736        javax.swing.GroupLayout jPanel12Layout = new javax.swing.GroupLayout(jPanel12);
737        jPanel12.setLayout(jPanel12Layout);
738        jPanel12Layout.setHorizontalGroup(
739            jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
740            .addGroup(jPanel12Layout.createSequentialGroup()
741                .addGap(28, 28, 28)
742                .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
743                    .addComponent(jLabel59)
744                    .addComponent(jLabel61)
745                    .addComponent(jLabel60))
746                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 50, Short.MAX_VALUE)
747                .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
748                    .addComponent(jTextField57, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
749                    .addComponent(jTextField56, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
750                    .addComponent(jTextField55, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
751                .addGap(39, 39, 39)
752                .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
753                    .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel12Layout.createSequentialGroup()
754                        .addComponent(jLabel63)
755                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
756                        .addComponent(jTextField59, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
757                    .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel12Layout.createSequentialGroup()
758                        .addComponent(jLabel62)
759                        .addGap(47, 47, 47)
760                        .addComponent(jTextField58, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
761                .addGap(201, 201, 201)
762                .addComponent(jButton24, javax.swing.GroupLayout.PREFERRED_SIZE, 109, javax.swing.GroupLayout.PREFERRED_SIZE)
763                .addGap(146, 146, 146))
764        );
765        jPanel12Layout.setVerticalGroup(
766            jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
767            .addGroup(jPanel12Layout.createSequentialGroup()
768                .addGap(26, 26, 26)
769                .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
770                    .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
771                        .addComponent(jLabel62)
772                        .addComponent(jTextField58, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
773                    .addGroup(jPanel12Layout.createSequentialGroup()
774                        .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
775                            .addComponent(jLabel59)
776                            .addComponent(jTextField55, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
777                        .addGap(18, 18, 18)
778                        .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
779                            .addComponent(jLabel60)
780                            .addComponent(jTextField56, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
781                            .addComponent(jLabel63)
782                            .addComponent(jTextField59, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
783                            .addComponent(jButton24))
784                        .addGap(18, 18, 18)
785                        .addGroup(jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
786                            .addComponent(jLabel61)
787                            .addComponent(jTextField57, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
788                .addContainerGap(41, Short.MAX_VALUE))
789        );
790
791        jTabbedPane3.addTab("Klientas", jPanel12);
792
793        jLabel64.setText("ID");
794
795        jLabel65.setText("Marke");
796
797        jLabel66.setText("Modelis");
798
799        jLabel67.setText("Metai");
800
801        jLabel68.setText("KlientoID");
802
803        jTextField60.setColumns(10);
804
805        jTextField61.setColumns(10);
806
807        jTextField62.setColumns(10);
808
809        jTextField63.setColumns(10);
810
811        jTextField64.setColumns(10);
812
813        jButton25.setText("Atnaujinti");
814        jButton25.addActionListener(new java.awt.event.ActionListener() {
815            public void actionPerformed(java.awt.event.ActionEvent evt) {
816                jButton25ActionPerformed(evt);
817            }
818        });
819
820        javax.swing.GroupLayout jPanel13Layout = new javax.swing.GroupLayout(jPanel13);
821        jPanel13.setLayout(jPanel13Layout);
822        jPanel13Layout.setHorizontalGroup(
823            jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
824            .addGroup(jPanel13Layout.createSequentialGroup()
825                .addGap(29, 29, 29)
826                .addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
827                    .addGroup(jPanel13Layout.createSequentialGroup()
828                        .addComponent(jLabel66)
829                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 34, Short.MAX_VALUE)
830                        .addComponent(jTextField62, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
831                    .addGroup(jPanel13Layout.createSequentialGroup()
832                        .addComponent(jLabel65)
833                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 41, Short.MAX_VALUE)
834                        .addComponent(jTextField61, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
835                    .addGroup(jPanel13Layout.createSequentialGroup()
836                        .addComponent(jLabel64)
837                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
838                        .addComponent(jTextField60, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
839                .addGap(26, 26, 26)
840                .addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
841                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel13Layout.createSequentialGroup()
842                        .addComponent(jLabel68)
843                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
844                        .addComponent(jTextField64, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
845                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel13Layout.createSequentialGroup()
846                        .addComponent(jLabel67)
847                        .addGap(34, 34, 34)
848                        .addComponent(jTextField63, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
849                .addGap(127, 127, 127)
850                .addComponent(jButton25, javax.swing.GroupLayout.PREFERRED_SIZE, 132, javax.swing.GroupLayout.PREFERRED_SIZE)
851                .addContainerGap(259, Short.MAX_VALUE))
852        );
853        jPanel13Layout.setVerticalGroup(
854            jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
855            .addGroup(jPanel13Layout.createSequentialGroup()
856                .addGap(21, 21, 21)
857                .addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
858                    .addComponent(jLabel64)
859                    .addComponent(jLabel67)
860                    .addComponent(jTextField60, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
861                    .addComponent(jTextField63, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
862                .addGap(19, 19, 19)
863                .addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
864                    .addComponent(jLabel65)
865                    .addComponent(jLabel68)
866                    .addComponent(jTextField61, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
867                    .addComponent(jTextField64, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
868                    .addComponent(jButton25))
869                .addGap(18, 18, 18)
870                .addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
871                    .addComponent(jLabel66)
872                    .addComponent(jTextField62, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
873                .addContainerGap(45, Short.MAX_VALUE))
874        );
875
876        jTabbedPane3.addTab("Automobilis", jPanel13);
877
878        jLabel69.setText("UzsakymoNr");
879
880        jLabel70.setText("DarbuotojoID");
881
882        jLabel71.setText("Data");
883
884        jTextField65.setColumns(10);
885
886        jTextField66.setColumns(10);
887
888        jTextField67.setColumns(10);
889
890        jLabel72.setText("Aprasymas");
891
892        jLabel73.setText("Kaina");
893
894        jLabel74.setText("AutomobilioID");
895
896        jTextField68.setColumns(10);
897
898        jTextField69.setColumns(10);
899
900        jTextField70.setColumns(10);
901
902        jButton26.setText("Atnaujinti");
903        jButton26.addActionListener(new java.awt.event.ActionListener() {
904            public void actionPerformed(java.awt.event.ActionEvent evt) {
905                jButton26ActionPerformed(evt);
906            }
907        });
908
909        javax.swing.GroupLayout jPanel14Layout = new javax.swing.GroupLayout(jPanel14);
910        jPanel14.setLayout(jPanel14Layout);
911        jPanel14Layout.setHorizontalGroup(
912            jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
913            .addGroup(jPanel14Layout.createSequentialGroup()
914                .addGap(23, 23, 23)
915                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
916                    .addComponent(jLabel69)
917                    .addComponent(jLabel70)
918                    .addComponent(jLabel71))
919                .addGap(45, 45, 45)
920                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
921                    .addGroup(jPanel14Layout.createSequentialGroup()
922                        .addComponent(jTextField67, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
923                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
924                        .addComponent(jLabel74))
925                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel14Layout.createSequentialGroup()
926                        .addComponent(jTextField66, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
927                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
928                        .addComponent(jLabel73))
929                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel14Layout.createSequentialGroup()
930                        .addComponent(jTextField65, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
931                        .addGap(63, 63, 63)
932                        .addComponent(jLabel72)))
933                .addGap(52, 52, 52)
934                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
935                    .addComponent(jTextField70, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
936                    .addGroup(jPanel14Layout.createSequentialGroup()
937                        .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
938                            .addComponent(jTextField68, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
939                            .addComponent(jTextField69, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
940                        .addGap(117, 117, 117)
941                        .addComponent(jButton26, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE)))
942                .addContainerGap(179, Short.MAX_VALUE))
943        );
944        jPanel14Layout.setVerticalGroup(
945            jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
946            .addGroup(jPanel14Layout.createSequentialGroup()
947                .addGap(27, 27, 27)
948                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
949                    .addComponent(jLabel69)
950                    .addComponent(jTextField65, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
951                    .addComponent(jLabel72)
952                    .addComponent(jTextField68, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
953                .addGap(18, 18, 18)
954                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
955                    .addComponent(jLabel70)
956                    .addComponent(jTextField66, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
957                    .addComponent(jLabel73)
958                    .addComponent(jTextField69, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
959                    .addComponent(jButton26))
960                .addGap(18, 18, 18)
961                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
962                    .addComponent(jLabel71)
963                    .addComponent(jTextField67, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
964                    .addComponent(jLabel74)
965                    .addComponent(jTextField70, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
966                .addContainerGap(40, Short.MAX_VALUE))
967        );
968
969        jTabbedPane3.addTab("Uzsakymas", jPanel14);
970
971        jButton4.setText("Istrinti darbuotoja");
972        jButton4.addActionListener(new java.awt.event.ActionListener() {
973            public void actionPerformed(java.awt.event.ActionEvent evt) {
974                jButton4ActionPerformed(evt);
975            }
976        });
977
978        jButton5.setText("Istrinti klienta");
979        jButton5.addActionListener(new java.awt.event.ActionListener() {
980            public void actionPerformed(java.awt.event.ActionEvent evt) {
981                jButton5ActionPerformed(evt);
982            }
983        });
984
985        jButton6.setText("Istrinti automobili");
986        jButton6.addActionListener(new java.awt.event.ActionListener() {
987            public void actionPerformed(java.awt.event.ActionEvent evt) {
988                jButton6ActionPerformed(evt);
989            }
990        });
991
992        jButton7.setText("Istrinti uzsakyma");
993        jButton7.addActionListener(new java.awt.event.ActionListener() {
994            public void actionPerformed(java.awt.event.ActionEvent evt) {
995                jButton7ActionPerformed(evt);
996            }
997        });
998
999        jTextField3.setColumns(5);
1000
1001        jLabel5.setText("Iveskite ID");
1002
1003        javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
1004        jPanel3.setLayout(jPanel3Layout);
1005        jPanel3Layout.setHorizontalGroup(
1006            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
1007            .addGroup(jPanel3Layout.createSequentialGroup()
1008                .addGap(31, 31, 31)
1009                .addComponent(jLabel5)
1010                .addGap(26, 26, 26)
1011                .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
1012                .addGap(43, 43, 43)
1013                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
1014                    .addComponent(jButton5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
1015                    .addComponent(jButton4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
1016                    .addComponent(jButton6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
1017                    .addComponent(jButton7, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
1018                .addContainerGap(562, Short.MAX_VALUE))
1019        );
1020        jPanel3Layout.setVerticalGroup(
1021            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
1022            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
1023                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
1024                .addComponent(jButton4)
1025                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
1026                    .addGroup(jPanel3Layout.createSequentialGroup()
1027                        .addGap(26, 26, 26)
1028                        .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
1029                            .addComponent(jLabel5)
1030                            .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
1031                    .addGroup(jPanel3Layout.createSequentialGroup()
1032                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
1033                        .addComponent(jButton5)
1034                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 8, Short.MAX_VALUE)
1035                        .addComponent(jButton6)))
1036                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
1037                .addComponent(jButton7)
1038                .addGap(46, 46, 46))
1039        );
1040
1041        jTabbedPane3.addTab("Istrinti duomenis", jPanel3);
1042
1043        jTabbedPane1.addTab("Koreguoti/istrinti duomenis", jTabbedPane3);
1044
1045        jTextArea1.setColumns(20);
1046        jTextArea1.setRows(5);
1047        jScrollPane1.setViewportView(jTextArea1);
1048
1049        jButton8.setText("Darbuotojus");
1050        jButton8.addActionListener(new java.awt.event.ActionListener() {
1051            public void actionPerformed(java.awt.event.ActionEvent evt) {
1052                jButton8ActionPerformed(evt);
1053            }
1054        });
1055
1056        jButton9.setText("Automobilius");
1057        jButton9.addActionListener(new java.awt.event.ActionListener() {
1058            public void actionPerformed(java.awt.event.ActionEvent evt) {
1059                jButton9ActionPerformed(evt);
1060            }
1061        });
1062
1063        jButton10.setText("Klientus");
1064        jButton10.addActionListener(new java.awt.event.ActionListener() {
1065            public void actionPerformed(java.awt.event.ActionEvent evt) {
1066                jButton10ActionPerformed(evt);
1067            }
1068        });
1069
1070        jButton11.setText("Uzsakymus");
1071        jButton11.addActionListener(new java.awt.event.ActionListener() {
1072            public void actionPerformed(java.awt.event.ActionEvent evt) {
1073                jButton11ActionPerformed(evt);
1074            }
1075        });
1076
1077        jLabel6.setText("Parodyti visus duomenu bazeje esancius:");
1078
1079        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
1080        jPanel2.setLayout(jPanel2Layout);
1081        jPanel2Layout.setHorizontalGroup(
1082            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
1083            .addGroup(jPanel2Layout.createSequentialGroup()
1084                .addContainerGap()
1085                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
1086                    .addGroup(jPanel2Layout.createSequentialGroup()
1087                        .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
1088                            .addComponent(jButton10, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)
1089                            .addComponent(jButton8, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE))
1090                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
1091                        .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
1092                            .addComponent(jButton9, javax.swing.GroupLayout.DEFAULT_SIZE, 110, Short.MAX_VALUE)
1093                            .addComponent(jButton11, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
1094                    .addGroup(jPanel2Layout.createSequentialGroup()
1095                        .addComponent(jLabel6)
1096                        .addGap(0, 0, Short.MAX_VALUE)))
1097                .addContainerGap())
1098        );
1099        jPanel2Layout.setVerticalGroup(
1100            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
1101            .addGroup(jPanel2Layout.createSequentialGroup()
1102                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
1103                .addComponent(jLabel6)
1104                .addGap(18, 18, 18)
1105                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
1106                    .addComponent(jButton8)
1107                    .addComponent(jButton9))
1108                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
1109                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
1110                    .addComponent(jButton11)
1111                    .addComponent(jButton10))
1112                .addGap(41, 41, 41))
1113        );
1114
1115        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
1116        getContentPane().setLayout(layout);
1117        layout.setHorizontalGroup(
1118            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
1119            .addComponent(jTabbedPane1)
1120            .addGroup(layout.createSequentialGroup()
1121                .addContainerGap()
1122                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 608, javax.swing.GroupLayout.PREFERRED_SIZE)
1123                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
1124                .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
1125                .addGap(0, 0, Short.MAX_VALUE))
1126        );
1127        layout.setVerticalGroup(
1128            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
1129            .addGroup(layout.createSequentialGroup()
1130                .addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 220, javax.swing.GroupLayout.PREFERRED_SIZE)
1131                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
1132                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
1133                    .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
1134                    .addGroup(layout.createSequentialGroup()
1135                        .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 163, javax.swing.GroupLayout.PREFERRED_SIZE)
1136                        .addGap(0, 4, Short.MAX_VALUE)))
1137                .addContainerGap())
1138        );
1139
1140        pack();
1141    }// </editor-fold>                        
1142
1143    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                         
1144        atsijunk();
1145    }                                        
1146
1147    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
1148        sukurtiLenteles();
1149    }                                        
1150
1151    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
1152        Connection rysininkas = gautiPrisijungima();
1153    }                                        
1154
1155    private void jTextField2ActionPerformed(java.awt.event.ActionEvent evt) {                                            
1156        // TODO add your handling code here:
1157    }                                           
1158
1159    private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {                                            
1160        // TODO add your handling code here:
1161    }                                           
1162
1163    private void jPasswordField1ActionPerformed(java.awt.event.ActionEvent evt) {                                                
1164        // TODO add your handling code here:
1165    }                                               
1166
1167    private void jButton15ActionPerformed(java.awt.event.ActionEvent evt) {                                          
1168        try {
1169            Connection rysininkas = gautiPrisijungima();
1170            PreparedStatement sqliterpimas = rysininkas.prepareStatement("Insert into Klientas(KlientoID, Vardas, Pavarde, Adresas, Telefonas) Values(?,?,?,?,?)");
1171            sqliterpimas.setInt(1, Integer.parseInt(jTextField27.getText()));
1172            sqliterpimas.setString(2, jTextField28.getText());
1173            sqliterpimas.setString(3, jTextField29.getText());
1174            sqliterpimas.setString(4, jTextField30.getText());
1175            sqliterpimas.setInt(5, Integer.parseInt(jTextField31.getText()));
1176            sqliterpimas.executeUpdate();
1177            jTextArea1.append("Klientas itrauktas.\n");
1178        }
1179        catch(Exception klaida) {
1180            jTextArea1.append("Klaida pridedant klienta "+klaida+"\n");
1181        }
1182    }                                         
1183
1184    private void jButton17ActionPerformed(java.awt.event.ActionEvent evt) {                                          
1185        try {
1186            Connection rysininkas = gautiPrisijungima();
1187            PreparedStatement sqliterpimas = rysininkas.prepareStatement("Insert into Automobilis(AutomobilioID, Marke, Modelis, Metai, KlientoID) Values(?,?,?,?,?)");
1188            sqliterpimas.setInt(1, Integer.parseInt(jTextField32.getText()));
1189            sqliterpimas.setString(2, jTextField33.getText());
1190            sqliterpimas.setString(3, jTextField34.getText());
1191            sqliterpimas.setInt(4, Integer.parseInt(jTextField35.getText()));
1192            sqliterpimas.setInt(5, Integer.parseInt(jTextField36.getText()));
1193            sqliterpimas.executeUpdate();
1194            jTextArea1.append("Automobilis itrauktas.\n");
1195        }
1196        catch(Exception klaida) {
1197            jTextArea1.append("Klaida pridedant automobili "+klaida+"\n");
1198        }
1199    }                                         
1200
1201    private void jButton19ActionPerformed(java.awt.event.ActionEvent evt) {                                          
1202        try {
1203            Connection rysininkas = gautiPrisijungima();
1204            PreparedStatement sqliterpimas = rysininkas.prepareStatement("Insert into Uzsakymas(UzsakymoNr, DarbuotojoID, Data, Aprasymas, Kaina, AutomobilioID) Values(?,?,?,?,?,?)");
1205            sqliterpimas.setInt(1, Integer.parseInt(jTextField37.getText()));
1206            sqliterpimas.setInt(2, Integer.parseInt(jTextField38.getText()));
1207            sqliterpimas.setDate(3, java.sql.Date.valueOf(jTextField39.getText()));
1208            sqliterpimas.setString(4, jTextField40.getText());
1209            sqliterpimas.setDouble(5, Double.parseDouble(jTextField41.getText()));
1210            sqliterpimas.setInt(6, Integer.parseInt(jTextField42.getText()));
1211            //          sqliterpimas.setDate(4, java.sql.Date.valueOf(jTextField6.getText()));
1212            sqliterpimas.executeUpdate();
1213            jTextArea1.append("Uzsakymas uzregistruotas.\n");
1214        }
1215        catch(Exception klaida) {
1216            jTextArea1.append("Klaida registruojant uzsakyma "+klaida+"\n");
1217        }
1218    }                                         
1219
1220    private void jButton21ActionPerformed(java.awt.event.ActionEvent evt) {                                          
1221        try {
1222            Connection rysininkas = gautiPrisijungima();
1223            PreparedStatement sqliterpimas = rysininkas.prepareStatement("Insert into Darbuotojas(DarbuotojoID, Vardas, Pavarde, Atlyginimas, Telefonas, Adresas) Values(?,?,?,?,?,?)");
1224            sqliterpimas.setInt(1, Integer.parseInt(jTextField43.getText()));
1225            sqliterpimas.setString(2, jTextField44.getText());
1226            sqliterpimas.setString(3, jTextField45.getText());
1227            sqliterpimas.setDouble(4, Double.parseDouble(jTextField47.getText()));
1228            sqliterpimas.setInt(5, Integer.parseInt(jTextField48.getText()));
1229            sqliterpimas.setString(6, jTextField46.getText());
1230            sqliterpimas.executeUpdate();
1231            jTextArea1.append("Darbuotojas itrauktas.\n");
1232        }
1233        catch(Exception klaida) {
1234            jTextArea1.append("Klaida pridedant darbuotoja "+klaida+"\n");
1235        }
1236    }                                         
1237
1238    private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {                                         
1239        try {
1240            Connection rysininkas = gautiPrisijungima();
1241            PreparedStatement trinti = rysininkas.prepareStatement("DELETE FROM Uzsakymas WHERE UzsakymoNr = " + Integer.parseInt(jTextField3.getText()));
1242            trinti.executeUpdate();
1243            jTextArea1.append("Uzsakymas istrintas (arba tokio iraso nera)\n");
1244            }
1245            catch(Exception klaida) {
1246                jTextArea1.append("Klaida: "+klaida+"\n");
1247        }
1248    }                                        
1249
1250    private void jButton23ActionPerformed(java.awt.event.ActionEvent evt) {                                          
1251        try {
1252            Connection rysininkas = gautiPrisijungima();
1253            PreparedStatement update = rysininkas.prepareStatement("UPDATE Darbuotojas SET Vardas = COALESCE(? , Vardas), Pavarde = COALESCE(? ,Pavarde), Atlyginimas = COALESCE(? , Atlyginimas), Telefonas = COALESCE(? , Telefonas), Adresas = COALESCE(? , Adresas) WHERE DarbuotojoID = ?");
1254            update.setString(1, jTextField50.getText());
1255            update.setString(2, jTextField51.getText());
1256            update.setDouble(3, Double.parseDouble(jTextField52.getText()));
1257            update.setInt(4, Integer.parseInt(jTextField53.getText()));
1258            update.setString(5, jTextField54.getText());
1259            update.setInt(6, Integer.parseInt(jTextField49.getText()));
1260            update.executeUpdate();
1261            jTextArea1.append("Duomenys atnaujinti\n");
1262        }
1263        catch(Exception klaida) {
1264            jTextArea1.append("Klaida: "+klaida+"\n");
1265        }
1266    }                                         
1267
1268    private void jButton24ActionPerformed(java.awt.event.ActionEvent evt) {                                          
1269        // TODO add your handling code here:
1270    }                                         
1271
1272    private void jButton25ActionPerformed(java.awt.event.ActionEvent evt) {                                          
1273        // TODO add your handling code here:
1274    }                                         
1275
1276    private void jButton26ActionPerformed(java.awt.event.ActionEvent evt) {                                          
1277        // TODO add your handling code here:
1278    }                                         
1279
1280    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                         
1281        try {
1282            Connection rysininkas = gautiPrisijungima();
1283            PreparedStatement trinti = rysininkas.prepareStatement("DELETE FROM Darbuotojas WHERE DarbuotojoID=?");
1284            trinti.setInt(1, Integer.parseInt(jTextField3.getText()));
1285            trinti.executeUpdate();
1286            jTextArea1.append("Darbuotojas istrintas (arba tokio iraso nera)");
1287        }
1288        catch(Exception klaida) {
1289            jTextArea1.append("Klaida: "+klaida+"\n");
1290        }
1291    }                                        
1292
1293    private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {                                         
1294        try {
1295            Connection rysininkas = gautiPrisijungima();
1296            PreparedStatement trinti = rysininkas.prepareStatement("DELETE FROM Klientas WHERE KlientoID = " + Integer.parseInt(jTextField3.getText()));
1297            trinti.executeUpdate();
1298            jTextArea1.append("Klientas istrintas (arba tokio iraso nera)\n");
1299            }
1300            catch(Exception klaida) {
1301                jTextArea1.append("Klaida: "+klaida+"\n");
1302        }
1303    }                                        
1304
1305    private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {                                         
1306        try {
1307            Connection rysininkas = gautiPrisijungima();
1308            PreparedStatement trinti = rysininkas.prepareStatement("DELETE FROM Automobilis WHERE AutomobilioID = " + Integer.parseInt(jTextField3.getText()));
1309            trinti.executeUpdate();
1310            jTextArea1.append("Automobilis istrintas (arba tokio iraso nera)\n");
1311            }
1312            catch(Exception klaida) {
1313                jTextArea1.append("Klaida: "+klaida+"\n");
1314        }
1315    }                                        
1316
1317    private void jButton11ActionPerformed(java.awt.event.ActionEvent evt) {                                          
1318        try {
1319            Connection rysininkas = gautiPrisijungima();
1320            PreparedStatement sqluzklausa = rysininkas.prepareStatement("SELECT UzsakymoNr, DarbuotojoID, Data, Aprasymas, Kaina, AutomobilioID FROM Uzsakymas");
1321            ResultSet rezultatas = sqluzklausa.executeQuery();
1322            PreparedStatement sqluzklausa2 = rysininkas.prepareStatement("SELECT COUNT(UzsakymoNr) FROM Uzsakymas");
1323            ResultSet sk = sqluzklausa2.executeQuery();
1324            parodytiUzsakymus(rezultatas, sk);
1325        }
1326        catch(Exception klaida) {
1327            jTextArea1.append("Klaida: "+klaida+"\n");
1328        }
1329    }                                         
1330
1331    private void jButton10ActionPerformed(java.awt.event.ActionEvent evt) {                                          
1332        try {
1333            Connection rysininkas = gautiPrisijungima();
1334            PreparedStatement sqluzklausa = rysininkas.prepareStatement("SELECT KlientoID, Vardas, Pavarde, Adresas, Telefonas FROM Klientas");
1335            ResultSet rezultatas = sqluzklausa.executeQuery();
1336            PreparedStatement sqluzklausa2 = rysininkas.prepareStatement("SELECT COUNT(KlientoID) FROM Klientas");
1337            ResultSet sk = sqluzklausa2.executeQuery();
1338            parodytiKlientus(rezultatas, sk);
1339        }
1340        catch(Exception klaida) {
1341            jTextArea1.append("Klaida: "+klaida+"\n");
1342        }
1343    }                                         
1344
1345    private void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {                                         
1346        try {
1347            Connection rysininkas = gautiPrisijungima();
1348            PreparedStatement sqluzklausa = rysininkas.prepareStatement("SELECT AutomobilioID, Marke, Modelis, Metai, KlientoID FROM Automobilis");
1349            ResultSet rezultatas = sqluzklausa.executeQuery();
1350            PreparedStatement sqluzklausa2 = rysininkas.prepareStatement("SELECT COUNT(AutomobilioID) FROM Automobilis");
1351            ResultSet sk = sqluzklausa2.executeQuery();
1352            parodytiAutomobilius(rezultatas, sk);
1353        }
1354        catch(Exception klaida) {
1355            jTextArea1.append("Klaida: "+klaida+"\n");
1356        }
1357    }                                        
1358
1359    private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {                                         
1360        try {
1361            Connection rysininkas = gautiPrisijungima();
1362            PreparedStatement sqluzklausa = rysininkas.prepareStatement("SELECT DarbuotojoID, Vardas, Pavarde, Atlyginimas, Telefonas, Adresas FROM Darbuotojas");
1363            ResultSet rezultatas = sqluzklausa.executeQuery();
1364            PreparedStatement sqluzklausa2 = rysininkas.prepareStatement("SELECT COUNT(DarbuotojoID) FROM Darbuotojas");
1365            ResultSet sk = sqluzklausa2.executeQuery();
1366            parodytiDarbuotojus(rezultatas, sk);
1367        }
1368        catch(Exception klaida) {
1369            jTextArea1.append("Klaida: "+klaida+"\n");
1370        }
1371    }                                        
1372
1373    Connection gautiPrisijungima() {
1374        try {
1375            String valdiklis = "com.mysql.jdbc.Driver";
1376            Class.forName(valdiklis);
1377            String kelias = "jdbc:mysql://"+jTextField2.getText();
1378            Connection prisijungimas =  DriverManager.getConnection(kelias, jTextField1.getText(), String.valueOf(jPasswordField1.getPassword()));
1379            jLabel4.setText("Prisijungta");
1380            return prisijungimas;
1381        }
1382        catch(Exception klaida) {
1383            jTextArea1.append("Klaida jungiantis "+klaida+"\n");
1384            return null;
1385        }
1386    }
1387    
1388    void parodytiDarbuotojus(ResultSet a, ResultSet b) throws SQLException {
1389        int cx;
1390        if (b.next()) {
1391            cx = b.getInt(1);
1392            if (cx != 0) {
1393                jTextArea1.setText("Darbuotoju skaicius duomenu bazeje: " + cx + "\n");
1394                jTextArea1.append("Id - Vardas - Pavarde - Atlyginimas - Telefonas - Adresas\n");
1395                while (a.next()) {
1396                    jTextArea1.append(a.getInt(1) + " - " + a.getString(2) + " - " + a.getString(3) +  " - " + a.getDouble(4) + " - " + a.getInt(5) + " - " + a.getString(6) + "\n");
1397                }
1398            }
1399        }
1400        else {
1401            jTextArea1.setText("Darbuotoju duomenu bazeje nera");
1402        }
1403    }
1404    
1405    void parodytiKlientus(ResultSet a, ResultSet b) throws SQLException {
1406        int cx;
1407        if (b.next()) {
1408            cx = b.getInt(1);
1409            if (cx != 0) {
1410                jTextArea1.setText("Klientu skaicius duomenu bazeje: " + cx + "\n");
1411                jTextArea1.append("Id - Vardas - Pavarde - Adresas - Telefonas\n");
1412                while (a.next()) {
1413                    jTextArea1.append(a.getInt(1) + " - " + a.getString(2) + " - " + a.getString(3) + " - " + a.getString(4) + " - " + a.getInt(5) + "\n");
1414                }
1415            }
1416        }
1417        else {
1418            jTextArea1.setText("Klientu duomenu bazeje nera");
1419        }
1420    }
1421    
1422    void parodytiUzsakymus(ResultSet a, ResultSet b) throws SQLException {
1423        int cx;
1424        if (b.next()) {
1425            cx = b.getInt(1);
1426            if (cx != 0) {
1427                jTextArea1.setText("Uzsakymu skaicius duomenu bazeje: " + cx + "\n");
1428                jTextArea1.append("Nr - DarbuotojoID - Data - Aprasymas - Kaina - AutomobilioID\n");
1429                while (a.next()) {
1430                    jTextArea1.append(a.getInt(1) + " - " + a.getInt(2) + " - " + a.getDate(3) + " - " + a.getString(4) + " - " + a.getInt(5) + " - " + a.getInt(6) + "\n");
1431                }
1432            }
1433            else {
1434                jTextArea1.setText("Uzsakymu duomenu bazeje nera.");
1435            }
1436        }
1437    }
1438    
1439    void parodytiAutomobilius(ResultSet a, ResultSet b) throws SQLException {
1440        int cx;
1441        if (b.next()) {
1442            cx = b.getInt(1);
1443            if (cx != 0) {
1444                jTextArea1.setText("Automobiliu skaicius duomenu bazeje: " + cx + "\n");
1445                jTextArea1.append("ID - Marke - Modelis - Metai - KlientoID\n");
1446                while (a.next()) {
1447                    jTextArea1.append(a.getInt(1) + " - " + a.getString(2) + " - " + a.getString(3) + " - " + a.getInt(4) + " - " + a.getInt(5) + "\n");
1448                }
1449            }
1450            else {
1451                jTextArea1.setText("Automobiliu duomenu bazeje nera.");
1452            }
1453        }
1454    }
1455    
1456    void sukurtiLenteles() {
1457        Connection rysininkas = gautiPrisijungima();
1458        try {
1459            if (rysininkas != null)
1460            {
1461                PreparedStatement sqlkreipinys = rysininkas.prepareStatement("CREATE TABLE IF not exists Klientas (KlientoID int not null, Vardas varchar(20), Pavarde varchar(20), Adresas varchar(60), Telefonas int not null, primary key (KlientoID))");
1462                sqlkreipinys.executeUpdate();
1463                jTextArea1.append("LentelÄ— Klientas yra.\n");
1464                
1465                sqlkreipinys = rysininkas.prepareStatement("CREATE TABLE IF not exists Automobilis (AutomobilioID int not null, Marke varchar(20), Modelis varchar(20), Metai int, KlientoID int not null, primary key (AutomobilioID), foreign key (KlientoID) references Klientas (KlientoID))");
1466                sqlkreipinys.executeUpdate();
1467                jTextArea1.append("LentelÄ— Automobilis yra.\n");
1468                
1469                sqlkreipinys = rysininkas.prepareStatement("CREATE TABLE IF not exists Darbuotojas (DarbuotojoID int not null, Vardas varchar(20), Pavarde varchar(20), Atlyginimas double not null, Telefonas int not null, Adresas varchar(60), primary key (DarbuotojoID))");
1470                sqlkreipinys.executeUpdate();
1471                jTextArea1.append("LentelÄ— Darbuotojas yra.\n");
1472                
1473                sqlkreipinys = rysininkas.prepareStatement("CREATE TABLE IF not exists Uzsakymas (UzsakymoNr int not null, DarbuotojoID int not null, Data date not null, Aprasymas varchar(255), Kaina double not null, AutomobilioID int not null, primary key (UzsakymoNr), foreign key (AutomobilioID) references Automobilis (AutomobilioID), foreign key (DarbuotojoID) references Darbuotojas (DarbuotojoID))");
1474                sqlkreipinys.executeUpdate();
1475                jTextArea1.append("LentelÄ— Uzsakymas yra.\n");
1476            }
1477        }
1478        catch(Exception klaida) {
1479            jTextArea1.append("Klaida jungiantis "+klaida+"\n");
1480        }
1481    }
1482    
1483    void atsijunk() {
1484        Connection prisijungimas = gautiPrisijungima();
1485        if (prisijungimas != null) {
1486            try {
1487                prisijungimas.close();
1488                prisijungimas = null;
1489                jLabel4.setText("Neprisijunkta prie DB");
1490            }
1491            catch(Exception klaida) {
1492                jTextArea1.append("Klaida atsijungiant nuo DB");
1493            }
1494        }
1495    } 
1496    
1497    /**
1498     * @param args the command line arguments
1499     */
1500    public static void main(String args[]) {
1501        /* Set the Nimbus look and feel */
1502        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
1503        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
1504         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
1505         */
1506        try {
1507            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
1508                if ("Nimbus".equals(info.getName())) {
1509                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
1510                    break;
1511                }
1512            }
1513        } catch (ClassNotFoundException ex) {
1514            java.util.logging.Logger.getLogger(Langas.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
1515        } catch (InstantiationException ex) {
1516            java.util.logging.Logger.getLogger(Langas.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
1517        } catch (IllegalAccessException ex) {
1518            java.util.logging.Logger.getLogger(Langas.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
1519        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
1520            java.util.logging.Logger.getLogger(Langas.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
1521        }
1522        //</editor-fold>
1523
1524        /* Create and display the form */
1525        java.awt.EventQueue.invokeLater(new Runnable() {
1526            public void run() {
1527                new Langas().setVisible(true);
1528            }
1529        });
1530    }
1531
1532    // Variables declaration - do not modify                     
1533    private javax.swing.JButton jButton1;
1534    private javax.swing.JButton jButton10;
1535    private javax.swing.JButton jButton11;
1536    private javax.swing.JButton jButton15;
1537    private javax.swing.JButton jButton17;
1538    private javax.swing.JButton jButton19;
1539    private javax.swing.JButton jButton2;
1540    private javax.swing.JButton jButton21;
1541    private javax.swing.JButton jButton23;
1542    private javax.swing.JButton jButton24;
1543    private javax.swing.JButton jButton25;
1544    private javax.swing.JButton jButton26;
1545    private javax.swing.JButton jButton3;
1546    private javax.swing.JButton jButton4;
1547    private javax.swing.JButton jButton5;
1548    private javax.swing.JButton jButton6;
1549    private javax.swing.JButton jButton7;
1550    private javax.swing.JButton jButton8;
1551    private javax.swing.JButton jButton9;
1552    private javax.swing.JLabel jLabel1;
1553    private javax.swing.JLabel jLabel2;
1554    private javax.swing.JLabel jLabel3;
1555    private javax.swing.JLabel jLabel31;
1556    private javax.swing.JLabel jLabel32;
1557    private javax.swing.JLabel jLabel33;
1558    private javax.swing.JLabel jLabel34;
1559    private javax.swing.JLabel jLabel35;
1560    private javax.swing.JLabel jLabel36;
1561    private javax.swing.JLabel jLabel37;
1562    private javax.swing.JLabel jLabel38;
1563    private javax.swing.JLabel jLabel39;
1564    private javax.swing.JLabel jLabel4;
1565    private javax.swing.JLabel jLabel40;
1566    private javax.swing.JLabel jLabel41;
1567    private javax.swing.JLabel jLabel42;
1568    private javax.swing.JLabel jLabel43;
1569    private javax.swing.JLabel jLabel44;
1570    private javax.swing.JLabel jLabel45;
1571    private javax.swing.JLabel jLabel46;
1572    private javax.swing.JLabel jLabel47;
1573    private javax.swing.JLabel jLabel48;
1574    private javax.swing.JLabel jLabel49;
1575    private javax.swing.JLabel jLabel5;
1576    private javax.swing.JLabel jLabel50;
1577    private javax.swing.JLabel jLabel51;
1578    private javax.swing.JLabel jLabel52;
1579    private javax.swing.JLabel jLabel53;
1580    private javax.swing.JLabel jLabel54;
1581    private javax.swing.JLabel jLabel55;
1582    private javax.swing.JLabel jLabel56;
1583    private javax.swing.JLabel jLabel57;
1584    private javax.swing.JLabel jLabel58;
1585    private javax.swing.JLabel jLabel59;
1586    private javax.swing.JLabel jLabel6;
1587    private javax.swing.JLabel jLabel60;
1588    private javax.swing.JLabel jLabel61;
1589    private javax.swing.JLabel jLabel62;
1590    private javax.swing.JLabel jLabel63;
1591    private javax.swing.JLabel jLabel64;
1592    private javax.swing.JLabel jLabel65;
1593    private javax.swing.JLabel jLabel66;
1594    private javax.swing.JLabel jLabel67;
1595    private javax.swing.JLabel jLabel68;
1596    private javax.swing.JLabel jLabel69;
1597    private javax.swing.JLabel jLabel70;
1598    private javax.swing.JLabel jLabel71;
1599    private javax.swing.JLabel jLabel72;
1600    private javax.swing.JLabel jLabel73;
1601    private javax.swing.JLabel jLabel74;
1602    private javax.swing.JPanel jPanel1;
1603    private javax.swing.JPanel jPanel10;
1604    private javax.swing.JPanel jPanel11;
1605    private javax.swing.JPanel jPanel12;
1606    private javax.swing.JPanel jPanel13;
1607    private javax.swing.JPanel jPanel14;
1608    private javax.swing.JPanel jPanel2;
1609    private javax.swing.JPanel jPanel3;
1610    private javax.swing.JPanel jPanel7;
1611    private javax.swing.JPanel jPanel8;
1612    private javax.swing.JPanel jPanel9;
1613    private javax.swing.JPasswordField jPasswordField1;
1614    private javax.swing.JScrollPane jScrollPane1;
1615    private javax.swing.JTabbedPane jTabbedPane1;
1616    private javax.swing.JTabbedPane jTabbedPane2;
1617    private javax.swing.JTabbedPane jTabbedPane3;
1618    private javax.swing.JTextArea jTextArea1;
1619    private javax.swing.JTextField jTextField1;
1620    private javax.swing.JTextField jTextField2;
1621    private javax.swing.JTextField jTextField27;
1622    private javax.swing.JTextField jTextField28;
1623    private javax.swing.JTextField jTextField29;
1624    private javax.swing.JTextField jTextField3;
1625    private javax.swing.JTextField jTextField30;
1626    private javax.swing.JTextField jTextField31;
1627    private javax.swing.JTextField jTextField32;
1628    private javax.swing.JTextField jTextField33;
1629    private javax.swing.JTextField jTextField34;
1630    private javax.swing.JTextField jTextField35;
1631    private javax.swing.JTextField jTextField36;
1632    private javax.swing.JTextField jTextField37;
1633    private javax.swing.JTextField jTextField38;
1634    private javax.swing.JTextField jTextField39;
1635    private javax.swing.JTextField jTextField40;
1636    private javax.swing.JTextField jTextField41;
1637    private javax.swing.JTextField jTextField42;
1638    private javax.swing.JTextField jTextField43;
1639    private javax.swing.JTextField jTextField44;
1640    private javax.swing.JTextField jTextField45;
1641    private javax.swing.JTextField jTextField46;
1642    private javax.swing.JTextField jTextField47;
1643    private javax.swing.JTextField jTextField48;
1644    private javax.swing.JTextField jTextField49;
1645    private javax.swing.JTextField jTextField50;
1646    private javax.swing.JTextField jTextField51;
1647    private javax.swing.JTextField jTextField52;
1648    private javax.swing.JTextField jTextField53;
1649    private javax.swing.JTextField jTextField54;
1650    private javax.swing.JTextField jTextField55;
1651    private javax.swing.JTextField jTextField56;
1652    private javax.swing.JTextField jTextField57;
1653    private javax.swing.JTextField jTextField58;
1654    private javax.swing.JTextField jTextField59;
1655    private javax.swing.JTextField jTextField60;
1656    private javax.swing.JTextField jTextField61;
1657    private javax.swing.JTextField jTextField62;
1658    private javax.swing.JTextField jTextField63;
1659    private javax.swing.JTextField jTextField64;
1660    private javax.swing.JTextField jTextField65;
1661    private javax.swing.JTextField jTextField66;
1662    private javax.swing.JTextField jTextField67;
1663    private javax.swing.JTextField jTextField68;
1664    private javax.swing.JTextField jTextField69;
1665    private javax.swing.JTextField jTextField70;
1666    // End of variables declaration                   
1667}