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







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
What are separators in java? Separators help elaborates the structure of a program. The separators used within HelloWorld are parentheses, ( ) , braces, { } , the period, .

Differentiate between Primitives and Objects Everything in Java is an "Object", as every class by default inherits from class "Object", except a few primitive data t

Describe the relational operators in java? Java has six relational operators which compare two numbers and return a boolean value. The relational operators are , > , , >=

The IncludeAction class is useful when you require to integrate Struts into an application that uses Servlets. Use the IncludeAction class to contain another resource in the respon

What is ARPANET and who developed it? ARPANET stands for Advanced Research Projects. The initial reasons were to communicate along with and share computer resources between mainl

Problem statement Part 1 Write an aspect that counts different kinds of method calls in a Java program. Your aspect should meet the following requirements:  The aspect should ma

Assignment Your task in this assignment is to develop a Java program that can communicate with a real SMTP email server for sending emails. It should have a graphical user inter

I send you these files in order to make clear image about my task that I want you to design for me an application for PC that used to control robot arm via micro controller PIC18.

I want to know if you can help me with a javacard programming project

Having one instance overall the application.eg.: Loggers