Guest User

Untitled

a guest
Jul 22nd, 2018
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 66.03 KB | None | 0 0
  1. import javax.swing.*;
  2. import java.awt.*;
  3. import java.awt.event.*;
  4. import java.sql.*;
  5. import javax.swing.JOptionPane;
  6. public class DBGui implements ActionListener
  7. {
  8. static Connection con;
  9. String userName;
  10. int userLevel ;
  11.  
  12. int width = 500;
  13. int height = 700;
  14.  
  15. String [] [] data = new String[10000][8];
  16. String tourCol[] = {"Name","Description","StartDate","EndDate","Type","StartCeremonyDate","ClosingCeremonyDate","ID"};
  17. String matchCol [] = {"ID","NumberOfSeats","MatchWeight","Location","TournamentID","FirstTeam","SecondTeam"};
  18. String ticketCol[] = {"Seat Number","Category","User Name","Match ID","Ticket ID","Price"};
  19. JFrame frame ;
  20. JScrollPane scrollPane ;
  21. JScrollPane scrollPaneViewTour;
  22. JScrollPane scrollPanelViewMatch;
  23. /*************************************************** WelcomePanel ****************************************************/
  24. JPanel welcomePanel;
  25. JLabel nameWelcomePanelLabel;
  26. JLabel passwordWelcomePanelLabel;
  27. JTextField nameWelcomePanel;
  28. JPasswordField passwordWelcomePanel;
  29. JButton loginWelcomePanel;
  30. JButton regWelcomePanel;
  31. ImageIcon ballIcon ;
  32. JLabel ballLabel ;
  33. /*************************************************** WelcomePanel ****************************************************/
  34.  
  35. /*************************************************** RegPanel ****************************************************/
  36. JPanel regPanel;
  37. JLabel firstNameLabel;
  38. JLabel middleNameLabel;
  39. JLabel lastNameLabel;
  40. JLabel telephoneLabel;
  41. JLabel mailLabel;
  42. JLabel userNameLabel;
  43. JLabel passwordLabel;
  44. JLabel retypePasswordLabel;
  45. JLabel countryLabel ;
  46. JLabel mobileLabel;
  47. JButton regButtonRegPanel ;
  48. JLabel dateOfBirthLabel;
  49. JButton back ;
  50.  
  51. JTextField firstNameField;
  52. JTextField middleNameField;
  53. JTextField lastNameField;
  54. JTextField telephoneField;
  55. JTextField mailField;
  56. JTextField userNameField;
  57. JPasswordField passwordField;
  58. JPasswordField retypePasswordField;
  59. JTextField countryField;
  60. JTextField dateOfBirthField;
  61. JTextField mobileField;
  62. /*************************************************** RegPanel ****************************************************/
  63.  
  64. /*************************************************** lowAdminPanel ****************************************************/
  65. JPanel lowAdminPanel;
  66. JButton viewTourL;
  67. JButton viewMatchL;
  68. JButton createMatch;
  69. JButton editMatch;
  70. JButton deleteMatch;
  71. JButton logOutL;
  72. /*************************************************** lowAdminPanel ****************************************************/
  73.  
  74. /*************************************************** highAdminPanel ****************************************************/
  75. JPanel highAdminPanel;
  76. JButton viewTourH;
  77. JButton viewMatchH;
  78. JButton createMatchH;
  79. JButton editMatchH;
  80. JButton deleteMatchH;
  81. JButton createTourH;
  82. JButton editTourH;
  83. JButton deleteTourH;
  84. JButton logOutH;
  85. /*************************************************** highAdminPanel ****************************************************/
  86.  
  87. /*************************************************** userPanel ****************************************************/
  88. JPanel userPanel;
  89. JButton userUpdate;
  90. JButton userView;
  91. JButton userReserve;
  92. JButton userFind;
  93. JButton userCancel;
  94. JButton userTour;
  95. JButton userMatch;
  96. JButton logOutR;
  97. /*************************************************** userPanel ****************************************************/
  98.  
  99. /*************************************************** createTournamentPanel ****************************************************/
  100. JPanel createTournamentPanel;
  101. JTextField tourDescripField;
  102. JTextField tourNameField;
  103. JTextField tourStartDateField;
  104. JTextField tourEndDateField;
  105. JTextField tourTypeField;
  106. JTextField tourOpenDateField;
  107. JTextField tourCloseDateField;
  108.  
  109. JLabel tourDescripLabel;
  110. JLabel tourNameLabel;
  111. JLabel tourStartDateLabel;
  112. JLabel tourEndDateLabel;
  113. JLabel tourTypeLabel;
  114. JLabel tourOpenDateLabel;
  115. JLabel tourCloseDateLabel;
  116.  
  117. JButton createTourBack;
  118. JButton createCurrentTour;
  119. /*************************************************** createTournamentPanel ****************************************************/
  120.  
  121. /*************************************************** createMatchPanel ****************************************************/
  122. JPanel createMatchPanel;
  123. JTextField numOfSeatsField;
  124. JTextField matchWeightField;
  125. JTextField locationField;
  126. JTextField tourIdField;
  127. JTextField firstTeamField;
  128. JTextField secondTeamField;
  129.  
  130. JLabel numOfSeatsLabel;
  131. JLabel matchWeightLabel;
  132. JLabel locationLabel;
  133. JLabel tourIdLabel;
  134. JLabel firstTeamLabel;
  135. JLabel secondTeamLabel;
  136.  
  137. JButton createMatchBack;
  138. JButton createCurrentMatch;
  139. /*************************************************** createMatchPanel ****************************************************/
  140.  
  141. /*************************************************** removeTournamentPanel ****************************************************/
  142. JPanel removeTournamentPanel;
  143. JTextField removeTourIdField;
  144. JLabel removeTourIdLabel;
  145. JButton removeCurrentTour;
  146. JButton removeTourBack;
  147. /*************************************************** removeTournamentPanel ****************************************************/
  148.  
  149. /*************************************************** removeMatchPanel ****************************************************/
  150. JPanel removeMatchPanel;
  151. JTextField removeMatchIdField;
  152. JLabel removeMatchIdLabel;
  153. JButton removeCurrentMatch;
  154. JButton removeMatchBack;
  155. /*************************************************** removeMatchPanel ****************************************************/
  156.  
  157. /*************************************************** reserveTicketPanel ****************************************************/
  158. JPanel reserveTicketPanel;
  159. JTable reserveTicketTable;
  160. JTextField reserveTicketField;
  161. JLabel reserveTicketLabel;
  162. JButton reserveTicketBack;
  163. JButton reserveCurrentTicket;
  164. JButton cancelReserveTicket;
  165. /*************************************************** reserveTicketPanel ****************************************************/
  166.  
  167. /*************************************************** viewTournamentsPanel ****************************************************/
  168. JPanel viewTourPanel;
  169. JTable viewTourTable;
  170. JScrollPane viewTourPane;
  171. JButton viewTourBack;
  172. /*************************************************** viewTournamentsPanel ****************************************************/
  173.  
  174. /*************************************************** viewMatchesPanel ****************************************************/
  175. JPanel viewMatchPanel;
  176. JTable viewMatchTable;
  177. JScrollPane viewMatchPane;
  178. JButton viewMatchBack;
  179. /*************************************************** viewMatchesPanel ****************************************************/
  180.  
  181. /*************************************************** findMatchesPanel ****************************************************/
  182. JPanel findMatchesPanel;
  183. JTextField findMatchesField;
  184. JLabel findMatchesLabel;
  185. JButton findMatchesBack;
  186. JButton findMatchesFind;
  187. JTable findMatchesTable;
  188. JScrollPane findMatchesPane;
  189. /*************************************************** findMatchesPanel ****************************************************/
  190.  
  191. /*************************************************** editProfilePanel ****************************************************/
  192. JPanel regPanelU;
  193. JLabel firstNameLabelU;
  194. JLabel middleNameLabelU;
  195. JLabel lastNameLabelU;
  196. JLabel telephoneLabelU;
  197. JLabel mailLabelU;
  198. JLabel passwordLabelU;
  199. JLabel retypePasswordLabelU;
  200. JLabel countryLabelU;
  201. JLabel mobileLabelU;
  202. JButton updateButtonRegPanel;
  203. JLabel dateOfBirthLabelU;
  204. JButton backU;
  205.  
  206. JTextField firstNameFieldU;
  207. JTextField middleNameFieldU;
  208. JTextField lastNameFieldU;
  209. JTextField telephoneFieldU;
  210. JTextField mailFieldU;
  211. JPasswordField passwordFieldU;
  212. JPasswordField retypePasswordFieldU;
  213. JTextField countryFieldU;
  214. JTextField dateOfBirthFieldU;
  215. JTextField mobileFieldU;
  216. /*************************************************** editProfilePanel ****************************************************/
  217.  
  218. /*************************************************** editTourPanel ****************************************************/
  219. JPanel createTournamentPanelU ;
  220. JTextField tourDescripFieldU;
  221. JTextField tourNameFieldU;
  222. JTextField tourStartDateFieldU;
  223. JTextField tourEndDateFieldU;
  224. JTextField tourTypeFieldU;
  225. JTextField tourOpenDateFieldU;
  226. JTextField tourCloseDateFieldU;
  227. JTextField tourIdFieldU;
  228.  
  229. JLabel tourDescripLabelU;
  230. JLabel tourNameLabelU;
  231. JLabel tourStartDateLabelU;
  232. JLabel tourEndDateLabelU;
  233. JLabel tourTypeLabelU;
  234. JLabel tourOpenDateLabelU;
  235. JLabel tourCloseDateLabelU;
  236. JLabel tourIdLabelU;
  237.  
  238. JButton createTourBackU;
  239. JButton createCurrentTourU;
  240. /*************************************************** editTourPanel ****************************************************/
  241.  
  242. /*************************************************** editMatchPanel ****************************************************/
  243. JPanel createMatchPanelU;
  244. JTextField numOfSeatsFieldU;
  245. JTextField matchWeightFieldU;
  246. JTextField locationFieldU;
  247. JTextField tourIdFieldUP;
  248. JTextField firstTeamFieldU;
  249. JTextField secondTeamFieldU;
  250. JTextField matchFieldU;
  251.  
  252. JLabel numOfSeatsLabelU;
  253. JLabel matchWeightLabelU;
  254. JLabel locationLabelU;
  255. JLabel tourIdLabelUP;
  256. JLabel firstTeamLabelU;
  257. JLabel secondTeamLabelU;
  258. JLabel matchLabelU;
  259.  
  260. JButton createMatchBackU;
  261. JButton createCurrentMatchU;
  262. /*************************************************** editMatchPanel ****************************************************/
  263.  
  264. /*************************************************** reserveTicketPanel ****************************************************/
  265. JPanel reserveTicketPanelU;
  266. JLabel reserveTicketLabelU;
  267. JTextField reserveTicketFieldU;
  268. JButton reserveTicketBackU;
  269. JButton reserveTicketNextU;
  270. /*************************************************** reserveTicketPanel ****************************************************/
  271.  
  272. /*************************************************** categoryPanel ****************************************************/
  273. JPanel categoryPanel ;
  274. JLabel category1Label;
  275. JLabel category2Label;
  276. JLabel category3Label;
  277. JTextField categoryField;
  278. JButton categoryBack;
  279. JButton categoryNext;
  280. boolean cflag1;
  281. boolean cflag2;
  282. boolean cflag3;
  283. /*************************************************** categoryPanel ****************************************************/
  284. public void categoryPanel()
  285. {
  286. categoryPanel = new JPanel();
  287. categoryPanel . setBounds(0,0,width,height);
  288. categoryPanel . setLayout(null);
  289.  
  290. category1Label = new JLabel();
  291. category2Label = new JLabel();
  292. category3Label = new JLabel();
  293.  
  294.  
  295. category1Label .setBounds(0,50,width,40);
  296. category2Label .setBounds(0,200,width,40);
  297. category3Label .setBounds(0,350,width,40);
  298.  
  299. categoryField = new JTextField("Type The Number Of Category");
  300. categoryField . setBounds(width/2-100,450,200,20);
  301.  
  302. categoryNext = new JButton("Next");
  303. categoryNext . setBounds(0,600,200,20);
  304.  
  305. categoryBack = new JButton("Back");
  306. categoryBack . setBounds(width-200-5,600,200,20);
  307.  
  308. categoryNext.addActionListener(this);
  309. categoryBack.addActionListener(this);
  310.  
  311. categoryPanel.add(category1Label);
  312. categoryPanel.add(category2Label);
  313. categoryPanel.add(category3Label);
  314. categoryPanel.add(categoryField);
  315. categoryPanel.add(categoryNext);
  316. categoryPanel.add(categoryBack);
  317. }
  318. public void reserveTicketPanelU()
  319. {
  320. reserveTicketPanelU = new JPanel();
  321. reserveTicketPanelU . setBounds(0,0,width,height);
  322. reserveTicketPanelU . setLayout(null);
  323.  
  324. reserveTicketLabelU = new JLabel("Type The Match ID");
  325. reserveTicketLabelU . setBounds(30,100,200,20);
  326.  
  327. reserveTicketFieldU = new JTextField();
  328. reserveTicketFieldU . setBounds(250,100,200,20);
  329.  
  330. reserveTicketBackU = new JButton("Back");
  331. reserveTicketNextU = new JButton("Next");
  332.  
  333. reserveTicketBackU . setBounds(0,400,200,20);
  334. reserveTicketNextU . setBounds(0,500,200,20);
  335.  
  336. reserveTicketBackU . addActionListener(this);
  337. reserveTicketNextU . addActionListener(this);
  338.  
  339. reserveTicketPanelU.add(reserveTicketLabelU);
  340. reserveTicketPanelU.add(reserveTicketFieldU);
  341. reserveTicketPanelU.add(reserveTicketNextU);
  342. reserveTicketPanelU.add(reserveTicketBackU);
  343. }
  344. public void editMatchPanel()
  345. {
  346. createMatchPanelU = new JPanel();
  347. createMatchPanelU . setBounds(0,0,width,height);
  348. createMatchPanelU . setLayout(null);
  349.  
  350. numOfSeatsLabelU = new JLabel("Number Of Seats *");
  351. matchWeightLabelU = new JLabel("Match Weight *");
  352. locationLabelU = new JLabel("Match Location");
  353. tourIdLabelUP = new JLabel("Tournament ID *");
  354. firstTeamLabelU = new JLabel("First Team Name *");
  355. secondTeamLabelU = new JLabel("Second Team Name *");
  356.  
  357. numOfSeatsFieldU = new JTextField();
  358. matchWeightFieldU = new JTextField();
  359. locationFieldU = new JTextField();
  360. tourIdFieldUP = new JTextField();
  361. firstTeamFieldU = new JTextField();
  362. secondTeamFieldU = new JTextField();
  363. matchFieldU = new JTextField();
  364. matchLabelU = new JLabel("Match ID To Be Updated");
  365.  
  366. numOfSeatsLabelU.setBounds(30,30,200,20);
  367. numOfSeatsFieldU.setBounds(250,30,200,20);
  368. matchWeightLabelU.setBounds(30,80,200,20);
  369. matchWeightFieldU.setBounds(250,80,200,20);
  370. locationLabelU.setBounds(30,130,200,20);
  371. locationFieldU.setBounds(250,130,200,20);
  372. tourIdLabelUP.setBounds(30,180,200,20);
  373. tourIdFieldUP.setBounds(250,180,200,20);
  374. firstTeamLabelU.setBounds(30,230,200,20);
  375. firstTeamFieldU.setBounds(250,230,200,20);
  376. secondTeamLabelU.setBounds(30,280,200,20);
  377. secondTeamFieldU.setBounds(250,280,200,20);
  378. matchFieldU.setBounds(250,330,200,20);
  379. matchLabelU.setBounds(30,330,200,20);
  380.  
  381. createMatchPanelU.add(numOfSeatsLabelU);
  382. createMatchPanelU.add(numOfSeatsFieldU);
  383. createMatchPanelU.add(matchWeightLabelU);
  384. createMatchPanelU.add(matchWeightFieldU);
  385. createMatchPanelU.add(locationLabelU);
  386. createMatchPanelU.add(locationFieldU);
  387. createMatchPanelU.add(tourIdLabelUP);
  388. createMatchPanelU.add(tourIdFieldUP);
  389. createMatchPanelU.add(firstTeamLabelU);
  390. createMatchPanelU.add(firstTeamFieldU);
  391. createMatchPanelU.add(secondTeamLabelU);
  392. createMatchPanelU.add(secondTeamFieldU);
  393. createMatchPanelU.add(matchFieldU);
  394. createMatchPanelU.add(matchLabelU);
  395.  
  396. createMatchBackU = new JButton("Back");
  397. createCurrentMatchU = new JButton("Edit");
  398.  
  399. createMatchBackU. setBounds(224,590,270,20);
  400. createCurrentMatchU . setBounds(0,620,270,20);
  401.  
  402. createMatchPanelU.add(createMatchBackU);
  403. createMatchPanelU.add(createCurrentMatchU);
  404.  
  405. createMatchBackU.addActionListener(this);
  406. createCurrentMatchU.addActionListener(this);
  407. }
  408. public void editTourPanel()
  409. {
  410. createTournamentPanelU = new JPanel();
  411. createTournamentPanelU . setBounds(0,0,width,height);
  412. createTournamentPanelU . setLayout(null);
  413.  
  414. tourDescripLabelU = new JLabel("Tournament Description");
  415. tourNameLabelU = new JLabel("Tournament Name");
  416. tourStartDateLabelU = new JLabel("Tour StartDate MM/DD/YYYY *");
  417. tourEndDateLabelU = new JLabel("Tour EndDate MM/DD/YYYY *");
  418. tourTypeLabelU = new JLabel("Tournament Type");
  419. tourOpenDateLabelU = new JLabel("Ceremony Start Date");
  420. tourCloseDateLabelU = new JLabel ("Ceremony End Date");
  421.  
  422. tourDescripFieldU = new JTextField();
  423. tourNameFieldU = new JTextField();
  424. tourStartDateFieldU = new JTextField();
  425. tourEndDateFieldU = new JTextField();
  426. tourTypeFieldU = new JTextField();
  427. tourOpenDateFieldU = new JTextField();
  428. tourCloseDateFieldU = new JTextField();
  429. tourIdFieldU = new JTextField();
  430. tourIdLabelU = new JLabel("Tour Id To Be Updated");
  431.  
  432. tourDescripLabelU.setBounds(30,30,200,20);
  433. tourDescripFieldU.setBounds(250,30,200,20);
  434. tourNameLabelU.setBounds(30,80,200,20);
  435. tourNameFieldU.setBounds(250,80,200,20);
  436. tourStartDateLabelU.setBounds(30,130,200,20);
  437. tourStartDateFieldU.setBounds(250,130,200,20);
  438. tourEndDateLabelU.setBounds(30,180,200,20);
  439. tourEndDateFieldU.setBounds(250,180,200,20);
  440. tourTypeLabelU.setBounds(30,230,200,20);
  441. tourTypeFieldU.setBounds(250,230,200,20);
  442. tourOpenDateLabelU.setBounds(30,280,200,20);
  443. tourOpenDateFieldU.setBounds(250,280,200,20);
  444. tourCloseDateLabelU.setBounds(30,330,200,20);
  445. tourCloseDateFieldU.setBounds(250,330,200,20);
  446. tourIdFieldU.setBounds(250,380,200,20);
  447. tourIdLabelU.setBounds(30,380,200,20);
  448.  
  449. createTournamentPanelU.add(tourDescripLabelU);
  450. createTournamentPanelU.add(tourDescripFieldU);
  451. createTournamentPanelU.add(tourNameLabelU);
  452. createTournamentPanelU.add(tourNameFieldU);
  453. createTournamentPanelU.add(tourStartDateLabelU);
  454. createTournamentPanelU.add(tourStartDateFieldU);
  455. createTournamentPanelU.add(tourEndDateLabelU);
  456. createTournamentPanelU.add(tourEndDateFieldU);
  457. createTournamentPanelU.add(tourTypeLabelU);
  458. createTournamentPanelU.add(tourTypeFieldU);
  459. createTournamentPanelU.add(tourOpenDateLabelU);
  460. createTournamentPanelU.add(tourOpenDateFieldU);
  461. createTournamentPanelU.add(tourCloseDateLabelU);
  462. createTournamentPanelU.add(tourCloseDateFieldU);
  463. createTournamentPanelU.add(tourIdFieldU);
  464. createTournamentPanelU.add(tourIdLabelU);
  465.  
  466. createTourBackU = new JButton("Back");
  467. createCurrentTourU = new JButton("Edit");
  468.  
  469. createTourBackU. setBounds(224,590,270,20);
  470. createCurrentTourU . setBounds(0,620,270,20);
  471.  
  472. createTournamentPanelU.add(createTourBackU);
  473. createTournamentPanelU.add(createCurrentTourU);
  474.  
  475. createTourBackU.addActionListener(this);
  476. createCurrentTourU.addActionListener(this);
  477. }
  478. public void createUpdateProfilePanel()
  479. {
  480. regPanelU = new JPanel();
  481. regPanelU . setBounds(0,0,width,height);
  482. regPanelU . setLayout(null);
  483.  
  484. firstNameLabelU = new JLabel("FirstName *");
  485. middleNameLabelU = new JLabel("MiddleName");
  486. lastNameLabelU = new JLabel("LastName");
  487. telephoneLabelU = new JLabel("Telephone Number");
  488. mailLabelU = new JLabel("E-mail");
  489. passwordLabelU = new JLabel("Password *");
  490. retypePasswordLabelU = new JLabel("Retype Password *");
  491. countryLabelU = new JLabel("Country");
  492. mobileLabelU = new JLabel("Mobile Number");
  493. dateOfBirthLabelU = new JLabel("Date Of Birth MM/DD/YYYY");
  494.  
  495. firstNameLabelU . setBounds(30,30,110,20);
  496. middleNameLabelU . setBounds(30,80,110,20);
  497. lastNameLabelU . setBounds(30,130,110,20);
  498. passwordLabelU . setBounds(30,230,110,20);
  499. retypePasswordLabelU . setBounds(30,280,110,20);
  500. telephoneLabelU . setBounds(30,330,110,20);
  501. mobileLabelU . setBounds(30,380,110,20);
  502. mailLabelU . setBounds(30,430,110,20);
  503. countryLabelU . setBounds(30,480,110,20);
  504. dateOfBirthLabelU. setBounds(30,530,210,20);
  505.  
  506. firstNameFieldU = new JTextField();
  507. middleNameFieldU = new JTextField();
  508. lastNameFieldU = new JTextField();
  509. passwordFieldU = new JPasswordField();
  510. retypePasswordFieldU = new JPasswordField();
  511. telephoneFieldU = new JTextField();
  512. mobileFieldU = new JTextField();
  513. mailFieldU = new JTextField();
  514. countryFieldU = new JTextField();
  515. dateOfBirthFieldU = new JTextField();
  516.  
  517. firstNameFieldU . setBounds(150,30,200,20);
  518. middleNameFieldU . setBounds(150,80,200,20);
  519. lastNameFieldU . setBounds(150,130,200,20);
  520. passwordFieldU . setBounds(150,230,200,20);
  521. retypePasswordFieldU . setBounds(150,280,200,20);
  522. telephoneFieldU . setBounds(150,330,200,20);
  523. mobileFieldU . setBounds(150,380,200,20);
  524. mailFieldU . setBounds(150,430,200,20);
  525. countryFieldU . setBounds(150,480,200,20);
  526. dateOfBirthFieldU . setBounds(250,530,200,20);
  527.  
  528. updateButtonRegPanel = new JButton("Update");
  529. backU = new JButton("Back");
  530.  
  531. updateButtonRegPanel . setBounds(224,590,270,20);
  532. backU . setBounds(0,620,270,20);
  533.  
  534. updateButtonRegPanel . addActionListener(this);
  535. backU.addActionListener(this);
  536.  
  537. regPanelU . add(firstNameLabelU);
  538. regPanelU . add(middleNameLabelU);
  539. regPanelU . add(lastNameLabelU);
  540. regPanelU . add(passwordLabelU);
  541. regPanelU . add(retypePasswordLabelU);
  542. regPanelU . add(telephoneLabelU);
  543. regPanelU . add(mobileLabelU);
  544. regPanelU . add(mailLabelU);
  545. regPanelU . add(countryLabelU);
  546. regPanelU . add(dateOfBirthLabelU);
  547. regPanelU.add(dateOfBirthFieldU);
  548.  
  549. regPanelU . add(firstNameFieldU);
  550. regPanelU . add(middleNameFieldU);
  551. regPanelU . add(lastNameFieldU);
  552. regPanelU . add(passwordFieldU);
  553. regPanelU . add(retypePasswordFieldU);
  554. regPanelU . add(telephoneFieldU);
  555. regPanelU . add(mobileFieldU);
  556. regPanelU . add(mailFieldU);
  557. regPanelU . add(countryFieldU);
  558.  
  559. regPanelU . add(updateButtonRegPanel);
  560. regPanelU . add(backU);
  561. }
  562. public void findMatchesPanel()
  563. {
  564. findMatchesPanel = new JPanel();
  565. findMatchesPanel . setBounds(0,0,width,height);
  566. findMatchesPanel . setLayout(null);
  567.  
  568. findMatchesField = new JTextField();
  569. findMatchesLabel = new JLabel("Enter The Date MM/DD/YYYY");
  570. findMatchesFind = new JButton("Find");
  571. findMatchesBack = new JButton("Back");
  572. findMatchesTable = new JTable(data,tourCol);
  573. findMatchesTable . setEnabled(false);
  574. findMatchesPane = new JScrollPane(findMatchesTable);
  575.  
  576. findMatchesPane . setBounds(0,100,width-5,400);
  577. findMatchesField . setBounds(250,30,200,20);
  578. findMatchesLabel . setBounds(30,30,200,20);
  579. findMatchesFind . setBounds(0,620,270,20);
  580. findMatchesBack . setBounds(224,590,270,20);
  581.  
  582. findMatchesPanel.add(findMatchesPane);
  583. findMatchesPanel.add(findMatchesField);
  584. findMatchesPanel.add(findMatchesLabel);
  585. findMatchesPanel.add(findMatchesFind);
  586. findMatchesPanel.add(findMatchesBack);
  587.  
  588. findMatchesFind.addActionListener(this);
  589. findMatchesBack.addActionListener(this);
  590.  
  591. }
  592. public void createWelcomePanel()
  593. {
  594. welcomePanel = new JPanel();
  595. welcomePanel . setBounds(0,0,width,height);
  596. welcomePanel . setLayout(null);
  597.  
  598. nameWelcomePanelLabel = new JLabel("Username");
  599. nameWelcomePanelLabel . setBounds(30,330,80,20);
  600. welcomePanel . add(nameWelcomePanelLabel);
  601.  
  602. passwordWelcomePanelLabel = new JLabel("Password");
  603. passwordWelcomePanelLabel . setBounds(30,390,80,20);
  604. welcomePanel . add(passwordWelcomePanelLabel);
  605.  
  606. nameWelcomePanel = new JTextField();
  607. nameWelcomePanel . setBounds(100,330,200,20);
  608. welcomePanel . add(nameWelcomePanel);
  609.  
  610. passwordWelcomePanel = new JPasswordField();
  611. passwordWelcomePanel . setBounds(100,390,200,20);
  612. welcomePanel . add(passwordWelcomePanel);
  613.  
  614. loginWelcomePanel = new JButton("Login");
  615. loginWelcomePanel . setBounds(224,450,270,20);
  616. loginWelcomePanel . addActionListener(this);
  617. welcomePanel . add(loginWelcomePanel);
  618.  
  619. regWelcomePanel = new JButton("Register");
  620. regWelcomePanel . setBounds(224,510,270,20);
  621. regWelcomePanel . addActionListener(this);
  622. welcomePanel . add(regWelcomePanel);
  623.  
  624. ballIcon = new ImageIcon("DB.jpg");
  625. ballLabel = new JLabel(ballIcon);
  626. ballLabel . setBounds(0,0,width,300);
  627. welcomePanel . add(ballLabel);
  628. }
  629. public void createRegPanel()
  630. {
  631. regPanel = new JPanel();
  632. regPanel . setBounds(0,0,width,height);
  633. regPanel . setLayout(null);
  634.  
  635. firstNameLabel = new JLabel("FirstName *");
  636. middleNameLabel = new JLabel("MiddleName");
  637. lastNameLabel = new JLabel("LastName");
  638. telephoneLabel = new JLabel("Telephone Number");
  639. mailLabel = new JLabel("E-mail");
  640. userNameLabel = new JLabel("UserName *");
  641. passwordLabel = new JLabel("Password *");
  642. retypePasswordLabel = new JLabel("Retype Password *");
  643. countryLabel = new JLabel("Country");
  644. mobileLabel = new JLabel("Mobile Number");
  645. dateOfBirthLabel = new JLabel("Date Of Birth MM/DD/YYYY");
  646.  
  647. firstNameLabel . setBounds(30,30,110,20);
  648. middleNameLabel . setBounds(30,80,110,20);
  649. lastNameLabel . setBounds(30,130,110,20);
  650. userNameLabel . setBounds(30,180,110,20);
  651. passwordLabel . setBounds(30,230,110,20);
  652. retypePasswordLabel . setBounds(30,280,110,20);
  653. telephoneLabel . setBounds(30,330,110,20);
  654. mobileLabel . setBounds(30,380,110,20);
  655. mailLabel . setBounds(30,430,110,20);
  656. countryLabel . setBounds(30,480,110,20);
  657. dateOfBirthLabel. setBounds(30,530,210,20);
  658.  
  659. firstNameField = new JTextField();
  660. middleNameField = new JTextField();
  661. lastNameField = new JTextField();
  662. userNameField = new JTextField();
  663. passwordField = new JPasswordField();
  664. retypePasswordField = new JPasswordField();
  665. telephoneField = new JTextField();
  666. mobileField = new JTextField();
  667. mailField = new JTextField();
  668. countryField = new JTextField();
  669. dateOfBirthField = new JTextField();
  670.  
  671. firstNameField . setBounds(150,30,200,20);
  672. middleNameField . setBounds(150,80,200,20);
  673. lastNameField . setBounds(150,130,200,20);
  674. userNameField . setBounds(150,180,200,20);
  675. passwordField . setBounds(150,230,200,20);
  676. retypePasswordField . setBounds(150,280,200,20);
  677. telephoneField . setBounds(150,330,200,20);
  678. mobileField . setBounds(150,380,200,20);
  679. mailField . setBounds(150,430,200,20);
  680. countryField . setBounds(150,480,200,20);
  681. dateOfBirthField . setBounds(250,530,200,20);
  682.  
  683. regButtonRegPanel = new JButton("Register");
  684. back = new JButton("Back");
  685.  
  686. regButtonRegPanel . setBounds(224,590,270,20);
  687. back . setBounds(0,620,270,20);
  688.  
  689. regButtonRegPanel . addActionListener(this);
  690. back.addActionListener(this);
  691.  
  692. regPanel . add(firstNameLabel);
  693. regPanel . add(middleNameLabel);
  694. regPanel . add(lastNameLabel);
  695. regPanel . add(userNameLabel);
  696. regPanel . add(passwordLabel);
  697. regPanel . add(retypePasswordLabel);
  698. regPanel . add(telephoneLabel);
  699. regPanel . add(mobileLabel);
  700. regPanel . add(mailLabel);
  701. regPanel . add(countryLabel);
  702. regPanel . add(dateOfBirthLabel);
  703. regPanel.add(dateOfBirthField);
  704.  
  705. regPanel . add(firstNameField);
  706. regPanel . add(middleNameField);
  707. regPanel . add(lastNameField);
  708. regPanel . add(userNameField);
  709. regPanel . add(passwordField);
  710. regPanel . add(retypePasswordField);
  711. regPanel . add(telephoneField);
  712. regPanel . add(mobileField);
  713. regPanel . add(mailField);
  714. regPanel . add(countryField);
  715.  
  716. regPanel . add(regButtonRegPanel);
  717. regPanel . add(back);
  718. }
  719. public void createLowAdmin()
  720. {
  721. lowAdminPanel = new JPanel();
  722. lowAdminPanel.setBounds(0,0,width,height);
  723. lowAdminPanel.setLayout(null);
  724.  
  725. createMatch = new JButton("Create Match");
  726. editMatch = new JButton("Edit Match");
  727. deleteMatch = new JButton("Delete Match");
  728. logOutL = new JButton("Logout");
  729. viewTourL = new JButton("View Tournaments");
  730. viewMatchL = new JButton("View Matches");
  731.  
  732. createMatch.setBounds(0,200,494,20);
  733. editMatch.setBounds(0,350,494,20);
  734. deleteMatch.setBounds(0,550,494,20);
  735. logOutL . setBounds(150,638,200,30);
  736. viewTourL . setBounds(0,0,494,20);
  737. viewMatchL . setBounds(0,100,494,20);
  738.  
  739. logOutL.addActionListener(this);
  740.  
  741. lowAdminPanel.add(createMatch);
  742. lowAdminPanel.add(editMatch);
  743. lowAdminPanel.add(deleteMatch);
  744. lowAdminPanel.add(logOutL);
  745. lowAdminPanel.add(viewTourL);
  746. lowAdminPanel.add(viewMatchL);
  747.  
  748. viewMatchL.addActionListener(this);
  749. viewTourL.addActionListener(this);
  750. createMatch.addActionListener(this);
  751. editMatch.addActionListener(this);
  752. deleteMatch.addActionListener(this);
  753. }
  754. public void createHighAdmin()
  755. {
  756. highAdminPanel = new JPanel();
  757. highAdminPanel.setBounds(0,0,width,height);
  758. highAdminPanel.setLayout(null);
  759. viewTourH = new JButton("View Tournaments");
  760. viewMatchH = new JButton("View Matches");
  761.  
  762. createMatchH = new JButton("Create Match");
  763. editMatchH = new JButton("Edit Match");
  764. deleteMatchH = new JButton("Delete Match");
  765. createTourH = new JButton("Create Tournament");
  766. editTourH = new JButton("Edit Tournament");
  767. deleteTourH = new JButton("Delete Tournament");
  768. logOutH = new JButton("Logout");
  769.  
  770. createMatchH.setBounds(30,180,200,20);
  771. editMatchH.setBounds(30,280,200,20);
  772. deleteMatchH.setBounds(30,380,200,20);
  773. createTourH.setBounds(270,280,200,20);
  774. editTourH.setBounds(270,380,200,20);
  775. deleteTourH.setBounds(270,480,200,20);
  776. logOutH . setBounds(150,638,200,30);
  777. viewTourH . setBounds(0,0,494,20);
  778. viewMatchH . setBounds(0,100,494,20);
  779.  
  780. logOutH.addActionListener(this);
  781.  
  782. highAdminPanel.add(createMatchH);
  783. highAdminPanel.add(editMatchH);
  784. highAdminPanel.add(deleteMatchH);
  785. highAdminPanel.add(createTourH);
  786. highAdminPanel.add(editTourH);
  787. highAdminPanel.add(deleteTourH);
  788. highAdminPanel.add(logOutH);
  789. highAdminPanel.add(viewTourH);
  790. highAdminPanel.add(viewMatchH);
  791.  
  792. viewMatchH.addActionListener(this);
  793. viewTourH.addActionListener(this);
  794. createMatchH.addActionListener(this);
  795. editMatchH.addActionListener(this);
  796. deleteMatchH.addActionListener(this);
  797. createTourH.addActionListener(this);
  798. editTourH.addActionListener(this);
  799. deleteTourH.addActionListener(this);
  800.  
  801. }
  802. public void createUserPanel()
  803. {
  804. userPanel = new JPanel();
  805. userPanel . setBounds(0,0,width,height);
  806. userPanel . setLayout(null);
  807.  
  808. userUpdate = new JButton("Update Profile");
  809. userView = new JButton("View Tickets");
  810. userReserve = new JButton("View-Reserve Ticket");
  811. userFind = new JButton("Find Tournaments");
  812. userCancel = new JButton("Cancel Reservation");
  813. userTour = new JButton("View Tournaments");
  814. userMatch = new JButton("View Matches");
  815. logOutR = new JButton("Logout");
  816.  
  817. userUpdate.setBounds(0,0,494,20);
  818. userReserve.setBounds(0,280,494,80);
  819. userFind.setBounds(0,100,494,20);
  820. userTour.setBounds(0,500,494,20);
  821. userMatch.setBounds(0,600,494,20);
  822. logOutR.setBounds(150,638,200,30);
  823.  
  824. logOutR.addActionListener(this);
  825.  
  826. userPanel.add(userUpdate);
  827. userPanel.add(userReserve);
  828. userPanel.add(userFind);
  829. userPanel.add(userTour);
  830. userPanel.add(userMatch);
  831. userPanel.add(logOutR);
  832.  
  833. userUpdate.addActionListener(this);
  834. userView.addActionListener(this);
  835. userReserve.addActionListener(this);
  836. userFind.addActionListener(this);
  837. userTour.addActionListener(this);
  838. userMatch.addActionListener(this);
  839. userCancel.addActionListener(this);
  840. }
  841. public void createTournamentPanel()
  842. {
  843. createTournamentPanel = new JPanel();
  844. createTournamentPanel . setBounds(0,0,width,height);
  845. createTournamentPanel . setLayout(null);
  846.  
  847. tourDescripLabel = new JLabel("Tournament Description");
  848. tourNameLabel = new JLabel("Tournament Name *");
  849. tourStartDateLabel = new JLabel("Tour StartDate MM/DD/YYYY *");
  850. tourEndDateLabel = new JLabel("Tour EndDate MM/DD/YYYY *");
  851. tourTypeLabel = new JLabel("Tournament Type");
  852. tourOpenDateLabel = new JLabel("Ceremony Start Date");
  853. tourCloseDateLabel = new JLabel ("Ceremony End Date");
  854.  
  855. tourDescripField = new JTextField();
  856. tourNameField = new JTextField();
  857. tourStartDateField = new JTextField();
  858. tourEndDateField = new JTextField();
  859. tourTypeField = new JTextField();
  860. tourOpenDateField = new JTextField();
  861. tourCloseDateField = new JTextField();
  862.  
  863. tourDescripLabel.setBounds(30,30,200,20);
  864. tourDescripField.setBounds(250,30,200,20);
  865. tourNameLabel.setBounds(30,80,200,20);
  866. tourNameField.setBounds(250,80,200,20);
  867. tourStartDateLabel.setBounds(30,130,200,20);
  868. tourStartDateField.setBounds(250,130,200,20);
  869. tourEndDateLabel.setBounds(30,180,200,20);
  870. tourEndDateField.setBounds(250,180,200,20);
  871. tourTypeLabel.setBounds(30,230,200,20);
  872. tourTypeField.setBounds(250,230,200,20);
  873. tourOpenDateLabel.setBounds(30,280,200,20);
  874. tourOpenDateField.setBounds(250,280,200,20);
  875. tourCloseDateLabel.setBounds(30,330,200,20);
  876. tourCloseDateField.setBounds(250,330,200,20);
  877.  
  878. createTournamentPanel.add(tourDescripLabel);
  879. createTournamentPanel.add(tourDescripField);
  880. createTournamentPanel.add(tourNameLabel);
  881. createTournamentPanel.add(tourNameField);
  882. createTournamentPanel.add(tourStartDateLabel);
  883. createTournamentPanel.add(tourStartDateField);
  884. createTournamentPanel.add(tourEndDateLabel);
  885. createTournamentPanel.add(tourEndDateField);
  886. createTournamentPanel.add(tourTypeLabel);
  887. createTournamentPanel.add(tourTypeField);
  888. createTournamentPanel.add(tourOpenDateLabel);
  889. createTournamentPanel.add(tourOpenDateField);
  890. createTournamentPanel.add(tourCloseDateLabel);
  891. createTournamentPanel.add(tourCloseDateField);
  892.  
  893. createTourBack = new JButton("Back");
  894. createCurrentTour = new JButton("Finish");
  895.  
  896. createTourBack. setBounds(224,590,270,20);
  897. createCurrentTour . setBounds(0,620,270,20);
  898.  
  899. createTournamentPanel.add(createTourBack);
  900. createTournamentPanel.add(createCurrentTour);
  901.  
  902. createTourBack.addActionListener(this);
  903. createCurrentTour.addActionListener(this);
  904. }
  905. public void createMatchPanel()
  906. {
  907. createMatchPanel = new JPanel();
  908. createMatchPanel . setBounds(0,0,width,height);
  909. createMatchPanel . setLayout(null);
  910.  
  911. numOfSeatsLabel = new JLabel("Number Of Seats *");
  912. matchWeightLabel = new JLabel("Match Weight * Between 1 and 10");
  913. locationLabel = new JLabel("Match Location");
  914. tourIdLabel = new JLabel("Tournament ID *");
  915. firstTeamLabel = new JLabel("First Team Name *");
  916. secondTeamLabel = new JLabel("Second Team Name *");
  917.  
  918. numOfSeatsField = new JTextField();
  919. matchWeightField = new JTextField();
  920. locationField = new JTextField();
  921. tourIdField = new JTextField();
  922. firstTeamField = new JTextField();
  923. secondTeamField = new JTextField();
  924.  
  925. numOfSeatsLabel.setBounds(30,30,200,20);
  926. numOfSeatsField.setBounds(250,30,200,20);
  927. matchWeightLabel.setBounds(30,80,200,20);
  928. matchWeightField.setBounds(250,80,200,20);
  929. locationLabel.setBounds(30,130,200,20);
  930. locationField.setBounds(250,130,200,20);
  931. tourIdLabel.setBounds(30,180,200,20);
  932. tourIdField.setBounds(250,180,200,20);
  933. firstTeamLabel.setBounds(30,230,200,20);
  934. firstTeamField.setBounds(250,230,200,20);
  935. secondTeamLabel.setBounds(30,280,200,20);
  936. secondTeamField.setBounds(250,280,200,20);
  937.  
  938. createMatchPanel.add(numOfSeatsLabel);
  939. createMatchPanel.add(numOfSeatsField);
  940. createMatchPanel.add(matchWeightLabel);
  941. createMatchPanel.add(matchWeightField);
  942. createMatchPanel.add(locationLabel);
  943. createMatchPanel.add(locationField);
  944. createMatchPanel.add(tourIdLabel);
  945. createMatchPanel.add(tourIdField);
  946. createMatchPanel.add(firstTeamLabel);
  947. createMatchPanel.add(firstTeamField);
  948. createMatchPanel.add(secondTeamLabel);
  949. createMatchPanel.add(secondTeamField);
  950.  
  951. createMatchBack = new JButton("Back");
  952. createCurrentMatch = new JButton("Finish");
  953.  
  954. createMatchBack. setBounds(224,590,270,20);
  955. createCurrentMatch . setBounds(0,620,270,20);
  956.  
  957. createMatchPanel.add(createMatchBack);
  958. createMatchPanel.add(createCurrentMatch);
  959.  
  960. createMatchBack.addActionListener(this);
  961. createCurrentMatch.addActionListener(this);
  962. }
  963. public void deleteTournamentPanel()
  964. {
  965. removeTournamentPanel = new JPanel();
  966. removeTournamentPanel . setBounds(0,0,width,height);
  967. removeTournamentPanel . setLayout(null);
  968.  
  969. removeTourIdLabel = new JLabel("Type The Tournament ID");
  970. removeTourIdField = new JTextField();
  971.  
  972. removeTourIdLabel.setBounds(30,30,200,20);
  973. removeTourIdField.setBounds(250,30,200,20);
  974.  
  975. removeTourBack = new JButton("Back");
  976. removeCurrentTour = new JButton("Remove Tournament");
  977.  
  978. removeTourBack. setBounds(224,590,270,20);
  979. removeCurrentTour . setBounds(0,620,270,20);
  980.  
  981. removeTournamentPanel.add(removeTourIdLabel);
  982. removeTournamentPanel.add(removeTourIdField);
  983. removeTournamentPanel.add(removeTourBack);
  984. removeTournamentPanel.add(removeCurrentTour);
  985.  
  986. removeTourBack.addActionListener(this);
  987. removeCurrentTour.addActionListener(this);
  988. }
  989. public void deleteMatchPanel()
  990. {
  991. removeMatchPanel = new JPanel();
  992. removeMatchPanel . setBounds(0,0,width,height);
  993. removeMatchPanel . setLayout(null);
  994.  
  995. removeMatchIdLabel = new JLabel("Type The Match ID");
  996. removeMatchIdField = new JTextField();
  997.  
  998. removeMatchIdLabel.setBounds(30,30,200,20);
  999. removeMatchIdField.setBounds(250,30,200,20);
  1000.  
  1001. removeMatchBack = new JButton("Back");
  1002. removeCurrentMatch = new JButton("Remove Match");
  1003.  
  1004. removeMatchBack. setBounds(224,590,270,20);
  1005. removeCurrentMatch . setBounds(0,620,270,20);
  1006.  
  1007. removeMatchPanel.add(removeMatchIdLabel);
  1008. removeMatchPanel.add(removeMatchIdField);
  1009. removeMatchPanel.add(removeMatchBack);
  1010. removeMatchPanel.add(removeCurrentMatch);
  1011.  
  1012. removeMatchBack.addActionListener(this);
  1013. removeCurrentMatch.addActionListener(this);
  1014. }
  1015. public void viewMatchesPanel()
  1016. {
  1017. viewMatchPanel = new JPanel();
  1018. viewMatchPanel . setBounds(0,0,width,height);
  1019. viewMatchPanel . setLayout(null);
  1020. viewMatchTable = new JTable(data,matchCol);
  1021. viewMatchTable.setEnabled(false);
  1022. viewMatchPane = new JScrollPane(viewMatchTable);
  1023. viewMatchPane . setBounds(0,0,width-5,500);
  1024. viewMatchPanel.add(viewMatchPane);
  1025.  
  1026. viewMatchBack = new JButton("Back");
  1027. viewMatchBack . setBounds(0,600,width,20);
  1028. viewMatchBack.addActionListener(this);
  1029. viewMatchPanel.add(viewMatchBack);
  1030. }
  1031. public void viewTournamentsPanel()
  1032. {
  1033. viewTourPanel = new JPanel();
  1034. viewTourPanel . setBounds(0,0,width,height);
  1035. viewTourPanel . setLayout(null);
  1036.  
  1037. viewTourTable = new JTable(data,tourCol);
  1038. viewTourPane = new JScrollPane(viewTourTable);
  1039. viewTourPane . setBounds(0,0,width-5,500);
  1040. viewTourPanel.add(viewTourPane);
  1041. viewTourTable.setEnabled(false);
  1042. viewTourBack = new JButton("Back");
  1043. viewTourBack . setBounds(0,600,width,20);
  1044.  
  1045. viewTourBack.addActionListener(this);
  1046. viewTourPanel.add(viewTourBack);
  1047. }
  1048. public void reserveTicketsPanel()
  1049. {
  1050. reserveTicketPanel = new JPanel();
  1051. reserveTicketPanel . setBounds(0,0,width,height);
  1052. reserveTicketPanel . setLayout(null);
  1053.  
  1054. reserveTicketTable = new JTable(data,ticketCol);
  1055. reserveTicketTable . setEnabled(false);
  1056. reserveTicketLabel = new JLabel("Type The Ticket ID");
  1057. reserveTicketField = new JTextField();
  1058.  
  1059. reserveTicketLabel.setBounds(30,540,200,20);
  1060. reserveTicketField.setBounds(250,540,200,20);
  1061.  
  1062. reserveTicketBack = new JButton("Back");
  1063. reserveCurrentTicket = new JButton("Reserve Ticket");
  1064. cancelReserveTicket = new JButton("Cancel Ticket");
  1065.  
  1066. cancelReserveTicket.setBounds(224,640,270,20);
  1067. reserveTicketBack. setBounds(224,580,270,20);
  1068. reserveCurrentTicket . setBounds(0,610,270,20);
  1069. reserveTicketTable.setEnabled(false);
  1070. scrollPane = new JScrollPane(reserveTicketTable);
  1071. scrollPane.setBounds(0,0,width-5,500);
  1072. // reserveTicketPanel.add(reserveTicketField);
  1073. // reserveTicketPanel.add(reserveTicketLabel);
  1074. reserveTicketPanel.add(reserveTicketBack);
  1075. reserveTicketPanel.add(scrollPane);
  1076. reserveTicketPanel.add(reserveCurrentTicket);
  1077. // reserveTicketPanel.add(cancelReserveTicket);
  1078.  
  1079. cancelReserveTicket.addActionListener(this);
  1080. reserveTicketBack.addActionListener(this);
  1081. reserveCurrentTicket.addActionListener(this);
  1082. }
  1083. public void createFrame()
  1084. {
  1085. createData();
  1086. categoryPanel();
  1087. reserveTicketPanelU();
  1088. editMatchPanel();
  1089. editTourPanel();
  1090. createUpdateProfilePanel();
  1091. viewMatchesPanel();
  1092. viewTournamentsPanel();
  1093. findMatchesPanel();
  1094. reserveTicketsPanel();
  1095. deleteMatchPanel();
  1096. deleteTournamentPanel();
  1097. createMatchPanel();
  1098. createTournamentPanel();
  1099. createUserPanel();
  1100. createHighAdmin();
  1101. createLowAdmin();
  1102. createRegPanel();
  1103. createWelcomePanel();
  1104. frame = new JFrame();
  1105. frame . setBounds(390,50,500,700);
  1106. frame . setLayout(null);
  1107. frame . add(welcomePanel);
  1108. frame . setResizable(false);
  1109. frame . setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  1110. frame . setVisible(true);
  1111. }
  1112. public void createData()
  1113. {
  1114. for(int i = 0 ; i<10000 ; ++i)
  1115. for(int j = 0 ; j<8 ; ++j)
  1116. data[i][j]="";
  1117. }
  1118. public DBGui()
  1119. {
  1120. connectUsingJDBC();
  1121. createFrame();
  1122. frame.validate();
  1123. }
  1124. public void actionPerformed(ActionEvent e)
  1125. {
  1126. createData();
  1127. if(e.getSource()==categoryNext)
  1128. {
  1129. categoryQuery();
  1130. String t = categoryField.getText();
  1131. if(t.equals("1")&&cflag1||t.equals("2")&&cflag2||t.equals("3")&&cflag3)
  1132. {
  1133. if(finalQuery())
  1134. {
  1135. JOptionPane.showMessageDialog(null, "New Ticket Bought","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
  1136.  
  1137. }
  1138. else
  1139. {
  1140. JOptionPane.showMessageDialog(null, "Error Check Match ID Or Category Number","Error Message",JOptionPane.PLAIN_MESSAGE );
  1141. }
  1142. }
  1143. else
  1144. {
  1145. JOptionPane.showMessageDialog(null, "Error Check Match ID Or Category Number","Error Message",JOptionPane.PLAIN_MESSAGE );
  1146. }
  1147. }
  1148. if(e.getSource()==categoryBack)
  1149. {
  1150. frame.remove(categoryPanel);
  1151. frame.add(reserveTicketPanelU);
  1152. frame.repaint();
  1153. }
  1154. if(e.getSource()==reserveTicketNextU)
  1155. {
  1156. if(ticketQuery())
  1157. {
  1158. frame.remove(reserveTicketPanelU);
  1159. frame.add(categoryPanel);
  1160. System.out.println(categoryQuery());
  1161. frame.repaint();
  1162. }
  1163. else
  1164. {
  1165. JOptionPane.showMessageDialog(null, "Error Check Match ID","Error Message",JOptionPane.PLAIN_MESSAGE );
  1166. }
  1167. }
  1168. if(e.getSource()==reserveTicketBackU)
  1169. {
  1170. frame.remove(reserveTicketPanelU);
  1171. frame.add(reserveTicketPanel);
  1172. viewTicketQuery();
  1173. frame.repaint();
  1174. }
  1175. if(e.getSource()==reserveCurrentTicket)
  1176. {
  1177. frame.remove(reserveTicketPanel);
  1178. frame.add(reserveTicketPanelU);
  1179. frame.repaint();
  1180. }
  1181. if(e.getSource()==findMatchesFind)
  1182. {
  1183. if(findTourQuery())
  1184. {
  1185. JOptionPane.showMessageDialog(null, "Tournaments Found Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
  1186. }
  1187. else
  1188. {
  1189. JOptionPane.showMessageDialog(null, "No Tournaments At The Specified Date Or Date Format Is Not Correct","Error Message",JOptionPane.PLAIN_MESSAGE);
  1190. }
  1191. }
  1192. if(e.getSource()==createCurrentMatchU)
  1193. {
  1194. if(updateMatchQuery(matchFieldU.getText()))
  1195. {
  1196. JOptionPane.showMessageDialog(null, "Match Updated Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
  1197. }
  1198. else
  1199. {
  1200. JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE);
  1201. }
  1202. }
  1203. if(e.getSource()==createMatchBackU)
  1204. {
  1205. if(userLevel==1)
  1206. {
  1207. frame.remove(createMatchPanelU);
  1208. frame.add(highAdminPanel);
  1209. frame.repaint();
  1210. }
  1211. else
  1212. {
  1213. frame.remove(createMatchPanelU);
  1214. frame.add(lowAdminPanel);
  1215. frame.repaint();
  1216. }
  1217. }
  1218. if(e.getSource()==editMatch)
  1219. {
  1220. frame.remove(lowAdminPanel);
  1221. frame.add(createMatchPanelU);
  1222. frame.repaint();
  1223. }
  1224. if(e.getSource()==editMatchH)
  1225. {
  1226. frame.remove(highAdminPanel);
  1227. frame.add(createMatchPanelU);
  1228. frame.repaint();
  1229. }
  1230. if(e.getSource()==createTourBackU)
  1231. {
  1232. frame.remove(createTournamentPanelU);
  1233. frame.add(highAdminPanel);
  1234. frame.repaint();
  1235. }
  1236. if(e.getSource()==editTourH)
  1237. {
  1238. frame.remove(highAdminPanel);
  1239. frame.add(createTournamentPanelU);
  1240. frame.repaint();
  1241. }
  1242. if(e.getSource()==createCurrentTourU)
  1243. {
  1244. if(updateTourQuery(tourIdFieldU.getText()))
  1245. {
  1246. JOptionPane.showMessageDialog(null, "Tournament Updated Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
  1247. frame.remove(createTournamentPanelU);
  1248. frame.add(highAdminPanel);
  1249. frame.repaint();
  1250. }
  1251. else
  1252. {
  1253. JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE);
  1254. }
  1255. }
  1256. if(e.getSource()==updateButtonRegPanel)
  1257. {
  1258. if(firstNameFieldU.getText().length()>0&&passwordFieldU.getText().equals(retypePasswordFieldU.getText())&&passwordFieldU.getText().length()>0)
  1259. {
  1260. if(updateQuery())
  1261. {
  1262. JOptionPane.showMessageDialog(null, "Profile Updated Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
  1263. frame.remove(regPanelU);
  1264. frame.add(userPanel);
  1265. frame.repaint();
  1266. }
  1267. else
  1268. JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE);
  1269. }
  1270. else
  1271. JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE);
  1272. }
  1273. if(e.getSource()==backU)
  1274. {
  1275. frame.remove(regPanelU);
  1276. frame.add(userPanel);
  1277. frame.repaint();
  1278. }
  1279. if(e.getSource()==userUpdate)
  1280. {
  1281. frame.remove(userPanel);
  1282. frame.add(regPanelU);
  1283. userDetailsQuery();
  1284. frame.repaint();
  1285. }
  1286. if(e.getSource()==removeCurrentTour)
  1287. {
  1288. if(removeTourQuery(removeTourIdField.getText()))
  1289. JOptionPane.showMessageDialog(null, "Tournament Deleted Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
  1290. else
  1291. JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE );
  1292. }
  1293. if(e.getSource()==createCurrentTour)
  1294. {
  1295. if(tourNameField.getText()!=null && tourNameField.getText().length()>0)
  1296. if(checkTourQuery(tourDescripField.getText(),tourNameField.getText(),tourStartDateField.getText(),tourEndDateField.getText(),tourTypeField.getText(),tourOpenDateField.getText(),tourEndDateField.getText()))
  1297. JOptionPane.showMessageDialog(null, "Tournament Created Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
  1298. else
  1299. JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE );
  1300. else
  1301. JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE );
  1302. }
  1303. if(e.getSource()==removeCurrentMatch)
  1304. {
  1305. if(deleteMatchQuery(removeMatchIdField.getText()))
  1306. JOptionPane.showMessageDialog(null, "The Match Was Deleted Successfull","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
  1307. else
  1308. JOptionPane.showMessageDialog(null, "Please Check The Match ID Again","Error Message",JOptionPane.PLAIN_MESSAGE );
  1309. }
  1310. if(e.getSource()==createCurrentMatch)
  1311. {
  1312. if(createMatchQuery(numOfSeatsField.getText(),matchWeightField.getText(),tourIdField.getText(),firstTeamField.getText(),secondTeamField.getText()))
  1313. {
  1314. insertMatchQuery(numOfSeatsField.getText(),matchWeightField.getText(),locationField.getText(),tourIdField.getText(),firstTeamField.getText(),secondTeamField.getText());
  1315. JOptionPane.showMessageDialog(null, "Match Was Created Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
  1316. }
  1317. else
  1318. JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE );
  1319. }
  1320. if(e.getSource()==userTour)
  1321. {
  1322. frame.remove(userPanel);
  1323. frame.add(viewTourPanel);
  1324. viewTourQuery();
  1325. frame.repaint();
  1326. }
  1327. if(e.getSource()==userMatch)
  1328. {
  1329. frame.remove(userPanel);
  1330. frame.add(viewMatchPanel);
  1331. viewMatchQuery();
  1332. frame.repaint();
  1333. }
  1334. if(e.getSource()==viewTourL)
  1335. {
  1336. frame.remove(lowAdminPanel);
  1337. frame.add(viewTourPanel);
  1338. viewTourQuery();
  1339. frame.repaint();
  1340. }
  1341. if(e.getSource()==viewMatchL)
  1342. {
  1343. frame.remove(lowAdminPanel);
  1344. frame.add(viewMatchPanel);
  1345. viewMatchQuery();
  1346. frame.repaint();
  1347. }
  1348. if(e.getSource()==viewTourH)
  1349. {
  1350. frame.remove(highAdminPanel);
  1351. frame.add(viewTourPanel);
  1352. viewTourQuery();
  1353. frame.repaint();
  1354. }
  1355. if(e.getSource()==viewMatchH)
  1356. {
  1357. frame.remove(highAdminPanel);
  1358. frame.add(viewMatchPanel);
  1359. viewMatchQuery();
  1360. frame.repaint();
  1361. }
  1362. if(e.getSource()==viewMatchBack)
  1363. {
  1364. frame.remove(viewMatchPanel);
  1365. if(userLevel==1)
  1366. frame.add(highAdminPanel);
  1367. else
  1368. if(userLevel==2)
  1369. frame.add(lowAdminPanel);
  1370. else
  1371. frame.add(userPanel);
  1372. frame.repaint();
  1373. }
  1374. if(e.getSource()==viewTourBack)
  1375. {
  1376. frame.remove(viewTourPanel);
  1377. if(userLevel==1)
  1378. frame.add(highAdminPanel);
  1379. else
  1380. if(userLevel==2)
  1381. frame.add(lowAdminPanel);
  1382. else
  1383. frame.add(userPanel);
  1384. frame.repaint();
  1385. }
  1386. if(e.getSource()==findMatchesBack)
  1387. {
  1388. frame.remove(findMatchesPanel);
  1389. frame.add(userPanel);
  1390. frame.repaint();
  1391. }
  1392. if(e.getSource()==reserveTicketBack)
  1393. {
  1394. frame.remove(reserveTicketPanel);
  1395. frame.add(userPanel);
  1396. frame.repaint();
  1397. }
  1398. if(e.getSource()==createMatchBack)
  1399. {
  1400. frame.remove(createMatchPanel);
  1401. if(userLevel==1)
  1402. frame.add(highAdminPanel);
  1403. else
  1404. frame.add(lowAdminPanel);
  1405. frame.repaint();
  1406. }
  1407. if(e.getSource()==createTourBack)
  1408. {
  1409. frame.remove(createTournamentPanel);
  1410. frame.add(highAdminPanel);
  1411. frame.repaint();
  1412. }
  1413. if(e.getSource()==removeMatchBack)
  1414. {
  1415. frame.remove(removeMatchPanel);
  1416. if(userLevel==1)
  1417. frame.add(highAdminPanel);
  1418. else
  1419. frame.add(lowAdminPanel);
  1420. frame.repaint();
  1421. }
  1422. if(e.getSource()==removeTourBack)
  1423. {
  1424. frame.remove(removeTournamentPanel);
  1425. frame.add(highAdminPanel);
  1426. frame.repaint();
  1427. }
  1428. if(e.getSource()==loginWelcomePanel)
  1429. {
  1430. String r = loginQuery(nameWelcomePanel.getText(),passwordWelcomePanel.getText());
  1431. if(r==null)
  1432. JOptionPane.showMessageDialog(null, "The Username or Password is not Correct","Error Message",JOptionPane.PLAIN_MESSAGE );
  1433.  
  1434. else
  1435. {
  1436. userName = nameWelcomePanel.getText();
  1437. if(r.equals("Registered"))
  1438. {
  1439. userLevel = 3;
  1440. frame.remove(welcomePanel);
  1441. frame.add(userPanel);
  1442. frame.repaint();
  1443. }
  1444. else
  1445. {
  1446. int level = adminLevel(nameWelcomePanel.getText());
  1447. System.out.println(level);
  1448. if(level==2)
  1449. {
  1450. userLevel = 2;
  1451. frame.remove(welcomePanel);
  1452. frame.add(lowAdminPanel);
  1453. frame.repaint();
  1454. }
  1455. else
  1456. {
  1457. userLevel = 1;
  1458. frame.remove(welcomePanel);
  1459. frame.add(highAdminPanel);
  1460. frame.repaint();
  1461. }
  1462. }
  1463. }
  1464. }
  1465. if(e.getSource()==regWelcomePanel)
  1466. {
  1467. frame.remove(welcomePanel);
  1468. frame.add(regPanel);
  1469. frame.repaint();
  1470. }
  1471. if(e.getSource()==back)
  1472. {
  1473. frame.remove(regPanel);
  1474. frame.add(welcomePanel);
  1475. frame.repaint();
  1476. }
  1477. if(e.getSource()==logOutL)
  1478. {
  1479. frame.remove(lowAdminPanel);
  1480. frame.add(welcomePanel);
  1481. frame.repaint();
  1482. }
  1483. if(e.getSource()==logOutH)
  1484. {
  1485. frame.remove(highAdminPanel);
  1486. frame.add(welcomePanel);
  1487. frame.repaint();
  1488. }
  1489. if(e.getSource()==logOutR)
  1490. {
  1491. frame.remove(userPanel);
  1492. frame.add(welcomePanel);
  1493. frame.repaint();
  1494. }
  1495. if(e.getSource()==regButtonRegPanel)
  1496. {
  1497. if(checkUserNameQuery(userNameField.getText())&&userNameField.getText().length()>0)
  1498. {
  1499. if(firstNameField.getText()==null||firstNameField.getText().length()<1)
  1500. {
  1501. JOptionPane.showMessageDialog(null, "Please Enter Your FirstName","Error Message",JOptionPane.PLAIN_MESSAGE );
  1502. }
  1503. else
  1504. {
  1505. if(passwordField.getText().equals(retypePasswordField.getText())&&passwordField.getText().length()>0)
  1506. {
  1507. if(insertUserQuery(firstNameField.getText(),middleNameField.getText(),lastNameField.getText(),telephoneField.getText(),userNameField.getText(),mailField.getText(),passwordField.getText(),dateOfBirthField.getText(),countryField.getText(),mobileField.getText()))
  1508. {
  1509. JOptionPane.showMessageDialog(null, "You Registered Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
  1510. userName = userNameField.getText();
  1511. userLevel = 3;
  1512. frame.remove(regPanel);
  1513. frame.add(userPanel);
  1514. frame.repaint();
  1515. }
  1516. else
  1517. {
  1518. JOptionPane.showMessageDialog(null, "Error Ocurred Please Check Your Data Carefully","Error Message",JOptionPane.PLAIN_MESSAGE );
  1519. }
  1520. }
  1521. else
  1522. {
  1523. JOptionPane.showMessageDialog(null, "The Password Doesn't Match","Error Message",JOptionPane.PLAIN_MESSAGE );
  1524. }
  1525. }
  1526. }
  1527. else
  1528. JOptionPane.showMessageDialog(null, "The Username Is Used","Error Message",JOptionPane.PLAIN_MESSAGE );
  1529. }
  1530. if(e.getSource()==createTourH)
  1531. {
  1532. frame.remove(highAdminPanel);
  1533. frame.add(createTournamentPanel);
  1534. frame.repaint();
  1535.  
  1536. }
  1537. if(e.getSource()==createMatchH)
  1538. {
  1539. frame.remove(highAdminPanel);
  1540. frame.add(createMatchPanel);
  1541. frame.repaint();
  1542. }
  1543. if(e.getSource()==createMatch)
  1544. {
  1545. frame.remove(lowAdminPanel);
  1546. frame.add(createMatchPanel);
  1547. frame.repaint();
  1548. }
  1549. if(e.getSource()==deleteTourH)
  1550. {
  1551. frame.remove(highAdminPanel);
  1552. frame.add(removeTournamentPanel);
  1553. frame.repaint();
  1554. }
  1555. if(e.getSource()==deleteMatchH)
  1556. {
  1557. frame.remove(highAdminPanel);
  1558. frame.add(removeMatchPanel);
  1559. frame.repaint();
  1560. }
  1561. if(e.getSource()==deleteMatch)
  1562. {
  1563. frame.remove(lowAdminPanel);
  1564. frame.add(removeMatchPanel);
  1565. frame.repaint();
  1566. }
  1567. if(e.getSource()==userReserve)
  1568. {
  1569. frame.remove(userPanel);
  1570. frame.add(reserveTicketPanel);
  1571. viewTicketQuery();
  1572. frame.repaint();
  1573. }
  1574. if(e.getSource()==userFind)
  1575. {
  1576. frame.remove(userPanel);
  1577. frame.add(findMatchesPanel);
  1578. frame.repaint();
  1579. }
  1580. }
  1581. public boolean finalQuery()
  1582. {
  1583. try
  1584. {
  1585. Statement st = con.createStatement();
  1586. ResultSet rs = st.executeQuery("select seatnumber from [Ticket] where id='"+reserveTicketFieldU.getText()+"' and category='"+categoryField.getText()+"'");
  1587. String x ="";
  1588. while(rs.next())
  1589. {
  1590. x = x+rs.getObject(1)+" ";
  1591. }
  1592. String [] in = x.split(" ");
  1593. boolean found = true;
  1594. int xi = 1;
  1595. for(int i = 1 ; i>0 & found ; ++i)
  1596. {
  1597. found = false;
  1598. for(int j = 0 ; j<in.length ; ++j)
  1599. if((i+"").equals(in[j]))
  1600. found = true;
  1601. if(!found)
  1602. {
  1603. xi = i;
  1604. }
  1605. }
  1606. st.executeUpdate("insert into [Ticket] values ('"+xi+"'"+","+"'"+categoryField.getText()+"'"+","+"'"+userName+"'"+","+"'"+reserveTicketFieldU.getText()+"')");
  1607. return true;
  1608. }
  1609. catch(Exception e)
  1610. {
  1611. return false;
  1612. }
  1613. }
  1614. public boolean categoryQuery()
  1615. {
  1616. try
  1617. {
  1618. Statement st = con.createStatement();
  1619. System.out.println("select numofseats from [Match] where id='"+reserveTicketFieldU.getText()+"'");
  1620. ResultSet rs = st.executeQuery("select numofseats from [Match] where id='"+reserveTicketFieldU.getText()+"'");
  1621. rs.next();
  1622. int s = new Integer(""+rs.getObject(1));
  1623. int cat1 = s/2;
  1624. int cat2 = s/4;
  1625. int cat3 = s/4;
  1626. int cat1r = 0;
  1627. int cat2r = 0;
  1628. int cat3r = 0;
  1629. rs = st.executeQuery("select * from [Ticket] where id='"+reserveTicketFieldU.getText()+"'");
  1630. ResultSetMetaData rsm = rs.getMetaData();
  1631. int columns = rsm.getColumnCount();
  1632. while(rs.next())
  1633. {
  1634. for(int i = 1 ; i<=columns ; ++i)
  1635. {
  1636. if(rsm.getColumnName(i).equals("category"))
  1637. {
  1638. String temp = ""+rs.getObject(i);
  1639. if(temp.equals("1"))
  1640. {
  1641. cat1r ++;
  1642. }
  1643. else
  1644. if(temp.equals("2"))
  1645. {
  1646. cat2r++;
  1647. }
  1648. else
  1649. {
  1650. cat3r++;
  1651. }
  1652. }
  1653. }
  1654. }
  1655. if(cat1r<cat1)
  1656. {
  1657. category1Label . setText(" Category 1 has Empty Seats");
  1658. cflag1 = true;
  1659. }
  1660. else
  1661. {
  1662. category1Label . setText(" Category 1 doesn't have Empty Seats");
  1663. cflag1 = false;
  1664. }
  1665. if(cat2r<cat2)
  1666. {
  1667. category2Label . setText(" Category 2 has Empty Seats");
  1668. cflag2 = true;
  1669. }
  1670. else
  1671. {
  1672. category2Label . setText(" Category 2 doesn't have Empty Seats");
  1673. cflag2 = false;
  1674. }
  1675. if(cat3r<cat3)
  1676. {
  1677. category3Label . setText(" Category 3 has Empty Seats");
  1678. cflag3 = true;
  1679. }
  1680. else
  1681. {
  1682. category3Label . setText(" Category 3 doesn't have Empty Seats");
  1683. cflag3 = false;
  1684. }
  1685. return true;
  1686. }
  1687. catch (Exception e) {System.out.println(e.getMessage());return false;}
  1688. }
  1689. public boolean ticketQuery()
  1690. {
  1691. return true ;
  1692. }
  1693. public boolean findTourQuery()
  1694. {
  1695. try
  1696. {
  1697. Statement st = con.createStatement();
  1698. ResultSet rs = st.executeQuery("select * from [Tournament] u where u.startdate = '"+findMatchesField.getText()+" 12:00:00 AM'");
  1699. ResultSetMetaData rsm = rs.getMetaData();
  1700. int columns = rsm.getColumnCount();
  1701. boolean flag = false;
  1702. int x = 0 ;
  1703. while (rs.next())
  1704. {
  1705. flag = true;
  1706. for (int i = 1,y=0; i <= columns; i++,y++)
  1707. {
  1708. Object rT = rs.getObject(i);
  1709. String r;
  1710. if(rT!=null)
  1711. r=""+rT;
  1712. else
  1713. r="Empty";
  1714. if(r!=null)
  1715. findMatchesTable.setValueAt(r,x,y);
  1716. else
  1717. findMatchesTable.setValueAt("Empty",x,y);
  1718. }
  1719. x++;
  1720. }
  1721. if(!flag)
  1722. return false;
  1723. return true;
  1724. }
  1725. catch (Exception e) {return false;}
  1726. }
  1727. public boolean updateMatchQuery(String tourName)
  1728. {
  1729. try
  1730. {
  1731. Statement st = con.createStatement();
  1732. ResultSet rs = st.executeQuery("select * from [Match] where id = '"+tourName+"'");
  1733. ResultSetMetaData rsm = rs.getMetaData();
  1734. int columns = rsm.getColumnCount();
  1735. String x = "";
  1736. while (rs.next())
  1737. {
  1738. rs.getObject(1);
  1739. for(int i = 2 ; i<=columns ; ++i)
  1740. x=x+""+rs.getObject(i)+" ";
  1741. }
  1742. if(x.equals(""))
  1743. return false;
  1744. String [] in = x.split(" ");
  1745.  
  1746. if(numOfSeatsFieldU.getText().length()>0)
  1747. {
  1748. in[0]=numOfSeatsFieldU.getText();
  1749. in[0]=""+((new Integer(numOfSeatsFieldU.getText())/4) *4);
  1750. }
  1751. if(matchWeightFieldU.getText().length()>0)
  1752. {
  1753. in[1]=matchWeightFieldU.getText();
  1754. }
  1755. if(locationFieldU.getText().length()>0)
  1756. {
  1757. in[2]=locationFieldU.getText();
  1758. }
  1759. if(tourIdFieldUP.getText().length()>0)
  1760. {
  1761. in[3]=tourIdFieldUP.getText();
  1762. }
  1763. if(firstTeamFieldU.getText().length()>0)
  1764. {
  1765. in[4]=firstTeamFieldU.getText();
  1766. }
  1767. if(secondTeamFieldU.getText().length()>0)
  1768. {
  1769. in[5]=secondTeamFieldU.getText();
  1770. }
  1771. for(int i = 0 ; i<in.length;++i)
  1772. in[i]="'"+in[i]+"'";
  1773. String r = "update [Match] set numofseats="+in[0]+",matchweight="+in[1]+",location="+in[2]+",trid="+in[3]+",teamname1="+in[4]+",teamname2="+in[5]+" where id = '"+tourName+"'";
  1774. st.executeUpdate(r);
  1775.  
  1776. return true;
  1777. }
  1778. catch (Exception e) {return false;}
  1779. }
  1780. public boolean updateTourQuery(String tourName)
  1781. {
  1782. try
  1783. {
  1784. Statement st = con.createStatement();
  1785. ResultSet rs = st.executeQuery("select * from [Tournament] where trid = '"+tourName+"'");
  1786. ResultSetMetaData rsm = rs.getMetaData();
  1787. int columns = rsm.getColumnCount();
  1788. String x = "";
  1789. while (rs.next())
  1790. {
  1791. for(int i = 1 ; i<=columns ; ++i)
  1792. x=x+""+rs.getObject(i)+" ";
  1793. }
  1794. if(x.equals(""))
  1795. return false;
  1796. String [] in = x.split(" ");
  1797.  
  1798. if(tourNameFieldU.getText().length()>0)
  1799. {
  1800. in[0]=tourNameFieldU.getText();
  1801. }
  1802. if(tourDescripFieldU.getText().length()>0)
  1803. {
  1804. in[1]=tourDescripFieldU.getText();
  1805. }
  1806. if(tourStartDateFieldU.getText().length()>0)
  1807. {
  1808. in[2]=tourStartDateFieldU.getText()+" 12:00:00 AM";
  1809. }
  1810. else
  1811. {
  1812. in[2]=" 12:00:00 AM";
  1813. }
  1814. if(tourEndDateFieldU.getText().length()>0)
  1815. {
  1816. in[3]=tourEndDateFieldU.getText()+" 12:00:00 AM";
  1817. }
  1818. else
  1819. {
  1820. in[3]=" 12:00:00 AM";
  1821. }
  1822. if(tourTypeFieldU.getText().length()>0)
  1823. {
  1824. in[4]=tourTypeFieldU.getText();
  1825. }
  1826. if(tourOpenDateFieldU.getText().length()>0)
  1827. {
  1828. in[5]=tourOpenDateFieldU.getText();
  1829. }
  1830. if(tourCloseDateFieldU.getText().length()>0)
  1831. {
  1832. in[6]=tourCloseDateFieldU.getText();
  1833. }
  1834. for(int i = 0 ; i<in.length;++i)
  1835. in[i]="'"+in[i]+"'";
  1836.  
  1837. String r = "update [Tournament] set name="+in[0]+",description="+in[1]+",startdate="+in[2]+",enddate="+in[3]+",type="+in[4]+",opening_ceremony_date="+in[5]+",closing_ceremony_date="+in[6]+" where trid = '"+tourName+"'";
  1838. st.executeUpdate(r);
  1839. return true;
  1840. }
  1841. catch (Exception e) {return false;}
  1842. }
  1843. public boolean updateQuery()
  1844. {
  1845. try
  1846. {
  1847. Statement st = con.createStatement();
  1848. String a = "update [Registered] set dateofbirth = "+"'"+(dateOfBirthFieldU.getText())+" 12:00:00 AM'"+",country = '"+(countryFieldU.getText())+"',mobile = "+"'"+(mobileFieldU.getText())+"' where '"+userName+"'"+" = username";
  1849. String b = "update [User] set firstname = "+"'"+(firstNameFieldU.getText())+"'"+",middlename = '"+(middleNameFieldU.getText())+"',lastname = "+"'"+(lastNameFieldU.getText())+"',"+"telephone = '"+telephoneFieldU.getText()+"',"+"password = '"+passwordFieldU.getText()+"',"+"email = '"+mailFieldU.getText()+"' where '"+userName+"'"+" = username";
  1850. System.out.println(a);
  1851. System.out.println(b);
  1852. st.executeUpdate(a);
  1853. st.executeUpdate(b);
  1854. return true;
  1855. }
  1856. catch (Exception e) {return false;}
  1857. }
  1858. public void userDetailsQuery()
  1859. {
  1860. try
  1861. {
  1862. Statement st = con.createStatement();
  1863. ResultSet rs = st.executeQuery("select * from [User] u,[Registered] r where u.username='"+userName+"' and r.username="+"'"+userName+"'");
  1864. ResultSetMetaData rsm = rs.getMetaData();
  1865. int columns = rsm.getColumnCount();
  1866. rs.next();
  1867. firstNameFieldU.setText(""+rs.getObject(1));
  1868. middleNameFieldU.setText(""+rs.getObject(2));
  1869. lastNameFieldU.setText(""+rs.getObject(3));
  1870. telephoneFieldU.setText(""+rs.getObject(4));
  1871. rs.getObject(5);
  1872. mailFieldU.setText(""+rs.getObject(6));
  1873. String t = ""+rs.getObject(7);
  1874. passwordFieldU.setText(t);
  1875. retypePasswordFieldU.setText(t);
  1876. rs.getObject(8);
  1877. dateOfBirthFieldU.setText(""+rs.getObject(9));
  1878. dateOfBirthFieldU.setText("");
  1879. countryFieldU.setText(""+rs.getObject(10));
  1880. mobileFieldU.setText(""+rs.getObject(11));
  1881. for(int i = 12 ; i<=columns ; ++i)
  1882. rs.getObject(i);
  1883. rs.next();
  1884. }
  1885. catch (Exception e) {System.out.println("Error");}
  1886. }
  1887. public boolean insertUserQuery(String n1,String n2,String n3,String n4,String n5,String n6 ,String n7 ,String n8 , String n9,String n10)
  1888. {
  1889. try
  1890. {
  1891. Statement st = con.createStatement();
  1892. n8="'"+n8+" 12:00:00 AM'";
  1893. n1="'"+n1+"'";n2="'"+n2+"'";n3="'"+n3+"'";n4="'"+n4+"'";n5="'"+n5+"'";n6="'"+n6+"'";n7="'"+n7+"'";n9="'"+n9+"'";n10="'"+n10+"'";
  1894. st.executeUpdate("insert into [User] values ("+n1+","+n2+","+n3+","+n4+","+n5+","+n6+","+n7+","+"'Registered')");
  1895. st.executeUpdate("insert into [Registered] values ("+n8+","+n9+","+n10+","+n5+")");
  1896. return true;
  1897. }
  1898. catch (Exception e)
  1899. {
  1900. try
  1901. {
  1902. Statement st = con.createStatement();
  1903. st.executeUpdate("delete from [user] where username = "+n5);
  1904. }
  1905. catch(Exception ee)
  1906. {
  1907. return false;
  1908. }
  1909. return false;
  1910. }
  1911. }
  1912. public boolean checkUserNameQuery(String n)
  1913. {
  1914. try
  1915. {
  1916. Statement st = con.createStatement();
  1917. ResultSet rs = st.executeQuery("select username from [User]");
  1918. boolean flag = true;
  1919. while(rs.next())
  1920. {
  1921. String r = ""+rs.getObject(1);
  1922. if(n.equals(r))
  1923. flag = false;
  1924. }
  1925. return flag;
  1926. }
  1927. catch (Exception e) {return false;}
  1928. }
  1929. public static void connectUsingJDBC()
  1930. {
  1931. String dataSourceName = "Stadium";
  1932. try
  1933. {
  1934. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  1935. String dbURL = "jdbc:odbc:" + dataSourceName;
  1936. con = DriverManager.getConnection(dbURL);
  1937. System.out.println("User connected using driver: " + con.getMetaData().getDriverName());
  1938. }
  1939. catch (Exception e)
  1940. {
  1941. e.printStackTrace();
  1942. }
  1943. }
  1944. public static String loginQuery(String n,String p)
  1945. {
  1946. try
  1947. {
  1948. Statement st = con.createStatement();
  1949. ResultSet rs = st.executeQuery("select typ from [user] u where u.username = "+"'"+n+"'"+" and "+"'"+p+"'"+" = u.password");
  1950. rs.next();
  1951. String t = ""+rs.getObject(1);
  1952. System.out.println(t);
  1953. return t;
  1954. }
  1955. catch (Exception e) {return null;}
  1956. }
  1957. public void viewTicketQuery()
  1958. {
  1959. try
  1960. {
  1961. Statement st = con.createStatement();
  1962. ResultSet rs = st.executeQuery("select * from Ticket where username='"+userName+"'");
  1963. ResultSetMetaData rsm = rs.getMetaData();
  1964. int columns = rsm.getColumnCount();
  1965. int x = 0 ;
  1966. while (rs.next())
  1967. {
  1968. for (int i = 1,y=0; i <= columns; i++,y++)
  1969. {
  1970. Object rT = rs.getObject(i);
  1971. String r;
  1972. if(rT!=null)
  1973. r=""+rT;
  1974. else
  1975. r="Empty";
  1976. if(r!=null)
  1977. reserveTicketTable.setValueAt(r,x,y);
  1978. else
  1979. reserveTicketTable.setValueAt("Empty",x,y);
  1980. }
  1981. x++;
  1982. }
  1983. }
  1984. catch (Exception e) {System.out.println(e.getMessage());}
  1985. }
  1986. public void viewTourQuery()
  1987. {
  1988. try
  1989. {
  1990. Statement st = con.createStatement();
  1991. ResultSet rs = st.executeQuery("select * from [Tournament]");
  1992. ResultSetMetaData rsm = rs.getMetaData();
  1993. int columns = rsm.getColumnCount();
  1994. int x = 0 ;
  1995. while (rs.next())
  1996. {
  1997. for (int i = 1,y=0; i <= columns; i++,y++)
  1998. {
  1999. Object rT = rs.getObject(i);
  2000. String r;
  2001. if(rT!=null)
  2002. r=""+rT;
  2003. else
  2004. r="Empty";
  2005. if(r!=null)
  2006. viewTourTable.setValueAt(r,x,y);
  2007. else
  2008. viewTourTable.setValueAt("Empty",x,y);
  2009. }
  2010. x++;
  2011. }
  2012. }
  2013. catch (Exception e) {System.out.println(e.getMessage());}
  2014. }
  2015. public void viewMatchQuery()
  2016. {
  2017. try
  2018. {
  2019. Statement st = con.createStatement();
  2020. ResultSet rs = st.executeQuery("select * from [Match]");
  2021. ResultSetMetaData rsm = rs.getMetaData();
  2022. int columns = rsm.getColumnCount();
  2023. int x = 0 ;
  2024. while (rs.next())
  2025. {
  2026. for (int i = 1,y=0; i <= columns; i++,y++)
  2027. {
  2028. Object rT = rs.getObject(i);
  2029. String r;
  2030. if(rT!=null)
  2031. r=""+rT;
  2032. else
  2033. r="Empty";
  2034. if(r!=null)
  2035. viewMatchTable.setValueAt(r,x,y);
  2036. else
  2037. viewMatchTable.setValueAt("Empty",x,y);
  2038. }
  2039. x++;
  2040. }
  2041. }
  2042. catch (Exception e) {System.out.println(e.getMessage());}
  2043. }
  2044. public boolean createMatchQuery(String seats , String weight , String id , String n1 , String n2)
  2045. {
  2046. try
  2047. {
  2048. new Integer(seats);
  2049. new Integer(weight);
  2050. boolean flag1 = false;
  2051. boolean flag2 = false;
  2052. boolean flag3 = false;
  2053. Statement st = con.createStatement();
  2054. ResultSet rs1 = st.executeQuery("select trid from [Tournament]");
  2055.  
  2056. while(rs1.next())
  2057. {
  2058. String temp = ""+rs1.getObject(1);
  2059. if(temp.equals(id))
  2060. flag1 = true;
  2061. }
  2062. ResultSet rs2 = st.executeQuery("select teamname from [Team]");
  2063. while(rs2.next())
  2064. {
  2065. String temp = ""+rs2.getObject(1);
  2066. if(temp.equals(n1))
  2067. flag2 = true;
  2068. else
  2069. if(temp.equals(n2))
  2070. flag3 = true;
  2071. }
  2072. if(!n1.equals(n2))
  2073. return flag1&&flag2&&flag3;
  2074. return false;
  2075. }
  2076. catch(Exception e){return false;}
  2077. }
  2078. public void insertMatchQuery(String n1,String n2,String n3,String n4,String n5,String n6)
  2079. {
  2080. n1 = ""+((new Integer(n1)/4) * 4);
  2081. n1 = "'"+n1+"'"; n2 = "'"+n2+"'"; n4 = "'"+n4+"'"; n3 = "'"+n3+"'"; n5 = "'"+n5+"'"; n6 = "'"+n6+"'";
  2082. String r = "insert into [Match] values("+n1+","+n2+","+n3+","+n4+","+n5+","+n6+")";
  2083. try
Add Comment
Please, Sign In to add comment