Create a JSP/Servlet based application to maintain a Customer Table with the following specifications.

1. [2] The Customer Table has the following fields: ID, Name, Address, Amount_Due, Preferred_Status. Create 5 records manually have at least 2 preferred customers (DO NOT write java code to add data at this point)

2. [3] The GUI has radio button for Preferred_Status and uses text boxes for the rest.

3. [10] The user can Search, Add and Modify Customer information. The user always starts with a Search. if a customer does not exist, you can add one; if the customer exists, you can modify contents.

Search/Modify [Works - Coded not working - Not Attempted]

Add

4. [5] When the user comes back to use the system, the ID field should be filled with the ID of the last customer whose data was accessed.

5. [7] If the searched customers balance is less than $100, the background for the Modify form should be Red for customers with Preferred_Status of false. Otherwise, the background is always white. (accomplish using a bean).

6. [3] Get the connection string from web.xml