APPLICATION: CarFax Application to look up and enter car records see image.

OBJECTIVE: Create a GUI DB Java Application

  • The applications should have the following classes

Class Description
Car Holds information about the Car object
CarFaxApp Application class starts up the application has the main method
CarFaxDB Database class. Has methods to load data from DB and save data to DB
CarFaxFrame Frame class has the UI design for the frame and controls
CarFaxValidator Validator class responsible for validating all data input

  • The application keeps track of cars by using their VIN number
  • You should be able to enter the following information

Field Datatype Validation
VIN String Has to be 5 chars (numbers + letters is ok)
MAKE String Cannot be blank
MODEL String Cannot be blank
YEAR Integer Has to be greater than 0

OPERATIONS:

Form Operations

  • Form loaded at start: You should read the records from the database and load them into the HashMap of the program. Display a welcome message (Welcome to Carfax App. XX cars have been loaded from the database).
  • Form closed at the end: When a form is closed it should save the data that the user has entered in the form from the HashMap car objects to the database. Display a closing message (Then you for using CarFax App. XX cars have been saved to the database)

Button Operations

  • ADD BUTTON: Adds the car object to the HashMap (DISPLAY SUCCESS OR FAILURE MESSAGE)
  • UPDATE BUTTON: Update the car object in the HashMap (DISPLAY SUCCESS OR FAILURE MESSAGE)
  • DELETE BUTTON: Delete the car object that the user selected from the HashMap (DISPLAY SUCCESS OR FAILURE MESSAGE)
  • CLEAR BUTTON: clear the fields on the GUI but not from the database
  • FIND BUTTON: The user enters the VIN number of the car to find. The program retrieve the car object matching the VIN number from the HashMap and displays it on the screen (DISPLAY SUCCESS OR FAILURE MESSAGE)

TEST DATA:

Operation VIN Make Model Year Result Screenshot
ADD Villi Honda Accord 2003 Y
ADD V2222 Acura Integra 2001 Y
ADD V3333 BMW 3251 2006 Y
ADD V4444 Mercedes CL320 2004 Y
ADD VSSSS Nissan 350Z 2005 Y
UPDATE V3333 SCION TC 2010 Y
UPDATE V4444 Mitsubishi Lancer 2012 Y
FIND V3333 Y
DELETE V2222 Y
FIND V2222 Y
ADD V1111 Acura Integra 2001 Y
ADD V2222 Acura Integra 2001 Y

Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.