Version 1.0 - initial release

Version 1.1 - clarified selection by name behavior


Due Date: 11:59 PM, Sunday April 22nd
Late Period : 11:59 PM, Tueday, April 24th


Lab Assignment 5: Creating a GUI interface to a SQL Database

The purpose of this lab is for you:
  • To gain more experience with using a higher level language interface with SQL;
  • To create a user interface that connects to your Lab 4 database.


Description of the Task for Lab 5

The database used by this program is the same as the one used after running your Lab 4 Assignment. The purpose of this part of the assignment is to write a dynamic program based on responses of the student and input from the database.

Activities

  1. Create GUI that will work with your Lab 4 database (i.e. your Lab3 data, plus the data input into Lab4, to bring the checked out books current.

    1. It should first ask for the members id and verify that the member has a valid entry. If the id is not currently in the system, it should ask the questions to add the member. It should have a termination condition here as well.
    2. It should then ask for the book they want to check out. This can be done one of three ways.
      1. ISBN
      2. Name - this can be a partial name, if more than one name matches, allow the user to select.
      3. Author, then choosing from a list of books by that author
    3. If the libraries have the book and there are copies available, the program should print a message telling the member what library and shelf the book is on (there may be more than one).
    4. If either library has the book and all copies are checked out, the program should print a message to the member that all copies are currently checked out.
    5. If neither library has the book, a message telling the member that the library does not currently have the book in stock.
    6. Note: this system is providing info only, do not check the book out as a part of these actions.
    7. Loop back to ask for the next member's id

  2. You may use any windowing package you choose to implement your GUI. You MUST ensure this code will run on the state capital machines talking to faure so the TA can grade your code. Here is a simple example of a program that does windowing. Here is a writeup for doing port forwarding on Windows and here is one for Ubuntu.

  3. For this assignment, you will need to submit your Lab5.java file.

    It is preferable that you include a README file. This file should explain how to run your program, especially if you have done something you expect may be different from other submissions or that may require special instructions for compilation and execution.



Submitting Your Assignment

Your database should be restored to initial state (end of L4) so your programs can be graded.
Submit
  • your Lab5.java file
  • any other required *.java files
  • your README file, if needed

using the Canvas CS 430 DL Assignment Submission icon
shown on the Canvas CS 430 DL Assignments page.

This is Lab Assignment 5.

References

http://www.kitebird.com/articles/jdbc.html#TOC_4.

http://www.developer.com/java/data/article.php/3417381.

Late Policy

Late programs are subject to a 20% late penalty.

For more information on SQL

Refer to http://dev.mysql.com/doc/mysql/en/ for the online MySQL Reference Manual, as well as information on downloading MySQL onto your own machine.

Please let us know if there are any obvious errors in this writeup.