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.
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
. Unzip it, and put the jar file someplace appropriate (such as the
directory). Add this to your phone book project as an external jar.
lectures for details.
Friday, December 7, before midnight. Zip up the servlet directory along with the HTML page, and submit via