Class: MetaData.java
Class: Participant.java
Class: ConnectionDB.java
Class: ConnectDatabase.java
Class: ParticipantDB.java
Class: Registration.java
Class: FormatUI.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
Date Added: April 5, 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.
Description: This month 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. In part 1 you find all source codes for
creating the Database, Desktop screen, and Registration Data Entry screen with all functionality to
Add, Update, and Delete a Bolder Boulder Race participant. In part 2 and 3 I will develop the Race, Winner, and Report sections.
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 you can download MySQL Installer 5.6.17 (234.7M) from
http://dev.mysql.com/downloads/windows/installer/
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.
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. (as above image)
Then use a .bat file or compile following files on command prompt in exact following orders
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 ParticipantDB.java -d c:\javacodes
C:\javacodes> javac Registration.java -d c:\javacodes
C:\javacodes> javac FormatUI.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"