Design a scheduler in java, JAVA Programming

Assignment Help:

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:

  • getRoutesByDepartingCity(String departing) - Returns an ArrayList of Route objects consisting of all routes that have a departing city matching the one supplied by the user.
  • addRoute(Route route) - Adds a new record to the Route table. It returns true if the new record was added successfully, false otherwise.

c)  SheridanRail.java - A Java main class that repeatedly does the following:

  • Prompts the user to enter one of the following options:

o  1 - List all flights by departing city
o  2 - Add a new flight
o  0 - Exit the program


Related Discussions:- Design a scheduler in java

Write a program to perform multiplication and division, Write a program to ...

Write a program to perform multiplication and division in java? Of course Java could also do multiplication and division. Because most keyboards don't have the times and divisi

What is setter methods explain with an example, What is Setter Methods expl...

What is Setter Methods explain with an example? Setter methods, also called as mutator methods, merely set the value of a field to a value specified through the argument to the

Describing service oriented architecture (soa)? , Service Oriented Architec...

Service Oriented Architecture Service Oriented Architecture (SOA) is an evolution of the fundamentals governing a component based development. Component based development gives

Ask to do it, Ask question #Minig cbhdsjamkvfdsk mum 100 words accepted#

Ask question #Minig cbhdsjamkvfdsk mum 100 words accepted#

Programming Excercise, I have to Create a program that determine the shippi...

I have to Create a program that determine the shipping cost for an order based on he following chart: From To Price $0.00 $19.99 $2.95 $20.00 $49.99 $3.95

Regex , Having trouble with a lab, need to

Having trouble with a lab, need to

Prepare simple spring maven task, Prepare Simple spring maven task Proje...

Prepare Simple spring maven task Project Description: We want a very simple delivery for one of our tasks using Spring STS Maven project. This chat does not have UI interf

Nelson-siegel parametric class of term structures, Since there are only a f...

Since there are only a finite number of bonds available in the market. There will always be "holes" to fill in when defining a yield curve in continuous time. A common approach is

Describe importing classes in java, Describe Importing Classes in java? ...

Describe Importing Classes in java? Fully qualified names such as java.net.URL are not the most convenient thing to have to type. You can use the shorter class names like URL w

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd