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

Multi treading array program, You are to write a program name arrayScaling....

You are to write a program name arrayScaling.java that will randomly generate 5000 integer number raging from 1 - 49 and place them in an array. 1.  The program will scale thi

Url instance and url connection instance, Difference between URL instance a...

Difference between URL instance and URL Connection instance? Ans) A URL instance shows the location of a resource, and a URL Connection instance shows a link for accessing or co

Kik messenger program, Kik Messenger is a plan mobile messenger like Skype....

Kik Messenger is a plan mobile messenger like Skype. It's available on each major smart phone for Android and Iphone. Here is the entire process: Could be able to add multipl

Introduction, the multiple of two number in java

the multiple of two number in java

Program to calculates the number of unique shapes, 1. Write the code for th...

1. Write the code for the method that calculates the number of unique shapes for a binary search tree with n nodes. Use the formula  where b n is the number of possible sh

How to prepare trial balnce reports, i m working on an accounting software ...

i m working on an accounting software and need the java code for preparing trial balance report

Programming, Byteland county is very famous for luminous jewels. Luminous j...

Byteland county is very famous for luminous jewels. Luminous jewels are used in making beautiful necklaces. A necklace consists of various luminous jewels of particular colour. Nec

Pattern printing program, Question Using 3 level of nested for loop, writ...

Question Using 3 level of nested for loop, write a program that will produce the output as below.

Basic difference between java and c++, Both Java and C++ use same syntax an...

Both Java and C++ use same syntax and are Object Oriented, but there are several differences between Java and C++:   1.    Java does not use pointers. Pointers are inherently

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