My apologies for providing this information so late.

If you can, please create a database named "phonebook" containing a table named phonebook, with columns name (as the primary key) and number. The names should include David Matuszek, John Smith, and Santa Claus. If you do this according to the directions below, I can use my own database, which will greatly simplify testing.

• Because this is so late, you may submit your program with your own database. My TA and I will do our best to install and use it. Please be sure your database is accessible by root with a blank password (the MySQL default).
  
  
• If you can, please use my database. I believe the adjustments to your program will be relatively minor. You do not need to turn in your copy of my database.
  
  
• The due date is extended by three days, to Monday, December 10.

Please collect all files (Tomcat's servlet directory, your client-side HTML and JavaScript, and possibly a database) into a single file, and zip it up to submit it via Blackboard.

• Several people have asked whether they should populate the database table dynamically, from the HTML page. That adds complexity, and I've tried to make the assignment as simple as possible, so there's no need to do this.
• So that we know what names to look up when we test , I had asked for the HTML to have a hard-wired pulldown list of names; that isn't necessary either, so long as there is some way to know what some of the names are, by looking at the HTML page.
• I'm not expecting "real" phone numbers.

I created this database and exported it, but didn't have time to figure out how to import it. Thanks to Mike Mattozzi and Daniel Sheiner for working this out. Here are the directions:

1. Make sure the MySQL server is running.
2. Create the database with: mysql -u root phonebook < create.sql
• The file create.sql is below
• This assumes you are in a directory where you can run mysql and access create.sql
3. Import the data with: mysql -u root phonebook < phonebook.sql
• The file phonebook.sql is below

Here is a link to the file create.sql, or you can copy and paste from the code below:

drop table if exists phonebook;
create table phonebook (
    name      varchar(30)    not null,
    number    varchar(15)    not null,
    primary key(name)
) engine=InnoDB;

Here is a link to the file phonebook.sql, or you can copy and paste from the code below:

# MySQL-Front 3.2  (Build 13.48)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES latin1 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='' */;


# Host: localhost    Database: phonebook
# ------------------------------------------------------
# Server version 4.1.9-max
INSERT INTO `phonebook` (`name`,`number`) VALUES ('David Matuszek','1-215-808-8122');
INSERT INTO `phonebook` (`name`,`number`) VALUES ('John Smith','555-1234');
INSERT INTO `phonebook` (`name`,`number`) VALUES ('John Doe','1-800-555-1212');
INSERT INTO `phonebook` (`name`,`number`) VALUES ('Mary Smith','1-900-123-4567');
INSERT INTO `phonebook` (`name`,`number`) VALUES ('Santa Claus','1-000-000-0001');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;