Shaz Software Solutions

Race Report

Participant Report

Contact Report

Running Race Event Management Software - Part 3( Report)
Part 1 (Registration)
Part 2 (Race and Winner)

Class: MetaData.java
Class: CustomMath.java
Class: CustomDateTime.java
Class: WinnerInfo.java
Class: RaceInfo.java
Class: Participant.java
Class: ConnectionDB.java
Class: ConnectDatabase.java
Class: WinnerDB.java
Class: RaceDB.java
Class: ParticipantDB.java
Class: Registration.java
Class: Race.java
Class: Winner.java
Class: RaceReport.java
Class: ParticipantReport.java
Class: ContactReport.java
Class: ReportSelector.java
Class: FormatUI.java
Class: RaceUI.java
Class: WinnerUI.java
Class: RegisterUI.java
Class: BolderRaceUI.java
Class: BolderMain.java
Author: Shahrzad Jahangirian
Language: Java (using Java 6) Download Java 6 and Download Java Runtime 6(JRE)
Database: MySql
Report: Dynamic Reports
Date Added: October 18, 2014
Licence: All source codes are for showing my skills in Software Development to get me a Job as an Application Developer. You are not allowed to sell this Application or use my codes to develop an application for Sale or apply my codes to develop software for commercial use and profit. You can offer me a price to buy the Application for mass production or buy my codes to develop your application for profit. Also you may offer me a price to buy this Application for your Business and ask me to update the codes to match your Business Requirements.

This application worth minimum of $5000 if it needs to be done in a Software Development company or in an IT Department.
Description:This is part 3 or final part of Running Race Event Management Software that I published its part 1 on April 5th 2014. In part 1 I completed main desktop and Registration screens that add, delete and update records in a database. In part 2 I added all source codes for Races and Winners screens to add, delete(no delete for Race) and update records in a database. In this page I included part 3 that contains three reports for this applications as Race Report, Participant Report, and Contact Report that I developed using Dynamic Reports. I included all completed source codes for this application in this page that includes part 1, 2, and 3 source codes.
Application requirement and specification came from Chapter 3 Entity Relationship Modeling of Developing Web-Enabled Decision Support Systems book. I found this sample chapter pdf file in Internet and you can download it from above link. The problem description is on page 69 as follows:
3.20 In-Class Assignment
Consider the following problem statement to draw an E-R diagram: The annual Bolder Boulder is one of America's top 10 km races. The race is held each Memorial Day in Boulder, Colorado. This race attracts world-class runners as well as casual joggers. It is a point-to-point race beginning at the Bank of Boulder at the northeast corner of the city, winding throughout the city streets, and ending near the town center in the University of Colorado's football stadium. The organizers record the following information for each race: the date of the race; the total number of runners registered for the race (on-line pre-registration is possible); the actual number of participants; the number of male runners; the number of female runners; the name of the male winner; the name of the female winner; the name of the male master (runner over the age of 40) winner; and the name of the female master winner. In addition, the following information about each participant is recorded: social security number, name, birth date, gender, address, age, and certified personal record (PR) running times for a 10 km race.
The above assignment is an example description for a typical custom design database application that today's world needs for many events, businesses, and much more. I also visited the Bolder Boulder Web site at http://www.bolderboulder.com/ and downloaded the Bolder BOULDER Entry Form that provided me with more information to design and develop this Application. The description is short and a person with no software development knowledge could not believe how much code need to be written to complete this Application.
Many Events, Organization and Business in today's world needs custom design database application to be developed for them with their unique requirements. Currently I am unemployed and I am available to be employed full time, part time, contract, or casual by a Company or a Business in Melbourne and its Suburbs in Australia. Please see and download my Resume, Qualifications from About menu.

How to Run: I tested all codes on Windows 7 Command Prompt with Download Java(TM) SE Runtime Environment 6 on my computer.(you may download it by visiting the link)
Also to run this application you have to have MySql installed in your computer and know what is your MySql Username and Password. I used MySql 5.6.15 for this Application. In the time of writting of this page October 18, 2014 you can download MySQL Installer 5.6.21 (287.0M) from http://dev.mysql.com/downloads/windows/installer/
Also in part 3 I used Dynamic Reports that you can download it freely from http://www.dynamicreports.org/ to implement Reports for Race Application. I installed and set it up in my computer by configuring Classpath to point to directory with Dynamic Reports .jar files. To run this application with Working Reports you need to install the Dynamic Reports correctly on your Computer.
Please note Dynamic Reports is a Free and open source Java reporting tool, it is not commercial and has many bugs. When you run the Application and press to display a Report, it takes few second before the report appear, also it displays many compiling debugging messages on command prompt. It is out of my reach to fix these outputs, it relates to Dynamic Reports software. Then you need to create all files and save it in a folder in your computer such as C:\javacodes and compile and run at command prompt as below, you may also download all source code files from Download Source Files (part 3) and there is a batch file for easier compiling that needs to be configure. I assumed you saved all files at C:\javacodes
For this Application first you need to run MetaData.java class successfuly with your MySql usename and password placed at jdbc:mysql://localhost?user=YourMysqlUsername&password=YourMysqlPassword for creating BOLDER Database, PARTICIPANT, RACE, and WINNER Tables as follows:
C:\javacodes> javac MetaData.java "This is to compile"
C:\javacodes> Java MetaData "This is to run"
Obviousley you should not have any error messages and also make sure Database and Tables have been created by visiting your own MySql Database in your computer.
Then use a .bat file or compile following files on command prompt in exact following orders
C:\javacodes> javac CustomMath.java -d c:\javacodes
C:\javacodes> javac CustomDateTime.java -d c:\javacodes
C:\javacodes> javac WinnerInfo.java -d c:\javacodes
C:\javacodes> javac RaceInfo.java -d c:\javacodes
C:\javacodes> javac Participant.java -d c:\javacodes
C:\javacodes> javac ConnectionDB.java -d c:\javacodes
C:\javacodes> javac ConnectDatabase.java -d c:\javacodes
C:\javacodes> javac WinnerDB.java -d c:\javacodes
C:\javacodes> javac RaceDB.java -d c:\javacodes
C:\javacodes> javac ParticipantDB.java -d c:\javacodes
C:\javacodes> javac Registration.java -d c:\javacodes
C:\javacodes> javac Race.java -d c:\javacodes
C:\javacodes> javac Winner.java -d c:\javacodes
C:\javacodes> javac RaceReport.java -d c:\javacodes
C:\javacodes> javac ParticipantReport.java -d c:\javacodes
C:\javacodes> javac ContactReport.java -d c:\javacodes
C:\javacodes> javac ReportSelector.java -d c:\javacodes
C:\javacodes> javac FormatUI.java -d c:\javacodes
C:\javacodes> javac RaceUI.java -d c:\javacodes
C:\javacodes> javac WinnerUI.java -d c:\javacodes
C:\javacodes> javac RegisterUI.java -d c:\javacodes
C:\javacodes> javac BolderRaceUI.java -d c:\javacodes
C:\javacodes> javac BolderMain.java "compiles the BolderMain class"
C:\javacodes> Java BolderMain "and finally with this statement runs this Application"

Class: MetaData.java

/*
 Class: MetaData
 Author: Shahrzad Jahangirian
 Date: March 25, 2014

This class establish a connection to MySql Database Managment System on your Computer
 using JDBC and then create a database named as
 BOLDER and then create PARTICIPANT, RACE, and WINNER Tables. It needs to be run only once to
 connect to MySql database using username and password at
 jdbc:mysql://localhost?user=YourMysqlUsername&password=YourMysqlPassword
 then it creates the Database, and its Tables.
 */

import java.sql.*;

public class MetaData {

public static void main(String args[]) {

String url =
                "jdbc:mysql://localhost?user=YourMysqlUsername&password=YourMysqlPassword";
        Connection con;
        String createDatabase = new String("create database BOLDER");
        String useDatabase = new String("use BOLDER");
        String participantTable = new String();
        String raceTable = new String();
        String winnerTable = new String();
        Statement stmt;

participantTable = "CREATE TABLE PARTICIPANT"
                + "(participantId INT NOT NULL, "
                + "ssn VARCHAR(35) NOT NULL UNIQUE, "
                + "name VARCHAR(100), "
                + "surname VARCHAR(150), "
                + "nickname VARCHAR(100), "
                + "birthDate VARCHAR(10),"
                + "age INTEGER,"
                + "pr VARCHAR(20),"
                + "address1 VARCHAR(200),"
                + "address2 VARCHAR(200),"
                + "city VARCHAR(100),"
                + "state VARCHAR(100),"
                + "zip VARCHAR(100),"
                + "country VARCHAR(25),"
                + "email VARCHAR(200),"
                + "gender VARCHAR(10),"
                + "mobile VARCHAR(35),"
                + "phone VARCHAR(50),"
                + "emergencyPhone VARCHAR(50),"
                + "raceType VARCHAR(20),"
                + "raceId INTEGER NOT NULL,"
                + "PRIMARY KEY(participantId))";

raceTable = "CREATE TABLE RACE"
                + "(raceId INT NOT NULL UNIQUE, "
                + "raceDate VARCHAR(10), "
                + "raceTime VARCHAR(20), "
                + "raceName VARCHAR(300), "
                + "PRIMARY KEY(raceId))";

winnerTable = "CREATE TABLE WINNER"
                + "(raceid INTEGER NOT NULL UNIQUE, "
                + "ssn VARCHAR(35), "
                + "master BOOLEAN, "
                + "PRIMARY KEY(raceId, ssn))";

try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (java.lang.ClassNotFoundException e) {
            System.err.println("ClassNotFoundException: " + e.getMessage());
        }

try {
            con = DriverManager.getConnection(url);
            stmt = con.createStatement();
            stmt.execute(createDatabase);
            stmt.execute(useDatabase);
            stmt.execute(raceTable);
            stmt.execute(participantTable);
            stmt.execute(winnerTable);        
            stmt.close();
            con.close();
        } catch (SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }
    }
}

Class: CustomMath.java

Class: CustomDateTime.java

/*
 Class: CustomDataTime
 Author: Shahrzad Jahangirian
 Date: May 2, 2014
 Description: A class for collection of methods relates to Date and Time that 
  usually needs to be used in most Applications. A generic and a helper class.
 */
package commonPKG;
import java.util.*;
import java.text.*;

public class CustomDateTime{

private int[] aDate = new int[3];

public CustomDateTime(){

}

// this method validate a date to be in dd/mm/yyyy format and not today's date
  public boolean validateADate(String bDate, String today) {
    boolean valid = true;
    try {
      String[] result = bDate.split("\\/");
      aDate[0] = Integer.parseInt(result[2]);
      aDate[1] = Integer.parseInt(result[1]);
      aDate[2] = Integer.parseInt(result[0]);
      if (bDate.equals(today) == true) {
        valid = false;
      }
    }
    catch (Exception ex) {
      valid = false;
    }
    return valid;
  }
  
    public int getADateYear(){
    return aDate[0];
  }
    
     public int getADateMonth(){
    return aDate[1];
  }
     
      public int getADateDay(){
    return aDate[2];
  }
  
   // this method validate a date to be in dd/mm/yyyy format.
  public boolean validateDate(String bDate) {
    boolean valid = true;
    int[] dateToValidate = new int[3];
    try {
      String[] result = bDate.split("\\/");
      dateToValidate[0] = Integer.parseInt(result[2]);
      dateToValidate[1] = Integer.parseInt(result[1]);
      dateToValidate[2] = Integer.parseInt(result[0]);     
    }
    catch (Exception ex) {
      valid = false;
    }
    return valid;
  }
   
}

Class: WinnerInfo.java

Class: RaceInfo.java

/*
 Class: RaceInfo
 Author: Shahrzad Jahangirian
 Date: May 2, 2014
 Description: A class for each Bolder Race information
 */
package PDpkg;

import java.util.*;
import java.text.*;

public class RaceInfo {
  private int raceId;    
  private int[] raceDate = new int[3]; //0=year, 1=month, 2=day
  private String raceTime = new String();
  private String raceName = new String();

public RaceInfo() {

}
 
  public int getRaceId() {
    return raceId;
  }

public String getRaceName() {
    return raceName;
  }

public String getRaceDate() {
    String result = String.valueOf(raceDate[0]) + "/" +
        String.valueOf(raceDate[1]) + "/" + String.valueOf(raceDate[2]);
    return result;
  }

public String getRaceTime() {
    return raceTime;
  }

public void setRaceId(int raceId) {
   this.raceId = raceId;
 }

public void setRaceName(String raceName) {
    this.raceName = raceName;
  }

public void setRaceTime(String raceTime) {
    this.raceTime = raceTime;
  }

public void setRaceDate(String bDate) {

String[] result = bDate.split("\\/");
   raceDate[0] = Integer.parseInt(result[2]);
   raceDate[1] = Integer.parseInt(result[1]);
   raceDate[2] = Integer.parseInt(result[0]);
 }

}

Class: Participant.java

/*
 Class: Participant
 Author: Shahrzad Jahangirian
 Date: March 24, 2014
 Description: A class for Bolder Race Participants
 */
package PDpkg;

import java.util.*;
import java.text.*;

public class Participant {
  private int id;
  private String ssn = new String();
  private String name = new String();
  private String surname = new String();
  private String nickname = new String();
  private int[] birthDate = new int[3]; //0=year, 1=month, 2=day
  private Calendar todaysDate;
  private int age;
  private String pr = new String();
  private String address1 = new String();
  private String address2 = new String();
  private String city = new String();
  private String state = new String();
  private String zip = new String();
  private String country = new String();
  private String gender = new String();
  private String email = new String();
  private String phone = new String();
  private String emergPhone = new String();
  private String mobile = new String();
  private int raceId;
  private String raceType = new String();

public Participant() {

}

// Calculate Age in years
  public int calculateAge() {
    todaysDate = Calendar.getInstance();
    todaysDate.setTime(new java.util.Date());
    age = todaysDate.get(Calendar.YEAR) - birthDate[0];
    return age;
  }

public int calculateAge(int birthYear) {
   todaysDate = Calendar.getInstance();
   todaysDate.setTime(new java.util.Date());
   age = todaysDate.get(Calendar.YEAR) - birthYear;
   return age;
 }

public int getId() {
    return id;
  }

public String getSsn() {
    return ssn;
  }

public String getName() {
    return name;
  }

public String getSurname() {
    return surname;
  }

public String getNickname() {
    return nickname;
  }

public String getBirthDate() {
    String result = String.valueOf(birthDate[0]) + "/" +
        String.valueOf(birthDate[1]) + "/" + String.valueOf(birthDate[2]);
    return result;
  }

public int getAge() {
    return age;
  }

public String getPr() {
    return pr;
  }

public String getAddress1() {
    return address1;
  }

public String getAddress2() {
    return address2;
  }

public String getCity() {
    return city;
  }

public String getState() {
    return state;
  }

public String getZip() {
    return zip;
  }

public String getCountry() {
    return country;
  }

public String getGender() {
    return gender;
  }

public String getEmail() {
    return email;
  }

public String getPhone() {
    return phone;
  }

public String getEmergPhone() {
    return emergPhone;
  }

public String getMobile() {
    return mobile;
  }

public int getRaceId() {
    return raceId;
  }

public String getRaceType() {
    return raceType;
  }

public void setId(int id) {
   this.id = id;
 }

public void setSsn(String ssn) {
    this.ssn = ssn;
  }

public void setName(String name) {
    this.name = name;
  }

public void setSurname(String surname) {
    this.surname = surname;
  }

public void setNickname(String nickname) {
    this.nickname = nickname;
  }

public void setBirthDate(String bDate) {

String[] result = bDate.split("\\/");
   birthDate[0] = Integer.parseInt(result[2]);
   birthDate[1] = Integer.parseInt(result[1]);
   birthDate[2] = Integer.parseInt(result[0]);
 }

public void setAge(int age) {
    this.age = age;
  }

public void setPr(String pr) {
    this.pr = pr;
  }

public void setAddress1(String address1) {
    this.address1 = address1;
  }

public void setAddress2(String address2) {
    this.address2 = address2;
  }

public void setCity(String city) {
    this.city = city;
  }

public void setState(String state) {
    this.state = state;
  }

public void setZip(String zip) {
    this.zip = zip;
  }

public void setCountry(String country) {
    this.country = country;
  }

public void setGender(String gender) {
    this.gender = gender;
  }

public void setEmail(String email) {
    this.email = email;
  }

public void setPhone(String phone) {
    this.phone = phone;
  }

public void setEmergPhone(String emergPhone) {
    this.emergPhone = emergPhone;
  }

public void setMobile(String mobile) {
    this.mobile = mobile;
  }

public void setRaceId(int raceId) {
    this.raceId = raceId;
  }

public void setRaceType(String raceType) {
    this.raceType = raceType;
  }

}

Class: ConnectionDB.java

/*
 Class: ConnectionDB
 Author: Shahrzad Jahangirian
 Date: March 26, 2014
 Description: This is a class for Database Conncetion.
 Replace your MySql usename and Password at
 String url = "jdbc:mysql://localhost?user=YourMysqlUsername&password=YourMysqlPassword";
 */
package DBpkg;

import java.sql.*;
import java.lang.*;

public class ConnectionDB {

protected Connection con = null;
    protected Statement stmt = null;
    protected PreparedStatement query = null;
    protected ResultSet rs = null;

public ConnectionDB() {
         dbConnect();
    }

public void dbConnect() {
        String url = "jdbc:mysql://localhost?user=root&password=MySqlPass22";
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (java.lang.ClassNotFoundException e) {
            System.err.print("ClassNotFoundException: ");
            System.err.println(e.getMessage());
        }
        try {
            con = DriverManager.getConnection(url);
            stmt = con.createStatement();
            stmt.execute("use BOLDER");
        } catch (SQLException ex) {
            System.err.println("SQLException dbConnect: " + ex.getMessage());
        }
    }

public void dbClose() {
        try {
            if (rs != null) {
                rs.close();
            }
            if (stmt != null) {
                stmt.close();
            }
            if (con != null) {
                con.close();
            }
        } catch (SQLException ex) {
            System.err.println("SQLException dbClose: " + ex.getMessage());
        }
    }
}

Class: ConnectDatabase.java

Class: WinnerDB.java

/*
 Class: WinnerDB
 Author: Shahrzad Jahangirian
 Update Date: June 21, 2014
 Description: This class does all database manipulation for Winner table of BOLDER Database.
 It extends ConnectionDB class.
 */
