Very easy html coding using Netbean IDE(10 minutes work):

Part 1: Use Java Derby database to create a database named CRM with a Customer table that has the following fields:

 

 CID: text with 10 spaces.  This is the key field of the customer table.

 Cname: text with 30 spaces.

 City: text with 30 spaces.

 Rating: text with 1 character.  This field has three possible values: A, B, C. 

 Email: text with 40 spaces

 

  You should enter about 5 records.

 

Part 2: Create a website with the following pages:

 

Home page:  This page contains three links:

 

1.      Show Selected Customer Data: This link opens a jsp page that creates a form with a listbox containing all the CIDs retrieved from the Customer table.  Then it will call a jsp page to show the selected customer’s detailed information in textboxes.

2.      Show Customers of a Selected Rating: This link opens a HTML page with a form that has a group of three radio buttons to select a rating A, B or C.  Then it calls a jsp page to show customers of the selected rating in a table.

 

All the jsp pages must have a link to navigate back to the home page:

Submit page views of all pages, and source code of all jsp pages.

 

 

You may use HTML List to organize links as code below:

 

<ul>

        <li><a >Show Selected Customer's Data </a></li> 

        <li> <a >Show Customers of Selected Rating</a></li>   

</ul>