Assignment #14

AJAX Customer/Database Query System

Filenames: CustomerList.java, CustomerQuery.java

Write a servlet that lists all customers in the mislab mysql customer table. Your list should include only customer number and customer name, listed in a well-formatted table. Provide at least one additional cell to the right of the customer name in your table – you will display detail information for that customer via AJAX.

Respond to clicking on a table row by submitting an AJAX request for that customer's information (submit a request for your CustomerQuery servlet). Display all information about that customer in the cell to the right of the customer name in your table.

In your index.html, change the href in the anchor tag for this assignment to request your CustomerList servlet.