API tools faq
paste
Guest User

Untitled

a guest
Jun 22nd, 2018
89
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 30.91 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. * To change this template, choose Tools | Templates
  3. * and open the template in the editor.
  4. */
  5.  
  6. /*
  7. * ApplicationForm.java
  8. *
  9. * Created on Jun 22, 2009, 9:07:18 AM
  10. */
  11.  
  12. package databaseproject;
  13.  
  14. import java.sql.Date;
  15. import javax.swing.JOptionPane;
  16.  
  17. /*
  18. *
  19. * @author user
  20. */
  21.  
  22. public class ApplicationForm extends javax.swing.JFrame {
  23. int index=0;
  24.  
  25. public ApplicationForm() {
  26. initComponents();
  27. }
  28.  
  29. /** This method is called from within the constructor to
  30. * initialize the form.
  31. * WARNING: Do NOT modify this code. The content of this method is
  32. * always regenerated by the Form Editor.
  33. */
  34. @SuppressWarnings("unchecked")
  35. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  36. private void initComponents() {
  37.  
  38. jLabel1 = new javax.swing.JLabel();
  39. Insertbutton = new javax.swing.JButton();
  40. jPanel1 = new javax.swing.JPanel();
  41. jLabel8 = new javax.swing.JLabel();
  42. Nametextfield = new javax.swing.JTextField();
  43. jLabel9 = new javax.swing.JLabel();
  44. Identitytextfield = new javax.swing.JTextField();
  45. jLabel10 = new javax.swing.JLabel();
  46. Surnametextfield = new javax.swing.JTextField();
  47. jLabel11 = new javax.swing.JLabel();
  48. Citytextfield = new javax.swing.JTextField();
  49. jLabel12 = new javax.swing.JLabel();
  50. Telephonetextfield = new javax.swing.JTextField();
  51. jLabel13 = new javax.swing.JLabel();
  52. Adresstextfield = new javax.swing.JTextField();
  53. Checkcitizenbutton = new javax.swing.JButton();
  54. jButton2 = new javax.swing.JButton();
  55. jButton3 = new javax.swing.JButton();
  56. jPanel2 = new javax.swing.JPanel();
  57. jLabel2 = new javax.swing.JLabel();
  58. jLabel3 = new javax.swing.JLabel();
  59. jLabel4 = new javax.swing.JLabel();
  60. jLabel5 = new javax.swing.JLabel();
  61. jLabel6 = new javax.swing.JLabel();
  62. jLabel7 = new javax.swing.JLabel();
  63. Prottextfield = new javax.swing.JTextField();
  64. Receivetextfield = new javax.swing.JTextField();
  65. Finishtextfield = new javax.swing.JTextField();
  66. Statecombobox = new javax.swing.JComboBox();
  67. Envelopefield = new javax.swing.JTextField();
  68. Ypalliloscombobox = new javax.swing.JComboBox();
  69. jButton4 = new javax.swing.JButton();
  70. jLabel14 = new javax.swing.JLabel();
  71.  
  72. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  73.  
  74. jLabel1.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N
  75. jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
  76. jLabel1.setText("ΣΤΟΙΧΕΙΑ ΑΙΤΗΣΗΣ");
  77.  
  78. Insertbutton.setText("ΚΑΤΑΧΩΡΗΣΗ ΑΙΤΗΣΗΣ");
  79. Insertbutton.addActionListener(new java.awt.event.ActionListener() {
  80. public void actionPerformed(java.awt.event.ActionEvent evt) {
  81. InsertbuttonActionPerformed(evt);
  82. }
  83. });
  84.  
  85. jPanel1.setBorder(javax.swing.BorderFactory.createEtchedBorder());
  86. jPanel1.setToolTipText("Στοιχεία συναλασσόμενου");
  87. jPanel1.setName(""); // NOI18N
  88.  
  89. jLabel8.setText("ΟΝΟΜΑ");
  90.  
  91. jLabel9.setText("A.TAYTOTHTAS");
  92.  
  93. jLabel10.setText("ΕΠΩΝΥΜΟ");
  94.  
  95. jLabel11.setText("ΠΟΛΗ");
  96.  
  97. jLabel12.setText("ΤΗΛΕΦΩΝΟ");
  98.  
  99. jLabel13.setText("ΔΙΕΥΘΥΝΣΗ");
  100.  
  101. Checkcitizenbutton.setText("ΕΛΕΓΧΟΣ ΚΑΤΑΧΩΡΗΣΗΣ ΠΟΛΙΤΗ");
  102. Checkcitizenbutton.addActionListener(new java.awt.event.ActionListener() {
  103. public void actionPerformed(java.awt.event.ActionEvent evt) {
  104. CheckcitizenbuttonActionPerformed(evt);
  105. }
  106. });
  107.  
  108. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  109. jPanel1.setLayout(jPanel1Layout);
  110. jPanel1Layout.setHorizontalGroup(
  111. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  112. .addGroup(jPanel1Layout.createSequentialGroup()
  113. .addContainerGap()
  114. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  115. .addGroup(jPanel1Layout.createSequentialGroup()
  116. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  117. .addComponent(jLabel12)
  118. .addComponent(jLabel10)
  119. .addComponent(jLabel9)
  120. .addComponent(jLabel13)
  121. .addComponent(jLabel8))
  122. .addGap(18, 18, 18)
  123. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  124. .addGroup(jPanel1Layout.createSequentialGroup()
  125. .addComponent(Identitytextfield, javax.swing.GroupLayout.PREFERRED_SIZE, 151, javax.swing.GroupLayout.PREFERRED_SIZE)
  126. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  127. .addComponent(Checkcitizenbutton))
  128. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  129. .addComponent(Adresstextfield, javax.swing.GroupLayout.Alignment.LEADING)
  130. .addComponent(Telephonetextfield, javax.swing.GroupLayout.Alignment.LEADING)
  131. .addComponent(Surnametextfield, javax.swing.GroupLayout.Alignment.LEADING)
  132. .addComponent(Citytextfield)
  133. .addComponent(Nametextfield, javax.swing.GroupLayout.DEFAULT_SIZE, 151, Short.MAX_VALUE))))
  134. .addComponent(jLabel11))
  135. .addContainerGap(102, Short.MAX_VALUE))
  136. );
  137. jPanel1Layout.setVerticalGroup(
  138. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  139. .addGroup(jPanel1Layout.createSequentialGroup()
  140. .addGap(31, 31, 31)
  141. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  142. .addComponent(jLabel9)
  143. .addComponent(Identitytextfield, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE)
  144. .addComponent(Checkcitizenbutton))
  145. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  146. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  147. .addGroup(jPanel1Layout.createSequentialGroup()
  148. .addComponent(Nametextfield, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  149. .addGap(9, 9, 9))
  150. .addGroup(jPanel1Layout.createSequentialGroup()
  151. .addComponent(jLabel8)
  152. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)))
  153. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  154. .addComponent(Surnametextfield, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)
  155. .addComponent(jLabel10))
  156. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  157. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  158. .addGroup(jPanel1Layout.createSequentialGroup()
  159. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  160. .addComponent(jLabel13)
  161. .addComponent(Adresstextfield, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  162. .addGap(11, 11, 11)
  163. .addComponent(jLabel11))
  164. .addComponent(Citytextfield, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE))
  165. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  166. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  167. .addComponent(jLabel12, javax.swing.GroupLayout.PREFERRED_SIZE, 19, javax.swing.GroupLayout.PREFERRED_SIZE)
  168. .addComponent(Telephonetextfield, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  169. .addContainerGap(64, Short.MAX_VALUE))
  170. );
  171.  
  172. jButton2.setText("ΚΑΘΑΡΙΣΜΟΣ ΦΟΡΜΑΣ ΓΙΑ ΚΑΤΑΧΩΡΗΣΗ ΝΕΑΣ ΑΙΤΗΣΗΣ");
  173. jButton2.addActionListener(new java.awt.event.ActionListener() {
  174. public void actionPerformed(java.awt.event.ActionEvent evt) {
  175. jButton2ActionPerformed(evt);
  176. }
  177. });
  178.  
  179. jButton3.setText("ΕΠΙΣΤΡΟΦΗ ΣΤΟ ΚΕΝΤΡΙΚΟ ΜΕΝΟΥ");
  180.  
  181. jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
  182.  
  183. jLabel2.setText("Α.ΠΡΩΤΟΚΟΛΛΟΥ");
  184.  
  185. jLabel3.setText("ΧΡΕΩΣΗ ΣΕ ΥΠΑΛΛΗΛΟ");
  186.  
  187. jLabel4.setText("ΗΜΕΡΟΜΗΝΙΑ ΚΑΤΑΘΕΣΗΣ");
  188.  
  189. jLabel5.setText("ΗΜΕΡΟΜΗΝΙΑ ΔΙΕΚΠΕΡΑΙΩΣΗΣ");
  190.  
  191. jLabel6.setText("ΚΑΤΑΣΤΑΣΗ ΑΙΤΗΣΗΣ");
  192.  
  193. jLabel7.setText("ΦΑΚΕΛΟΣ");
  194.  
  195. Statecombobox.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "ΑΝΟΙΧΤΗ", "ΚΛΕΙΣΤΗ" }));
  196. Statecombobox.addActionListener(new java.awt.event.ActionListener() {
  197. public void actionPerformed(java.awt.event.ActionEvent evt) {
  198. StatecomboboxActionPerformed(evt);
  199. }
  200. });
  201.  
  202. Ypalliloscombobox.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "101", "102", "103" }));
  203. Ypalliloscombobox.addActionListener(new java.awt.event.ActionListener() {
  204. public void actionPerformed(java.awt.event.ActionEvent evt) {
  205. YpalliloscomboboxActionPerformed(evt);
  206. }
  207. });
  208.  
  209. javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
  210. jPanel2.setLayout(jPanel2Layout);
  211. jPanel2Layout.setHorizontalGroup(
  212. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  213. .addGroup(jPanel2Layout.createSequentialGroup()
  214. .addContainerGap()
  215. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  216. .addGroup(jPanel2Layout.createSequentialGroup()
  217. .addComponent(jLabel2)
  218. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 116, Short.MAX_VALUE)
  219. .addComponent(Prottextfield, javax.swing.GroupLayout.PREFERRED_SIZE, 146, javax.swing.GroupLayout.PREFERRED_SIZE)
  220. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED))
  221. .addGroup(jPanel2Layout.createSequentialGroup()
  222. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  223. .addComponent(jLabel4)
  224. .addComponent(jLabel5)
  225. .addComponent(jLabel6)
  226. .addComponent(jLabel7)
  227. .addComponent(jLabel3))
  228. .addGap(53, 53, 53)
  229. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  230. .addComponent(Finishtextfield, javax.swing.GroupLayout.DEFAULT_SIZE, 146, Short.MAX_VALUE)
  231. .addComponent(Envelopefield, javax.swing.GroupLayout.DEFAULT_SIZE, 146, Short.MAX_VALUE)
  232. .addComponent(Receivetextfield, javax.swing.GroupLayout.DEFAULT_SIZE, 146, Short.MAX_VALUE)
  233. .addComponent(Ypalliloscombobox, 0, 146, Short.MAX_VALUE)
  234. .addComponent(Statecombobox, 0, 146, Short.MAX_VALUE))))
  235. .addGap(196, 196, 196))
  236. );
  237. jPanel2Layout.setVerticalGroup(
  238. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  239. .addGroup(jPanel2Layout.createSequentialGroup()
  240. .addContainerGap()
  241. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  242. .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 12, javax.swing.GroupLayout.PREFERRED_SIZE)
  243. .addComponent(Prottextfield, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  244. .addGap(18, 18, 18)
  245. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  246. .addComponent(jLabel3)
  247. .addComponent(Ypalliloscombobox, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  248. .addGap(18, 18, 18)
  249. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  250. .addComponent(jLabel4)
  251. .addComponent(Receivetextfield, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  252. .addGap(29, 29, 29)
  253. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  254. .addComponent(jLabel5)
  255. .addComponent(Finishtextfield, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  256. .addGap(18, 18, 18)
  257. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  258. .addComponent(jLabel6)
  259. .addComponent(Statecombobox, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  260. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  261. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  262. .addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 18, javax.swing.GroupLayout.PREFERRED_SIZE)
  263. .addComponent(Envelopefield, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE))
  264. .addContainerGap(63, Short.MAX_VALUE))
  265. );
  266.  
  267. jButton4.setText("ΕΞΟΔΟΣ");
  268.  
  269. jLabel14.setFont(new java.awt.Font("Arial", 1, 14)); // NOI18N
  270. jLabel14.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
  271. jLabel14.setText("ΣΤΟΙΧΕΙΑ ΣΥΝΑΛΑΣΣΟΜΕΝΟΥ");
  272.  
  273. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  274. getContentPane().setLayout(layout);
  275. layout.setHorizontalGroup(
  276. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  277. .addGroup(layout.createSequentialGroup()
  278. .addContainerGap()
  279. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  280. .addGroup(layout.createSequentialGroup()
  281. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  282. .addComponent(jButton4, javax.swing.GroupLayout.DEFAULT_SIZE, 247, Short.MAX_VALUE)
  283. .addComponent(Insertbutton, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 247, Short.MAX_VALUE))
  284. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  285. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  286. .addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  287. .addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
  288. .addComponent(jLabel14, javax.swing.GroupLayout.PREFERRED_SIZE, 560, javax.swing.GroupLayout.PREFERRED_SIZE)
  289. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  290. .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  291. .addComponent(jLabel1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  292. .addComponent(jPanel1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
  293. .addContainerGap())
  294. );
  295. layout.setVerticalGroup(
  296. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  297. .addGroup(layout.createSequentialGroup()
  298. .addGap(24, 24, 24)
  299. .addComponent(jLabel14, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE)
  300. .addGap(22, 22, 22)
  301. .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  302. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  303. .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE)
  304. .addGap(18, 18, 18)
  305. .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  306. .addGap(22, 22, 22)
  307. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  308. .addComponent(Insertbutton)
  309. .addComponent(jButton2))
  310. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  311. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  312. .addComponent(jButton4)
  313. .addComponent(jButton3))
  314. .addGap(23, 23, 23))
  315. );
  316.  
  317. jPanel1.getAccessibleContext().setAccessibleName("");
  318.  
  319. pack();
  320. }// </editor-fold>
  321. public Date Convertstrtodate(String s)
  322. {
  323. String[] parts1 = s.split("/");
  324. int day1 = new Integer(parts1[0]).intValue();
  325. int month1 = new Integer(parts1[1]).intValue();
  326. int year1 = new Integer(parts1[2]).intValue();
  327. Date Start = new Date(year1-1900, month1-1, day1);
  328. return Start;
  329. }
  330.  
  331.  
  332.  
  333. private void StatecomboboxActionPerformed(java.awt.event.ActionEvent evt) {
  334. // TODO add your handling code here:
  335. }
  336.  
  337. private void InsertbuttonActionPerformed(java.awt.event.ActionEvent evt) {
  338.  
  339. System.out.println(index);
  340.  
  341. if(index==0)
  342. {
  343. JOptionPane.showMessageDialog(this, "ΚΑΝΤΕ ΠΡΩΤΑ ΕΛΕΓΧΟ ΚΑΤΑΧΩΡΗΣΗΣ ΠΟΛΙΤΗ");
  344.  
  345. }
  346.  
  347. else if(index==2)
  348. {
  349.  
  350. Dbconnection db= new Dbconnection();
  351. db.connect();
  352. String aprotok = Prottextfield.getText();
  353. String ypallhlos= (String) Ypalliloscombobox.getSelectedItem();
  354. String lhpsh = Receivetextfield.getText();
  355. String diekperaiwsh = Finishtextfield.getText();
  356. String katastash = (String) Statecombobox.getSelectedItem();
  357. String fakelos = Envelopefield.getText();
  358.  
  359.  
  360.  
  361. String identity= Identitytextfield.getText();
  362. String name= Nametextfield.getText();
  363. String surname = Surnametextfield.getText();
  364. String adress = Adresstextfield.getText();
  365. String city = Citytextfield.getText();
  366. String telephone = Telephonetextfield.getText();
  367.  
  368.  
  369.  
  370. Date hmlhpshs= Convertstrtodate(lhpsh);
  371. Date hmdiekp= Convertstrtodate(diekperaiwsh);
  372.  
  373.  
  374.  
  375.  
  376. int aInt = Integer.parseInt(aprotok);
  377. int bInt = Integer.parseInt(ypallhlos);
  378. int cInt = Integer.parseInt(telephone);
  379. Application aithsh= new Application(aInt,identity,bInt,katastash,fakelos,hmlhpshs,hmdiekp);
  380. db.insertApplication(aithsh);
  381. Citizen cit= new Citizen(identity,name,surname,adress,city,cInt);
  382. db.insertCitizen(cit);
  383. db.disconnect();
  384. Insertbutton.setEnabled(false);
  385. Checkcitizenbutton.setEnabled(false);
  386. }
  387. else if(index==1)
  388. {
  389. Dbconnection db= new Dbconnection();
  390. db.connect();
  391.  
  392. String aprotok = Prottextfield.getText();
  393. String ypallhlos= (String) Ypalliloscombobox.getSelectedItem();
  394. String lhpsh = Receivetextfield.getText();
  395. String diekperaiwsh = Finishtextfield.getText();
  396. String katastash = (String) Statecombobox.getSelectedItem();
  397. String fakelos = Envelopefield.getText();
  398. String identity= Identitytextfield.getText();
  399.  
  400.  
  401. Date hmlhpshs= Convertstrtodate(lhpsh);
  402. Date hmdiekp= Convertstrtodate(diekperaiwsh);
  403.  
  404. int aInt = Integer.parseInt(aprotok);
  405. int bInt = Integer.parseInt(ypallhlos);
  406.  
  407. Application aithsh= new Application(aInt,identity,bInt,katastash,fakelos,hmlhpshs,hmdiekp);
  408. db.insertApplication(aithsh);
  409. db.disconnect();
  410. Insertbutton.setEnabled(false);
  411. Checkcitizenbutton.setEnabled(false);
  412. }
  413.  
  414.  
  415.  
  416. }
  417.  
  418. private void CheckcitizenbuttonActionPerformed(java.awt.event.ActionEvent evt) {
  419.  
  420.  
  421. Dbconnection db= new Dbconnection();
  422. db.connect();
  423. String identity=Identitytextfield.getText();
  424. if (identity.equals(""))
  425. {
  426. JOptionPane.showMessageDialog(this, "ΕΙΣΑΓΕΤΕ ΠΡΩΤΑ ΑΡΙΘΜΟ ΤΑΥΤΟΤΗΤΑΣ");}
  427.  
  428. else
  429. {
  430. System.out.println(db.CheckExistingCitizen(identity));
  431. if (db.CheckExistingCitizen(identity)!=0)
  432. {
  433. this.Identitytextfield.setEditable(false);
  434. this.Nametextfield.setEditable(false);
  435. this.Surnametextfield.setEditable(false);
  436. this.Adresstextfield.setEditable(false);
  437. this.Citytextfield.setEditable(false);
  438. this.Telephonetextfield.setEditable(false);
  439. JOptionPane.showMessageDialog(this,"O ΠΟΛΙΤΗΣ ΕΙΝΑΙ ΚΑΤΑΧΩΡΗΜΕΝΟΣ. ΚΑΤΑΧΩΡΕΙΣΤΕ ΜΟΝΟ ΤΑ ΣΤΟΙΧΕΙΑ ΤΗΣ ΑΙΤΗΣΗΣ!!" );
  440. index=1;
  441. }
  442.  
  443. else
  444. {
  445. this.Identitytextfield.setEditable(false);
  446. JOptionPane.showMessageDialog(this,"O ΠΟΛΙΤΗΣ ΔΕΝ ΕΧΕΙ ΚΑΤΑΧΩΡΗΘΕΙ. ΚΑΤΑΧΩΡΕΙΣΤΕ ΚΑΙ ΤΑ ΥΠΟΛΟΙΠΑ ΣΤΟΙΧΕΙΑ ΤΟΥ!!" );
  447. index=2;
  448.  
  449.  
  450. }
  451. }
  452.  
  453. db.disconnect();
  454.  
  455. }
  456.  
  457. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  458.  
  459. index=0;
  460. Prottextfield.setText("");
  461. Receivetextfield.setText("");
  462. Finishtextfield.setText("");
  463. Envelopefield.setText("");
  464. Identitytextfield.setText("");
  465.  
  466. Nametextfield.setText("");
  467. Surnametextfield.setText("");
  468. Adresstextfield.setText("");
  469. Citytextfield.setText("");
  470. Telephonetextfield.setText("");
  471.  
  472. Nametextfield.setEditable(true);
  473. Surnametextfield.setEditable(true);
  474. Adresstextfield.setEditable(true);
  475. Citytextfield.setEditable(true);
  476. Telephonetextfield.setEditable(true);
  477. Identitytextfield.setEditable(true);
  478.  
  479. Insertbutton.setEnabled(true);
  480. Checkcitizenbutton.setEnabled(true);
  481.  
  482.  
  483. }
  484.  
  485. private void YpalliloscomboboxActionPerformed(java.awt.event.ActionEvent evt) {
  486. // TODO add your handling code here:
  487. }
  488.  
  489. /**
  490. * @param args the command line arguments
  491. */
  492. public static void main(String args[]) {
  493. java.awt.EventQueue.invokeLater(new Runnable() {
  494. public void run() {
  495. new ApplicationForm().setVisible(true);
  496. }
  497. });
  498. }
  499.  
  500. // Variables declaration - do not modify
  501. private javax.swing.JTextField Adresstextfield;
  502. private javax.swing.JButton Checkcitizenbutton;
  503. private javax.swing.JTextField Citytextfield;
  504. private javax.swing.JTextField Envelopefield;
  505. private javax.swing.JTextField Finishtextfield;
  506. private javax.swing.JTextField Identitytextfield;
  507. private javax.swing.JButton Insertbutton;
  508. private javax.swing.JTextField Nametextfield;
  509. private javax.swing.JTextField Prottextfield;
  510. private javax.swing.JTextField Receivetextfield;
  511. private javax.swing.JComboBox Statecombobox;
  512. private javax.swing.JTextField Surnametextfield;
  513. private javax.swing.JTextField Telephonetextfield;
  514. private javax.swing.JComboBox Ypalliloscombobox;
  515. private javax.swing.JButton jButton2;
  516. private javax.swing.JButton jButton3;
  517. private javax.swing.JButton jButton4;
  518. private javax.swing.JLabel jLabel1;
  519. private javax.swing.JLabel jLabel10;
  520. private javax.swing.JLabel jLabel11;
  521. private javax.swing.JLabel jLabel12;
  522. private javax.swing.JLabel jLabel13;
  523. private javax.swing.JLabel jLabel14;
  524. private javax.swing.JLabel jLabel2;
  525. private javax.swing.JLabel jLabel3;
  526. private javax.swing.JLabel jLabel4;
  527. private javax.swing.JLabel jLabel5;
  528. private javax.swing.JLabel jLabel6;
  529. private javax.swing.JLabel jLabel7;
  530. private javax.swing.JLabel jLabel8;
  531. private javax.swing.JLabel jLabel9;
  532. private javax.swing.JPanel jPanel1;
  533. private javax.swing.JPanel jPanel2;
  534. // End of variables declaration
  535.  
  536. }
  537.  
  538.  
  539.  
  540.  
  541.  
  542.  
  543.  
  544.  
  545. /*
  546. * To change this template, choose Tools | Templates
  547. * and open the template in the editor.
  548. */
  549.  
  550. package databaseproject;
  551.  
  552. import java.sql.Connection;
  553. import java.sql.DriverManager;
  554. import java.sql.ResultSet;
  555. import java.sql.SQLException;
  556. import java.sql.Statement;
  557. import java.util.logging.Level;
  558. import java.util.logging.Logger;
  559.  
  560. /**
  561. *
  562. * @author 312user
  563. */
  564. public class Dbconnection {
  565.  
  566.  
  567. Connection con;
  568. private Statement stmt;
  569. ResultSet srs;
  570.  
  571. public void connect()
  572. {
  573. try {
  574. Class.forName("jstels.jdbc.mdb.MDBDriver");
  575. this.con = DriverManager.getConnection("jdbc:jstels:mdb:c:/java/protokolo.mdb");
  576. this.stmt = con.createStatement();
  577. } catch (SQLException ex) {
  578. Logger.getLogger(Dbconnection.class.getName()).log(Level.SEVERE, null, ex);
  579. } catch (ClassNotFoundException ex) {
  580. Logger.getLogger(Dbconnection.class.getName()).log(Level.SEVERE, null, ex);
  581. }
  582. }
  583. public void disconnect()
  584.  
  585. {
  586. try {
  587. this.con.close();
  588. } catch (SQLException ex) {
  589. Logger.getLogger(Dbconnection.class.getName()).log(Level.SEVERE, null, ex);
  590. }
  591. }
  592. public void insertCitizen(Citizen h)
  593. {
  594. try {
  595. String sql = "INSERT INTO CITIZENS VALUES('" + h.identity + "','" + h.name + "','" + h.surname + "','"+h.adress+"','"+h.city+"',"+h.telephone+")";
  596. this.stmt.execute(sql);
  597. } catch (SQLException ex) {
  598. Logger.getLogger(Dbconnection.class.getName()).log(Level.SEVERE, null, ex);
  599. }
  600.  
  601. }
  602. public void deleteCitizen(String i)
  603. {
  604. try {
  605. String sql = "DELETE FROM CITIZENS WHERE IDNUMBER = '"+i+"'";
  606. this.stmt.execute(sql);
  607. } catch (SQLException ex) {
  608. Logger.getLogger(Dbconnection.class.getName()).log(Level.SEVERE, null, ex);
  609. }
  610.  
  611. }
  612. public void selectCitizen()
  613. {
  614. try {
  615. try {
  616. stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  617. srs = stmt.executeQuery("SELECT * FROM CITIZENS");
  618. } catch (SQLException ex) {
  619. Logger.getLogger(Dbconnection.class.getName()).log(Level.SEVERE, null, ex);
  620. }
  621. while (srs.next()) {
  622. String name = srs.getString("NAME");
  623. String surname = srs.getString("SURNAME");
  624. System.out.println(name + " " + surname);
  625. }
  626. } catch (SQLException ex) {
  627. Logger.getLogger(Dbconnection.class.getName()).log(Level.SEVERE, null, ex);
  628. }
  629.  
  630.  
  631.  
  632.  
  633.  
  634. }
  635.  
  636. public void insertApplication(Application h)
  637. {
  638. try {
  639. String sql = "INSERT INTO APPLICATION VALUES(" + h.getProtocol() + ",'" + h.getIdentity() + "'," + h.getEmployeecode() + ",'"+h.getState()+"','"+h.getEnvelope()+"','"+h.getReceivedate().toString()+"','"+h.getEnddate().toString()+"')";
  640. this.stmt.execute(sql);
  641. } catch (SQLException ex) {
  642. Logger.getLogger(Dbconnection.class.getName()).log(Level.SEVERE, null, ex);
  643. }
  644.  
  645. }
  646.  
  647. public int CheckExistingCitizen(String s)
  648. {
  649. int i = 0;
  650. try {
  651. String sql = "SELECT IDNUMBER from CITIZENS where IDNUMBER='"+s+"'";
  652. ResultSet apantiseis = this.stmt.executeQuery(sql);
  653.  
  654. while ( apantiseis.next() )
  655. {i++;}
  656.  
  657. } catch (SQLException ex) {
  658. Logger.getLogger(Dbconnection.class.getName()).log(Level.SEVERE, null, ex);
  659. }
  660.  
  661. return i;
  662. }
  663.  
  664. }
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!