Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import javax.swing.*;
- import java.awt.*;
- import java.awt.event.*;
- import java.sql.*;
- import javax.swing.JOptionPane;
- public class DBGui implements ActionListener
- {
- static Connection con;
- String userName;
- int userLevel ;
- int width = 500;
- int height = 700;
- String [] [] data = new String[10000][8];
- String tourCol[] = {"Name","Description","StartDate","EndDate","Type","StartCeremonyDate","ClosingCeremonyDate","ID"};
- String matchCol [] = {"ID","NumberOfSeats","MatchWeight","Location","TournamentID","FirstTeam","SecondTeam"};
- String ticketCol[] = {"Seat Number","Category","User Name","Match ID","Ticket ID","Price"};
- JFrame frame ;
- JScrollPane scrollPane ;
- JScrollPane scrollPaneViewTour;
- JScrollPane scrollPanelViewMatch;
- /*************************************************** WelcomePanel ****************************************************/
- JPanel welcomePanel;
- JLabel nameWelcomePanelLabel;
- JLabel passwordWelcomePanelLabel;
- JTextField nameWelcomePanel;
- JPasswordField passwordWelcomePanel;
- JButton loginWelcomePanel;
- JButton regWelcomePanel;
- ImageIcon ballIcon ;
- JLabel ballLabel ;
- /*************************************************** WelcomePanel ****************************************************/
- /*************************************************** RegPanel ****************************************************/
- JPanel regPanel;
- JLabel firstNameLabel;
- JLabel middleNameLabel;
- JLabel lastNameLabel;
- JLabel telephoneLabel;
- JLabel mailLabel;
- JLabel userNameLabel;
- JLabel passwordLabel;
- JLabel retypePasswordLabel;
- JLabel countryLabel ;
- JLabel mobileLabel;
- JButton regButtonRegPanel ;
- JLabel dateOfBirthLabel;
- JButton back ;
- JTextField firstNameField;
- JTextField middleNameField;
- JTextField lastNameField;
- JTextField telephoneField;
- JTextField mailField;
- JTextField userNameField;
- JPasswordField passwordField;
- JPasswordField retypePasswordField;
- JTextField countryField;
- JTextField dateOfBirthField;
- JTextField mobileField;
- /*************************************************** RegPanel ****************************************************/
- /*************************************************** lowAdminPanel ****************************************************/
- JPanel lowAdminPanel;
- JButton viewTourL;
- JButton viewMatchL;
- JButton createMatch;
- JButton editMatch;
- JButton deleteMatch;
- JButton logOutL;
- /*************************************************** lowAdminPanel ****************************************************/
- /*************************************************** highAdminPanel ****************************************************/
- JPanel highAdminPanel;
- JButton viewTourH;
- JButton viewMatchH;
- JButton createMatchH;
- JButton editMatchH;
- JButton deleteMatchH;
- JButton createTourH;
- JButton editTourH;
- JButton deleteTourH;
- JButton logOutH;
- /*************************************************** highAdminPanel ****************************************************/
- /*************************************************** userPanel ****************************************************/
- JPanel userPanel;
- JButton userUpdate;
- JButton userView;
- JButton userReserve;
- JButton userFind;
- JButton userCancel;
- JButton userTour;
- JButton userMatch;
- JButton logOutR;
- /*************************************************** userPanel ****************************************************/
- /*************************************************** createTournamentPanel ****************************************************/
- JPanel createTournamentPanel;
- JTextField tourDescripField;
- JTextField tourNameField;
- JTextField tourStartDateField;
- JTextField tourEndDateField;
- JTextField tourTypeField;
- JTextField tourOpenDateField;
- JTextField tourCloseDateField;
- JLabel tourDescripLabel;
- JLabel tourNameLabel;
- JLabel tourStartDateLabel;
- JLabel tourEndDateLabel;
- JLabel tourTypeLabel;
- JLabel tourOpenDateLabel;
- JLabel tourCloseDateLabel;
- JButton createTourBack;
- JButton createCurrentTour;
- /*************************************************** createTournamentPanel ****************************************************/
- /*************************************************** createMatchPanel ****************************************************/
- JPanel createMatchPanel;
- JTextField numOfSeatsField;
- JTextField matchWeightField;
- JTextField locationField;
- JTextField tourIdField;
- JTextField firstTeamField;
- JTextField secondTeamField;
- JLabel numOfSeatsLabel;
- JLabel matchWeightLabel;
- JLabel locationLabel;
- JLabel tourIdLabel;
- JLabel firstTeamLabel;
- JLabel secondTeamLabel;
- JButton createMatchBack;
- JButton createCurrentMatch;
- /*************************************************** createMatchPanel ****************************************************/
- /*************************************************** removeTournamentPanel ****************************************************/
- JPanel removeTournamentPanel;
- JTextField removeTourIdField;
- JLabel removeTourIdLabel;
- JButton removeCurrentTour;
- JButton removeTourBack;
- /*************************************************** removeTournamentPanel ****************************************************/
- /*************************************************** removeMatchPanel ****************************************************/
- JPanel removeMatchPanel;
- JTextField removeMatchIdField;
- JLabel removeMatchIdLabel;
- JButton removeCurrentMatch;
- JButton removeMatchBack;
- /*************************************************** removeMatchPanel ****************************************************/
- /*************************************************** reserveTicketPanel ****************************************************/
- JPanel reserveTicketPanel;
- JTable reserveTicketTable;
- JTextField reserveTicketField;
- JLabel reserveTicketLabel;
- JButton reserveTicketBack;
- JButton reserveCurrentTicket;
- JButton cancelReserveTicket;
- /*************************************************** reserveTicketPanel ****************************************************/
- /*************************************************** viewTournamentsPanel ****************************************************/
- JPanel viewTourPanel;
- JTable viewTourTable;
- JScrollPane viewTourPane;
- JButton viewTourBack;
- /*************************************************** viewTournamentsPanel ****************************************************/
- /*************************************************** viewMatchesPanel ****************************************************/
- JPanel viewMatchPanel;
- JTable viewMatchTable;
- JScrollPane viewMatchPane;
- JButton viewMatchBack;
- /*************************************************** viewMatchesPanel ****************************************************/
- /*************************************************** findMatchesPanel ****************************************************/
- JPanel findMatchesPanel;
- JTextField findMatchesField;
- JLabel findMatchesLabel;
- JButton findMatchesBack;
- JButton findMatchesFind;
- JTable findMatchesTable;
- JScrollPane findMatchesPane;
- /*************************************************** findMatchesPanel ****************************************************/
- /*************************************************** editProfilePanel ****************************************************/
- JPanel regPanelU;
- JLabel firstNameLabelU;
- JLabel middleNameLabelU;
- JLabel lastNameLabelU;
- JLabel telephoneLabelU;
- JLabel mailLabelU;
- JLabel passwordLabelU;
- JLabel retypePasswordLabelU;
- JLabel countryLabelU;
- JLabel mobileLabelU;
- JButton updateButtonRegPanel;
- JLabel dateOfBirthLabelU;
- JButton backU;
- JTextField firstNameFieldU;
- JTextField middleNameFieldU;
- JTextField lastNameFieldU;
- JTextField telephoneFieldU;
- JTextField mailFieldU;
- JPasswordField passwordFieldU;
- JPasswordField retypePasswordFieldU;
- JTextField countryFieldU;
- JTextField dateOfBirthFieldU;
- JTextField mobileFieldU;
- /*************************************************** editProfilePanel ****************************************************/
- /*************************************************** editTourPanel ****************************************************/
- JPanel createTournamentPanelU ;
- JTextField tourDescripFieldU;
- JTextField tourNameFieldU;
- JTextField tourStartDateFieldU;
- JTextField tourEndDateFieldU;
- JTextField tourTypeFieldU;
- JTextField tourOpenDateFieldU;
- JTextField tourCloseDateFieldU;
- JTextField tourIdFieldU;
- JLabel tourDescripLabelU;
- JLabel tourNameLabelU;
- JLabel tourStartDateLabelU;
- JLabel tourEndDateLabelU;
- JLabel tourTypeLabelU;
- JLabel tourOpenDateLabelU;
- JLabel tourCloseDateLabelU;
- JLabel tourIdLabelU;
- JButton createTourBackU;
- JButton createCurrentTourU;
- /*************************************************** editTourPanel ****************************************************/
- /*************************************************** editMatchPanel ****************************************************/
- JPanel createMatchPanelU;
- JTextField numOfSeatsFieldU;
- JTextField matchWeightFieldU;
- JTextField locationFieldU;
- JTextField tourIdFieldUP;
- JTextField firstTeamFieldU;
- JTextField secondTeamFieldU;
- JTextField matchFieldU;
- JLabel numOfSeatsLabelU;
- JLabel matchWeightLabelU;
- JLabel locationLabelU;
- JLabel tourIdLabelUP;
- JLabel firstTeamLabelU;
- JLabel secondTeamLabelU;
- JLabel matchLabelU;
- JButton createMatchBackU;
- JButton createCurrentMatchU;
- /*************************************************** editMatchPanel ****************************************************/
- /*************************************************** reserveTicketPanel ****************************************************/
- JPanel reserveTicketPanelU;
- JLabel reserveTicketLabelU;
- JTextField reserveTicketFieldU;
- JButton reserveTicketBackU;
- JButton reserveTicketNextU;
- /*************************************************** reserveTicketPanel ****************************************************/
- /*************************************************** categoryPanel ****************************************************/
- JPanel categoryPanel ;
- JLabel category1Label;
- JLabel category2Label;
- JLabel category3Label;
- JTextField categoryField;
- JButton categoryBack;
- JButton categoryNext;
- boolean cflag1;
- boolean cflag2;
- boolean cflag3;
- /*************************************************** categoryPanel ****************************************************/
- public void categoryPanel()
- {
- categoryPanel = new JPanel();
- categoryPanel . setBounds(0,0,width,height);
- categoryPanel . setLayout(null);
- category1Label = new JLabel();
- category2Label = new JLabel();
- category3Label = new JLabel();
- category1Label .setBounds(0,50,width,40);
- category2Label .setBounds(0,200,width,40);
- category3Label .setBounds(0,350,width,40);
- categoryField = new JTextField("Type The Number Of Category");
- categoryField . setBounds(width/2-100,450,200,20);
- categoryNext = new JButton("Next");
- categoryNext . setBounds(0,600,200,20);
- categoryBack = new JButton("Back");
- categoryBack . setBounds(width-200-5,600,200,20);
- categoryNext.addActionListener(this);
- categoryBack.addActionListener(this);
- categoryPanel.add(category1Label);
- categoryPanel.add(category2Label);
- categoryPanel.add(category3Label);
- categoryPanel.add(categoryField);
- categoryPanel.add(categoryNext);
- categoryPanel.add(categoryBack);
- }
- public void reserveTicketPanelU()
- {
- reserveTicketPanelU = new JPanel();
- reserveTicketPanelU . setBounds(0,0,width,height);
- reserveTicketPanelU . setLayout(null);
- reserveTicketLabelU = new JLabel("Type The Match ID");
- reserveTicketLabelU . setBounds(30,100,200,20);
- reserveTicketFieldU = new JTextField();
- reserveTicketFieldU . setBounds(250,100,200,20);
- reserveTicketBackU = new JButton("Back");
- reserveTicketNextU = new JButton("Next");
- reserveTicketBackU . setBounds(0,400,200,20);
- reserveTicketNextU . setBounds(0,500,200,20);
- reserveTicketBackU . addActionListener(this);
- reserveTicketNextU . addActionListener(this);
- reserveTicketPanelU.add(reserveTicketLabelU);
- reserveTicketPanelU.add(reserveTicketFieldU);
- reserveTicketPanelU.add(reserveTicketNextU);
- reserveTicketPanelU.add(reserveTicketBackU);
- }
- public void editMatchPanel()
- {
- createMatchPanelU = new JPanel();
- createMatchPanelU . setBounds(0,0,width,height);
- createMatchPanelU . setLayout(null);
- numOfSeatsLabelU = new JLabel("Number Of Seats *");
- matchWeightLabelU = new JLabel("Match Weight *");
- locationLabelU = new JLabel("Match Location");
- tourIdLabelUP = new JLabel("Tournament ID *");
- firstTeamLabelU = new JLabel("First Team Name *");
- secondTeamLabelU = new JLabel("Second Team Name *");
- numOfSeatsFieldU = new JTextField();
- matchWeightFieldU = new JTextField();
- locationFieldU = new JTextField();
- tourIdFieldUP = new JTextField();
- firstTeamFieldU = new JTextField();
- secondTeamFieldU = new JTextField();
- matchFieldU = new JTextField();
- matchLabelU = new JLabel("Match ID To Be Updated");
- numOfSeatsLabelU.setBounds(30,30,200,20);
- numOfSeatsFieldU.setBounds(250,30,200,20);
- matchWeightLabelU.setBounds(30,80,200,20);
- matchWeightFieldU.setBounds(250,80,200,20);
- locationLabelU.setBounds(30,130,200,20);
- locationFieldU.setBounds(250,130,200,20);
- tourIdLabelUP.setBounds(30,180,200,20);
- tourIdFieldUP.setBounds(250,180,200,20);
- firstTeamLabelU.setBounds(30,230,200,20);
- firstTeamFieldU.setBounds(250,230,200,20);
- secondTeamLabelU.setBounds(30,280,200,20);
- secondTeamFieldU.setBounds(250,280,200,20);
- matchFieldU.setBounds(250,330,200,20);
- matchLabelU.setBounds(30,330,200,20);
- createMatchPanelU.add(numOfSeatsLabelU);
- createMatchPanelU.add(numOfSeatsFieldU);
- createMatchPanelU.add(matchWeightLabelU);
- createMatchPanelU.add(matchWeightFieldU);
- createMatchPanelU.add(locationLabelU);
- createMatchPanelU.add(locationFieldU);
- createMatchPanelU.add(tourIdLabelUP);
- createMatchPanelU.add(tourIdFieldUP);
- createMatchPanelU.add(firstTeamLabelU);
- createMatchPanelU.add(firstTeamFieldU);
- createMatchPanelU.add(secondTeamLabelU);
- createMatchPanelU.add(secondTeamFieldU);
- createMatchPanelU.add(matchFieldU);
- createMatchPanelU.add(matchLabelU);
- createMatchBackU = new JButton("Back");
- createCurrentMatchU = new JButton("Edit");
- createMatchBackU. setBounds(224,590,270,20);
- createCurrentMatchU . setBounds(0,620,270,20);
- createMatchPanelU.add(createMatchBackU);
- createMatchPanelU.add(createCurrentMatchU);
- createMatchBackU.addActionListener(this);
- createCurrentMatchU.addActionListener(this);
- }
- public void editTourPanel()
- {
- createTournamentPanelU = new JPanel();
- createTournamentPanelU . setBounds(0,0,width,height);
- createTournamentPanelU . setLayout(null);
- tourDescripLabelU = new JLabel("Tournament Description");
- tourNameLabelU = new JLabel("Tournament Name");
- tourStartDateLabelU = new JLabel("Tour StartDate MM/DD/YYYY *");
- tourEndDateLabelU = new JLabel("Tour EndDate MM/DD/YYYY *");
- tourTypeLabelU = new JLabel("Tournament Type");
- tourOpenDateLabelU = new JLabel("Ceremony Start Date");
- tourCloseDateLabelU = new JLabel ("Ceremony End Date");
- tourDescripFieldU = new JTextField();
- tourNameFieldU = new JTextField();
- tourStartDateFieldU = new JTextField();
- tourEndDateFieldU = new JTextField();
- tourTypeFieldU = new JTextField();
- tourOpenDateFieldU = new JTextField();
- tourCloseDateFieldU = new JTextField();
- tourIdFieldU = new JTextField();
- tourIdLabelU = new JLabel("Tour Id To Be Updated");
- tourDescripLabelU.setBounds(30,30,200,20);
- tourDescripFieldU.setBounds(250,30,200,20);
- tourNameLabelU.setBounds(30,80,200,20);
- tourNameFieldU.setBounds(250,80,200,20);
- tourStartDateLabelU.setBounds(30,130,200,20);
- tourStartDateFieldU.setBounds(250,130,200,20);
- tourEndDateLabelU.setBounds(30,180,200,20);
- tourEndDateFieldU.setBounds(250,180,200,20);
- tourTypeLabelU.setBounds(30,230,200,20);
- tourTypeFieldU.setBounds(250,230,200,20);
- tourOpenDateLabelU.setBounds(30,280,200,20);
- tourOpenDateFieldU.setBounds(250,280,200,20);
- tourCloseDateLabelU.setBounds(30,330,200,20);
- tourCloseDateFieldU.setBounds(250,330,200,20);
- tourIdFieldU.setBounds(250,380,200,20);
- tourIdLabelU.setBounds(30,380,200,20);
- createTournamentPanelU.add(tourDescripLabelU);
- createTournamentPanelU.add(tourDescripFieldU);
- createTournamentPanelU.add(tourNameLabelU);
- createTournamentPanelU.add(tourNameFieldU);
- createTournamentPanelU.add(tourStartDateLabelU);
- createTournamentPanelU.add(tourStartDateFieldU);
- createTournamentPanelU.add(tourEndDateLabelU);
- createTournamentPanelU.add(tourEndDateFieldU);
- createTournamentPanelU.add(tourTypeLabelU);
- createTournamentPanelU.add(tourTypeFieldU);
- createTournamentPanelU.add(tourOpenDateLabelU);
- createTournamentPanelU.add(tourOpenDateFieldU);
- createTournamentPanelU.add(tourCloseDateLabelU);
- createTournamentPanelU.add(tourCloseDateFieldU);
- createTournamentPanelU.add(tourIdFieldU);
- createTournamentPanelU.add(tourIdLabelU);
- createTourBackU = new JButton("Back");
- createCurrentTourU = new JButton("Edit");
- createTourBackU. setBounds(224,590,270,20);
- createCurrentTourU . setBounds(0,620,270,20);
- createTournamentPanelU.add(createTourBackU);
- createTournamentPanelU.add(createCurrentTourU);
- createTourBackU.addActionListener(this);
- createCurrentTourU.addActionListener(this);
- }
- public void createUpdateProfilePanel()
- {
- regPanelU = new JPanel();
- regPanelU . setBounds(0,0,width,height);
- regPanelU . setLayout(null);
- firstNameLabelU = new JLabel("FirstName *");
- middleNameLabelU = new JLabel("MiddleName");
- lastNameLabelU = new JLabel("LastName");
- telephoneLabelU = new JLabel("Telephone Number");
- mailLabelU = new JLabel("E-mail");
- passwordLabelU = new JLabel("Password *");
- retypePasswordLabelU = new JLabel("Retype Password *");
- countryLabelU = new JLabel("Country");
- mobileLabelU = new JLabel("Mobile Number");
- dateOfBirthLabelU = new JLabel("Date Of Birth MM/DD/YYYY");
- firstNameLabelU . setBounds(30,30,110,20);
- middleNameLabelU . setBounds(30,80,110,20);
- lastNameLabelU . setBounds(30,130,110,20);
- passwordLabelU . setBounds(30,230,110,20);
- retypePasswordLabelU . setBounds(30,280,110,20);
- telephoneLabelU . setBounds(30,330,110,20);
- mobileLabelU . setBounds(30,380,110,20);
- mailLabelU . setBounds(30,430,110,20);
- countryLabelU . setBounds(30,480,110,20);
- dateOfBirthLabelU. setBounds(30,530,210,20);
- firstNameFieldU = new JTextField();
- middleNameFieldU = new JTextField();
- lastNameFieldU = new JTextField();
- passwordFieldU = new JPasswordField();
- retypePasswordFieldU = new JPasswordField();
- telephoneFieldU = new JTextField();
- mobileFieldU = new JTextField();
- mailFieldU = new JTextField();
- countryFieldU = new JTextField();
- dateOfBirthFieldU = new JTextField();
- firstNameFieldU . setBounds(150,30,200,20);
- middleNameFieldU . setBounds(150,80,200,20);
- lastNameFieldU . setBounds(150,130,200,20);
- passwordFieldU . setBounds(150,230,200,20);
- retypePasswordFieldU . setBounds(150,280,200,20);
- telephoneFieldU . setBounds(150,330,200,20);
- mobileFieldU . setBounds(150,380,200,20);
- mailFieldU . setBounds(150,430,200,20);
- countryFieldU . setBounds(150,480,200,20);
- dateOfBirthFieldU . setBounds(250,530,200,20);
- updateButtonRegPanel = new JButton("Update");
- backU = new JButton("Back");
- updateButtonRegPanel . setBounds(224,590,270,20);
- backU . setBounds(0,620,270,20);
- updateButtonRegPanel . addActionListener(this);
- backU.addActionListener(this);
- regPanelU . add(firstNameLabelU);
- regPanelU . add(middleNameLabelU);
- regPanelU . add(lastNameLabelU);
- regPanelU . add(passwordLabelU);
- regPanelU . add(retypePasswordLabelU);
- regPanelU . add(telephoneLabelU);
- regPanelU . add(mobileLabelU);
- regPanelU . add(mailLabelU);
- regPanelU . add(countryLabelU);
- regPanelU . add(dateOfBirthLabelU);
- regPanelU.add(dateOfBirthFieldU);
- regPanelU . add(firstNameFieldU);
- regPanelU . add(middleNameFieldU);
- regPanelU . add(lastNameFieldU);
- regPanelU . add(passwordFieldU);
- regPanelU . add(retypePasswordFieldU);
- regPanelU . add(telephoneFieldU);
- regPanelU . add(mobileFieldU);
- regPanelU . add(mailFieldU);
- regPanelU . add(countryFieldU);
- regPanelU . add(updateButtonRegPanel);
- regPanelU . add(backU);
- }
- public void findMatchesPanel()
- {
- findMatchesPanel = new JPanel();
- findMatchesPanel . setBounds(0,0,width,height);
- findMatchesPanel . setLayout(null);
- findMatchesField = new JTextField();
- findMatchesLabel = new JLabel("Enter The Date MM/DD/YYYY");
- findMatchesFind = new JButton("Find");
- findMatchesBack = new JButton("Back");
- findMatchesTable = new JTable(data,tourCol);
- findMatchesTable . setEnabled(false);
- findMatchesPane = new JScrollPane(findMatchesTable);
- findMatchesPane . setBounds(0,100,width-5,400);
- findMatchesField . setBounds(250,30,200,20);
- findMatchesLabel . setBounds(30,30,200,20);
- findMatchesFind . setBounds(0,620,270,20);
- findMatchesBack . setBounds(224,590,270,20);
- findMatchesPanel.add(findMatchesPane);
- findMatchesPanel.add(findMatchesField);
- findMatchesPanel.add(findMatchesLabel);
- findMatchesPanel.add(findMatchesFind);
- findMatchesPanel.add(findMatchesBack);
- findMatchesFind.addActionListener(this);
- findMatchesBack.addActionListener(this);
- }
- public void createWelcomePanel()
- {
- welcomePanel = new JPanel();
- welcomePanel . setBounds(0,0,width,height);
- welcomePanel . setLayout(null);
- nameWelcomePanelLabel = new JLabel("Username");
- nameWelcomePanelLabel . setBounds(30,330,80,20);
- welcomePanel . add(nameWelcomePanelLabel);
- passwordWelcomePanelLabel = new JLabel("Password");
- passwordWelcomePanelLabel . setBounds(30,390,80,20);
- welcomePanel . add(passwordWelcomePanelLabel);
- nameWelcomePanel = new JTextField();
- nameWelcomePanel . setBounds(100,330,200,20);
- welcomePanel . add(nameWelcomePanel);
- passwordWelcomePanel = new JPasswordField();
- passwordWelcomePanel . setBounds(100,390,200,20);
- welcomePanel . add(passwordWelcomePanel);
- loginWelcomePanel = new JButton("Login");
- loginWelcomePanel . setBounds(224,450,270,20);
- loginWelcomePanel . addActionListener(this);
- welcomePanel . add(loginWelcomePanel);
- regWelcomePanel = new JButton("Register");
- regWelcomePanel . setBounds(224,510,270,20);
- regWelcomePanel . addActionListener(this);
- welcomePanel . add(regWelcomePanel);
- ballIcon = new ImageIcon("DB.jpg");
- ballLabel = new JLabel(ballIcon);
- ballLabel . setBounds(0,0,width,300);
- welcomePanel . add(ballLabel);
- }
- public void createRegPanel()
- {
- regPanel = new JPanel();
- regPanel . setBounds(0,0,width,height);
- regPanel . setLayout(null);
- firstNameLabel = new JLabel("FirstName *");
- middleNameLabel = new JLabel("MiddleName");
- lastNameLabel = new JLabel("LastName");
- telephoneLabel = new JLabel("Telephone Number");
- mailLabel = new JLabel("E-mail");
- userNameLabel = new JLabel("UserName *");
- passwordLabel = new JLabel("Password *");
- retypePasswordLabel = new JLabel("Retype Password *");
- countryLabel = new JLabel("Country");
- mobileLabel = new JLabel("Mobile Number");
- dateOfBirthLabel = new JLabel("Date Of Birth MM/DD/YYYY");
- firstNameLabel . setBounds(30,30,110,20);
- middleNameLabel . setBounds(30,80,110,20);
- lastNameLabel . setBounds(30,130,110,20);
- userNameLabel . setBounds(30,180,110,20);
- passwordLabel . setBounds(30,230,110,20);
- retypePasswordLabel . setBounds(30,280,110,20);
- telephoneLabel . setBounds(30,330,110,20);
- mobileLabel . setBounds(30,380,110,20);
- mailLabel . setBounds(30,430,110,20);
- countryLabel . setBounds(30,480,110,20);
- dateOfBirthLabel. setBounds(30,530,210,20);
- firstNameField = new JTextField();
- middleNameField = new JTextField();
- lastNameField = new JTextField();
- userNameField = new JTextField();
- passwordField = new JPasswordField();
- retypePasswordField = new JPasswordField();
- telephoneField = new JTextField();
- mobileField = new JTextField();
- mailField = new JTextField();
- countryField = new JTextField();
- dateOfBirthField = new JTextField();
- firstNameField . setBounds(150,30,200,20);
- middleNameField . setBounds(150,80,200,20);
- lastNameField . setBounds(150,130,200,20);
- userNameField . setBounds(150,180,200,20);
- passwordField . setBounds(150,230,200,20);
- retypePasswordField . setBounds(150,280,200,20);
- telephoneField . setBounds(150,330,200,20);
- mobileField . setBounds(150,380,200,20);
- mailField . setBounds(150,430,200,20);
- countryField . setBounds(150,480,200,20);
- dateOfBirthField . setBounds(250,530,200,20);
- regButtonRegPanel = new JButton("Register");
- back = new JButton("Back");
- regButtonRegPanel . setBounds(224,590,270,20);
- back . setBounds(0,620,270,20);
- regButtonRegPanel . addActionListener(this);
- back.addActionListener(this);
- regPanel . add(firstNameLabel);
- regPanel . add(middleNameLabel);
- regPanel . add(lastNameLabel);
- regPanel . add(userNameLabel);
- regPanel . add(passwordLabel);
- regPanel . add(retypePasswordLabel);
- regPanel . add(telephoneLabel);
- regPanel . add(mobileLabel);
- regPanel . add(mailLabel);
- regPanel . add(countryLabel);
- regPanel . add(dateOfBirthLabel);
- regPanel.add(dateOfBirthField);
- regPanel . add(firstNameField);
- regPanel . add(middleNameField);
- regPanel . add(lastNameField);
- regPanel . add(userNameField);
- regPanel . add(passwordField);
- regPanel . add(retypePasswordField);
- regPanel . add(telephoneField);
- regPanel . add(mobileField);
- regPanel . add(mailField);
- regPanel . add(countryField);
- regPanel . add(regButtonRegPanel);
- regPanel . add(back);
- }
- public void createLowAdmin()
- {
- lowAdminPanel = new JPanel();
- lowAdminPanel.setBounds(0,0,width,height);
- lowAdminPanel.setLayout(null);
- createMatch = new JButton("Create Match");
- editMatch = new JButton("Edit Match");
- deleteMatch = new JButton("Delete Match");
- logOutL = new JButton("Logout");
- viewTourL = new JButton("View Tournaments");
- viewMatchL = new JButton("View Matches");
- createMatch.setBounds(0,200,494,20);
- editMatch.setBounds(0,350,494,20);
- deleteMatch.setBounds(0,550,494,20);
- logOutL . setBounds(150,638,200,30);
- viewTourL . setBounds(0,0,494,20);
- viewMatchL . setBounds(0,100,494,20);
- logOutL.addActionListener(this);
- lowAdminPanel.add(createMatch);
- lowAdminPanel.add(editMatch);
- lowAdminPanel.add(deleteMatch);
- lowAdminPanel.add(logOutL);
- lowAdminPanel.add(viewTourL);
- lowAdminPanel.add(viewMatchL);
- viewMatchL.addActionListener(this);
- viewTourL.addActionListener(this);
- createMatch.addActionListener(this);
- editMatch.addActionListener(this);
- deleteMatch.addActionListener(this);
- }
- public void createHighAdmin()
- {
- highAdminPanel = new JPanel();
- highAdminPanel.setBounds(0,0,width,height);
- highAdminPanel.setLayout(null);
- viewTourH = new JButton("View Tournaments");
- viewMatchH = new JButton("View Matches");
- createMatchH = new JButton("Create Match");
- editMatchH = new JButton("Edit Match");
- deleteMatchH = new JButton("Delete Match");
- createTourH = new JButton("Create Tournament");
- editTourH = new JButton("Edit Tournament");
- deleteTourH = new JButton("Delete Tournament");
- logOutH = new JButton("Logout");
- createMatchH.setBounds(30,180,200,20);
- editMatchH.setBounds(30,280,200,20);
- deleteMatchH.setBounds(30,380,200,20);
- createTourH.setBounds(270,280,200,20);
- editTourH.setBounds(270,380,200,20);
- deleteTourH.setBounds(270,480,200,20);
- logOutH . setBounds(150,638,200,30);
- viewTourH . setBounds(0,0,494,20);
- viewMatchH . setBounds(0,100,494,20);
- logOutH.addActionListener(this);
- highAdminPanel.add(createMatchH);
- highAdminPanel.add(editMatchH);
- highAdminPanel.add(deleteMatchH);
- highAdminPanel.add(createTourH);
- highAdminPanel.add(editTourH);
- highAdminPanel.add(deleteTourH);
- highAdminPanel.add(logOutH);
- highAdminPanel.add(viewTourH);
- highAdminPanel.add(viewMatchH);
- viewMatchH.addActionListener(this);
- viewTourH.addActionListener(this);
- createMatchH.addActionListener(this);
- editMatchH.addActionListener(this);
- deleteMatchH.addActionListener(this);
- createTourH.addActionListener(this);
- editTourH.addActionListener(this);
- deleteTourH.addActionListener(this);
- }
- public void createUserPanel()
- {
- userPanel = new JPanel();
- userPanel . setBounds(0,0,width,height);
- userPanel . setLayout(null);
- userUpdate = new JButton("Update Profile");
- userView = new JButton("View Tickets");
- userReserve = new JButton("View-Reserve Ticket");
- userFind = new JButton("Find Tournaments");
- userCancel = new JButton("Cancel Reservation");
- userTour = new JButton("View Tournaments");
- userMatch = new JButton("View Matches");
- logOutR = new JButton("Logout");
- userUpdate.setBounds(0,0,494,20);
- userReserve.setBounds(0,280,494,80);
- userFind.setBounds(0,100,494,20);
- userTour.setBounds(0,500,494,20);
- userMatch.setBounds(0,600,494,20);
- logOutR.setBounds(150,638,200,30);
- logOutR.addActionListener(this);
- userPanel.add(userUpdate);
- userPanel.add(userReserve);
- userPanel.add(userFind);
- userPanel.add(userTour);
- userPanel.add(userMatch);
- userPanel.add(logOutR);
- userUpdate.addActionListener(this);
- userView.addActionListener(this);
- userReserve.addActionListener(this);
- userFind.addActionListener(this);
- userTour.addActionListener(this);
- userMatch.addActionListener(this);
- userCancel.addActionListener(this);
- }
- public void createTournamentPanel()
- {
- createTournamentPanel = new JPanel();
- createTournamentPanel . setBounds(0,0,width,height);
- createTournamentPanel . setLayout(null);
- tourDescripLabel = new JLabel("Tournament Description");
- tourNameLabel = new JLabel("Tournament Name *");
- tourStartDateLabel = new JLabel("Tour StartDate MM/DD/YYYY *");
- tourEndDateLabel = new JLabel("Tour EndDate MM/DD/YYYY *");
- tourTypeLabel = new JLabel("Tournament Type");
- tourOpenDateLabel = new JLabel("Ceremony Start Date");
- tourCloseDateLabel = new JLabel ("Ceremony End Date");
- tourDescripField = new JTextField();
- tourNameField = new JTextField();
- tourStartDateField = new JTextField();
- tourEndDateField = new JTextField();
- tourTypeField = new JTextField();
- tourOpenDateField = new JTextField();
- tourCloseDateField = new JTextField();
- tourDescripLabel.setBounds(30,30,200,20);
- tourDescripField.setBounds(250,30,200,20);
- tourNameLabel.setBounds(30,80,200,20);
- tourNameField.setBounds(250,80,200,20);
- tourStartDateLabel.setBounds(30,130,200,20);
- tourStartDateField.setBounds(250,130,200,20);
- tourEndDateLabel.setBounds(30,180,200,20);
- tourEndDateField.setBounds(250,180,200,20);
- tourTypeLabel.setBounds(30,230,200,20);
- tourTypeField.setBounds(250,230,200,20);
- tourOpenDateLabel.setBounds(30,280,200,20);
- tourOpenDateField.setBounds(250,280,200,20);
- tourCloseDateLabel.setBounds(30,330,200,20);
- tourCloseDateField.setBounds(250,330,200,20);
- createTournamentPanel.add(tourDescripLabel);
- createTournamentPanel.add(tourDescripField);
- createTournamentPanel.add(tourNameLabel);
- createTournamentPanel.add(tourNameField);
- createTournamentPanel.add(tourStartDateLabel);
- createTournamentPanel.add(tourStartDateField);
- createTournamentPanel.add(tourEndDateLabel);
- createTournamentPanel.add(tourEndDateField);
- createTournamentPanel.add(tourTypeLabel);
- createTournamentPanel.add(tourTypeField);
- createTournamentPanel.add(tourOpenDateLabel);
- createTournamentPanel.add(tourOpenDateField);
- createTournamentPanel.add(tourCloseDateLabel);
- createTournamentPanel.add(tourCloseDateField);
- createTourBack = new JButton("Back");
- createCurrentTour = new JButton("Finish");
- createTourBack. setBounds(224,590,270,20);
- createCurrentTour . setBounds(0,620,270,20);
- createTournamentPanel.add(createTourBack);
- createTournamentPanel.add(createCurrentTour);
- createTourBack.addActionListener(this);
- createCurrentTour.addActionListener(this);
- }
- public void createMatchPanel()
- {
- createMatchPanel = new JPanel();
- createMatchPanel . setBounds(0,0,width,height);
- createMatchPanel . setLayout(null);
- numOfSeatsLabel = new JLabel("Number Of Seats *");
- matchWeightLabel = new JLabel("Match Weight * Between 1 and 10");
- locationLabel = new JLabel("Match Location");
- tourIdLabel = new JLabel("Tournament ID *");
- firstTeamLabel = new JLabel("First Team Name *");
- secondTeamLabel = new JLabel("Second Team Name *");
- numOfSeatsField = new JTextField();
- matchWeightField = new JTextField();
- locationField = new JTextField();
- tourIdField = new JTextField();
- firstTeamField = new JTextField();
- secondTeamField = new JTextField();
- numOfSeatsLabel.setBounds(30,30,200,20);
- numOfSeatsField.setBounds(250,30,200,20);
- matchWeightLabel.setBounds(30,80,200,20);
- matchWeightField.setBounds(250,80,200,20);
- locationLabel.setBounds(30,130,200,20);
- locationField.setBounds(250,130,200,20);
- tourIdLabel.setBounds(30,180,200,20);
- tourIdField.setBounds(250,180,200,20);
- firstTeamLabel.setBounds(30,230,200,20);
- firstTeamField.setBounds(250,230,200,20);
- secondTeamLabel.setBounds(30,280,200,20);
- secondTeamField.setBounds(250,280,200,20);
- createMatchPanel.add(numOfSeatsLabel);
- createMatchPanel.add(numOfSeatsField);
- createMatchPanel.add(matchWeightLabel);
- createMatchPanel.add(matchWeightField);
- createMatchPanel.add(locationLabel);
- createMatchPanel.add(locationField);
- createMatchPanel.add(tourIdLabel);
- createMatchPanel.add(tourIdField);
- createMatchPanel.add(firstTeamLabel);
- createMatchPanel.add(firstTeamField);
- createMatchPanel.add(secondTeamLabel);
- createMatchPanel.add(secondTeamField);
- createMatchBack = new JButton("Back");
- createCurrentMatch = new JButton("Finish");
- createMatchBack. setBounds(224,590,270,20);
- createCurrentMatch . setBounds(0,620,270,20);
- createMatchPanel.add(createMatchBack);
- createMatchPanel.add(createCurrentMatch);
- createMatchBack.addActionListener(this);
- createCurrentMatch.addActionListener(this);
- }
- public void deleteTournamentPanel()
- {
- removeTournamentPanel = new JPanel();
- removeTournamentPanel . setBounds(0,0,width,height);
- removeTournamentPanel . setLayout(null);
- removeTourIdLabel = new JLabel("Type The Tournament ID");
- removeTourIdField = new JTextField();
- removeTourIdLabel.setBounds(30,30,200,20);
- removeTourIdField.setBounds(250,30,200,20);
- removeTourBack = new JButton("Back");
- removeCurrentTour = new JButton("Remove Tournament");
- removeTourBack. setBounds(224,590,270,20);
- removeCurrentTour . setBounds(0,620,270,20);
- removeTournamentPanel.add(removeTourIdLabel);
- removeTournamentPanel.add(removeTourIdField);
- removeTournamentPanel.add(removeTourBack);
- removeTournamentPanel.add(removeCurrentTour);
- removeTourBack.addActionListener(this);
- removeCurrentTour.addActionListener(this);
- }
- public void deleteMatchPanel()
- {
- removeMatchPanel = new JPanel();
- removeMatchPanel . setBounds(0,0,width,height);
- removeMatchPanel . setLayout(null);
- removeMatchIdLabel = new JLabel("Type The Match ID");
- removeMatchIdField = new JTextField();
- removeMatchIdLabel.setBounds(30,30,200,20);
- removeMatchIdField.setBounds(250,30,200,20);
- removeMatchBack = new JButton("Back");
- removeCurrentMatch = new JButton("Remove Match");
- removeMatchBack. setBounds(224,590,270,20);
- removeCurrentMatch . setBounds(0,620,270,20);
- removeMatchPanel.add(removeMatchIdLabel);
- removeMatchPanel.add(removeMatchIdField);
- removeMatchPanel.add(removeMatchBack);
- removeMatchPanel.add(removeCurrentMatch);
- removeMatchBack.addActionListener(this);
- removeCurrentMatch.addActionListener(this);
- }
- public void viewMatchesPanel()
- {
- viewMatchPanel = new JPanel();
- viewMatchPanel . setBounds(0,0,width,height);
- viewMatchPanel . setLayout(null);
- viewMatchTable = new JTable(data,matchCol);
- viewMatchTable.setEnabled(false);
- viewMatchPane = new JScrollPane(viewMatchTable);
- viewMatchPane . setBounds(0,0,width-5,500);
- viewMatchPanel.add(viewMatchPane);
- viewMatchBack = new JButton("Back");
- viewMatchBack . setBounds(0,600,width,20);
- viewMatchBack.addActionListener(this);
- viewMatchPanel.add(viewMatchBack);
- }
- public void viewTournamentsPanel()
- {
- viewTourPanel = new JPanel();
- viewTourPanel . setBounds(0,0,width,height);
- viewTourPanel . setLayout(null);
- viewTourTable = new JTable(data,tourCol);
- viewTourPane = new JScrollPane(viewTourTable);
- viewTourPane . setBounds(0,0,width-5,500);
- viewTourPanel.add(viewTourPane);
- viewTourTable.setEnabled(false);
- viewTourBack = new JButton("Back");
- viewTourBack . setBounds(0,600,width,20);
- viewTourBack.addActionListener(this);
- viewTourPanel.add(viewTourBack);
- }
- public void reserveTicketsPanel()
- {
- reserveTicketPanel = new JPanel();
- reserveTicketPanel . setBounds(0,0,width,height);
- reserveTicketPanel . setLayout(null);
- reserveTicketTable = new JTable(data,ticketCol);
- reserveTicketTable . setEnabled(false);
- reserveTicketLabel = new JLabel("Type The Ticket ID");
- reserveTicketField = new JTextField();
- reserveTicketLabel.setBounds(30,540,200,20);
- reserveTicketField.setBounds(250,540,200,20);
- reserveTicketBack = new JButton("Back");
- reserveCurrentTicket = new JButton("Reserve Ticket");
- cancelReserveTicket = new JButton("Cancel Ticket");
- cancelReserveTicket.setBounds(224,640,270,20);
- reserveTicketBack. setBounds(224,580,270,20);
- reserveCurrentTicket . setBounds(0,610,270,20);
- reserveTicketTable.setEnabled(false);
- scrollPane = new JScrollPane(reserveTicketTable);
- scrollPane.setBounds(0,0,width-5,500);
- // reserveTicketPanel.add(reserveTicketField);
- // reserveTicketPanel.add(reserveTicketLabel);
- reserveTicketPanel.add(reserveTicketBack);
- reserveTicketPanel.add(scrollPane);
- reserveTicketPanel.add(reserveCurrentTicket);
- // reserveTicketPanel.add(cancelReserveTicket);
- cancelReserveTicket.addActionListener(this);
- reserveTicketBack.addActionListener(this);
- reserveCurrentTicket.addActionListener(this);
- }
- public void createFrame()
- {
- createData();
- categoryPanel();
- reserveTicketPanelU();
- editMatchPanel();
- editTourPanel();
- createUpdateProfilePanel();
- viewMatchesPanel();
- viewTournamentsPanel();
- findMatchesPanel();
- reserveTicketsPanel();
- deleteMatchPanel();
- deleteTournamentPanel();
- createMatchPanel();
- createTournamentPanel();
- createUserPanel();
- createHighAdmin();
- createLowAdmin();
- createRegPanel();
- createWelcomePanel();
- frame = new JFrame();
- frame . setBounds(390,50,500,700);
- frame . setLayout(null);
- frame . add(welcomePanel);
- frame . setResizable(false);
- frame . setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
- frame . setVisible(true);
- }
- public void createData()
- {
- for(int i = 0 ; i<10000 ; ++i)
- for(int j = 0 ; j<8 ; ++j)
- data[i][j]="";
- }
- public DBGui()
- {
- connectUsingJDBC();
- createFrame();
- frame.validate();
- }
- public void actionPerformed(ActionEvent e)
- {
- createData();
- if(e.getSource()==categoryNext)
- {
- categoryQuery();
- String t = categoryField.getText();
- if(t.equals("1")&&cflag1||t.equals("2")&&cflag2||t.equals("3")&&cflag3)
- {
- if(finalQuery())
- {
- JOptionPane.showMessageDialog(null, "New Ticket Bought","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
- }
- else
- {
- JOptionPane.showMessageDialog(null, "Error Check Match ID Or Category Number","Error Message",JOptionPane.PLAIN_MESSAGE );
- }
- }
- else
- {
- JOptionPane.showMessageDialog(null, "Error Check Match ID Or Category Number","Error Message",JOptionPane.PLAIN_MESSAGE );
- }
- }
- if(e.getSource()==categoryBack)
- {
- frame.remove(categoryPanel);
- frame.add(reserveTicketPanelU);
- frame.repaint();
- }
- if(e.getSource()==reserveTicketNextU)
- {
- if(ticketQuery())
- {
- frame.remove(reserveTicketPanelU);
- frame.add(categoryPanel);
- System.out.println(categoryQuery());
- frame.repaint();
- }
- else
- {
- JOptionPane.showMessageDialog(null, "Error Check Match ID","Error Message",JOptionPane.PLAIN_MESSAGE );
- }
- }
- if(e.getSource()==reserveTicketBackU)
- {
- frame.remove(reserveTicketPanelU);
- frame.add(reserveTicketPanel);
- viewTicketQuery();
- frame.repaint();
- }
- if(e.getSource()==reserveCurrentTicket)
- {
- frame.remove(reserveTicketPanel);
- frame.add(reserveTicketPanelU);
- frame.repaint();
- }
- if(e.getSource()==findMatchesFind)
- {
- if(findTourQuery())
- {
- JOptionPane.showMessageDialog(null, "Tournaments Found Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
- }
- else
- {
- JOptionPane.showMessageDialog(null, "No Tournaments At The Specified Date Or Date Format Is Not Correct","Error Message",JOptionPane.PLAIN_MESSAGE);
- }
- }
- if(e.getSource()==createCurrentMatchU)
- {
- if(updateMatchQuery(matchFieldU.getText()))
- {
- JOptionPane.showMessageDialog(null, "Match Updated Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
- }
- else
- {
- JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE);
- }
- }
- if(e.getSource()==createMatchBackU)
- {
- if(userLevel==1)
- {
- frame.remove(createMatchPanelU);
- frame.add(highAdminPanel);
- frame.repaint();
- }
- else
- {
- frame.remove(createMatchPanelU);
- frame.add(lowAdminPanel);
- frame.repaint();
- }
- }
- if(e.getSource()==editMatch)
- {
- frame.remove(lowAdminPanel);
- frame.add(createMatchPanelU);
- frame.repaint();
- }
- if(e.getSource()==editMatchH)
- {
- frame.remove(highAdminPanel);
- frame.add(createMatchPanelU);
- frame.repaint();
- }
- if(e.getSource()==createTourBackU)
- {
- frame.remove(createTournamentPanelU);
- frame.add(highAdminPanel);
- frame.repaint();
- }
- if(e.getSource()==editTourH)
- {
- frame.remove(highAdminPanel);
- frame.add(createTournamentPanelU);
- frame.repaint();
- }
- if(e.getSource()==createCurrentTourU)
- {
- if(updateTourQuery(tourIdFieldU.getText()))
- {
- JOptionPane.showMessageDialog(null, "Tournament Updated Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
- frame.remove(createTournamentPanelU);
- frame.add(highAdminPanel);
- frame.repaint();
- }
- else
- {
- JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE);
- }
- }
- if(e.getSource()==updateButtonRegPanel)
- {
- if(firstNameFieldU.getText().length()>0&&passwordFieldU.getText().equals(retypePasswordFieldU.getText())&&passwordFieldU.getText().length()>0)
- {
- if(updateQuery())
- {
- JOptionPane.showMessageDialog(null, "Profile Updated Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
- frame.remove(regPanelU);
- frame.add(userPanel);
- frame.repaint();
- }
- else
- JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE);
- }
- else
- JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE);
- }
- if(e.getSource()==backU)
- {
- frame.remove(regPanelU);
- frame.add(userPanel);
- frame.repaint();
- }
- if(e.getSource()==userUpdate)
- {
- frame.remove(userPanel);
- frame.add(regPanelU);
- userDetailsQuery();
- frame.repaint();
- }
- if(e.getSource()==removeCurrentTour)
- {
- if(removeTourQuery(removeTourIdField.getText()))
- JOptionPane.showMessageDialog(null, "Tournament Deleted Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
- else
- JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE );
- }
- if(e.getSource()==createCurrentTour)
- {
- if(tourNameField.getText()!=null && tourNameField.getText().length()>0)
- if(checkTourQuery(tourDescripField.getText(),tourNameField.getText(),tourStartDateField.getText(),tourEndDateField.getText(),tourTypeField.getText(),tourOpenDateField.getText(),tourEndDateField.getText()))
- JOptionPane.showMessageDialog(null, "Tournament Created Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
- else
- JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE );
- else
- JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE );
- }
- if(e.getSource()==removeCurrentMatch)
- {
- if(deleteMatchQuery(removeMatchIdField.getText()))
- JOptionPane.showMessageDialog(null, "The Match Was Deleted Successfull","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
- else
- JOptionPane.showMessageDialog(null, "Please Check The Match ID Again","Error Message",JOptionPane.PLAIN_MESSAGE );
- }
- if(e.getSource()==createCurrentMatch)
- {
- if(createMatchQuery(numOfSeatsField.getText(),matchWeightField.getText(),tourIdField.getText(),firstTeamField.getText(),secondTeamField.getText()))
- {
- insertMatchQuery(numOfSeatsField.getText(),matchWeightField.getText(),locationField.getText(),tourIdField.getText(),firstTeamField.getText(),secondTeamField.getText());
- JOptionPane.showMessageDialog(null, "Match Was Created Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
- }
- else
- JOptionPane.showMessageDialog(null, "Error Ocurred Check The Data Again","Error Message",JOptionPane.PLAIN_MESSAGE );
- }
- if(e.getSource()==userTour)
- {
- frame.remove(userPanel);
- frame.add(viewTourPanel);
- viewTourQuery();
- frame.repaint();
- }
- if(e.getSource()==userMatch)
- {
- frame.remove(userPanel);
- frame.add(viewMatchPanel);
- viewMatchQuery();
- frame.repaint();
- }
- if(e.getSource()==viewTourL)
- {
- frame.remove(lowAdminPanel);
- frame.add(viewTourPanel);
- viewTourQuery();
- frame.repaint();
- }
- if(e.getSource()==viewMatchL)
- {
- frame.remove(lowAdminPanel);
- frame.add(viewMatchPanel);
- viewMatchQuery();
- frame.repaint();
- }
- if(e.getSource()==viewTourH)
- {
- frame.remove(highAdminPanel);
- frame.add(viewTourPanel);
- viewTourQuery();
- frame.repaint();
- }
- if(e.getSource()==viewMatchH)
- {
- frame.remove(highAdminPanel);
- frame.add(viewMatchPanel);
- viewMatchQuery();
- frame.repaint();
- }
- if(e.getSource()==viewMatchBack)
- {
- frame.remove(viewMatchPanel);
- if(userLevel==1)
- frame.add(highAdminPanel);
- else
- if(userLevel==2)
- frame.add(lowAdminPanel);
- else
- frame.add(userPanel);
- frame.repaint();
- }
- if(e.getSource()==viewTourBack)
- {
- frame.remove(viewTourPanel);
- if(userLevel==1)
- frame.add(highAdminPanel);
- else
- if(userLevel==2)
- frame.add(lowAdminPanel);
- else
- frame.add(userPanel);
- frame.repaint();
- }
- if(e.getSource()==findMatchesBack)
- {
- frame.remove(findMatchesPanel);
- frame.add(userPanel);
- frame.repaint();
- }
- if(e.getSource()==reserveTicketBack)
- {
- frame.remove(reserveTicketPanel);
- frame.add(userPanel);
- frame.repaint();
- }
- if(e.getSource()==createMatchBack)
- {
- frame.remove(createMatchPanel);
- if(userLevel==1)
- frame.add(highAdminPanel);
- else
- frame.add(lowAdminPanel);
- frame.repaint();
- }
- if(e.getSource()==createTourBack)
- {
- frame.remove(createTournamentPanel);
- frame.add(highAdminPanel);
- frame.repaint();
- }
- if(e.getSource()==removeMatchBack)
- {
- frame.remove(removeMatchPanel);
- if(userLevel==1)
- frame.add(highAdminPanel);
- else
- frame.add(lowAdminPanel);
- frame.repaint();
- }
- if(e.getSource()==removeTourBack)
- {
- frame.remove(removeTournamentPanel);
- frame.add(highAdminPanel);
- frame.repaint();
- }
- if(e.getSource()==loginWelcomePanel)
- {
- String r = loginQuery(nameWelcomePanel.getText(),passwordWelcomePanel.getText());
- if(r==null)
- JOptionPane.showMessageDialog(null, "The Username or Password is not Correct","Error Message",JOptionPane.PLAIN_MESSAGE );
- else
- {
- userName = nameWelcomePanel.getText();
- if(r.equals("Registered"))
- {
- userLevel = 3;
- frame.remove(welcomePanel);
- frame.add(userPanel);
- frame.repaint();
- }
- else
- {
- int level = adminLevel(nameWelcomePanel.getText());
- System.out.println(level);
- if(level==2)
- {
- userLevel = 2;
- frame.remove(welcomePanel);
- frame.add(lowAdminPanel);
- frame.repaint();
- }
- else
- {
- userLevel = 1;
- frame.remove(welcomePanel);
- frame.add(highAdminPanel);
- frame.repaint();
- }
- }
- }
- }
- if(e.getSource()==regWelcomePanel)
- {
- frame.remove(welcomePanel);
- frame.add(regPanel);
- frame.repaint();
- }
- if(e.getSource()==back)
- {
- frame.remove(regPanel);
- frame.add(welcomePanel);
- frame.repaint();
- }
- if(e.getSource()==logOutL)
- {
- frame.remove(lowAdminPanel);
- frame.add(welcomePanel);
- frame.repaint();
- }
- if(e.getSource()==logOutH)
- {
- frame.remove(highAdminPanel);
- frame.add(welcomePanel);
- frame.repaint();
- }
- if(e.getSource()==logOutR)
- {
- frame.remove(userPanel);
- frame.add(welcomePanel);
- frame.repaint();
- }
- if(e.getSource()==regButtonRegPanel)
- {
- if(checkUserNameQuery(userNameField.getText())&&userNameField.getText().length()>0)
- {
- if(firstNameField.getText()==null||firstNameField.getText().length()<1)
- {
- JOptionPane.showMessageDialog(null, "Please Enter Your FirstName","Error Message",JOptionPane.PLAIN_MESSAGE );
- }
- else
- {
- if(passwordField.getText().equals(retypePasswordField.getText())&&passwordField.getText().length()>0)
- {
- if(insertUserQuery(firstNameField.getText(),middleNameField.getText(),lastNameField.getText(),telephoneField.getText(),userNameField.getText(),mailField.getText(),passwordField.getText(),dateOfBirthField.getText(),countryField.getText(),mobileField.getText()))
- {
- JOptionPane.showMessageDialog(null, "You Registered Successfully","Confirmation Message",JOptionPane.PLAIN_MESSAGE );
- userName = userNameField.getText();
- userLevel = 3;
- frame.remove(regPanel);
- frame.add(userPanel);
- frame.repaint();
- }
- else
- {
- JOptionPane.showMessageDialog(null, "Error Ocurred Please Check Your Data Carefully","Error Message",JOptionPane.PLAIN_MESSAGE );
- }
- }
- else
- {
- JOptionPane.showMessageDialog(null, "The Password Doesn't Match","Error Message",JOptionPane.PLAIN_MESSAGE );
- }
- }
- }
- else
- JOptionPane.showMessageDialog(null, "The Username Is Used","Error Message",JOptionPane.PLAIN_MESSAGE );
- }
- if(e.getSource()==createTourH)
- {
- frame.remove(highAdminPanel);
- frame.add(createTournamentPanel);
- frame.repaint();
- }
- if(e.getSource()==createMatchH)
- {
- frame.remove(highAdminPanel);
- frame.add(createMatchPanel);
- frame.repaint();
- }
- if(e.getSource()==createMatch)
- {
- frame.remove(lowAdminPanel);
- frame.add(createMatchPanel);
- frame.repaint();
- }
- if(e.getSource()==deleteTourH)
- {
- frame.remove(highAdminPanel);
- frame.add(removeTournamentPanel);
- frame.repaint();
- }
- if(e.getSource()==deleteMatchH)
- {
- frame.remove(highAdminPanel);
- frame.add(removeMatchPanel);
- frame.repaint();
- }
- if(e.getSource()==deleteMatch)
- {
- frame.remove(lowAdminPanel);
- frame.add(removeMatchPanel);
- frame.repaint();
- }
- if(e.getSource()==userReserve)
- {
- frame.remove(userPanel);
- frame.add(reserveTicketPanel);
- viewTicketQuery();
- frame.repaint();
- }
- if(e.getSource()==userFind)
- {
- frame.remove(userPanel);
- frame.add(findMatchesPanel);
- frame.repaint();
- }
- }
- public boolean finalQuery()
- {
- try
- {
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select seatnumber from [Ticket] where id='"+reserveTicketFieldU.getText()+"' and category='"+categoryField.getText()+"'");
- String x ="";
- while(rs.next())
- {
- x = x+rs.getObject(1)+" ";
- }
- String [] in = x.split(" ");
- boolean found = true;
- int xi = 1;
- for(int i = 1 ; i>0 & found ; ++i)
- {
- found = false;
- for(int j = 0 ; j<in.length ; ++j)
- if((i+"").equals(in[j]))
- found = true;
- if(!found)
- {
- xi = i;
- }
- }
- st.executeUpdate("insert into [Ticket] values ('"+xi+"'"+","+"'"+categoryField.getText()+"'"+","+"'"+userName+"'"+","+"'"+reserveTicketFieldU.getText()+"')");
- return true;
- }
- catch(Exception e)
- {
- return false;
- }
- }
- public boolean categoryQuery()
- {
- try
- {
- Statement st = con.createStatement();
- System.out.println("select numofseats from [Match] where id='"+reserveTicketFieldU.getText()+"'");
- ResultSet rs = st.executeQuery("select numofseats from [Match] where id='"+reserveTicketFieldU.getText()+"'");
- rs.next();
- int s = new Integer(""+rs.getObject(1));
- int cat1 = s/2;
- int cat2 = s/4;
- int cat3 = s/4;
- int cat1r = 0;
- int cat2r = 0;
- int cat3r = 0;
- rs = st.executeQuery("select * from [Ticket] where id='"+reserveTicketFieldU.getText()+"'");
- ResultSetMetaData rsm = rs.getMetaData();
- int columns = rsm.getColumnCount();
- while(rs.next())
- {
- for(int i = 1 ; i<=columns ; ++i)
- {
- if(rsm.getColumnName(i).equals("category"))
- {
- String temp = ""+rs.getObject(i);
- if(temp.equals("1"))
- {
- cat1r ++;
- }
- else
- if(temp.equals("2"))
- {
- cat2r++;
- }
- else
- {
- cat3r++;
- }
- }
- }
- }
- if(cat1r<cat1)
- {
- category1Label . setText(" Category 1 has Empty Seats");
- cflag1 = true;
- }
- else
- {
- category1Label . setText(" Category 1 doesn't have Empty Seats");
- cflag1 = false;
- }
- if(cat2r<cat2)
- {
- category2Label . setText(" Category 2 has Empty Seats");
- cflag2 = true;
- }
- else
- {
- category2Label . setText(" Category 2 doesn't have Empty Seats");
- cflag2 = false;
- }
- if(cat3r<cat3)
- {
- category3Label . setText(" Category 3 has Empty Seats");
- cflag3 = true;
- }
- else
- {
- category3Label . setText(" Category 3 doesn't have Empty Seats");
- cflag3 = false;
- }
- return true;
- }
- catch (Exception e) {System.out.println(e.getMessage());return false;}
- }
- public boolean ticketQuery()
- {
- return true ;
- }
- public boolean findTourQuery()
- {
- try
- {
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select * from [Tournament] u where u.startdate = '"+findMatchesField.getText()+" 12:00:00 AM'");
- ResultSetMetaData rsm = rs.getMetaData();
- int columns = rsm.getColumnCount();
- boolean flag = false;
- int x = 0 ;
- while (rs.next())
- {
- flag = true;
- for (int i = 1,y=0; i <= columns; i++,y++)
- {
- Object rT = rs.getObject(i);
- String r;
- if(rT!=null)
- r=""+rT;
- else
- r="Empty";
- if(r!=null)
- findMatchesTable.setValueAt(r,x,y);
- else
- findMatchesTable.setValueAt("Empty",x,y);
- }
- x++;
- }
- if(!flag)
- return false;
- return true;
- }
- catch (Exception e) {return false;}
- }
- public boolean updateMatchQuery(String tourName)
- {
- try
- {
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select * from [Match] where id = '"+tourName+"'");
- ResultSetMetaData rsm = rs.getMetaData();
- int columns = rsm.getColumnCount();
- String x = "";
- while (rs.next())
- {
- rs.getObject(1);
- for(int i = 2 ; i<=columns ; ++i)
- x=x+""+rs.getObject(i)+" ";
- }
- if(x.equals(""))
- return false;
- String [] in = x.split(" ");
- if(numOfSeatsFieldU.getText().length()>0)
- {
- in[0]=numOfSeatsFieldU.getText();
- in[0]=""+((new Integer(numOfSeatsFieldU.getText())/4) *4);
- }
- if(matchWeightFieldU.getText().length()>0)
- {
- in[1]=matchWeightFieldU.getText();
- }
- if(locationFieldU.getText().length()>0)
- {
- in[2]=locationFieldU.getText();
- }
- if(tourIdFieldUP.getText().length()>0)
- {
- in[3]=tourIdFieldUP.getText();
- }
- if(firstTeamFieldU.getText().length()>0)
- {
- in[4]=firstTeamFieldU.getText();
- }
- if(secondTeamFieldU.getText().length()>0)
- {
- in[5]=secondTeamFieldU.getText();
- }
- for(int i = 0 ; i<in.length;++i)
- in[i]="'"+in[i]+"'";
- 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+"'";
- st.executeUpdate(r);
- return true;
- }
- catch (Exception e) {return false;}
- }
- public boolean updateTourQuery(String tourName)
- {
- try
- {
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select * from [Tournament] where trid = '"+tourName+"'");
- ResultSetMetaData rsm = rs.getMetaData();
- int columns = rsm.getColumnCount();
- String x = "";
- while (rs.next())
- {
- for(int i = 1 ; i<=columns ; ++i)
- x=x+""+rs.getObject(i)+" ";
- }
- if(x.equals(""))
- return false;
- String [] in = x.split(" ");
- if(tourNameFieldU.getText().length()>0)
- {
- in[0]=tourNameFieldU.getText();
- }
- if(tourDescripFieldU.getText().length()>0)
- {
- in[1]=tourDescripFieldU.getText();
- }
- if(tourStartDateFieldU.getText().length()>0)
- {
- in[2]=tourStartDateFieldU.getText()+" 12:00:00 AM";
- }
- else
- {
- in[2]=" 12:00:00 AM";
- }
- if(tourEndDateFieldU.getText().length()>0)
- {
- in[3]=tourEndDateFieldU.getText()+" 12:00:00 AM";
- }
- else
- {
- in[3]=" 12:00:00 AM";
- }
- if(tourTypeFieldU.getText().length()>0)
- {
- in[4]=tourTypeFieldU.getText();
- }
- if(tourOpenDateFieldU.getText().length()>0)
- {
- in[5]=tourOpenDateFieldU.getText();
- }
- if(tourCloseDateFieldU.getText().length()>0)
- {
- in[6]=tourCloseDateFieldU.getText();
- }
- for(int i = 0 ; i<in.length;++i)
- in[i]="'"+in[i]+"'";
- 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+"'";
- st.executeUpdate(r);
- return true;
- }
- catch (Exception e) {return false;}
- }
- public boolean updateQuery()
- {
- try
- {
- Statement st = con.createStatement();
- String a = "update [Registered] set dateofbirth = "+"'"+(dateOfBirthFieldU.getText())+" 12:00:00 AM'"+",country = '"+(countryFieldU.getText())+"',mobile = "+"'"+(mobileFieldU.getText())+"' where '"+userName+"'"+" = username";
- 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";
- System.out.println(a);
- System.out.println(b);
- st.executeUpdate(a);
- st.executeUpdate(b);
- return true;
- }
- catch (Exception e) {return false;}
- }
- public void userDetailsQuery()
- {
- try
- {
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select * from [User] u,[Registered] r where u.username='"+userName+"' and r.username="+"'"+userName+"'");
- ResultSetMetaData rsm = rs.getMetaData();
- int columns = rsm.getColumnCount();
- rs.next();
- firstNameFieldU.setText(""+rs.getObject(1));
- middleNameFieldU.setText(""+rs.getObject(2));
- lastNameFieldU.setText(""+rs.getObject(3));
- telephoneFieldU.setText(""+rs.getObject(4));
- rs.getObject(5);
- mailFieldU.setText(""+rs.getObject(6));
- String t = ""+rs.getObject(7);
- passwordFieldU.setText(t);
- retypePasswordFieldU.setText(t);
- rs.getObject(8);
- dateOfBirthFieldU.setText(""+rs.getObject(9));
- dateOfBirthFieldU.setText("");
- countryFieldU.setText(""+rs.getObject(10));
- mobileFieldU.setText(""+rs.getObject(11));
- for(int i = 12 ; i<=columns ; ++i)
- rs.getObject(i);
- rs.next();
- }
- catch (Exception e) {System.out.println("Error");}
- }
- public boolean insertUserQuery(String n1,String n2,String n3,String n4,String n5,String n6 ,String n7 ,String n8 , String n9,String n10)
- {
- try
- {
- Statement st = con.createStatement();
- n8="'"+n8+" 12:00:00 AM'";
- n1="'"+n1+"'";n2="'"+n2+"'";n3="'"+n3+"'";n4="'"+n4+"'";n5="'"+n5+"'";n6="'"+n6+"'";n7="'"+n7+"'";n9="'"+n9+"'";n10="'"+n10+"'";
- st.executeUpdate("insert into [User] values ("+n1+","+n2+","+n3+","+n4+","+n5+","+n6+","+n7+","+"'Registered')");
- st.executeUpdate("insert into [Registered] values ("+n8+","+n9+","+n10+","+n5+")");
- return true;
- }
- catch (Exception e)
- {
- try
- {
- Statement st = con.createStatement();
- st.executeUpdate("delete from [user] where username = "+n5);
- }
- catch(Exception ee)
- {
- return false;
- }
- return false;
- }
- }
- public boolean checkUserNameQuery(String n)
- {
- try
- {
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select username from [User]");
- boolean flag = true;
- while(rs.next())
- {
- String r = ""+rs.getObject(1);
- if(n.equals(r))
- flag = false;
- }
- return flag;
- }
- catch (Exception e) {return false;}
- }
- public static void connectUsingJDBC()
- {
- String dataSourceName = "Stadium";
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- String dbURL = "jdbc:odbc:" + dataSourceName;
- con = DriverManager.getConnection(dbURL);
- System.out.println("User connected using driver: " + con.getMetaData().getDriverName());
- }
- catch (Exception e)
- {
- e.printStackTrace();
- }
- }
- public static String loginQuery(String n,String p)
- {
- try
- {
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select typ from [user] u where u.username = "+"'"+n+"'"+" and "+"'"+p+"'"+" = u.password");
- rs.next();
- String t = ""+rs.getObject(1);
- System.out.println(t);
- return t;
- }
- catch (Exception e) {return null;}
- }
- public void viewTicketQuery()
- {
- try
- {
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select * from Ticket where username='"+userName+"'");
- ResultSetMetaData rsm = rs.getMetaData();
- int columns = rsm.getColumnCount();
- int x = 0 ;
- while (rs.next())
- {
- for (int i = 1,y=0; i <= columns; i++,y++)
- {
- Object rT = rs.getObject(i);
- String r;
- if(rT!=null)
- r=""+rT;
- else
- r="Empty";
- if(r!=null)
- reserveTicketTable.setValueAt(r,x,y);
- else
- reserveTicketTable.setValueAt("Empty",x,y);
- }
- x++;
- }
- }
- catch (Exception e) {System.out.println(e.getMessage());}
- }
- public void viewTourQuery()
- {
- try
- {
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select * from [Tournament]");
- ResultSetMetaData rsm = rs.getMetaData();
- int columns = rsm.getColumnCount();
- int x = 0 ;
- while (rs.next())
- {
- for (int i = 1,y=0; i <= columns; i++,y++)
- {
- Object rT = rs.getObject(i);
- String r;
- if(rT!=null)
- r=""+rT;
- else
- r="Empty";
- if(r!=null)
- viewTourTable.setValueAt(r,x,y);
- else
- viewTourTable.setValueAt("Empty",x,y);
- }
- x++;
- }
- }
- catch (Exception e) {System.out.println(e.getMessage());}
- }
- public void viewMatchQuery()
- {
- try
- {
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select * from [Match]");
- ResultSetMetaData rsm = rs.getMetaData();
- int columns = rsm.getColumnCount();
- int x = 0 ;
- while (rs.next())
- {
- for (int i = 1,y=0; i <= columns; i++,y++)
- {
- Object rT = rs.getObject(i);
- String r;
- if(rT!=null)
- r=""+rT;
- else
- r="Empty";
- if(r!=null)
- viewMatchTable.setValueAt(r,x,y);
- else
- viewMatchTable.setValueAt("Empty",x,y);
- }
- x++;
- }
- }
- catch (Exception e) {System.out.println(e.getMessage());}
- }
- public boolean createMatchQuery(String seats , String weight , String id , String n1 , String n2)
- {
- try
- {
- new Integer(seats);
- new Integer(weight);
- boolean flag1 = false;
- boolean flag2 = false;
- boolean flag3 = false;
- Statement st = con.createStatement();
- ResultSet rs1 = st.executeQuery("select trid from [Tournament]");
- while(rs1.next())
- {
- String temp = ""+rs1.getObject(1);
- if(temp.equals(id))
- flag1 = true;
- }
- ResultSet rs2 = st.executeQuery("select teamname from [Team]");
- while(rs2.next())
- {
- String temp = ""+rs2.getObject(1);
- if(temp.equals(n1))
- flag2 = true;
- else
- if(temp.equals(n2))
- flag3 = true;
- }
- if(!n1.equals(n2))
- return flag1&&flag2&&flag3;
- return false;
- }
- catch(Exception e){return false;}
- }
- public void insertMatchQuery(String n1,String n2,String n3,String n4,String n5,String n6)
- {
- n1 = ""+((new Integer(n1)/4) * 4);
- n1 = "'"+n1+"'"; n2 = "'"+n2+"'"; n4 = "'"+n4+"'"; n3 = "'"+n3+"'"; n5 = "'"+n5+"'"; n6 = "'"+n6+"'";
- String r = "insert into [Match] values("+n1+","+n2+","+n3+","+n4+","+n5+","+n6+")";
- try
Add Comment
Please, Sign In to add comment