Author: Shahrzad Jahangirian
Language: Java (using Java 6) Download Java 6 and Download Java Runtime 6(JRE)
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"