package DBpkg;

import java.sql.*;
import java.util.*;
import java.lang.*;
import java.lang.Integer;

import PDpkg.WinnerInfo;

public class WinnerDB extends ConnectionDB {

private WinnerInfo winnerinfo = new WinnerInfo();

public WinnerDB() {
        
    }
    
    public boolean isWinnerEmpty() {
        boolean empty = false;
        try {
            rs = null;
            query = con.prepareStatement("select * from Winner");           
            rs = query.executeQuery();
            if (!rs.next()) {
                empty = true;
            }
        } catch (Exception ex) {
        //    System.err.println("SQLException isWinnerEmpty" + ex.getMessage());
        } 
        return empty;
    }

public boolean isWinnerDuplicate(int id, String ssn) {
        boolean duplicate = false;
        try {
            rs = null;
            query = con.prepareStatement("select * from Winner where raceId = ? and ssn = ?");
            query.setInt(1, id);
            query.setString(2, ssn);
            rs = query.executeQuery();
            if (rs.first()) {
                duplicate = true;                
                fillRecord();
            }
        } catch (Exception ex) {
         //   System.err.println("SQLException isWinnerDuplicate" + ex.getMessage());
        } 
        return duplicate;
    }
    
    public boolean isWinnerExist(int id, String ssn) {
        boolean exist = false;
        try {
            rs = null;
            query = con.prepareStatement("select * from Winner where raceId = ? and ssn = ?");
            query.setInt(1, id);
            query.setString(2, ssn);
            rs = query.executeQuery();
            if (rs.first()) {
                exist = true;                
                fillRecord();
            }
        } catch (Exception ex) {
          //  System.err.println("SQLException isWinnerExist" + ex.getMessage());
        } 
        return exist;
    }
    
    public boolean isRaceId(int id) {
        boolean exist = false;
        try {
            rs = null;
            query = con.prepareStatement("select * from Winner where raceId = ?");
            query.setInt(1, id);           
            rs = query.executeQuery();
            if (rs.first()) {
                exist = true;                               
            }
        } catch (Exception ex) {
          //  System.err.println("SQLException isWinnerExist" + ex.getMessage());
        } 
        return exist;
    }
    
    public boolean isSsnId(String id) {
        boolean exist = false;
        try {
            rs = null;
            query = con.prepareStatement("select * from Winner where ssn = ?");
            query.setString(1, id);           
            rs = query.executeQuery();
            if (rs.first()) {
                exist = true;                               
            }
        } catch (Exception ex) {
          //  System.err.println("SQLException isWinnerExist" + ex.getMessage());
        } 
        return exist;
    }

public void fillRecord() {
        winnerinfo = new WinnerInfo();
        try {
            winnerinfo.setRaceId(rs.getInt(1));
            winnerinfo.setSSN(rs.getString(2));
            winnerinfo.setMaster(rs.getBoolean(3));

} catch (Exception ex) {
        //    System.err.println("SQLException fillRecord: " + ex.getMessage());
        } 
    }

public WinnerInfo getRecord() {
        return winnerinfo;
    }

public boolean saveWinner(WinnerInfo record) {
        boolean ok = true;
        try {
            query = con.prepareStatement(
                    "insert into Winner values"
                    + "(?,?, ?)");

query.setInt(1, record.getRaceId());
            query.setString(2, record.getSSN());
            query.setBoolean(3, record.getMaster());                    
            query.executeUpdate();
        } catch (SQLException ex) {
            ok = false;
        //    System.err.println("SQLException saveWinner: " + ex.getMessage());
        } 
        return ok;
    }

public boolean updateWinner(WinnerInfo record) {
        boolean ok = true;
        try {
            query = con.prepareStatement(
                    "update Winner set Master=? where raceId = ? and ssn = ?");
            
            query.setBoolean(1, record.getMaster());
            query.setInt(2, record.getRaceId());
            query.setString(3, record.getSSN());                     
            query.executeUpdate();
        } catch (SQLException ex) {
            ok = false;
        //    System.err.println("SQLException updateWinner: " + ex.getMessage());
        } 
        return ok;
    }
    
    public boolean deleteWinner(int id, String ssn){       
         boolean ok = true;
        try {           
            query = con.prepareStatement(
                    "delete from Winner where raceId = ? and ssn = ?");
            query.setInt(1, id);
            query.setString(2, ssn);
            query.executeUpdate();
             } catch (SQLException ex) {
            ok = false;
         //   System.err.println("SQLException deleteWinner: " + ex.getMessage());
        } 
        return ok;       
    }
}

Class: RaceDB.java

/*
 Class: RaceDB
 Author: Shahrzad Jahangirian
 Update Date: May 2, 2014
 Description: This class does all database manipulation for Race table of BOLDER Database.
 It extends ConnectionDB class.
 */
package DBpkg;

import java.sql.*;
import java.util.*;
import java.lang.*;
import java.lang.Integer;

import PDpkg.RaceInfo;
import DBpkg.WinnerDB;

public class RaceDB extends ConnectionDB {

private RaceInfo raceinfo = new RaceInfo();
    private ArrayList<RaceInfo> raceList = new ArrayList<RaceInfo>();
    private boolean isWinner = false;

public RaceDB() {
    }

public boolean isRaceIdDuplicate(int id) {
        boolean duplicate = false;
        try {
            rs = null;
            query = con.prepareStatement("select * from Race where raceId = ?");
            query.setInt(1, id);
            rs = query.executeQuery();
            if (rs.first()) {
                duplicate = true;
                fillRecord();
            }
        } catch (Exception ex) {
            //   System.err.println("SQLException isRaceIdDuplicate" + ex.getMessage());
        }
        return duplicate;
    }

public boolean isRaceEmpty() {
        boolean empty = false;
        try {
            rs = null;
            query = con.prepareStatement("select * from Race");
            rs = query.executeQuery();
            if (!rs.next()) {
                empty = true;
            }
        } catch (Exception ex) {
            //  System.err.println("SQLException isRaceEmpty" + ex.getMessage());
        }
        return empty;
    }

public boolean isRaceIdExist(int id) {
        boolean exist = false;
        try {
            rs = null;
            query = con.prepareStatement("select * from Race where raceId = ?");
            query.setInt(1, id);
            rs = query.executeQuery();
            if (rs.first()) {
                exist = true;
                fillRecord();
            }
        } catch (Exception ex) {
            //   System.err.println("SQLException isRaceIdExist" + ex.getMessage());
        }
        return exist;
    }

public ArrayList getAllRaces() {
        try {
            rs = null;
            query = con.prepareStatement("select * from Race");
            rs = query.executeQuery();
            while (rs.next()) {
                fillRecord();
                raceList.add(raceinfo);
            }
        } catch (Exception ex) {
            //    System.err.println("SQLException getAllRaces" + ex.getMessage());
        }
        return raceList;
    }

public void fillRecord() {
        raceinfo = new RaceInfo();
        try {
            raceinfo.setRaceId(rs.getInt(1));
            raceinfo.setRaceDate(rs.getString(2));
            raceinfo.setRaceTime(rs.getString(3));
            raceinfo.setRaceName(rs.getString(4));

} catch (Exception ex) {
            //     System.err.println("SQLException fillRecord: " + ex.getMessage());
        }
    }

public RaceInfo getRecord() {
        return raceinfo;
    }

public boolean saveRace(RaceInfo record) {
        boolean ok = true;
        try {
            query = con.prepareStatement(
                    "insert into RACE values"
                    + "(?,?, ?, ?)");

query.setInt(1, record.getRaceId());
            query.setString(2, record.getRaceDate());
            query.setString(3, record.getRaceTime());
            query.setString(4, record.getRaceName());
            query.executeUpdate();
        } catch (SQLException ex) {
            ok = false;
            //   System.err.println("SQLException saveRace: " + ex.getMessage());
        }
        return ok;
    }

public boolean updateRace(RaceInfo record) {
        boolean ok = true;
        try {
            query = con.prepareStatement(
                    "update RACE set raceDate=?,raceTime=?,raceName=? where raceId = ?");

query.setString(1, record.getRaceDate());
            query.setString(2, record.getRaceTime());
            query.setString(3, record.getRaceName());
            query.setInt(4, record.getRaceId());
            query.executeUpdate();
        } catch (SQLException ex) {
            ok = false;
            //   System.err.println("SQLException updateRace: " + ex.getMessage());
        }
        return ok;
    }
    
    public boolean isRaceInWinner(){
        return isWinner;
    }
      
    public boolean deleteRace(int id) {
        boolean ok = true;
        isWinner = false;      
        WinnerDB winnerdb = new WinnerDB();  
        boolean exist = winnerdb.isRaceId(id);
        if (exist == true) {           
            ok = false;
            isWinner = true;
        }     
         else {
            try {               
                query = con.prepareStatement(
                        "delete from Race where raceId = ?");
                query.setInt(1, id);
                query.executeUpdate();
            } catch (SQLException ex) {
                ok = false;
                   System.err.println("SQLException deleteRace: " + ex.getMessage());
            }
        }
        return ok;
    }
}

Class: ParticipantDB.java

/*
 Class: ParticipantDB
 Author: Shahrzad Jahangirian
 Update Date: March 26, 2014
 Description: This class does all database manipulation for PARTICIPANT table of BOLDER Database.
 It extends ConnectionDB class.
 */
package DBpkg;

import java.sql.*;
import java.util.*;
import java.lang.*;
import java.lang.Integer;

import PDpkg.Participant;
import DBpkg.WinnerDB;

public class ParticipantDB extends ConnectionDB {

private Participant person = new Participant();
    private ArrayList<Participant> parList = new ArrayList<Participant>();
    private boolean isWinner = false;

public ParticipantDB() {
        
    }
    
      public boolean isParticipantEmpty() {
        boolean empty = false;
        try {
            rs = null;
            query = con.prepareStatement("select * from PARTICIPANT");           
            rs = query.executeQuery();
            if (!rs.next()) {
                empty = true;
            }
        } catch (Exception ex) {
            System.err.println("SQLException isParticipantEmpty" + ex.getMessage());
        } 
        return empty;
    }

public int getNextId() {
        int id = 0;
        ArrayList<Integer> idList = new ArrayList<Integer>();        
        try {
            query = con.prepareStatement("select participantId from PARTICIPANT");
            rs = query.executeQuery();
            while (rs.next()) {
                idList.add(Integer.valueOf(rs.getInt(1)));
            }
            Collections.sort(idList);
            int lastIndex = idList.size() - 1;
            Integer ref = idList.get(lastIndex);
            id = ref.intValue();
            id++;
        } catch (Exception ex) {
           // System.err.println("SQLException getNextId" + ex.getMessage());
        }
        return id;
    }
    
     public ArrayList getAllParticipant() {
        try {
            rs = null;
            query = con.prepareStatement("select * from PARTICIPANT");
            rs = query.executeQuery();
            while (rs.next()) {
                fillRecord();
                parList.add(person);
            }
        } catch (Exception ex) {
            //    System.err.println("SQLException getAllRaces" + ex.getMessage());
        }
        return parList;
    }

public boolean isSsnDuplicate(String ssnId) {
        boolean duplicate = false;
        try {
            rs = null;
            query = con.prepareStatement("select * from PARTICIPANT where ssn = ?");
            query.setString(1, ssnId);
            rs = query.executeQuery();
            if (rs.first()) {
                duplicate = true;                
                fillRecord();
            }
        } catch (Exception ex) {
            System.err.println("SQLException isSsnDuplicate" + ex.getMessage());
        }
        return duplicate;
    }
    
    public boolean isSsnExist(String ssnId) {
        boolean exist = false;
        try {
            rs = null;
            query = con.prepareStatement("select * from PARTICIPANT where ssn = ?");
            query.setString(1, ssnId);
            rs = query.executeQuery();
            if (rs.first()) {
                exist = true;                
                fillRecord();
            }
        } catch (Exception ex) {
            System.err.println("SQLException isSsnExist" + ex.getMessage());
        }
        return exist;
    }

public void fillRecord() {
        person = new Participant();
        try {
            person.setId(rs.getInt(1));
            person.setSsn(rs.getString(2));
            person.setName(rs.getString(3));
            person.setSurname(rs.getString(4));
            person.setNickname(rs.getString(5));
            person.setBirthDate(rs.getString(6));
            person.setAge(rs.getInt(7));
            person.setPr(rs.getString(8));
            person.setAddress1(rs.getString(9));
            person.setAddress2(rs.getString(10));
            person.setCity(rs.getString(11));
            person.setState(rs.getString(12));
            person.setZip(rs.getString(13));
            person.setCountry(rs.getString(14));
            person.setEmail(rs.getString(15));
            person.setGender(rs.getString(16));
            person.setMobile(rs.getString(17));
            person.setPhone(rs.getString(18));
            person.setEmergPhone(rs.getString(19));
            person.setRaceType(rs.getString(20));
            person.setRaceId(rs.getInt(21));

} catch (Exception ex) {
            System.err.println("SQLException fillRecord: " + ex.getMessage());
        }
    }

public Participant getRecord() {
        return person;
    }

public void displayList(ArrayList<Integer> list) {
        for (int i = 0; i < list.size(); i++) {
            System.out.println(i + "idList " + list.get(i));
        }

}

public boolean saveParticipant(Participant record) {
        boolean ok = true;
        try {
            query = con.prepareStatement(
                    "insert into PARTICIPANT values"
                    + "(?,?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?)");

query.setInt(1, record.getId());
            query.setString(2, record.getSsn());
            query.setString(3, record.getName());
            query.setString(4, record.getSurname());
            query.setString(5, record.getNickname());
            query.setString(6, record.getBirthDate());
            query.setInt(7, record.getAge());
            query.setString(8, record.getPr());
            query.setString(9, record.getAddress1());
            query.setString(10, record.getAddress2());
            query.setString(11, record.getCity());
            query.setString(12, record.getState());
            query.setString(13, record.getZip());
            query.setString(14, record.getCountry());
            query.setString(15, record.getEmail());
            query.setString(16, record.getGender());
            query.setString(17, record.getMobile());
            query.setString(18, record.getPhone());
            query.setString(19, record.getEmergPhone());
            query.setString(20, record.getRaceType());
            query.setInt(21, record.getRaceId());
            query.executeUpdate();
        } catch (SQLException ex) {
            ok = false;
            System.err.println("SQLException saveParticipant: " + ex.getMessage());
        }
        return ok;
    }

public boolean updateParticipant(Participant record) {
        boolean ok = true;
        try {
            query = con.prepareStatement(
                    "update PARTICIPANT set ssn=?,name=?,surname=?,nickname=?, birthdate=?,"
                    + "age=?,pr=?,address1=?,address2=?,city=?,state=?,zip=?,country=?,email=?,"
                    + "gender=?,mobile=?,phone=?,emergencyPhone=?,racetype=?,raceid=? where participantId = ?");
            
            query.setString(1, record.getSsn());
            query.setString(2, record.getName());
            query.setString(3, record.getSurname());
            query.setString(4, record.getNickname());
            query.setString(5, record.getBirthDate());
            query.setInt(6, record.getAge());
            query.setString(7, record.getPr());
            query.setString(8, record.getAddress1());
            query.setString(9, record.getAddress2());
            query.setString(10, record.getCity());
            query.setString(11, record.getState());
            query.setString(12, record.getZip());
            query.setString(13, record.getCountry());
            query.setString(14, record.getEmail());
            query.setString(15, record.getGender());
            query.setString(16, record.getMobile());
            query.setString(17, record.getPhone());
            query.setString(18, record.getEmergPhone());
            query.setString(19, record.getRaceType());
            query.setInt(20, record.getRaceId());
            query.setInt(21, record.getId());
            query.executeUpdate();
        } catch (SQLException ex) {
            ok = false;
            System.err.println("SQLException updateParticipant: " + ex.getMessage());
        }
        return ok;
    }
    
   public String findSSN(int id){
         String ssnStr = new String();
        try {
            rs = null;
            query = con.prepareStatement("select ssn from PARTICIPANT where participantId = ?");
            query.setInt(1, id);
            rs = query.executeQuery();
            if (rs.first()) {
                ssnStr = rs.getString(1);
            }
        } catch (Exception ex) {
            System.err.println("SQLException findSSn" + ex.getMessage());
        }
        return ssnStr;
    } 
    
    public boolean deleteParticipant(int id,String ssn){       
         boolean ok = true;
         isWinner = false;
        WinnerDB winnerdb = new WinnerDB();
        boolean exist = winnerdb.isSsnId(ssn);
        if (exist == true) {
            ok = false;
            isWinner = true;
        } else {
        try {
            query = con.prepareStatement(
                    "delete from PARTICIPANT where participantId = ?");
            query.setInt(1, id);
            query.executeUpdate();
             } catch (SQLException ex) {
            ok = false;
            System.err.println("SQLException deleteParticipant: " + ex.getMessage());
        }
        }
        return ok;       
    }
    
    public boolean isSsnInWinner(){
        return isWinner;
    }
    
       public boolean isRaceId(int id) {
        boolean exist = false;
        try {
            rs = null;
            query = con.prepareStatement("select * from Participant where raceId = ?");
            query.setInt(1, id);           
            rs = query.executeQuery();
            if (rs.first()) {
                exist = true;                               
            }
        } catch (Exception ex) {
          //  System.err.println("SQLException isWinnerExist" + ex.getMessage());
        } 
        return exist;
    }
  
}

Class: Registration.java

/*
 Class: Registration
 Author: Shahrzad Jahangirian
 Date: March 24, 2014
 Update Date: May 2, 2014
 Description: A problem domain class for processing Registration
 */
package PDpkg;
import java.util.*;
import java.text.*;
import PDpkg.Participant;
import DBpkg.ParticipantDB;

public class Registration{

private ParticipantDB participantDb = new ParticipantDB();
 private int[] birthDate2 = new int[3];

public Registration(){

}
  
