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

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

Ask an Expert

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

Write your message here..

Related Questions

Password Generator Software, In this exercise, I want you to generate passw... In this exercise, I want you to generate password based on random number generator. Develop an application that keeps track of the URL, username and password. I have listed few st

Online music store application, An online music store offers all songs for ... An online music store offers all songs for 3$ each. The store requires members to prepay any amount of money they wish, and then download as many songs accordingly. You are require

Describe what is meant by a constructor in java, Question: (a) Describe... Question: (a) Describe what is meant by a ‘constructor' in Java. Use a simple example to illustrate your answer. (b) Differentiate between a class method and an instance me

Java, 1. Which of the following are not valid Java identifiers, and why? (... 1. Which of the following are not valid Java identifiers, and why? (a) wolVes (b) United(there is only one) (c) 87 (d) 5 3 (e) Real ale (f) isFound?by 2. A class Television

Design a scheduler in java, Your task is to design a scheduler for the Sher... 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 sea

What is white space explain proper use of white space java, What is White S... What is White Space? explain proper use of white space in java? White space consists mainly of the space character in which you generates through hitting the space bar on your

What do you understand by java virtual machine, Java Programming 1. Wha... Java Programming 1. What do you understand by Java Virtual Machine? 2. Write a simple Java program to display a string message and explain the steps of compilation and execu

A java gui application, Design A Word document/ report containing pro... Design A Word document/ report containing program design documentation, including UML diagrams (Use case, class and sequence) and written descriptions of each class or module

How can you define a consistent web design, How can you define a consistent... How can you define a consistent web design? Why is it needed? A consistent web design should be the one in which achieves the result in which it was designed for, which result

Prepare a game in corona for android and ios, Prepare a Game in Corona for ... Prepare a Game in Corona for Android and IOS Project Description: We want to develop a game for mobile platform same as Zombie Smasher for iOS and Android. Everything is r