CIT 597 Assignment
9: Phone book Fall 2007, David Matuszek
Purposes of this assignment:
Introduce you to Ajax
Introduce you to JDBC
Give you more practice with servlets
General idea of the assignment:
Create an online phone book.
Details:
Use a MySQL database to hold several names and phone numbers.
Write a servlet that accepts a name and returns a phone number (only).
There is no need for either session management or JSP.
Write an HTML page that lets the select a name from a drop-down list.
Put your name on this page (so we know who we are grading).
Use Ajax to send the name to the server and get back the phone number.
Use the HTML DOM to display the number without refreshing the entire page.
You should have MySQL already installed (from the first assignment).
Download the Connector/J ZIP file from http://dev.mysql.com/downloads/connector/j/5.1.html. Unzip it, and put the jar file someplace appropriate (such as the Eclipse/plugins directory). Add this to your phone book project as an external jar.