  public boolean isParticipantEmpty(){
      return participantDb.isParticipantEmpty();
  }

public boolean validateDate(String bDate, String today) {
    boolean valid = true;
    try {
      String[] result = bDate.split("\\/");
      birthDate2[0] = Integer.parseInt(result[2]);
      birthDate2[1] = Integer.parseInt(result[1]);
      birthDate2[2] = Integer.parseInt(result[0]);
      if (bDate.equals(today) == true) {
        valid = false;
      }
    }
    catch (Exception ex) {
      valid = false;
    }
    return valid;
  }

public int getBirthYear(){
    return birthDate2[0];
  }

public boolean isInteger(String str) {
    boolean valid = false;
    try {
      Integer.parseInt(str);
      valid = true;
    }
    catch (Exception e) {
      valid = false;
    }
    return valid;
  }
  
  public Participant validateSSN(String ssnId){
      Participant person = new Participant();
      boolean duplicateSSN = false;
      duplicateSSN = participantDb.isSsnDuplicate(ssnId);
      if (duplicateSSN == true){    
          person = participantDb.getRecord();
      }
      return person;
  }

public boolean registerParticipant(Participant person){
    boolean ok = false;
    person.setId(participantDb.getNextId());
    ok = participantDb.saveParticipant(person);
    return ok;
  }
  
  public boolean updateParticipant(Participant person){
    boolean ok = false;    
    ok = participantDb.updateParticipant(person);
    return ok;
  }
  
  public boolean deleteParticipant(int participantId, String ssn){
    boolean ok = false;    
    ok = participantDb.deleteParticipant(participantId,ssn);
    return ok;
  }  
  
  public boolean isSsnInWinner(){
      return participantDb.isSsnInWinner();
  }
}

Class: Race.java

/*
 Class: Race
 Author: Shahrzad Jahangirian
 Date: May 2, 2014
 Description: A problem domain class for processing Races
 */
package PDpkg;
import java.util.*;
import java.text.*;
import PDpkg.RaceInfo;
import DBpkg.RaceDB;

public class Race{

private RaceDB raceDb = new RaceDB();
 private String[] raceIds;

public Race(){

}
  
  public boolean isRaceEmpty(){
      return raceDb.isRaceEmpty();
  }
  
  public String[] getAllRacesIds(){
      raceDb = new RaceDB();
      ArrayList raceLst = new ArrayList();
      raceLst = raceDb.getAllRaces();
      raceIds = new String[raceLst.size()];
      for(int i=0; i< raceLst.size(); i++){
          raceIds[i]=new String(String.valueOf(((RaceInfo)raceLst.get(i)).getRaceId()));
      }
      return raceIds;
  }
  
  public RaceInfo validateRaceId(int raceId){
      RaceInfo raceRecord = new RaceInfo();
      boolean duplicateRaceId = false;
      duplicateRaceId = raceDb.isRaceIdDuplicate(raceId);
      if (duplicateRaceId == true){    
          raceRecord = raceDb.getRecord();
      } 
      return raceRecord;
  }

public boolean addRace(RaceInfo raceRecord){
    boolean ok = false;   
    ok = raceDb.saveRace(raceRecord);
    return ok;
  }
  
  public boolean updateRace(RaceInfo raceRecord){
    boolean ok = false;    
    ok = raceDb.updateRace(raceRecord);
    return ok;
  }
  
  public boolean deleteRace(int raceId){
    boolean ok = false;    
    ok = raceDb.deleteRace(raceId);
    return ok;
  }
  
   public boolean isRaceInWinner(){
      return raceDb.isRaceInWinner();
  }

}

Class: Winner.java

/*
 Class: Winner
 Author: Shahrzad Jahangirian
 Date: June 21, 2014
 Description: A problem domain class for processing Bolder Race Winners
 */
package PDpkg;
import java.util.*;
import java.text.*;
import PDpkg.WinnerInfo;
import DBpkg.ParticipantDB;
import DBpkg.RaceDB;
import DBpkg.WinnerDB;

public class Winner{

private WinnerDB winnerDb = new WinnerDB();
 private RaceDB racedb = new RaceDB();
 private ParticipantDB playerdb = new ParticipantDB();

public Winner(){

}
  
    public WinnerInfo isDuplicateEntry(int raceId, String ssn){
      WinnerInfo winnerRecord = new WinnerInfo();
      boolean duplicate = false;
      duplicate = winnerDb.isWinnerDuplicate(raceId,ssn);
      if (duplicate == true){    
          winnerRecord = winnerDb.getRecord();
      } 
      return winnerRecord;
  }

public boolean isRaceId(int raceId){  
      return racedb.isRaceIdExist(raceId);
  }
  
  public boolean isParticipantSSN(String ssnId){  
      return playerdb.isSsnExist(ssnId);
  }

public boolean addWinner(WinnerInfo winnerRecord){
    boolean ok = false;   
    ok = winnerDb.saveWinner(winnerRecord);
    return ok;
  }
  
  public boolean updateWinner(WinnerInfo winnerRecord){
    boolean ok = false;    
    ok = winnerDb.updateWinner(winnerRecord);
    return ok;
  }
  
  public boolean deleteWinner(int raceId, String ssn){
    boolean ok = false;    
    ok = winnerDb.deleteWinner(raceId, ssn);
    return ok;
  }  
  
    public boolean isWinnerEmpty(){
      return winnerDb.isWinnerEmpty();
  }
}

Class: RaceReport.java

/*
 Class: RaceReport
 Author: Shahrzad Jahangirian
 Date: September 24, 2014
 Description: This class will create a Race Report that display all races that have been 
 * entered into the System. 
 * I used DynamicReports - Free Java reporting library for creating reports dynamically
 */
package Reportpkg;

import static net.sf.dynamicreports.report.builder.DynamicReports.*;
import java.awt.Color;
import java.math.BigDecimal;
import net.sf.dynamicreports.report.builder.style.StyleBuilder;
import net.sf.dynamicreports.report.constant.HorizontalAlignment;
import net.sf.dynamicreports.report.constant.VerticalAlignment;
import net.sf.dynamicreports.report.datasource.DRDataSource;
import net.sf.dynamicreports.report.exception.DRException;
import net.sf.jasperreports.engine.JRDataSource;
import net.sf.dynamicreports.jasper.builder.JasperReportBuilder;
import net.sf.dynamicreports.report.builder.DynamicReports;
import net.sf.dynamicreports.report.builder.column.Columns;
import net.sf.dynamicreports.report.builder.component.Components;
import net.sf.dynamicreports.report.builder.datatype.DataTypes;
import net.sf.dynamicreports.report.datasource.DRDataSource;
import net.sf.dynamicreports.report.exception.DRException;
import net.sf.jasperreports.engine.JRDataSource;
import java.util.*;
import java.text.*;
import DBpkg.RaceDB;
import PDpkg.RaceInfo;

public class RaceReport {

private RaceDB raceDb = new RaceDB();
    private ArrayList<RaceInfo> raceLst = new ArrayList<RaceInfo>();
    private RaceInfo raceinfo = new RaceInfo();

public RaceReport() {
        raceLst = raceDb.getAllRaces();
        build();
    }

private JRDataSource createDataSource() {
        DRDataSource dataSource = new DRDataSource("raceId", "raceDate", "raceTime", "raceName");
        for (int i = 0; i < raceLst.size(); i++) {
            raceinfo = new RaceInfo();
            raceinfo = (RaceInfo) raceLst.get(i);
            dataSource.add(raceinfo.getRaceId(), raceinfo.getRaceDate(), raceinfo.getRaceTime(), raceinfo.getRaceName());
        }
        return dataSource;  
    } 
}

Class: ParticipantReport.java

/*
 Class: ParticipantReport
 Author: Shahrzad Jahangirian
 Date: September 30, 2014
 Description: This class will create Participant Report and displays all Participant that have been 
 * entered into the System. 
 * I used DynamicReports - Free Java reporting library for creating reports dynamically
 */
package Reportpkg;

import static net.sf.dynamicreports.report.builder.DynamicReports.*;
import java.awt.Color;
import java.math.BigDecimal;
import net.sf.dynamicreports.report.builder.style.StyleBuilder;
import net.sf.dynamicreports.report.constant.HorizontalAlignment;
import net.sf.dynamicreports.report.constant.VerticalAlignment;
import net.sf.dynamicreports.report.datasource.DRDataSource;
import net.sf.dynamicreports.report.exception.DRException;
import net.sf.jasperreports.engine.JRDataSource;
import net.sf.dynamicreports.jasper.builder.JasperReportBuilder;
import net.sf.dynamicreports.report.builder.DynamicReports;
import net.sf.dynamicreports.report.builder.column.Columns;
import net.sf.dynamicreports.report.builder.component.Components;
import net.sf.dynamicreports.report.constant.PageOrientation;
import net.sf.dynamicreports.report.constant.PageType;
import net.sf.dynamicreports.report.builder.datatype.DataTypes;
import net.sf.dynamicreports.report.datasource.DRDataSource;
import net.sf.dynamicreports.report.exception.DRException;
import net.sf.jasperreports.engine.JRDataSource;
import java.util.*;
import java.text.*;
import DBpkg.ParticipantDB;
import PDpkg.Participant;

public class ParticipantReport{
       
    private ParticipantDB parDb = new ParticipantDB();
    private ArrayList<Participant> parLst = new ArrayList<Participant>();
    private Participant par = new Participant();

public ParticipantReport(){
        parLst = parDb.getAllParticipant();
        build();
    }

private void build() {
        StyleBuilder boldStyle = stl.style().bold();
        StyleBuilder boldCenteredStyle = stl.style(boldStyle).setHorizontalAlignment(HorizontalAlignment.CENTER);
        StyleBuilder columnTitleStyle = stl.style(boldCenteredStyle)
                .setBorder(stl.pen1Point())                
                .setBackgroundColor(Color.LIGHT_GRAY);
        StyleBuilder plainStyle = stl.style().setAlignment(HorizontalAlignment.CENTER,VerticalAlignment.TOP);
      //  StyleBuilder plainCenteredStyle = stl.style(plainStyle).setHorizontalAlignment(HorizontalAlignment.CENTER);
        //StyleBuilder columnStyle = stl.style(plainCenteredStyle);
        try {
            JasperReportBuilder report = DynamicReports.report();
            report.setColumnTitleStyle(columnTitleStyle);
            report.setColumnStyle(plainStyle);
            report.setPageFormat(PageType.A3, PageOrientation.LANDSCAPE);
            report.highlightDetailEvenRows();
            report.addColumn(Columns.column("SSN", "ssn", DataTypes.stringType()));
            report.addColumn(Columns.column("Name", "name", DataTypes.stringType()));
            report.addColumn(Columns.column("Surname", "surname", DataTypes.stringType()));
            report.addColumn(Columns.column("Age", "age", DataTypes.integerType()));
            report.addColumn(Columns.column("Gender", "gender", DataTypes.stringType()));
            report.addColumn(Columns.column("Race ID", "raceId", DataTypes.integerType()));
            report.addColumn(Columns.column("Race Type", "raceType", DataTypes.stringType()));
            report.addColumn(Columns.column("Mobile", "mobile", DataTypes.stringType()));
            report.addColumn(Columns.column("Phone", "phone", DataTypes.stringType()));
            report.addColumn(Columns.column("Email", "email", DataTypes.stringType()));           
            report.addTitle(Components.text("Bolder Boulder Race Participants Report").setStyle(boldCenteredStyle));
            report.addPageFooter(Components.pageXofY().setStyle(boldCenteredStyle));
            report.setDataSource(createDataSource());
            report.show(false);
        } catch (DRException e) {
            e.printStackTrace();
        }
    }

private JRDataSource createDataSource() {
        DRDataSource dataSource = new DRDataSource("ssn", "name", "surname", "age","gender","raceId","raceType",
                "mobile","phone","email");
        for (int i = 0; i < parLst.size(); i++) {
            par = new Participant();
            par = (Participant) parLst.get(i);
            dataSource.add(par.getSsn(),par.getName(),par.getSurname(),par.getAge(),par.getGender(),par.getRaceId(),
                    par.getRaceType(),par.getMobile(),par.getPhone(),par.getEmail());
        }
        return dataSource;  
    } 
  
}

Class: ContactReport.java

/*
 Class: ContactReport
 Author: Shahrzad Jahangirian
 Date: October 7, 2014
 Description: This class will create a Contact Report and displays all Participant Contact details that have been 
 * entered into the System. 
 * I used DynamicReports - Free Java reporting library for creating this report dynamically
 */
package Reportpkg;

import static net.sf.dynamicreports.report.builder.DynamicReports.*;
import java.awt.Color;
import java.math.BigDecimal;
import net.sf.dynamicreports.report.builder.style.StyleBuilder;
import net.sf.dynamicreports.report.constant.HorizontalAlignment;
import net.sf.dynamicreports.report.constant.VerticalAlignment;
import net.sf.dynamicreports.report.datasource.DRDataSource;
import net.sf.dynamicreports.report.exception.DRException;
import net.sf.jasperreports.engine.JRDataSource;
import net.sf.dynamicreports.jasper.builder.JasperReportBuilder;
import net.sf.dynamicreports.report.builder.DynamicReports;
import net.sf.dynamicreports.report.builder.column.Columns;
import net.sf.dynamicreports.report.builder.component.Components;
import net.sf.dynamicreports.report.constant.PageOrientation;
import net.sf.dynamicreports.report.constant.PageType;
import net.sf.dynamicreports.report.builder.datatype.DataTypes;
import net.sf.dynamicreports.report.datasource.DRDataSource;
import net.sf.dynamicreports.report.exception.DRException;
import net.sf.jasperreports.engine.JRDataSource;
import java.util.*;
import java.text.*;
import DBpkg.ParticipantDB;
import PDpkg.Participant;

public class ContactReport{
       
    private ParticipantDB parDb = new ParticipantDB();
    private ArrayList<Participant> parLst = new ArrayList<Participant>();
    private Participant par = new Participant();

public ContactReport(){
        parLst = parDb.getAllParticipant();
        build();
    }

private void build() {
        StyleBuilder boldStyle = stl.style().bold();
        StyleBuilder boldCenteredStyle = stl.style(boldStyle).setHorizontalAlignment(HorizontalAlignment.CENTER);
        StyleBuilder columnTitleStyle = stl.style(boldCenteredStyle)
                .setBorder(stl.pen1Point())                
                .setBackgroundColor(Color.LIGHT_GRAY);
        StyleBuilder plainStyle = stl.style().setAlignment(HorizontalAlignment.CENTER,VerticalAlignment.TOP);
      //  StyleBuilder plainCenteredStyle = stl.style(plainStyle).setHorizontalAlignment(HorizontalAlignment.CENTER);
        //StyleBuilder columnStyle = stl.style(plainCenteredStyle);
        try {
            JasperReportBuilder report = DynamicReports.report();
            report.setColumnTitleStyle(columnTitleStyle);
            report.setColumnStyle(plainStyle);
            report.setPageFormat(PageType.A3, PageOrientation.LANDSCAPE);
            report.highlightDetailEvenRows();
            report.addColumn(Columns.column("SSN", "ssn", DataTypes.stringType()));
            report.addColumn(Columns.column("Name", "name", DataTypes.stringType()));
            report.addColumn(Columns.column("Surname", "surname", DataTypes.stringType()));
            report.addColumn(Columns.column("Address 1", "address1", DataTypes.stringType()));
            report.addColumn(Columns.column("Address2", "address2", DataTypes.stringType()));
            report.addColumn(Columns.column("City", "city", DataTypes.stringType()));
            report.addColumn(Columns.column("State", "state", DataTypes.stringType()));
            report.addColumn(Columns.column("Zip Code", "zip", DataTypes.stringType()));
            report.addColumn(Columns.column("Country", "country", DataTypes.stringType()));
            report.addColumn(Columns.column("Mobile", "mobile", DataTypes.stringType()));
            report.addColumn(Columns.column("Phone", "phone", DataTypes.stringType()));
            report.addColumn(Columns.column("Emergency Phone", "emergPhone", DataTypes.stringType()));
            report.addColumn(Columns.column("Email", "email", DataTypes.stringType()));           
            report.addTitle(Components.text("Bolder Boulder Race Participants Contact Report").setStyle(boldCenteredStyle));
            report.addPageFooter(Components.pageXofY().setStyle(boldCenteredStyle));
            report.setDataSource(createDataSource());
            report.show(false);
        } catch (DRException e) {
            e.printStackTrace();
        }
    }

private JRDataSource createDataSource() {
        DRDataSource dataSource = new DRDataSource("ssn", "name", "surname", "address1","address2","city","state",
                "zip","country","mobile","phone","emergPhone","email");
        for (int i = 0; i < parLst.size(); i++) {
            par = new Participant();
            par = (Participant) parLst.get(i);
            dataSource.add(par.getSsn(),par.getName(),par.getSurname(),par.getAddress1(),par.getAddress2(),par.getCity(),
                    par.getState(),par.getZip(),par.getCountry(),par.getMobile(),par.getPhone(),par.getEmergPhone(),par.getEmail());
        }
        return dataSource;  
    } 
  
}

Class: ReportSelector.java (not used)

Class: FormatUI.java

/*
 Class: FormatUI
 Author: Shahrzad Jahangirian
 Update Date: March 15, 2014
 Description: A helper class that has been used to format different
 Swing components.
 */
package commonPKG;

import javax.swing.*;
import java.awt.*;
import java.awt.*;
import javax.swing.*;
import java.lang.Exception;
import java.lang.*;
import javax.swing.border.EmptyBorder;

public class FormatUI {

public FormatUI() {

}

public JPanel createStatusBar(JPanel statusBar, int Bred, int Bgreen, int Bblue,int width,int height){
        statusBar.setLayout(new BorderLayout());
        statusBar.setBorder(javax.swing.BorderFactory.createEtchedBorder());
        statusBar.setBackground(new Color(Bred, Bgreen, Bblue));
        statusBar.setPreferredSize(new Dimension(width,height));
        return statusBar;
  }
  
