In this lab you will build a java program that will act as a shipping
clerk's view of the data in the database. Your java program will run on
eagle and will connect to the database that lives on my machine
(192.168.150.49). You will use the database that you created and filled
in lab 1.
Wed Oct 26th
You are to build a graphical (Swing window based) java program which
will query your database and display information to the user, a
shipping clerk in the company. You will use JDBC and the mysql
connector software to access the database from your java application.
You only need to provide a means to view the data in this lab. In a
forthcoming lab you will update the database while enforcing integrity
The data shapshot that the clerk most needs is the ability to see each
order, including the name of the product that was ordered, the quantity
ordered, the first,middle and last name of the customer who made the
order and the shipping address of the order.
- You must provide a mechanism to select an order to be viewed
- Once the user has selected the order, all of the attendant
information should be updated in the GUI application.
A second view of the data that the shipping clerk needs is as follows:
The clerk should be able to type in a product name and have all of the
orders for that product (along with the name and state the order is to
be shipped to) appear in a list.
The user should be able to choose which ever view is needed at any
time. However, only one of the two views should be visible at any one
When your program is ready, you need to write a readme.txt file that
provides me the following information:
- Your name
- The name of your java files
- The implementation decisions that you made. Why did you solve the
problem the way that you did?
- Directions on running and using your program. What should I
expect when I start the program? Do I have to login? How do I switch
between the two views?
- And any problems or bugs left in your program. If your program
doesn't quite work in some situations, tell me about it. If your
program doesn't run or compile, I want to know that before I try.
Zipping your files
If you are in a directory called lab2 when you read this, move to
the parent folder/directory
(where the '..' means <parent directory> note that there is a
space between cd and ..)
now zip up the entire lab2 directory and send it to me.
zip -r lab2.zip lab2
This means zip up the entire lab1 directory (the -r flag says do
everything in the directory not just the directory itself) and put it
in a file called lab2.zip
Now prepare to email your lab to me.
type the following command
Pine is a terminal based email program. From eagle, you will only be
able to send mail to bridgew.edu email addresses. You will submit your
lab by email to me this semester. However you need to configure pine
the first time you use it.
- Type the 'S' key to choose the Setup menu item (or use your arrow
keys to select it and then press return)
- Type the 'C' key to choose the Config menu.
- Use the down arrow key twice to highlight the smtp-server
setting. You are now telling pine which server your mail is on.
- Type the 'c' key to change value. You will now see a prompt at
the bottom of your window.
- If you know what server you use to check mail, use that value.
Otherwise, type mailgate.bridgew.edu, which seems to work for nearly
all of my students.
- Now type 'e' to Exit setup. Pine will ask you if you wish to save
(commit) your changes. Answer 'y'
- You have now configured pine
Choose 'c' to compose a mail and send me a mail with the zip file of
your lab solution attached.