CS532 01                                                        Assignment 3

Due 04/26/2018

Part I:

1. Setting up the Apache Tomcat Server

Configure the TOMCAT web server (or any other web server that supports the JSP) for testing the JSPs and Custom tags.

2. Deploy and test the JSP

Deploy and test one simple JSP example and custom tag example from the TOMCAT web server page.

(Please read the lecture notes for setting up the JSP tag library.)

--------------------------------------------------------------------------------------------

Part II:

1. Develop JSP (Develop only the following 3 JSPs)

Design and develop Java JSPs to process the Book client requests.

1. Develop an index.jsp with the dbConnection JavaBean class to connect to the Book database.
 You may call the dbConnection from the index.jsp using <java:useBean ...> 
 (Use a Http session in the JSP to store the database login, password, and database connection.)

2. Develop a dbQuery.jsp to process the data query request from the client.

 You should try to create the similar GUI as in the previous assignments.
 The JSP should use a custom tag to process the data query from the database to hide the SQL operation details.
The custom tag/tags should use the same database connection object stored in the Http session.

3. Develop a dbUpdate.jsp to process the data update request from the client.

You should try to create the similar GUI as in the previous assignments.
The JSP should use a custom tag to process the data update from the database to hide the SQL operation details.  
 - The custom tag/tags should use the same database connection object stored in the Http session.

2. Deploy and Test the Three-Tier JSP Client-Servlet/Custom Tags Server-Database System

Combine the above into a three-tier client/application server/database application.

You should try to reuse the java code developed in assignment 1 and 2.

- Deploy your JSP project in a war file and test it in a TOMCAT web server and your Book database.

--------------------------------------------------------------------------------------------

Homework Hand in Policy:

- Write a MS Word report that describes your program reuse, development problems, and a set of screen shots with date info to show the major steps in develop and deploy the JSP.

Submit your report and all JSP and Java source code files in the drop box of the class SaKai web site.

- Demonstrate your system runs in the class on the due day.