Assignment 4: Servlets Due Date : Mon 8 Sep 2003 Your task is to create a registration system for a student workshop, using servlets and JDBC. The following features should be supported. 1) Anyone can register. No need for any authentication. Fields to be filled in: Name, email, department. Registration status is set to pending. Create a single relation with all the above columns. 2) Administrator can login using a password, and see all registrations. Can select any registration and change status to approved or rejected. Create a relation to store the password. The administrator interface could be simple (e.g. a form with a text box to enter an email id and a menu to select status), or more user friendly (list of all registrations with a menu for status which can be changed). Use sessions for this servlet, so the password has to be entered only once in a session. 3) Anyone can see a list of all registrations, along with status. You can provide some simple summary information if time permits. References : ~~~~~~~~~ 1) Servlet tutorial on the course web page 2) http://www.cs.bham.ac.uk/~tmw/servlet_tutorial/ 3) http://www.doofus.org/Java/Jeeves/servlet_tutorial/examples.html