Lab/Program Assignment 5
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.
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.
- 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.
- 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.
- It should then ask for the book they
want to check out. This can be done one of three ways.
- Name - this can be a partial name, if more than one name matches, allow the user to select.
- Author, then choosing from a list of books by that author
- 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).
- 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.
- If neither library has the book, a message telling the member that the library does not currently have the book in stock.
- Note: this system is providing info only, do not check the book out as a part of these actions.
- Loop back to ask for the next member's id
- 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.
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.
- 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.
Description of the Task for Lab 5
Submitting Your Assignment
- Your database should be restored to initial state (end of L4) so your
programs can be graded.
- 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.
- 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.