CS500 01                                       Assignment 3
Due 05/06/2008

Java Programming Project on PC/CS3

Design and develop GUIs with Java to process the data.

1. Java Client JFrame GUI

a. Write a Java GUI program using JFrame similar to the previous assignment 2.

b. Send the database query, insert, delete, and update requests to the Java server using TCP/IP socket.
Assume the server host name and port number are well known. Server will simply echo back the results to the client GUI window.

2. Java Server program

Write a Java server program (select and use a port number between 8000 and 9000) to accept the TCP/IP connection request and process the requests come from the client.

Run the Java client on a PC and Java server on cs1.

3. (Optional) Run Three-tier Java client/server/database system

a. Download the MySQL Connection/J JDBC driver on your subdirectory.
b. Make a database connection to the MySQL winestore database on cs3 using JDBC.
c. Start your server program on cs1
   - java -cp .:mysql-connector-java-3.1.7-bin.jar your-server-name
(the jar file should be at the same subdirectory as your server program)
d. Start your Java GUI client on a PC.
e. Read the request string from the client; parsing and process the database query or update request;
    send the response string back to the client.
f. Wait for processing the next request from the clients.
)

Assignment Hand-in Policy:

1. Write a MS word report that describes your development process, any problems that you have solved, and run results (with screen shots).
    Email the instructor the report and your Java source code files on the due day.

Instructor reserves the right to ask you demonstrate your programs in instructor's office if needed.