Design a scheduler in java, JAVA Programming

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) - 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) - 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) - 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

Posted Date: 2/15/2013 6:08:47 AM | Location : United States

Related Discussions:- Design a scheduler in java, Assignment Help, Ask Question on Design a scheduler in java, Get Answer, Expert's Help, Design a scheduler in java Discussions

Write discussion on Design a scheduler in java
Your posts are moderated
Related Questions
API consumer -This application should consume a third party API -You should use more than just one method of the API, I'd like to see at least 3 or 4 -Have some concept

As registered nurses, we often wonder "am I responsible for the L.P.N's and the C.N.A. assigned on my floor.  Will I be blamed if someone makes an error or if someone gets hurt?  N

Fill in the necessary parts to create a GUI that uses the CardDeck class.  In your GUI you should have a text field for each hand, two buttons and a text area.   Your program s

Consider the following C++ template class. #include using namespace std; template class SortedList { public: SortedList() {size = 0;} void insert(T item); friend ostrea

What is an immutable object? An immutable object is one that we can't change once it's created. Steps involved in creation of an immutable object are: Make all of its data f

Java coding required Project Description: Need to develop a website. Require Java coders urgently. Skills required are Graphic Design, HTML, PHP, Java, Website Design

Develop a Graphical Display Framework Project Description: The intent of this project is to prepare a web based graphical display framework that will display many data points

Need Simple Desktop Software I am seeking a software that can do the subsequent: 1. Check position for a URL in Google, Yahoo, Bing. 2. Check position for a YouTube video

A final class will not be extended i.e. A final method cannot be overridden when its class is added. You can't modify value of a final variable.