Due Date: Tuesday, May 4

As usual, submit all work electronically. The database file must be named hw4.mdb (don't change the name!). You can download the Access 98 file here. Since the database file must be registered on my machine for your code to work, and I don't want to register the database many times, the path must be exactly the same for all students. The registration should be hw4.

You should also have two html files (hw6a.htm and hw6b.htm).

You should also have two java files (hw6a.java and hw6b.java).

The first HTML file should have a text field and a submit button. The text field allows the user to enter the name of a student. When the user clicks the submit button, the servlet hw6a is started. This servlet will respond with "No such student" if the student doesn't exist. The servlet will display the student's name, phone number, grade, homeroom, instrument ID, instrument, and teacher if the student does exist.

The second HTML button will have text fields (or other form elements) on it for a user to enter a name, phone, grade, homeroom, and instrument ID (use a number between 101 and 115). It also has a submit button that causes execution of the hw6b servlet. The servlet will insert a new record into the Students table - the record should also include today's date as the RentalDate. Don't worry about error checking.