CS500
01
Assignment 3
Due
Part I: Group Report of Lecture Notes and Textbook studied on Web
Development using Java
Write a Microsoft report to summarize your group Java study activities. The report must have the following.
1. The time and date of your group study and the topics covered in each study session.
2.
The group discussion summary of each topic studied.
3. Questions
and answers and any issues discussed in each study session.
4. Conclusions
of knowledge learned.
Email the report to the instructor
on the due day.
Part II: Java Programming Project on PC/cs1
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 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
know. 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.
(Extra credit:
3. 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 (screen shots).
Email the instructor the report and your Java source code
files on the due day.
2. Instructor may ask you to demonstrate your project to the instructor if needed.