CS4347 and CS6360 Project Phase 3

Write a Java program that does the following:

  1. Takes a date, meter ID (or customer ID and location), and meter reading and enters (updates in your meter reading table) that reading for the given date.  This program must perform error checking, such that if a reading already exists for that meter, the user gets a message.  Similarly, attempting to enter a reading for a nonexistent meter should give an error.  You may use either stored procedures or embedded SQL to do the database part of this.
  2. Allows you to look up a customer by Customer ID or first and last name.  While Customer IDs are unique, names are not, so if you do the latter lookup, your program should show the name, address, and Customer ID and allow the user to choose from a list for the next step.
  3. Once the program has looked up a Customer by Customer ID (or chosen one from the list) bring up all the customer information and allow the user to change it.  Also show the customer's current balance, if any. One common reason you will change this is if your customer moves to a new address. Allow changing anything but the primary key, in other words.

To hand in:

  1. The Java source code for your program.
  2. Screen shots in .JPG format showing the results of the above three operations on your database using at least two data elements.
  3. If you use stored procedures, please put them into a text file with a .SQL extension and include them.  If you use embedded SQL, that will be in your Java code.  Don't send a backup of your database.
  4. A text file with your expected letter grade on this phase of the project.

  • Grading:

    • Correctness 60%: The program must bring up the correct data and handle errors appropriately.
    • Documentation 10%:
    • Quality of the SQL statements in the code or stored procedures: 30 %.

    How to submit:

    • Name a .Zip file with the course number, your last name, and the assignment number.  For example, if I were submitting this it woud be CS6360ColeAsg3.zip.  Use WebCT only, please.  This will accept .Zip files.

    Due Date: April 28, 2009 at 11:00 PM.