  public JPanel createBodyPanel(JPanel bodyPanel, int Bred, int Bgreen, int Bblue,int width,int height){
        bodyPanel.setLayout(null);
        bodyPanel.setBorder(javax.swing.BorderFactory.createEtchedBorder());
        bodyPanel.setBackground(new Color(Bred, Bgreen, Bblue));
        bodyPanel.setPreferredSize(new Dimension(width,height));
        return bodyPanel;
  }

public JMenuBar formatJMenuBar(JMenuBar aMenuBar, int x, int y, int width,
                                 int height, int Bred, int Bgreen, int Bblue,
                                 int Fred, int Fgreen, int Fblue,
                                 String fontFace,
                                 int fontStyle, int fontSize) {
    aMenuBar.setBounds(new Rectangle(x, y, width, height));
    aMenuBar.setBackground(new Color(Bred, Bgreen, Bblue));
    aMenuBar.setForeground(new Color(Fred, Fgreen, Fblue));
    aMenuBar.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aMenuBar.setAlignmentX( (float) 0.0);
    aMenuBar.setAlignmentY( (float) 0.0);
    aMenuBar.setOpaque(true);
    return aMenuBar;

}

public JMenu formatJMenu(JMenu aMenu, int Bred, int Bgreen, int Bblue,
                           int Fred, int Fgreen, int Fblue, String fontFace,
                           int fontStyle, int fontSize) {
    aMenu.setBackground(new Color(Bred, Bgreen, Bblue));
    aMenu.setForeground(new Color(Fred, Fgreen, Fblue));
    aMenu.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aMenu.setOpaque(true);
    return aMenu;

}

public JMenuItem formatJMenuItem(JMenuItem aMenuItem, int Bred, int Bgreen,
                                   int Bblue,
                                   int Fred, int Fgreen, int Fblue,
                                   String fontFace,
                                   int fontStyle, int fontSize) {
    aMenuItem.setBackground(new Color(Bred, Bgreen, Bblue));
    aMenuItem.setForeground(new Color(Fred, Fgreen, Fblue));
    aMenuItem.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aMenuItem.setOpaque(true);
    return aMenuItem;

}

public JToolBar formatJToolBar(JToolBar aToolBar, int Bred, int Bgreen,
                                 int Bblue) {
    aToolBar.setBackground(new Color(Bred, Bgreen, Bblue));
    aToolBar.setRollover(true);
    aToolBar.setOpaque(true);
    return aToolBar;

}

public void centerFrame(JFrame anObject) {
    Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
    int screenWidth = screenSize.width;
    int screenHeight = screenSize.height;
    Dimension frameSize = anObject.getSize();
    int x = (screenWidth - frameSize.width) / 2;
    int y = (screenHeight - frameSize.height) / 2;
    anObject.setLocation(x, y);
  }

/* A method to return a formatted JLabel
   formatLabel(variable name,text,x-cordinate,y-cordinate,
     width,height,background Red RGB color,background Green RGB color,
   background Blue RGB color, foreground Red RGB color, foreground Green RGB color,
   foreground Blue RGB color, font face string,
   font style number(PLAIN, BOLD, ITALIC, or BOLD+ITALIC), font size.
   */
  public JLabel formatLabel(JLabel aLabel, String txt, int x, int y, int width,
                            int height, int Bred, int Bgreen, int Bblue,
                            int Fred, int Fgreen, int Fblue, String fontFace,
                            int fontStyle, int fontSize, int vert, int horz) {
    aLabel.setOpaque(true);
    aLabel.setText(txt);
    aLabel.setBounds(new Rectangle(x, y, width, height));
    aLabel.setBackground(new Color(Bred, Bgreen, Bblue));
    aLabel.setForeground(new Color(Fred, Fgreen, Fblue));
    aLabel.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aLabel.setVerticalAlignment(vert);
    aLabel.setHorizontalAlignment(horz);

return aLabel;
  }

public JLabel formatLabel(JLabel aLabel, int x, int y, int width,
                            int height, int Bred, int Bgreen, int Bblue,
                            int Fred, int Fgreen, int Fblue, String fontFace,
                            int fontStyle, int fontSize, int vert, int horz) {
    aLabel.setOpaque(true);
    aLabel.setBounds(new Rectangle(x, y, width, height));
    aLabel.setBackground(new Color(Bred, Bgreen, Bblue));
    aLabel.setForeground(new Color(Fred, Fgreen, Fblue));
    aLabel.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aLabel.setVerticalAlignment(vert);
    aLabel.setHorizontalAlignment(horz);

return aLabel;
  }
  
  public JLabel formatIconLabel(JLabel aLabel, int x, int y, int width,
                            int height, int Bred, int Bgreen, int Bblue,
                            int Fred, int Fgreen, int Fblue, String fontFace,
                            int fontStyle, int fontSize, int vert, int horz) {
        
    aLabel.setOpaque(true);    
    aLabel.setBounds(new Rectangle(x, y, width, height));
    aLabel.setBackground(new Color(Bred, Bgreen, Bblue));
    aLabel.setForeground(new Color(Fred, Fgreen, Fblue));
    aLabel.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aLabel.setVerticalTextPosition(vert);
    aLabel.setHorizontalTextPosition(horz);

return aLabel;
  }

public JRadioButton formatRadioButton(JRadioButton aRadioButton, String txt,
                                        int x, int y, int width,
                                        int height, int Bred, int Bgreen,
                                        int Bblue,
                                        int Fred, int Fgreen, int Fblue,
                                        String fontFace,
                                        int fontStyle, int fontSize) {
    aRadioButton.setOpaque(true);
    aRadioButton.setText(txt);
    aRadioButton.setBounds(new Rectangle(x, y, width, height));
    aRadioButton.setBackground(new Color(Bred, Bgreen, Bblue));
    aRadioButton.setForeground(new Color(Fred, Fgreen, Fblue));
    aRadioButton.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    return aRadioButton;
  }

public JTextField formatTextField(JTextField aTextField, String txt, int x, int y,
                                  int width, int height, int Bred, int Bgreen,
                                  int Bblue, int Fred, int Fgreen,
                                  int Fblue, String fontFace, int fontStyle,
                                  int fontSize, int border
                                  ) {
    aTextField.setEditable(true);
    aTextField.setBounds(new Rectangle(x, y, width, height));
    aTextField.setBackground(new Color(Bred, Bgreen, Bblue));
    aTextField.setForeground(new Color(Fred, Fgreen, Fblue));
    aTextField.setText(txt);
    aTextField.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    switch (border) {
      case 0:
        aTextField.setBorder(BorderFactory.createLoweredBevelBorder());
        break;
      case 1:
        aTextField.setBorder(BorderFactory.createEmptyBorder());
        break;
      case 2:
        aTextField.setBorder(BorderFactory.createEtchedBorder());
        break;
      case 4:
        aTextField.setBorder(BorderFactory.createRaisedBevelBorder());
        break;
    }
    return aTextField;
  }

public JPasswordField formatPasswordField(JPasswordField aPasswordField,
                                            String txt, int x,
                                            int y, int width, int height,
                                            int Bred,
                                            int Bgreen,
                                            int Bblue, int Fred, int Fgreen,
                                            int Fblue,
                                            String fontFace, int fontStyle,
                                            int fontSize
                                            ) {
    aPasswordField.setBorder(BorderFactory.createCompoundBorder());
    aPasswordField.setOpaque(true);
    aPasswordField.setText(txt);
    aPasswordField.setBounds(new Rectangle(x, y, width, height));
    aPasswordField.setBackground(new Color(Bred, Bgreen, Bblue));
    aPasswordField.setForeground(new Color(Fred, Fgreen, Fblue));
    aPasswordField.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    return aPasswordField;
  }

public JFormattedTextField formatFormattedTextField(JFormattedTextField
      aFormattedTextField, int x, int y, int width, int height, String option,
      int Bred, int Bgreen,
      int Bblue, int Fred, int Fgreen, int Fblue, String fontFace,
      int fontStyle, int fontSize,int border
      ) throws
      Exception {
    aFormattedTextField.setOpaque(true);
    aFormattedTextField.setBounds(new Rectangle(x, y, width, height));
    aFormattedTextField.setBackground(new Color(Bred, Bgreen, Bblue));
    aFormattedTextField.setForeground(new Color(Fred, Fgreen, Fblue));
    aFormattedTextField.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    switch (border) {
      case 0:
        aFormattedTextField.setBorder(BorderFactory.createLoweredBevelBorder());
        break;
      case 1:
        aFormattedTextField.setBorder(BorderFactory.createEmptyBorder());
        break;
      case 2:
        aFormattedTextField.setBorder(BorderFactory.createEtchedBorder());
        break;
      case 4:
        aFormattedTextField.setBorder(BorderFactory.createRaisedBevelBorder());
        break;
    }

return aFormattedTextField;
  }

public JComboBox formatComboBox(JComboBox aComboBox, int x, int y, int width,
                                  int height, boolean editable,
                                  boolean selected,
                                  int index, int Bred, int Bgreen,
                                  int Bblue, int Fred, int Fgreen, int Fblue,
                                  String fontFace,
                                  int fontStyle, int fontSize,int border
                                  ) {
    aComboBox.setBounds(new Rectangle(x, y, width, height));
    aComboBox.setOpaque(true);
    aComboBox.setBackground(new Color(Bred, Bgreen, Bblue));
    aComboBox.setForeground(new Color(Fred, Fgreen, Fblue));
    aComboBox.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aComboBox.setEditable(editable);
    if (selected == true) {
      aComboBox.setSelectedIndex(index);
    }
    switch (border) {
      case 0:
        aComboBox.setBorder(BorderFactory.createLoweredBevelBorder());
        break;
      case 1:
        aComboBox.setBorder(BorderFactory.createEmptyBorder());
        break;
      case 2:
        aComboBox.setBorder(BorderFactory.createEtchedBorder());
        break;
      case 4:
        aComboBox.setBorder(BorderFactory.createRaisedBevelBorder());
        break;
    }

return aComboBox;
  }

public JScrollPane formatScrollPane(JScrollPane aScrollpane, int x, int y,
                                      int width,
                                      int height, int Bred, int Bgreen,
                                      int Bblue, int Fred, int Fgreen,
                                      int Fblue, String fontFace,
                                      int fontStyle, int fontSize
                                      ) {
    aScrollpane.setBorder(BorderFactory.createLoweredBevelBorder());
    aScrollpane.setBounds(new Rectangle(x, y, width, height));
    aScrollpane.setBackground(new Color(Bred, Bgreen, Bblue));
    aScrollpane.setForeground(new Color(Fred, Fgreen, Fblue));
    aScrollpane.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aScrollpane.setOpaque(true);

return aScrollpane;
  }

public JTable formatTable(JTable aTable, int x, int y,
                            int width,
                            int height, int Bred, int Bgreen,
                            int Bblue, int Fred, int Fgreen,
                            int Fblue, String fontFace,
                            int fontStyle, int fontSize
                            ) {
    aTable.setBorder(BorderFactory.createLoweredBevelBorder());
    aTable.setBounds(new Rectangle(x, y, width, height));
    aTable.setBackground(new Color(Bred, Bgreen, Bblue));
    aTable.setForeground(new Color(Fred, Fgreen, Fblue));
    aTable.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aTable.setOpaque(true);

return aTable;
  }

public JTextArea formatTextArea(JTextArea aTextArea, String txt, int x, int y,
                                  int width, int height, int Bred, int Bgreen,
                                  int Bblue, int Fred, int Fgreen,
                                  int Fblue, String fontFace, int fontStyle,
                                  int fontSize, int border
                                  ) {
    aTextArea.setLineWrap(true);
    aTextArea.setWrapStyleWord(true);
    aTextArea.setEditable(true);
    aTextArea.setBounds(new Rectangle(x, y, width, height));
    aTextArea.setBackground(new Color(Bred, Bgreen, Bblue));
    aTextArea.setForeground(new Color(Fred, Fgreen, Fblue));
    aTextArea.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    switch (border) {
      case 0:
        aTextArea.setBorder(BorderFactory.createLoweredBevelBorder());
        break;
      case 1:
        aTextArea.setBorder(BorderFactory.createEmptyBorder());
        break;
      case 2:
        aTextArea.setBorder(BorderFactory.createEtchedBorder());
        break;
      case 4:
        aTextArea.setBorder(BorderFactory.createRaisedBevelBorder());
        break;
    }
    return aTextArea;
  }

public TextArea formatTextArea(TextArea aTextArea, String txt, int x, int y,
                                 int width, int height, int Bred, int Bgreen,
                                 int Bblue, int Fred, int Fgreen,
                                 int Fblue, String fontFace, int fontStyle,
                                 int fontSize
                                 ) {
    aTextArea.setEditable(true);
    aTextArea.setBounds(new Rectangle(x, y, width, height));
    aTextArea.setBackground(new Color(Bred, Bgreen, Bblue));
    aTextArea.setForeground(new Color(Fred, Fgreen, Fblue));
    aTextArea.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    return aTextArea;
  }

public JTextPane formatTextPane(JTextPane aTextPane, String txt, int x, int y,
                                  int width, int height, int Bred, int Bgreen,
                                  int Bblue, int Fred, int Fgreen,
                                  int Fblue, String fontFace, int fontStyle,
                                  int fontSize, int border
                                  ) {
    aTextPane.setEditable(true);
    aTextPane.setBounds(new Rectangle(x, y, width, height));
    aTextPane.setBackground(new Color(Bred, Bgreen, Bblue));
    aTextPane.setForeground(new Color(Fred, Fgreen, Fblue));
    aTextPane.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    switch (border) {
      case 0:
        aTextPane.setBorder(BorderFactory.createLoweredBevelBorder());
        break;
      case 1:
        aTextPane.setBorder(BorderFactory.createEmptyBorder());
        break;
      case 2:
        aTextPane.setBorder(BorderFactory.createEtchedBorder());
        break;
      case 4:
        aTextPane.setBorder(BorderFactory.createRaisedBevelBorder());
        break;
    }
    return aTextPane;
  }

public JButton formatJToolBarButton(JButton aButton, String iconPath, int x,
                                      int y, int width, int height, int margin1,
                                      int margin2, int margin3, int margin4,
                                      int Bred, int Bgreen, int Bblue,
                                      boolean focus, boolean opaque,
                                      String tooltext) {

aButton = new JButton(new ImageIcon(iconPath));
    aButton.setOpaque(opaque);
    aButton.setBorder(new EmptyBorder(x, y, width, height));
    aButton.setMargin(new Insets(margin1, margin2, margin3, margin4));
    aButton.setRequestFocusEnabled(focus);
    aButton.setBackground(new Color(Bred, Bgreen, Bblue));
    aButton.setToolTipText(tooltext);
    return aButton;
  }

public JButton formatButton(JButton aButton, String txt, int x, int y,
                              int width,
                              int height, int Bred, int Bgreen,
                              int Bblue, int Fred, int Fgreen, int Fblue,
                              String fontFace,
                              int fontStyle, int fontSize
                              ) {
    aButton.setOpaque(true);
    aButton.setText(txt);
    aButton.setBounds(new Rectangle(x, y, width, height));
    aButton.setBackground(new Color(Bred, Bgreen, Bblue));
    aButton.setForeground(new Color(Fred, Fgreen, Fblue));
    aButton.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));

return aButton;
  }

public JButton formatButton(JButton aButton, String txt, int x, int y,
                              int width,
                              int height, int Fred, int Fgreen, int Fblue,
                              String fontFace,
                              int fontStyle, int fontSize
                              ) {
    aButton.setOpaque(true);
    aButton.setText(txt);
    aButton.setBounds(new Rectangle(x, y, width, height));
    aButton.setForeground(new Color(Fred, Fgreen, Fblue));
    aButton.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));

return aButton;
  }

public JCheckBox formatCheckBox(JCheckBox aButton, String txt, int x, int y,
                                  int width,
                                  int height, int Bred, int Bgreen,
                                  int Bblue, int Fred, int Fgreen, int Fblue,
                                  String fontFace,
                                  int fontStyle, int fontSize
                                  ) {
    aButton.setOpaque(true);
    aButton.setText(txt);
    aButton.setBounds(new Rectangle(x, y, width, height));
    aButton.setBackground(new Color(Bred, Bgreen, Bblue));
    aButton.setForeground(new Color(Fred, Fgreen, Fblue));
    aButton.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));

return aButton;
  }

public JPanel formatPanel(JPanel aPanel, int border, Color lineColor,
                            int lineThick,
                            String borderTitle, int x, int y, int width,
                            int height, int Bred, int Bgreen, int Bblue,
                            int Fred, int Fgreen, int Fblue, String fontFace,
                            int fontStyle, int fontSize) {
    aPanel.setOpaque(true);
    aPanel.setBounds(new Rectangle(x, y, width, height));
    aPanel.setBackground(new Color(Bred, Bgreen, Bblue));
    aPanel.setForeground(new Color(Fred, Fgreen, Fblue));
    aPanel.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    switch (border) {
      case 0:
        aPanel.setBorder(BorderFactory.createLoweredBevelBorder());
        break;
      case 1:
        aPanel.setBorder(BorderFactory.createEmptyBorder());
        break;
      case 2:
        aPanel.setBorder(BorderFactory.createEtchedBorder());
        break;
      case 3:
        aPanel.setBorder(BorderFactory.createLineBorder(lineColor, lineThick));
        break;
      case 4:
        aPanel.setBorder(BorderFactory.createRaisedBevelBorder());
        break;
      case 5:
        aPanel.setBorder(BorderFactory.createTitledBorder(borderTitle));
        break;
    }
    return aPanel;
  }

public JPanel formatPanel(JPanel aPanel, int border, int x, int y, int width,
                            int height, int Bred, int Bgreen, int Bblue,
                            int Fred, int Fgreen, int Fblue, String fontFace,
                            int fontStyle, int fontSize) {
    aPanel.setOpaque(true);
    aPanel.setBounds(new Rectangle(x, y, width, height));
    aPanel.setBackground(new Color(Bred, Bgreen, Bblue));
    aPanel.setForeground(new Color(Fred, Fgreen, Fblue));
    aPanel.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    switch (border) {
      case 0:
        aPanel.setBorder(BorderFactory.createLoweredBevelBorder());
        break;
      case 1:
        aPanel.setBorder(BorderFactory.createEmptyBorder());
        break;
      case 2:
        aPanel.setBorder(BorderFactory.createEtchedBorder());
        break;
      case 4:
        aPanel.setBorder(BorderFactory.createRaisedBevelBorder());
        break;
    }
    return aPanel;
  }

public JPanel formatPanel(JPanel aPanel, int Bred, int Bgreen, int Bblue,
                            int Fred, int Fgreen, int Fblue, String fontFace,
                            int fontStyle, int fontSize) {
    aPanel.setOpaque(true);
    aPanel.setBackground(new Color(Bred, Bgreen, Bblue));
    aPanel.setForeground(new Color(Fred, Fgreen, Fblue));
    aPanel.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    return aPanel;
  }

}

Class: RaceUI.java

