Race Report

Race Report

Participant Reportpg

Participant Report

Contact 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"

December 17, 2015: From today, I accept orders to develop small to medium size custom desktop applications.
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 (not used)
Class: FormatUI.java
Class: RaceUI.java
Class: WinnerUI.java
Class: RegisterUI.java
Class: BolderRaceUI.java
Class: BolderMain.java