Your task is to design a scheduler for the Sheridan Rail Corporation which keeps track of all daily scheduled trips for the railway. Users can add new trips as well as perform searches (queries) on the scheduler based on departing city. The focus of this assignment is on JDBC, dynamic SQL using prepared statements, and object-relational mappings. This assignment is to be completed individually. Your submission must consist of a zip file containing your entire NetBeans project. You will NOT receive any program completeness marks if you only submit your .java files!
You are required to implement the following classes:
a) DBConnectionFactory.java - A class that manages connections to your database and associated resources. You must use this class to get connections to the database and close all JDBC objects.
See prog38081.lesson04.connectionfactory.DBConnectionFactory for an example.
b) Route.java - A class that models the Route table from the SheridanRail database. This class provides an object-relational mapping with the Route table and must have implementations for the following static method signatures:
c) SheridanRail.java - A Java main class that repeatedly does the following:
o 1 - List all flights by departing city o 2 - Add a new flight o 0 - Exit the program