/*
 Class: RaceUI
 Author: Shahrzad Jahangirian
 Date: May 2, 2014
 Description: A data entry screen for add, update, and delete a Race in 
 * annual Bolder Boulder Races.
 */
package GUIpkg;

import javax.swing.*;
import java.awt.*;
import java.awt.*;
import java.awt.Color;
import java.awt.event.*;
import java.util.*;
import java.text.*;

import commonPKG.FormatUI;
import commonPKG.CustomDateTime;
import commonPKG.CustomMath;
import PDpkg.Race;
import PDpkg.RaceInfo;

public class RaceUI
        extends JFrame {

private JPanel bodyPanel = new JPanel();
    private JPanel statusBarPanel = new JPanel();
    private JLabel statusBarLabel = new JLabel();
    private JLabel raceIdLabel = new JLabel();
    private JLabel raceNameLabel = new JLabel();
    private JLabel raceDateLabel = new JLabel();
    private JLabel raceTimeLabel = new JLabel();
    private JTextField raceIdTextField = new JTextField();
    private JTextField raceNameTextField = new JTextField();
    private JTextField raceDateTextField = new JTextField();
    private JTextField raceTimeTextField = new JTextField();
    private JButton saveButton = new JButton();
    private JButton clearButton = new JButton();
    private JButton deleteButton = new JButton();
    private JButton updateButton = new JButton();
    private Date calendar;
    private SimpleDateFormat sdf;
    private String dateString = new String();
    private FormatUI format = new FormatUI();
    private String dupRaceId = new String();
    private boolean raceIdFocus = false;
    private boolean raceIdTyped = false;
    private ImageIcon raceIcon = new ImageIcon("icons/race_th.png");
    private CustomDateTime cDateTime = new CustomDateTime();
    private CustomMath cMath = new CustomMath();
    private RaceInfo raceinfo = new RaceInfo();
    private Race race = new Race();
    private RaceInfo updateRace = new RaceInfo();

public RaceUI() {
        try {
            jbInit();
        } catch (Exception e) {
            e.printStackTrace();
        }

}

public void jbInit() {

bodyPanel = format.formatPanel(bodyPanel, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12);
        bodyPanel.setLayout(null);
        statusBarPanel = format.createStatusBar(statusBarPanel, 240, 240, 240, 800,
                25);
        formatUserInterfaces();
        addListeners();
        addToPanel();
        setActionButtons(true, true, false, false);

this.setSize(767, 200);
        format.centerFrame(this);
        this.setResizable(false);
        this.getContentPane().setLayout(new BorderLayout());
        this.getContentPane().add(bodyPanel, null);
        this.getContentPane().add(statusBarPanel, BorderLayout.PAGE_END);
        this.getContentPane().setBackground(new Color(250, 250, 250));
        this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
        this.setIconImage(raceIcon.getImage());
        this.setTitle("Add a Race");
    }

public void setActionButtons(boolean saveFlag, boolean clearFlag, boolean delFlag, boolean updateFlag) {
        saveButton.setVisible(saveFlag);
        clearButton.setVisible(clearFlag);
     //   deleteButton.setVisible(delFlag);
        updateButton.setVisible(updateFlag);
    }

public void setStatusBar(String msg) {
        statusBarLabel.setText(msg);
    }

public void formatUserInterfaces() {
        statusBarLabel = format.formatLabel(statusBarLabel,
                "", 1, 1,
                750, 20, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        raceIdLabel = format.formatLabel(raceIdLabel,
                "Race ID", 16, 10,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        raceIdTextField = format.formatTextField(raceIdTextField, "", 15,
                30, 175, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        raceNameLabel = format.formatLabel(raceNameLabel,
                "Race Name", 201, 10,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        raceNameTextField = format.formatTextField(raceNameTextField, "", 200,
                30, 250, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        raceDateLabel = format.formatLabel(raceDateLabel,
                "Race Date", 461, 10,
                125, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        calendar = new GregorianCalendar(TimeZone.getDefault()).getTime();
        sdf = new SimpleDateFormat("d/MM/yyyy");
        dateString = sdf.format(calendar);
        raceDateTextField = format.formatTextField(raceDateTextField, dateString,
                460,
                30, 137, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        raceTimeLabel = format.formatLabel(raceTimeLabel,
                "Race Time", 608, 10,
                75, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        raceTimeTextField = format.formatTextField(raceTimeTextField, "", 607,
                30, 137, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        saveButton = format.formatButton(saveButton, "Save", 570, 85, 83, 25, 96,
                104, 113, "Arial", 0, 12);
        updateButton = format.formatButton(updateButton, "Update", 570, 85, 83, 25,
                96,
                104, 113, "Arial", 0, 12);
        deleteButton = format.formatButton(deleteButton, "Delete", 478, 85, 83, 25,
                96,
                104, 113, "Arial", 0, 12);
        clearButton = format.formatButton(clearButton, "Clear", 662, 85, 83, 25,
                96,
                104, 113, "Arial", 0, 12);

}

public void addListeners() {
        clearButton.addActionListener(new RaceUI_clearButton_actionAdapter(this));
        saveButton.addActionListener(new RaceUI_saveButton_actionAdapter(this));
        raceIdTextField.addFocusListener(new RaceUI_raceIdTextField_focusAdapter(this));
        raceIdTextField.addKeyListener(new RaceUI_raceIdTextField_keyAdapter(this));
        deleteButton.addActionListener(new RaceUI_deleteButton_actionAdapter(this));
        updateButton.addActionListener(new RaceUI_updateButton_actionAdapter(this));
    }

public void addToPanel() {
        statusBarPanel.add(statusBarLabel);
        bodyPanel.add(raceIdLabel);
        bodyPanel.add(raceIdTextField);
        bodyPanel.add(raceNameLabel);
        bodyPanel.add(raceNameTextField);
        bodyPanel.add(raceDateLabel);
        bodyPanel.add(raceDateTextField);
        bodyPanel.add(raceTimeLabel);
        bodyPanel.add(raceTimeTextField);
        bodyPanel.add(updateButton);
     //   bodyPanel.add(deleteButton);
        bodyPanel.add(saveButton);
        bodyPanel.add(clearButton);
    }

void clearButton_actionPerformed(ActionEvent e) {
        clear();
    }

public void clear() {
        raceIdTextField.setText("");
        raceNameTextField.setText("");
        raceDateTextField.setText(dateString);
        raceTimeTextField.setText("");
        statusBarLabel.setText("");
        raceIdTextField.setEditable(true);
        raceIdTextField.setBackground(new Color(255, 255, 255));
        setActionButtons(true, true, false, false);
        this.setTitle("Add a Race");
    }

public boolean validateEntries() {
        boolean valid = true;

if ((raceIdTextField.getText().trim().length() > 10)
                || (raceIdTextField.getText().trim().equals("") == true)
                || (cMath.isInteger(raceIdTextField.getText().trim()) == false)
                || (cMath.isGreaterThanZero(raceIdTextField.getText().trim()) == false)) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Race Id must be a Number Greater than 0 and to maximum of 10 Digits.");
            Toolkit.getDefaultToolkit().beep();
        } else if (raceNameTextField.getText().trim().length() > 300) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 300 Characters are allowed for Race Name.");
            Toolkit.getDefaultToolkit().beep();
        } else if (cDateTime.validateDate(raceDateTextField.getText().trim()) == false) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Date of Race must be in dd/mm/yyyy format.");
            Toolkit.getDefaultToolkit().beep();
        } else if (raceTimeTextField.getText().trim().length() > 20) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 20 Characters are allowed for Race Time.");
            Toolkit.getDefaultToolkit().beep();
        }
        return valid;
    }

public void allocateRecord() {
        raceinfo = new RaceInfo();

raceinfo.setRaceId(Integer.parseInt(raceIdTextField.getText().trim()));
        raceinfo.setRaceDate(raceDateTextField.getText().trim());
        raceinfo.setRaceTime(raceTimeTextField.getText().trim());
        raceinfo.setRaceName(raceNameTextField.getText().trim());

}

public void saveButton_actionPerformed(ActionEvent e) {
        boolean valid = false;
        boolean saved = false;
        valid = validateEntries();
        if (valid == true) {
            allocateRecord();
            saved = race.addRace(raceinfo);
            if (saved == true) {
                clear();
                statusBarLabel.setText(raceinfo.getRaceId() + " Number has been added successfully.");
            } else {
                statusBarLabel.setText("ERROR: " + raceinfo.getRaceId() + " has not been Saved");
            }
        }
    }

void raceIdTextField_focusGained(FocusEvent e) {
        raceIdFocus = true;
    }

void raceIdTextField_keyTyped(KeyEvent e) {
        raceIdTyped = true;
    }

public boolean validateRaceIdTextFieldEntry() {
        boolean valid = true;
        if ((raceIdTextField.getText().trim().length() > 10)
                || (raceIdTextField.getText().trim().equals("") == true)
                || (cMath.isInteger(raceIdTextField.getText().trim()) == false)
                || (cMath.isGreaterThanZero(raceIdTextField.getText().trim()) == false)) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Race Id must be a Number Greater than 0 and to maximum of 10 Digits.");
            Toolkit.getDefaultToolkit().beep();
        }
        return valid;
    }

void raceIdTextField_focusLost(FocusEvent e) {
        updateRace = new RaceInfo();
        if ((raceIdFocus == true) && (raceIdTyped == true)) {
            if (validateRaceIdTextFieldEntry() == true) {
                updateRace = race.validateRaceId(Integer.parseInt(raceIdTextField.getText().trim()));
            }
            if (updateRace.getRaceId() > 0) {
                dupRaceId = raceIdTextField.getText().trim();
                statusBarLabel.setText("Duplicate Entry: " + dupRaceId + " is already Exist. You are allowed to update all fields except Race ID");
                displayRecord(updateRace);
                raceIdTextField.setEditable(false);
                raceIdTextField.setBackground(new Color(217, 233, 238));
                setActionButtons(false, true, true, true);
                this.setTitle("Update A Race");
            } else {
                raceIdTextField.setEditable(true);
                raceIdTextField.setBackground(new Color(255, 255, 255));
            }
        }
        raceIdFocus = false;
        raceIdTyped = false;

}

public void displayRecord(RaceInfo raceline) {
        raceIdTextField.setText(String.valueOf(raceline.getRaceId()));
        raceNameTextField.setText(raceline.getRaceName());
        raceDateTextField.setText(raceline.getRaceDate());
        raceTimeTextField.setText(raceline.getRaceTime());
    }

void deleteButton_actionPerformed(ActionEvent e) {
        boolean delFlag = false;
        Object[] options = {"Yes", "No", "Cancel"};
        this.setTitle("Delete A Race");
        int response = JOptionPane.showOptionDialog(this,
                "Are you sure you want to permanently delete this Race?",
                "Confirm Delete",
                JOptionPane.YES_NO_CANCEL_OPTION,
                JOptionPane.WARNING_MESSAGE,
                null,
                options,
                options[2]);
        if (response == 0) {
            
            delFlag = race.deleteRace(updateRace.getRaceId());
        }
        if (delFlag == true) {
            statusBarLabel.setText(updateRace.getRaceId() + " has been Removed from Database.");
            clear();
        } else {
            boolean flag = race.isRaceInWinner();         
            if (flag == true) {
                statusBarLabel.setText("ERROR: There is a Winner with this Race ID, Delete the Winner First.");
            }           
            else {
                statusBarLabel.setText("ERROR: " + updateRace.getRaceId() + " has not removed from Database");
            }
        }
    }

void updateButton_actionPerformed(ActionEvent e) {
        boolean valid = false;
        boolean updated = false;
        valid = validateEntries();
        if (valid == true) {
            allocateRecord();
            raceinfo.setRaceId(updateRace.getRaceId());
            updated = race.updateRace(raceinfo);
            if (updated == true) {
                clear();
                statusBarLabel.setText(raceinfo.getRaceId() + " Race has been updated successfully.");
            } else {
                statusBarLabel.setText("ERROR: " + raceinfo.getRaceId() + " Race update has not been Saved");

}
        }
    }
}

class RaceUI_clearButton_actionAdapter
        implements java.awt.event.ActionListener {

RaceUI adaptee;

RaceUI_clearButton_actionAdapter(RaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.clearButton_actionPerformed(e);
    }
}

class RaceUI_saveButton_actionAdapter
        implements java.awt.event.ActionListener {

RaceUI adaptee;

RaceUI_saveButton_actionAdapter(RaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.saveButton_actionPerformed(e);
    }
}

class RaceUI_raceIdTextField_focusAdapter extends java.awt.event.FocusAdapter {

RaceUI adaptee;

RaceUI_raceIdTextField_focusAdapter(RaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void focusGained(FocusEvent e) {
        adaptee.raceIdTextField_focusGained(e);
    }

public void focusLost(FocusEvent e) {
        adaptee.raceIdTextField_focusLost(e);
    }
}

class RaceUI_raceIdTextField_keyAdapter extends java.awt.event.KeyAdapter {

RaceUI adaptee;

RaceUI_raceIdTextField_keyAdapter(RaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void keyTyped(KeyEvent e) {
        adaptee.raceIdTextField_keyTyped(e);
    }
}

class RaceUI_deleteButton_actionAdapter implements java.awt.event.ActionListener {

RaceUI adaptee;

RaceUI_deleteButton_actionAdapter(RaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.deleteButton_actionPerformed(e);
    }
}

class RaceUI_updateButton_actionAdapter implements java.awt.event.ActionListener {

RaceUI adaptee;

RaceUI_updateButton_actionAdapter(RaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.updateButton_actionPerformed(e);
    }
}

Class: WinnerUI.java

/*
 Class: WinnerUI
 Author: Shahrzad Jahangirian
 Date: June 21, 2014
 Description: A data entry screen for add, update, and delete a Race Winner in 
 * annual Bolder Boulder Races.
 */
package GUIpkg;

import javax.swing.*;
import java.awt.*;
import java.awt.*;
import java.awt.Color;
import java.awt.event.*;
import java.util.*;
import java.text.*;

import commonPKG.FormatUI;
import commonPKG.CustomMath;
import PDpkg.Winner;
import PDpkg.WinnerInfo;

public class WinnerUI
        extends JFrame {

private JPanel bodyPanel = new JPanel();
    private JPanel statusBarPanel = new JPanel();
    private JLabel statusBarLabel = new JLabel();
    private JLabel raceIdLabel = new JLabel();
    private JLabel ssnLabel = new JLabel();
    private JLabel masterLabel = new JLabel();
    private JTextField raceIdTextField = new JTextField();
    private JTextField ssnTextField = new JTextField();
    private String[] masterString = {"YES", "NO"};
    private JComboBox masterComboBox = new JComboBox(masterString);
    private JButton saveButton = new JButton();
    private JButton clearButton = new JButton();
    private JButton deleteButton = new JButton();
    private JButton updateButton = new JButton();
    private FormatUI format = new FormatUI();
    private String dupRaceId = new String();
    private boolean raceIdFocus = false;
    private boolean raceIdTyped = false;
    private ImageIcon raceIcon = new ImageIcon("icons/winner_th.png");
    private WinnerInfo winnerinfo = new WinnerInfo();
    private Winner winner = new Winner();
    private WinnerInfo updateWinner = new WinnerInfo();
    private CustomMath cMath = new CustomMath();

public WinnerUI() {
        try {
            jbInit();
        } catch (Exception e) {
            e.printStackTrace();
        }

}

public void jbInit() {

public void setActionButtons(boolean saveFlag, boolean clearFlag, boolean delFlag, boolean updateFlag) {
        saveButton.setVisible(saveFlag);
        clearButton.setVisible(clearFlag);
        deleteButton.setVisible(delFlag);
        updateButton.setVisible(updateFlag);
    }

public void setStatusBar(String msg) {
        statusBarLabel.setText(msg);
    }

public void formatUserInterfaces() {
        statusBarLabel = format.formatLabel(statusBarLabel,
                "", 1, 1,
                750, 20, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        raceIdLabel = format.formatLabel(raceIdLabel,
                "Race ID", 16, 10,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        raceIdTextField = format.formatTextField(raceIdTextField, "", 15,
                30, 175, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        ssnLabel = format.formatLabel(ssnLabel,
                "Social Security Number", 201, 10,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        ssnTextField = format.formatTextField(ssnTextField, "", 200,
                30, 250, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        masterLabel = format.formatLabel(masterLabel,
                "Master", 461, 10,
                125, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        masterComboBox = format.formatComboBox(masterComboBox, 460, 30, 137, 25, false, false,
                0, 255, 255, 255, 96, 104, 113,
                "Arial", 0, 12, 3);
        saveButton = format.formatButton(saveButton, "Save", 570, 85, 83, 25, 96,
                104, 113, "Arial", 0, 12);
        updateButton = format.formatButton(updateButton, "Update", 570, 85, 83, 25,
                96,
                104, 113, "Arial", 0, 12);
        deleteButton = format.formatButton(deleteButton, "Delete", 478, 85, 83, 25,
                96,
                104, 113, "Arial", 0, 12);
        clearButton = format.formatButton(clearButton, "Clear", 662, 85, 83, 25,
                96,
                104, 113, "Arial", 0, 12);

}

public void addListeners() {
        clearButton.addActionListener(new WinnerUI_clearButton_actionAdapter(this));
        saveButton.addActionListener(new WinnerUI_saveButton_actionAdapter(this));
        raceIdTextField.addFocusListener(new WinnerUI_raceIdTextField_focusAdapter(this));
        raceIdTextField.addKeyListener(new WinnerUI_raceIdTextField_keyAdapter(this));
        deleteButton.addActionListener(new WinnerUI_deleteButton_actionAdapter(this));
        updateButton.addActionListener(new WinnerUI_updateButton_actionAdapter(this));
    }

public void addToPanel() {
        statusBarPanel.add(statusBarLabel);
        bodyPanel.add(raceIdLabel);
        bodyPanel.add(raceIdTextField);
        bodyPanel.add(ssnLabel);
        bodyPanel.add(ssnTextField);
        bodyPanel.add(masterLabel);
        bodyPanel.add(masterComboBox);
        bodyPanel.add(updateButton);
        bodyPanel.add(deleteButton);
        bodyPanel.add(saveButton);
        bodyPanel.add(clearButton);
    }

void clearButton_actionPerformed(ActionEvent e) {
        clear();
    }

public void clear() {
        raceIdTextField.setText("");
        ssnTextField.setText("");
        statusBarLabel.setText("");
        raceIdTextField.setEditable(true);
        ssnTextField.setEditable(true);
        raceIdTextField.setBackground(new Color(255, 255, 255));
        ssnTextField.setBackground(new Color(255, 255, 255));
        setActionButtons(true, true, false, false);
        this.setTitle("Add A Winner");
    }

public boolean validateEntries() {
        boolean valid = true;

public void allocateRecord() {
        winnerinfo = new WinnerInfo();

winnerinfo.setRaceId(Integer.parseInt(raceIdTextField.getText().trim()));
        winnerinfo.setSSN(ssnTextField.getText().trim());
        if ((masterComboBox.getSelectedItem().toString()).equals("YES") == true) {
            winnerinfo.setMaster(true);
        } else {
            winnerinfo.setMaster(false);
        }

}

public void saveButton_actionPerformed(ActionEvent e) {
        boolean valid = false;
        boolean saved = false;

valid = validateEntries();
        if (valid == true) {
            if (winner.isParticipantSSN(ssnTextField.getText().trim()) == false) {
                valid = false;
                statusBarLabel.setText(ssnTextField.getText().trim() + " does not exist in Database. Please try again.");
            } else if (winner.isRaceId(Integer.parseInt(raceIdTextField.getText().trim())) == false) {
                valid = false;
                statusBarLabel.setText(raceIdTextField.getText().trim() + " does not exist in Database. Please try again.");
            } else if (validateDuplicate() == true) {
                valid = false;
                raceIdTextField.setEditable(false);
                ssnTextField.setEditable(false);
                raceIdTextField.setBackground(new Color(217,233,238));
                ssnTextField.setBackground(new Color(217,233,238));
            } else {
                valid = true;
                raceIdTextField.setEditable(true);
                ssnTextField.setEditable(true);
                raceIdTextField.setBackground(new Color(255, 255, 255));
                ssnTextField.setBackground(new Color(255, 255, 255));
            }
        }
        if (valid == true) {
            allocateRecord();
            saved = winner.addWinner(winnerinfo);
            if (saved == true) {
                clear();
                statusBarLabel.setText("Winner with SSN No: " + winnerinfo.getSSN() + " for Race "
                        + winnerinfo.getRaceId() + " has been added successfully.");
            } else {
                statusBarLabel.setText("Error: Winner with SSN No: " + winnerinfo.getSSN() + " for Race "
                        + winnerinfo.getRaceId() + " has not been Saved");
            }
        }
    }

void raceIdTextField_focusGained(FocusEvent e) {
        raceIdFocus = true;
    }

void raceIdTextField_keyTyped(KeyEvent e) {
        raceIdTyped = true;
    }

public boolean validateDuplicate() {
        updateWinner = new WinnerInfo();
        updateWinner = winner.isDuplicateEntry(Integer.parseInt(raceIdTextField.getText().trim()), ssnTextField.getText().trim());
        boolean dup = false;
        if (updateWinner.getRaceId() > 0) {
            statusBarLabel.setText("Duplicate Entry, this record is already in Database. You are only allowed to update Master.");
            displayRecord(updateWinner);
            setActionButtons(false, true, true, true);
            this.setTitle("Update A Winner");
            dup = true;
        }
        return dup;
    }

public void displayRecord(WinnerInfo winnerline) {
        raceIdTextField.setText(String.valueOf(winnerline.getRaceId()));
        ssnTextField.setText(winnerline.getSSN());
        if (winnerline.getMaster() == true) {
            masterComboBox.setSelectedIndex(0);
        } else {
            masterComboBox.setSelectedIndex(1);
        }
    }

void deleteButton_actionPerformed(ActionEvent e) {
        boolean delFlag = false;
        Object[] options = {"Yes", "No", "Cancel"};
        this.setTitle("Delete A Winner");
        int response = JOptionPane.showOptionDialog(this,
                "Are you sure you want to permanently delete this Winner?",
                "Confirm Delete",
                JOptionPane.YES_NO_CANCEL_OPTION,
                JOptionPane.WARNING_MESSAGE,
                null,
                options,
                options[2]);
        if (response == 0) {          
            delFlag = winner.deleteWinner(Integer.parseInt(raceIdTextField.getText().trim()), ssnTextField.getText().trim());                 
            if (delFlag == true) {
                statusBarLabel.setText("Winner with SSN No: " + winnerinfo.getSSN() + " for Race "
                        + winnerinfo.getRaceId() + " has been Removed from Database.");
                clear();
            } else {
                statusBarLabel.setText("Error: Winner with SSN No: " + winnerinfo.getSSN() + " for Race "
                        + winnerinfo.getRaceId() + " has not been removed from Database");
            }
        }
    }

void updateButton_actionPerformed(ActionEvent e) {
        boolean valid = false;
        boolean updated = false;
        valid = validateEntries();
        if (valid == true) {
            allocateRecord();
            winnerinfo.setRaceId(updateWinner.getRaceId());
            updated = winner.updateWinner(winnerinfo);
            if (updated == true) {
                clear();
                statusBarLabel.setText("Winner with SSN No: " + updateWinner.getSSN() + " for Race "
                        + updateWinner.getRaceId() + " has been updated successfully.");
            } else {
                statusBarLabel.setText("Error: Winner with SSN No: " + updateWinner.getSSN() + " for Race "
                        + updateWinner.getRaceId() + " update has not been Saved");
            }
        }
    }
}

class WinnerUI_clearButton_actionAdapter
        implements java.awt.event.ActionListener {

WinnerUI adaptee;

WinnerUI_clearButton_actionAdapter(WinnerUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.clearButton_actionPerformed(e);
    }
}

class WinnerUI_saveButton_actionAdapter
        implements java.awt.event.ActionListener {

WinnerUI adaptee;

WinnerUI_saveButton_actionAdapter(WinnerUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.saveButton_actionPerformed(e);
    }
}

class WinnerUI_raceIdTextField_focusAdapter extends java.awt.event.FocusAdapter {

WinnerUI adaptee;

WinnerUI_raceIdTextField_focusAdapter(WinnerUI adaptee) {
        this.adaptee = adaptee;
    }

public void focusGained(FocusEvent e) {
        adaptee.raceIdTextField_focusGained(e);
    }

}

class WinnerUI_raceIdTextField_keyAdapter extends java.awt.event.KeyAdapter {

WinnerUI adaptee;

WinnerUI_raceIdTextField_keyAdapter(WinnerUI adaptee) {
        this.adaptee = adaptee;
    }

public void keyTyped(KeyEvent e) {
        adaptee.raceIdTextField_keyTyped(e);
    }
}

class WinnerUI_deleteButton_actionAdapter implements java.awt.event.ActionListener {

WinnerUI adaptee;

WinnerUI_deleteButton_actionAdapter(WinnerUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.deleteButton_actionPerformed(e);
    }
}

class WinnerUI_updateButton_actionAdapter implements java.awt.event.ActionListener {

WinnerUI adaptee;

WinnerUI_updateButton_actionAdapter(WinnerUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.updateButton_actionPerformed(e);
    }
}

Class: RegisterUI.java

/*
 Class: RegisterUI
 Author: Shahrzad Jahangirian
 Date: March 20, 2014
 Description: A data entry screen for register, update, and delete a participant 
 * for Bolder Race.
 */
package GUIpkg;

import javax.swing.*;
import java.awt.*;
import java.awt.*;
import java.awt.Color;
import java.awt.event.*;
import java.util.*;
import java.text.*;

import commonPKG.FormatUI;
import PDpkg.Registration;
import PDpkg.Participant;
import PDpkg.Race;

public class RegisterUI
        extends JFrame {

private JPanel bodyPanel = new JPanel();
    private JPanel statusBarPanel = new JPanel();
    private JLabel statusBarLabel = new JLabel();
    private JLabel ssnLabel = new JLabel();
    private JLabel nameLabel = new JLabel();
    private JLabel surnameLabel = new JLabel();
    private JLabel nicknameLabel = new JLabel();
    private JLabel birthDateLabel = new JLabel();
    private JLabel ageLabel = new JLabel();
    private JLabel prLabel = new JLabel();
    private JLabel address1Label = new JLabel();
    private JLabel address2Label = new JLabel();
    private JLabel cityLabel = new JLabel();
    private JLabel stateLabel = new JLabel();
    private JLabel zipLabel = new JLabel();
    private JLabel countryLabel = new JLabel();
    private JLabel emailLabel = new JLabel();
    private JLabel genderLabel = new JLabel();
    private JLabel mobileLabel = new JLabel();
    private JLabel phoneLabel = new JLabel();
    private JLabel emergPhoneLabel = new JLabel();
    private JLabel raceTypeLabel = new JLabel();
    private JLabel raceIdLabel = new JLabel();
    private JTextField ssnTextField = new JTextField();
    private JTextField nameTextField = new JTextField();
    private JTextField surnameTextField = new JTextField();
    private JTextField nicknameTextField = new JTextField();
    private JTextField birthDateTextField = new JTextField();
    private JTextField ageTextField = new JTextField();
    private JTextField prTextField = new JTextField();
    private JTextField address1TextField = new JTextField();
    private JTextField address2TextField = new JTextField();
    private JTextField cityTextField = new JTextField();
    private JTextField stateTextField = new JTextField();
    private JTextField zipTextField = new JTextField();
    private JTextField countryTextField = new JTextField();
    private JTextField emailTextField = new JTextField();
    private String[] genderString = {
        "Male", "Female"};
    private JComboBox genderComboBox = new JComboBox(genderString);
    private JTextField mobileTextField = new JTextField();
    private JTextField phoneTextField = new JTextField();
    private JTextField emergPhoneTextField = new JTextField();
    private String[] raceTypeString = {
        "Runner", "Jogger", "JogWalker", "WalkJogger", "Walker", "Wheelchair"};
    private JComboBox raceTypeComboBox = new JComboBox(raceTypeString);
    private String[] raceIdString;
    private JComboBox raceIdComboBox;
    private JButton saveButton = new JButton();
    private JButton clearButton = new JButton();
    private JButton deleteButton = new JButton();
    private JButton updateButton = new JButton();
    private Date calendar;
    private SimpleDateFormat sdf;
    private String dateString = new String();
    private boolean ageFlag = false;
    private FormatUI format = new FormatUI();
    private Registration reg = new Registration();
    private Participant person = new Participant();
    private Participant updatePerson = new Participant();
    private String dupSSN = new String();
    private boolean ssnFocus = false;
    private boolean ssnTyped = false;
    private ImageIcon regIcon = new ImageIcon("icons/register_th.png");
    private Race race = new Race();

public RegisterUI() {
        try {
            jbInit();
        } catch (Exception e) {
            e.printStackTrace();
        }

}

public void jbInit() {

bodyPanel = format.formatPanel(bodyPanel, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12);
        bodyPanel.setLayout(null);
        statusBarPanel = format.createStatusBar(statusBarPanel, 240, 240, 240, 800,
                25);
        raceIdString = race.getAllRacesIds();
        raceIdComboBox = new JComboBox(raceIdString);
        formatUserInterfaces();
        addListeners();
        addToPanel();
        setActionButtons(true, true, false, false);

this.setSize(767, 435);
        format.centerFrame(this);
        this.setResizable(false);
        this.getContentPane().setLayout(new BorderLayout());
        this.getContentPane().add(bodyPanel, null);
        this.getContentPane().add(statusBarPanel, BorderLayout.PAGE_END);
        this.getContentPane().setBackground(new Color(250, 250, 250));
        this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
        this.setIconImage(regIcon.getImage());
        this.setTitle("Register a Participant");
    }

public void setActionButtons(boolean saveFlag, boolean clearFlag, boolean delFlag, boolean updateFlag) {
        saveButton.setVisible(saveFlag);
        clearButton.setVisible(clearFlag);
        deleteButton.setVisible(delFlag);
        updateButton.setVisible(updateFlag);
    }

public void setStatusBar(String msg) {
        statusBarLabel.setText(msg);
    }

public void formatUserInterfaces() {
        statusBarLabel = format.formatLabel(statusBarLabel,
                "", 1, 1,
                750, 20, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        ssnLabel = format.formatLabel(ssnLabel,
                "Social Security Number", 16, 10,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        ssnTextField = format.formatTextField(ssnTextField, "", 15,
                30, 175, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        nameLabel = format.formatLabel(nameLabel,
                "First Name", 201, 10,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        nameTextField = format.formatTextField(nameTextField, "", 200,
                30, 175, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        surnameLabel = format.formatLabel(surnameLabel,
                "Surname", 386, 10,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        surnameTextField = format.formatTextField(surnameTextField, "", 385,
                30, 175, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        nicknameLabel = format.formatLabel(nicknameLabel,
                "Nickname", 571, 10,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        nicknameTextField = format.formatTextField(nicknameTextField, "", 570,
                30, 175, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        birthDateLabel = format.formatLabel(birthDateLabel,
                "Birth Date", 16, 70,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);

calendar = new GregorianCalendar(TimeZone.getDefault()).getTime();
        sdf = new SimpleDateFormat("d/MM/yyyy");
        dateString = sdf.format(calendar);
        birthDateTextField = format.formatTextField(birthDateTextField, dateString,
                15,
                90, 175, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        ageLabel = format.formatLabel(ageLabel,
                "Age", 201, 70,
                75, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        ageTextField = format.formatTextField(ageTextField, "", 200,
                90, 82, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        genderLabel = format.formatLabel(genderLabel,
                "Gender", 293, 70,
                75, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        genderComboBox = format.formatComboBox(genderComboBox, 292, 91, 83, 25, false, false,
                0, 255, 255, 255, 96, 104, 113,
                "Arial", 0, 12, 3);
        emailLabel = format.formatLabel(emailLabel,
                "Email Address", 386, 70,
                100, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        emailTextField = format.formatTextField(emailTextField, "", 385,
                90, 360, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        address1Label = format.formatLabel(address1Label,
                "Address 1", 16, 130,
                100, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        address1TextField = format.formatTextField(address1TextField, "", 15,
                150, 360, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        address2Label = format.formatLabel(address2Label,
                "Address 2", 386, 130,
                100, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        address2TextField = format.formatTextField(address2TextField, "", 385,
                150, 360, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        cityLabel = format.formatLabel(cityLabel,
                "City", 16, 190,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        cityTextField = format.formatTextField(cityTextField, "", 15,
                210, 175, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        stateLabel = format.formatLabel(stateLabel,
                "State", 201, 190,
                75, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        stateTextField = format.formatTextField(stateTextField, "", 200,
                210, 82, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        zipLabel = format.formatLabel(zipLabel,
                "Zip Code", 293, 190,
                75, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        zipTextField = format.formatTextField(zipTextField, "", 292,
                210, 83, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        countryLabel = format.formatLabel(countryLabel,
                "Country", 386, 190,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        countryTextField = format.formatTextField(countryTextField, "", 385,
                210, 175, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        phoneLabel = format.formatLabel(phoneLabel,
                "Phone", 571, 190,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        phoneTextField = format.formatTextField(phoneTextField, "", 570,
                210, 175, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        emergPhoneLabel = format.formatLabel(emergPhoneLabel,
                "Emergency Phone", 16, 250,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        emergPhoneTextField = format.formatTextField(emergPhoneTextField, "", 15,
                270, 175, 25, 255, 255, 255,
                96,
                104, 113, "Arial", 0, 12, 0);
        mobileLabel = format.formatLabel(mobileLabel,
                "Mobile Phone", 201, 250,
                150, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        mobileTextField = format.formatTextField(mobileTextField, "", 200,
                270, 175, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        prLabel = format.formatLabel(prLabel,
                "PR", 386, 250,
                75, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        prTextField = format.formatTextField(prTextField, "", 385,
                270, 82, 25, 255, 255, 255, 96,
                104, 113, "Arial", 0, 12, 0);
        raceTypeLabel = format.formatLabel(raceTypeLabel,
                "Race Type", 571, 250,
                75, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        raceTypeComboBox = format.formatComboBox(raceTypeComboBox, 570, 271, 175, 25, false, false,
                0, 255, 255, 255, 96, 104, 113,
                "Arial", 0, 12, 3);
        raceIdLabel = format.formatLabel(raceIdLabel,
                "Race ID", 478, 250,
                75, 17, 240, 240, 240, 96, 104, 113,
                "Arial", 0, 12, SwingConstants.CENTER,
                SwingConstants.LEFT);
        raceIdComboBox = format.formatComboBox(raceIdComboBox, 477, 271, 83, 25, false, false,
                0, 255, 255, 255, 96, 104, 113,
                "Arial", 0, 12, 3);
        saveButton = format.formatButton(saveButton, "Save", 570, 320, 83, 25, 96,
                104, 113, "Arial", 0, 12);
        updateButton = format.formatButton(updateButton, "Update", 570, 320, 83, 25,
                96,
                104, 113, "Arial", 0, 12);
        deleteButton = format.formatButton(deleteButton, "Delete", 478, 320, 83, 25,
                96,
                104, 113, "Arial", 0, 12);
        clearButton = format.formatButton(clearButton, "Clear", 662, 320, 83, 25,
                96,
                104, 113, "Arial", 0, 12);

}

public void addListeners() {
        clearButton.addActionListener(new RegisterUI_clearButton_actionAdapter(this));
        saveButton.addActionListener(new RegisterUI_saveButton_actionAdapter(this));
        birthDateTextField.addFocusListener(new RegisterUI_birthDateTextField_focusAdapter(this));
        prTextField.addFocusListener(new RegisterUI_prTextField_focusAdapter(this));
        ssnTextField.addFocusListener(new RegisterUI_ssnTextField_focusAdapter(this));
        ssnTextField.addKeyListener(new RegisterUI_ssnTextField_keyAdapter(this));
        deleteButton.addActionListener(new RegisterUI_deleteButton_actionAdapter(this));
        updateButton.addActionListener(new RegisterUI_updateButton_actionAdapter(this));
    }

public void addToPanel() {
        statusBarPanel.add(statusBarLabel);
        bodyPanel.add(ssnLabel);
        bodyPanel.add(ssnTextField);
        bodyPanel.add(nameLabel);
        bodyPanel.add(nameTextField);
        bodyPanel.add(surnameLabel);
        bodyPanel.add(surnameTextField);
        bodyPanel.add(nicknameLabel);
        bodyPanel.add(nicknameTextField);
        bodyPanel.add(birthDateLabel);
        bodyPanel.add(birthDateTextField);
        bodyPanel.add(ageLabel);
        bodyPanel.add(ageTextField);
        bodyPanel.add(genderLabel);
        bodyPanel.add(genderComboBox);
        bodyPanel.add(emailLabel);
        bodyPanel.add(emailTextField);
        bodyPanel.add(address1Label);
        bodyPanel.add(address1TextField);

bodyPanel.add(address2Label);
        bodyPanel.add(address2TextField);
        bodyPanel.add(cityLabel);
        bodyPanel.add(cityTextField);
        bodyPanel.add(stateLabel);
        bodyPanel.add(stateTextField);
        bodyPanel.add(zipLabel);
        bodyPanel.add(zipTextField);
        bodyPanel.add(countryLabel);
        bodyPanel.add(countryTextField);
        bodyPanel.add(phoneLabel);
        bodyPanel.add(phoneTextField);
        bodyPanel.add(emergPhoneLabel);
        bodyPanel.add(emergPhoneTextField);
        bodyPanel.add(mobileLabel);
        bodyPanel.add(mobileTextField);
        bodyPanel.add(prLabel);
        bodyPanel.add(prTextField);
        bodyPanel.add(raceIdLabel);
        bodyPanel.add(raceIdComboBox);
        bodyPanel.add(raceTypeLabel);
        bodyPanel.add(raceTypeComboBox);
        bodyPanel.add(updateButton);
        bodyPanel.add(deleteButton);
        bodyPanel.add(saveButton);
        bodyPanel.add(clearButton);
    }

void clearButton_actionPerformed(ActionEvent e) {
        clear();
    }

public void clear() {
        ssnTextField.setText("");
        nameTextField.setText("");
        surnameTextField.setText("");
        nicknameTextField.setText("");
        birthDateTextField.setText(dateString);
        ageTextField.setText("");
        prTextField.setText("");
        address1TextField.setText("");
        address2TextField.setText("");
        cityTextField.setText("");
        stateTextField.setText("");
        zipTextField.setText("");
        countryTextField.setText("");
        emailTextField.setText("");
        genderComboBox.setSelectedIndex(0);
        mobileTextField.setText("");
        phoneTextField.setText("");
        emergPhoneTextField.setText("");
        raceTypeComboBox.setSelectedIndex(0);
        raceIdComboBox.setSelectedIndex(0);
        statusBarLabel.setText("");
        setActionButtons(true, true, false, false);
        this.setTitle("Register a Participant");
    }

public boolean validateEntries() {
        boolean valid = true;

if ((ssnTextField.getText().trim().length() > 35)
                || (ssnTextField.getText().trim().equals("") == true)) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 35 Characters are allowed for Social Security Number.");
            Toolkit.getDefaultToolkit().beep();
        } else if (nameTextField.getText().trim().length() > 100) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 100 Characters are allowed for First Name.");
            Toolkit.getDefaultToolkit().beep();
        } else if (surnameTextField.getText().trim().length() > 150) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 150 Characters are allowed for Surname.");
            Toolkit.getDefaultToolkit().beep();
        } else if (nicknameTextField.getText().trim().length() > 100) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 100 Characters are allowed for Nickname.");
            Toolkit.getDefaultToolkit().beep();
        } else if (reg.validateDate(birthDateTextField.getText().trim(), dateString) == false) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Date of Birth must be in dd/mm/yyyy format and not Today's Date");
            Toolkit.getDefaultToolkit().beep();
        } else if ((ageTextField.getText().trim().equals("") == false) && (reg.isInteger(ageTextField.getText().trim()) == false)) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Age must be an Integer Number");
            Toolkit.getDefaultToolkit().beep();
        } else if (prTextField.getText().trim().length() > 200) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 20 Characters are allowed for PR(Personal Running Record).");
            Toolkit.getDefaultToolkit().beep();
        } else if (address1TextField.getText().trim().length() > 200) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 200 Characters are allowed for Address 1.");
            Toolkit.getDefaultToolkit().beep();
        } else if (address2TextField.getText().trim().length() > 200) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 200 Characters are allowed for Address 2.");
            Toolkit.getDefaultToolkit().beep();
        } else if (cityTextField.getText().trim().length() > 100) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 100 Characters are allowed for City.");
            Toolkit.getDefaultToolkit().beep();
        } else if (stateTextField.getText().trim().length() > 100) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 100 Characters are allowed for State.");
            Toolkit.getDefaultToolkit().beep();
        } else if (zipTextField.getText().trim().length() > 25) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 25 Characters are allowed for Zip Code.");
            Toolkit.getDefaultToolkit().beep();
        } else if (countryTextField.getText().trim().length() > 100) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 100 Characters are allowed for Country.");
            Toolkit.getDefaultToolkit().beep();
        } else if (emailTextField.getText().trim().length() > 200) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 100 Characters are allowed for Email.");
            Toolkit.getDefaultToolkit().beep();
        } else if (mobileTextField.getText().trim().length() > 35) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 35 Characters are allowed for Mobile.");
            Toolkit.getDefaultToolkit().beep();
        } else if (phoneTextField.getText().trim().length() > 50) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 50 Characters are allowed for Phone.");
            Toolkit.getDefaultToolkit().beep();
        } else if (emergPhoneTextField.getText().trim().length() > 50) {
            valid = false;
            statusBarLabel.setText(
                    " Error: Maximum of 100 Characters are allowed for Emergency Phone.");
            Toolkit.getDefaultToolkit().beep();
        }
        return valid;
    }

public void allocateRecord() {
        person = new Participant();
        person.setSsn(ssnTextField.getText().trim());
        person.setName(nameTextField.getText().trim());
        person.setSurname(surnameTextField.getText().trim());
        person.setNickname(nicknameTextField.getText().trim());
        person.setBirthDate(birthDateTextField.getText().trim());
        if (ageTextField.getText().trim().equals("") == false) {
            person.setAge(Integer.parseInt(ageTextField.getText().trim()));
        }
        person.setPr(prTextField.getText().trim());
        person.setAddress1(address1TextField.getText().trim());
        person.setAddress2(address2TextField.getText().trim());
        person.setCity(cityTextField.getText().trim());
        person.setState(stateTextField.getText().trim());
        person.setZip(zipTextField.getText().trim());
        person.setCountry(countryTextField.getText().trim());
        person.setGender((String) genderComboBox.getSelectedItem());
        person.setEmail(emailTextField.getText().trim());
        person.setPhone(phoneTextField.getText().trim());
        person.setEmergPhone(emergPhoneTextField.getText().trim());
        person.setMobile(mobileTextField.getText().trim());
        person.setRaceId(Integer.parseInt((String) raceIdComboBox.getSelectedItem()));
        person.setRaceType((String) raceTypeComboBox.getSelectedItem());

}

public void saveButton_actionPerformed(ActionEvent e) {
        boolean valid = false;
        boolean saved = false;
        valid = validateEntries();
        if (valid == true) {
            allocateRecord();
            saved = reg.registerParticipant(person);
            if (saved == true) {
                clear();
                statusBarLabel.setText(person.getSsn() + " Social Security Number has been registered successfully.");
            } else {
                statusBarLabel.setText("ERROR: " + person.getSsn() + " has not been Saved");
            }
        }
    }

void birthDateTextField_focusGained(FocusEvent e) {
        statusBarLabel.setText("Birth Date must be in DD/MM/YYYY format");
        ageFlag = true;
    }

void prTextField_focusGained(FocusEvent e) {
        statusBarLabel.setText("Enter Personal Running Record (PR)");
    }

void prTextField_focusLost(FocusEvent e) {
        statusBarLabel.setText("");
    }

void birthDateTextField_focusLost(FocusEvent e) {
        statusBarLabel.setText("");
        if (reg.validateDate(birthDateTextField.getText().trim(), dateString) == true) {
            ageTextField.setText(String.valueOf(person.calculateAge(reg.getBirthYear())));
        }

}

void ssnTextField_focusGained(FocusEvent e) {
        ssnFocus = true;
    }

void ssnTextField_keyTyped(KeyEvent e) {
        ssnTyped = true;
    }

void ssnTextField_focusLost(FocusEvent e) {
        updatePerson = new Participant();
        if ((ssnFocus == true) && (ssnTyped == true)) {
            updatePerson = reg.validateSSN(ssnTextField.getText().trim());
            if (((updatePerson.getSsn()).equals("")) == false) {
                dupSSN = ssnTextField.getText().trim();
                statusBarLabel.setText("Duplicate Entry, " + dupSSN + " Social Security Number is already Registered.");
                displayRecord(updatePerson);
                setActionButtons(false, true, true, true);
                this.setTitle("Participant");
            }
        }
        ssnFocus = false;
        ssnTyped = false;

}

public void displayRecord(Participant aPerson) {
        ssnTextField.setText(aPerson.getSsn());
        nameTextField.setText(aPerson.getName());
        surnameTextField.setText(aPerson.getSurname());
        nicknameTextField.setText(aPerson.getNickname());
        birthDateTextField.setText(aPerson.getBirthDate());
        ageTextField.setText(String.valueOf(aPerson.getAge()));
        prTextField.setText(aPerson.getPr());
        address1TextField.setText(aPerson.getAddress1());
        address2TextField.setText(aPerson.getAddress2());
        cityTextField.setText(aPerson.getCity());
        stateTextField.setText(aPerson.getState());
        zipTextField.setText(aPerson.getZip());
        countryTextField.setText(aPerson.getCountry());
        genderComboBox.setSelectedItem(aPerson.getGender());
        emailTextField.setText(aPerson.getEmail());
        phoneTextField.setText(aPerson.getPhone());
        emergPhoneTextField.setText(aPerson.getEmergPhone());
        mobileTextField.setText(aPerson.getMobile());
        raceIdComboBox.setSelectedItem(String.valueOf(aPerson.getRaceId()));
        raceTypeComboBox.setSelectedItem(aPerson.getRaceType());
    }

void deleteButton_actionPerformed(ActionEvent e) {
        boolean delFlag = false;
        Object[] options = {"Yes", "No", "Cancel"};
        this.setTitle("Delete A Participant");
        int response = JOptionPane.showOptionDialog(this,
                "Are you sure you want to permanently delete this Participant?",
                "Confirm Delete",
                JOptionPane.YES_NO_CANCEL_OPTION,
                JOptionPane.WARNING_MESSAGE,
                null,
                options,
                options[2]);

if (response == 0) {
            delFlag = reg.deleteParticipant(updatePerson.getId(), updatePerson.getSsn());
        }
        if (delFlag == true) {
            statusBarLabel.setText(updatePerson.getSsn() + " has been Removed from Database.");
            clear();
        } else {
            boolean flag = reg.isSsnInWinner();
            if (flag == true) {
                statusBarLabel.setText("ERROR: There is a Winner with this Social Security Number, Delete the Winner First.");
            } else {
                statusBarLabel.setText("ERROR: " + updatePerson.getSsn() + " has not removed from Database");
            }

}
    }

void updateButton_actionPerformed(ActionEvent e) {
        boolean valid = false;
        boolean updated = false;
        valid = validateEntries();
        if (valid == true) {
            allocateRecord();
            person.setId(updatePerson.getId());
            updated = reg.updateParticipant(person);
            if (updated == true) {
                clear();
                statusBarLabel.setText(person.getSsn() + " Social Security Number has been updated successfully.");
            } else {
                statusBarLabel.setText("ERROR: " + person.getSsn() + " Update has not been Saved");

}
        }
    }
}

class RegisterUI_clearButton_actionAdapter
        implements java.awt.event.ActionListener {

RegisterUI adaptee;

RegisterUI_clearButton_actionAdapter(RegisterUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.clearButton_actionPerformed(e);
    }
}

class RegisterUI_saveButton_actionAdapter
        implements java.awt.event.ActionListener {

RegisterUI adaptee;

RegisterUI_saveButton_actionAdapter(RegisterUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.saveButton_actionPerformed(e);
    }
}

class RegisterUI_birthDateTextField_focusAdapter
        extends java.awt.event.FocusAdapter {

RegisterUI adaptee;

RegisterUI_birthDateTextField_focusAdapter(RegisterUI adaptee) {
        this.adaptee = adaptee;
    }

public void focusGained(FocusEvent e) {
        adaptee.birthDateTextField_focusGained(e);
    }

public void focusLost(FocusEvent e) {
        adaptee.birthDateTextField_focusLost(e);
    }
}

class RegisterUI_prTextField_focusAdapter
        extends java.awt.event.FocusAdapter {

RegisterUI adaptee;

RegisterUI_prTextField_focusAdapter(RegisterUI adaptee) {
        this.adaptee = adaptee;
    }

public void focusGained(FocusEvent e) {
        adaptee.prTextField_focusGained(e);
    }

public void focusLost(FocusEvent e) {
        adaptee.prTextField_focusLost(e);
    }
}

class RegisterUI_ssnTextField_focusAdapter extends java.awt.event.FocusAdapter {

RegisterUI adaptee;

RegisterUI_ssnTextField_focusAdapter(RegisterUI adaptee) {
        this.adaptee = adaptee;
    }

public void focusGained(FocusEvent e) {
        adaptee.ssnTextField_focusGained(e);
    }

public void focusLost(FocusEvent e) {
        adaptee.ssnTextField_focusLost(e);
    }
}

class RegisterUI_ssnTextField_keyAdapter extends java.awt.event.KeyAdapter {

RegisterUI adaptee;

RegisterUI_ssnTextField_keyAdapter(RegisterUI adaptee) {
        this.adaptee = adaptee;
    }

public void keyTyped(KeyEvent e) {
        adaptee.ssnTextField_keyTyped(e);
    }
}

class RegisterUI_deleteButton_actionAdapter implements java.awt.event.ActionListener {

RegisterUI adaptee;

RegisterUI_deleteButton_actionAdapter(RegisterUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.deleteButton_actionPerformed(e);
    }
}

class RegisterUI_updateButton_actionAdapter implements java.awt.event.ActionListener {

RegisterUI adaptee;

RegisterUI_updateButton_actionAdapter(RegisterUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.updateButton_actionPerformed(e);
    }
}

Class: BolderRaceUI.java

/*
 Class: BolderRaceUI
 Author: Shahrzad Jahangirian
 Date: March 14, 2014
 Description: This is the Bolder Race main Graphical User Interface. It is an
 * user friendly desktop look alike screen that a computer illiterate operator can
 * easily navigate different application options for use. It has large icons placed
 * on screen for easy access to different application functionality.
 */
package GUIpkg;

import javax.swing.*;
import java.awt.*;
import java.awt.*;
import java.awt.Color;

import commonPKG.FormatUI;
import PDpkg.ConnectDatabase;
import PDpkg.Race;
import PDpkg.Registration;
import PDpkg.Winner;
import Reportpkg.RaceReport;
import Reportpkg.ContactReport;
import Reportpkg.ParticipantReport;
//import GUIpkg.ReportSelector;
import java.awt.event.*;

public class BolderRaceUI
        extends JFrame {

private JMenuBar mainMenuBar = new JMenuBar();
    private JMenu fileMenu = new JMenu("File");
    private JMenuItem exitMenuItem = new JMenuItem("Exit");
    private JMenu participantMenu = new JMenu("Participant");
    private JMenuItem registerMenuItem = new JMenuItem("Register");
    private JMenuItem deleteMenuItem = new JMenuItem("Delete");
    private JMenuItem updateMenuItem = new JMenuItem("Update");
    private JMenu raceMenu = new JMenu("Race");
    private JMenuItem addRaceMenuItem = new JMenuItem("Add");
    private JMenuItem deleteRaceMenuItem = new JMenuItem("Delete");
    private JMenuItem updateRaceMenuItem = new JMenuItem("Update");
    private JMenu winnerMenu = new JMenu("Winner");
    private JMenuItem addWinnerMenuItem = new JMenuItem("Add");
    private JMenuItem deleteWinnerMenuItem = new JMenuItem("Delete");
    private JMenuItem updateWinnerMenuItem = new JMenuItem("Update");
    private JMenu reportMenu = new JMenu("Report");
    private JMenuItem raceReportMenuItem = new JMenuItem("Race Report");
    private JMenuItem contactReportMenuItem = new JMenuItem("Contact Report");
    private JMenuItem winnerReportMenuItem = new JMenuItem("Winner Report");
    private JMenuItem participantReportMenuItem = new JMenuItem("participant Report");
    private JToolBar mainToolBar = new JToolBar();
    private JButton registerButton;
    private JButton raceButton;
    private JButton winnerButton;
    private JButton reportButton;
    private JPanel bodyPanel = new JPanel();
    private ImageIcon appIcon = new ImageIcon("icons/bolder.png");
    private ImageIcon registerIcon = new ImageIcon("icons/register.png");
    private JLabel registerIconLabel = new JLabel("Participant", registerIcon, JLabel.CENTER);
    private ImageIcon raceIcon = new ImageIcon("icons/race.png");
    private JLabel raceIconLabel = new JLabel("Race", raceIcon, JLabel.CENTER);
    private ImageIcon winnerIcon = new ImageIcon("icons/winner.png");
    private JLabel winnerIconLabel = new JLabel("Winner", winnerIcon, JLabel.CENTER);
    private ImageIcon reportIcon = new ImageIcon("icons/report.png");
    private JLabel reportIconLabel = new JLabel("Report", reportIcon, JLabel.CENTER);
    private ImageIcon exitIcon = new ImageIcon("icons/exit.png");
    private JLabel exitIconLabel = new JLabel("EXIT", exitIcon, JLabel.CENTER);
    private JPanel statusBarPanel = new JPanel();
    private RegisterUI registerUI;
    private RaceUI raceUI = new RaceUI();
    private WinnerUI winnerUI = new WinnerUI();
    private ConnectDatabase connect = new ConnectDatabase();
    private FormatUI format = new FormatUI();
    private Race race = new Race();
    private Registration reg = new Registration();
    private Winner winner = new Winner();
    // private ReportSelector selector = new ReportSelector();

public BolderRaceUI() {
        try {
            jbInit();
        } catch (Exception e) {
            e.printStackTrace();
        }

}

public void jbInit() {

setupMenuBar();
        setupToolBar();
        bodyPanel = format.createBodyPanel(bodyPanel, 96, 104, 113, 800, 700);
        statusBarPanel = format.createStatusBar(statusBarPanel, 250, 250, 250, 800, 25);
        format.centerFrame(this);
        addListeners();
        addIcons();

this.setSize(800, 700);
        this.setExtendedState(Frame.MAXIMIZED_BOTH);
        this.setJMenuBar(mainMenuBar);
        this.getContentPane().setLayout(new BorderLayout());

this.getContentPane().add(mainToolBar, BorderLayout.PAGE_START);
        this.getContentPane().add(bodyPanel, BorderLayout.CENTER);
        this.getContentPane().add(statusBarPanel, BorderLayout.PAGE_END);
        this.getContentPane().setBackground(new Color(96, 104, 113));
        this.setIconImage(appIcon.getImage());
        this.setTitle("Bolder Boulder Races");
        this.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
        this.setResizable(true);
        this.setVisible(true);
    }

public void addIcons() {
        registerIconLabel = format.formatIconLabel(registerIconLabel, 50, 25, 250,
                125, 96, 104, 113, 250, 250, 250, "Arial", 1,
                14, JLabel.BOTTOM, JLabel.CENTER);
        raceIconLabel = format.formatIconLabel(raceIconLabel, 50, 150, 250,
                125, 96, 104, 113, 250, 250, 250, "Arial", 1,
                14, JLabel.BOTTOM, JLabel.CENTER);
        winnerIconLabel = format.formatIconLabel(winnerIconLabel, 50, 275, 250,
                125, 96, 104, 113, 250, 250, 250, "Arial", 1,
                14, JLabel.BOTTOM, JLabel.CENTER);
        reportIconLabel = format.formatIconLabel(reportIconLabel, 50, 400, 250,
                125, 96, 104, 113, 250, 250, 250, "Arial", 1,
                14, JLabel.BOTTOM, JLabel.CENTER);
        exitIconLabel = format.formatIconLabel(exitIconLabel, 400, 400, 250,
                125, 96, 104, 113, 250, 250, 250, "Arial", 1,
                14, JLabel.BOTTOM, JLabel.CENTER);

bodyPanel.add(registerIconLabel, null);
        bodyPanel.add(raceIconLabel, null);
        bodyPanel.add(winnerIconLabel, null);
        bodyPanel.add(reportIconLabel, null);
        bodyPanel.add(exitIconLabel, null);
    }

public void setupMenuBar() {
        mainMenuBar = format.formatJMenuBar(mainMenuBar, 0, 0, 792, 30, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        fileMenu = format.formatJMenu(fileMenu, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        exitMenuItem = format.formatJMenuItem(exitMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        fileMenu.add(exitMenuItem);

participantMenu = format.formatJMenu(participantMenu, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        registerMenuItem = format.formatJMenuItem(registerMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        updateMenuItem = format.formatJMenuItem(updateMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        deleteMenuItem = format.formatJMenuItem(deleteMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        participantMenu.add(registerMenuItem);
        participantMenu.add(updateMenuItem);
        participantMenu.add(deleteMenuItem);

raceMenu = format.formatJMenu(raceMenu, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        addRaceMenuItem = format.formatJMenuItem(addRaceMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        updateRaceMenuItem = format.formatJMenuItem(updateRaceMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        deleteRaceMenuItem = format.formatJMenuItem(deleteRaceMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        raceMenu.add(addRaceMenuItem);
        raceMenu.add(updateRaceMenuItem);
        //    raceMenu.add(deleteRaceMenuItem);

winnerMenu = format.formatJMenu(winnerMenu, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        addWinnerMenuItem = format.formatJMenuItem(addWinnerMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        updateWinnerMenuItem = format.formatJMenuItem(updateWinnerMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        deleteWinnerMenuItem = format.formatJMenuItem(deleteWinnerMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        winnerMenu.add(addWinnerMenuItem);
        winnerMenu.add(updateWinnerMenuItem);
        winnerMenu.add(deleteWinnerMenuItem);

reportMenu = format.formatJMenu(reportMenu, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        raceReportMenuItem = format.formatJMenuItem(raceReportMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        contactReportMenuItem = format.formatJMenuItem(contactReportMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        winnerReportMenuItem = format.formatJMenuItem(winnerReportMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        participantReportMenuItem = format.formatJMenuItem(participantReportMenuItem, 250, 250, 250, 96, 104, 113, "Arial", 0, 14);
        reportMenu.add(raceReportMenuItem);
        reportMenu.add(contactReportMenuItem);
        // reportMenu.add(winnerReportMenuItem);
        reportMenu.add(participantReportMenuItem);

mainMenuBar.add(fileMenu);
        mainMenuBar.add(participantMenu);
        mainMenuBar.add(raceMenu);
        mainMenuBar.add(winnerMenu);
        mainMenuBar.add(reportMenu);
    }

public void setupToolBar() {
        mainToolBar = format.formatJToolBar(mainToolBar, 250, 250, 250);
        registerButton = format.formatJToolBarButton(registerButton, "icons/register_th.png", 4,
                4, 4, 4, 1, 1, 1, 1, 250, 250, 250, false, false, "Register");
        raceButton = format.formatJToolBarButton(registerButton, "icons/race_th.png", 4,
                4, 4, 4, 1, 1, 1, 1, 250, 250, 250, false, false, "Race");
        winnerButton = format.formatJToolBarButton(registerButton, "icons/winner_th.png", 4,
                4, 4, 4, 1, 1, 1, 1, 250, 250, 250, false, false, "Winner");
        reportButton = format.formatJToolBarButton(registerButton, "icons/report_th.png", 4,
                4, 4, 4, 1, 1, 1, 1, 250, 250, 250, false, false, "Report");
        mainToolBar.add(registerButton);
        mainToolBar.add(raceButton);
        mainToolBar.add(winnerButton);
        mainToolBar.add(reportButton);
    }

public void addListeners() {
        exitMenuItem.addActionListener(new BolderRaceUI_exitMenuItem_actionAdapter(this));
        this.addWindowListener(new BolderRaceUI_this_windowAdapter(this));
        registerButton.addActionListener(new BolderRaceUI_registerButton_actionAdapter(this));
        registerIconLabel.addMouseListener(new BolderRaceUI_registerIconLabel_mouseAdapter(this));
        raceButton.addActionListener(new BolderRaceUI_raceButton_actionAdapter(this));
        winnerButton.addActionListener(new BolderRaceUI_winnerButton_actionAdapter(this));
        reportButton.addActionListener(new BolderRaceUI_reportButton_actionAdapter(this));
        raceIconLabel.addMouseListener(new BolderRaceUI_raceIconLabel_mouseAdapter(this));
        winnerIconLabel.addMouseListener(new BolderRaceUI_winnerIconLabel_mouseAdapter(this));
        reportIconLabel.addMouseListener(new BolderRaceUI_reportIconLabel_mouseAdapter(this));
        exitIconLabel.addMouseListener(new BolderRaceUI_exitIconLabel_mouseAdapter(this));
        registerMenuItem.addActionListener(new BolderRaceUI_registerMenuItem_actionAdapter(this));
        updateMenuItem.addActionListener(new BolderRaceUI_updateMenuItem_actionAdapter(this));
        deleteMenuItem.addActionListener(new BolderRaceUI_deleteMenuItem_actionAdapter(this));
        addRaceMenuItem.addActionListener(new BolderRaceUI_addRaceMenuItem_actionAdapter(this));
        updateRaceMenuItem.addActionListener(new BolderRaceUI_updateRaceMenuItem_actionAdapter(this));
        deleteRaceMenuItem.addActionListener(new BolderRaceUI_deleteRaceMenuItem_actionAdapter(this));
        addWinnerMenuItem.addActionListener(new BolderRaceUI_addWinnerMenuItem_actionAdapter(this));
        updateWinnerMenuItem.addActionListener(new BolderRaceUI_updateWinnerMenuItem_actionAdapter(this));
        deleteWinnerMenuItem.addActionListener(new BolderRaceUI_deleteWinnerMenuItem_actionAdapter(this));
        raceReportMenuItem.addActionListener(new BolderRaceUI_raceReportMenuItem_actionAdapter(this));
        contactReportMenuItem.addActionListener(new BolderRaceUI_contactReportMenuItem_actionAdapter(this));
        winnerReportMenuItem.addActionListener(new BolderRaceUI_winnerReportMenuItem_actionAdapter(this));
        participantReportMenuItem.addActionListener(new BolderRaceUI_participantReportMenuItem_actionAdapter(this));
    }

public int selectReport() {
        String[] options = new String[]{"Race Report", "Participant Report", "Contact Report"};
        int response = JOptionPane.showOptionDialog(null, "Select A Report", "Report Selector",
                JOptionPane.DEFAULT_OPTION, JOptionPane.PLAIN_MESSAGE,
                null, options, options[0]);
        return response;
    }

public void displayReport(int choice) {
        switch (choice) {
            case 0: {
                RaceReport racereport = new RaceReport();
            }
            break;
            case 1: {
                ParticipantReport parReport = new ParticipantReport();
            }
            break;
            case 2: {
                ContactReport contactreport = new ContactReport();
            }
            break;
        }
    }

public void displayRegScreen() {
        if (race.isRaceEmpty()) {
            JOptionPane.showMessageDialog(this, "Enter Race First, there is no Race in Database");
        } else {
            registerUI = new RegisterUI();
            registerUI.setVisible(true);
        }
    }

public void displayWinnerScreen() {
        if (race.isRaceEmpty()) {
            JOptionPane.showMessageDialog(this, "Enter Races, there is no Race in Database");
        } else if (reg.isParticipantEmpty()) {
            JOptionPane.showMessageDialog(this, "Enter Participants, there is no Participant in Database");
        } else {
            winnerUI.clear();
            winnerUI.setStatusBar("");
            winnerUI.setVisible(true);
        }
    }

void registerButton_actionPerformed(ActionEvent e) {
        displayRegScreen();
    }

void exitMenuItem_actionPerformed(ActionEvent e) {
        connect.closeAll();
        System.exit(0);
    }

void this_windowClosing(WindowEvent e) {
        connect.closeAll();
        System.exit(0);
    }

void registerIconLabel_mouseClicked(MouseEvent e) {
        displayRegScreen();
    }

void raceButton_actionPerformed(ActionEvent e) {
        addRace();
    }

void winnerButton_actionPerformed(ActionEvent e) {
        displayWinnerScreen();
    }

void reportButton_actionPerformed(ActionEvent e) {
        int option = selectReport();
        System.out.println(option);
        displayReport(option);
    }

void raceIconLabel_mouseClicked(MouseEvent e) {
        addRace();
    }

void winnerIconLabel_mouseClicked(MouseEvent e) {
        displayWinnerScreen();
    }

void reportIconLabel_mouseClicked(MouseEvent e) {
        int option = selectReport();
        System.out.println(option);
        displayReport(option);
    }

void exitIconLabel_mouseClicked(MouseEvent e) {
        connect.closeAll();
        System.exit(0);
    }

void registerMenuItem_actionPerformed(ActionEvent e) {
        displayRegScreen();
    }

void updateMenuItem_actionPerformed(ActionEvent e) {
        if (reg.isParticipantEmpty()) {
            JOptionPane.showMessageDialog(this, "There is no Participant to Update");
        } else {
            displayRegScreen();
            registerUI.clear();
            registerUI.setTitle("Update a Participant");
            registerUI.setStatusBar("Enter a Social Security Number to find and update a Participant");
            registerUI.setActionButtons(false, true, false, true);
            registerUI.setVisible(true);
        }
    }

void deleteMenuItem_actionPerformed(ActionEvent e) {
        if (reg.isParticipantEmpty()) {
            JOptionPane.showMessageDialog(this, "There is no Participant to Delete");
        } else {
            displayRegScreen();
            registerUI.clear();
            registerUI.setTitle("Delete a Participant");
            registerUI.setStatusBar(" Enter a Social Security Number to find and delete a Participant");
            registerUI.setActionButtons(false, true, true, false);
            registerUI.setVisible(true);
        }
    }

public void addRace() {
        raceUI.clear();
        raceUI.setTitle("Add a Race");
        raceUI.setStatusBar(" Add a Race Carefully, You can not delete a Race.");
        raceUI.setActionButtons(true, true, false, false);
        raceUI.setVisible(true);
    }

void addRaceMenuItem_actionPerformed(ActionEvent e) {
        addRace();
    }

void updateRaceMenuItem_actionPerformed(ActionEvent e) {
        if (race.isRaceEmpty()) {
            JOptionPane.showMessageDialog(this, "Enter Races, there is no Race in Database to Update");
        } else {
            raceUI.clear();
            raceUI.setTitle("Update a Race");
            raceUI.setStatusBar(" Enter a Race ID to update a Race");
            raceUI.setActionButtons(false, true, false, true);
            raceUI.setVisible(true);
        }
    }

void deleteRaceMenuItem_actionPerformed(ActionEvent e) {
        if (race.isRaceEmpty()) {
            JOptionPane.showMessageDialog(this, "Enter Races, there is no Race in Database to Delete");
        } else {
            raceUI.clear();
            raceUI.setTitle("Delete a Race");
            raceUI.setStatusBar("Enter a Race ID to delete a Race");
            raceUI.setActionButtons(false, true, true, false);
            raceUI.setVisible(true);
        }
    }

void addWinnerMenuItem_actionPerformed(ActionEvent e) {
        displayWinnerScreen();
    }

void updateWinnerMenuItem_actionPerformed(ActionEvent e) {
        if (winner.isWinnerEmpty()) {
            JOptionPane.showMessageDialog(this, "Enter Winners, there is no Winner in Database to Update");
        } else {
            winnerUI.clear();
            winnerUI.setTitle("Update a Winner");
            winnerUI.setStatusBar("Enter a Race ID & a Social Security Number to update a Winner");
            winnerUI.setActionButtons(false, true, false, true);
            winnerUI.setVisible(true);
        }
    }

void deleteWinnerMenuItem_actionPerformed(ActionEvent e) {
        if (winner.isWinnerEmpty()) {
            JOptionPane.showMessageDialog(this, "Enter Winners, there is no Winner in Database to Delete");
        } else {
            winnerUI.clear();
            winnerUI.setTitle("Delete a Winner");
            winnerUI.setStatusBar("Enter a Race ID & a Social Security Number to delete a Winner");
            winnerUI.setActionButtons(false, true, true, false);
            winnerUI.setVisible(true);
        }
    }

void raceReportMenuItem_actionPerformed(ActionEvent e) {
        RaceReport racereport = new RaceReport();
    }

void contactReportMenuItem_actionPerformed(ActionEvent e) {
        ContactReport contactreport = new ContactReport();
    }

void winnerReportMenuItem_actionPerformed(ActionEvent e) {
    }

void participantReportMenuItem_actionPerformed(ActionEvent e) {
        ParticipantReport parReport = new ParticipantReport();
    }
}

class BolderRaceUI_registerButton_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_registerButton_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.registerButton_actionPerformed(e);
    }
}

class BolderRaceUI_exitMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_exitMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.exitMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_this_windowAdapter extends java.awt.event.WindowAdapter {

BolderRaceUI adaptee;

BolderRaceUI_this_windowAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void windowClosing(WindowEvent e) {
        adaptee.this_windowClosing(e);
    }
}

class BolderRaceUI_registerIconLabel_mouseAdapter extends java.awt.event.MouseAdapter {

BolderRaceUI adaptee;

BolderRaceUI_registerIconLabel_mouseAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void mouseClicked(MouseEvent e) {
        adaptee.registerIconLabel_mouseClicked(e);
    }
}

class BolderRaceUI_raceButton_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_raceButton_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.raceButton_actionPerformed(e);
    }
}

class BolderRaceUI_winnerButton_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_winnerButton_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.winnerButton_actionPerformed(e);
    }
}

class BolderRaceUI_reportButton_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_reportButton_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.reportButton_actionPerformed(e);
    }
}

class BolderRaceUI_raceIconLabel_mouseAdapter extends java.awt.event.MouseAdapter {

BolderRaceUI adaptee;

BolderRaceUI_raceIconLabel_mouseAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void mouseClicked(MouseEvent e) {
        adaptee.raceIconLabel_mouseClicked(e);
    }
}

class BolderRaceUI_winnerIconLabel_mouseAdapter extends java.awt.event.MouseAdapter {

BolderRaceUI adaptee;

BolderRaceUI_winnerIconLabel_mouseAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void mouseClicked(MouseEvent e) {
        adaptee.winnerIconLabel_mouseClicked(e);
    }
}

class BolderRaceUI_reportIconLabel_mouseAdapter extends java.awt.event.MouseAdapter {

BolderRaceUI adaptee;

BolderRaceUI_reportIconLabel_mouseAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void mouseClicked(MouseEvent e) {
        adaptee.reportIconLabel_mouseClicked(e);
    }
}

class BolderRaceUI_exitIconLabel_mouseAdapter extends java.awt.event.MouseAdapter {

BolderRaceUI adaptee;

BolderRaceUI_exitIconLabel_mouseAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void mouseClicked(MouseEvent e) {
        adaptee.exitIconLabel_mouseClicked(e);
    }
}

class BolderRaceUI_registerMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_registerMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.registerMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_addRaceMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_addRaceMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.addRaceMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_addWinnerMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_addWinnerMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.addWinnerMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_updateMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_updateMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.updateMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_updateRaceMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_updateRaceMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.updateRaceMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_updateWinnerMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_updateWinnerMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.updateWinnerMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_deleteMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_deleteMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.deleteMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_deleteRaceMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_deleteRaceMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.deleteRaceMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_deleteWinnerMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_deleteWinnerMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.deleteWinnerMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_raceReportMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_raceReportMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.raceReportMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_contactReportMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_contactReportMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.contactReportMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_winnerReportMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_winnerReportMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.winnerReportMenuItem_actionPerformed(e);
    }
}

class BolderRaceUI_participantReportMenuItem_actionAdapter implements java.awt.event.ActionListener {

BolderRaceUI adaptee;

BolderRaceUI_participantReportMenuItem_actionAdapter(BolderRaceUI adaptee) {
        this.adaptee = adaptee;
    }

public void actionPerformed(ActionEvent e) {
        adaptee.participantReportMenuItem_actionPerformed(e);
    }
}

Class: BolderMain.java

Running Race Event Management Software - Part 3( Report) Part 1 (Registration) Part 2 (Race and Winner)

Running Race Event Management Software - Part 3( Report)
Part 1 (Registration)
Part 2 (Race and Winner)