Assignment 5

			       Date : Friday 31 Aug, 2001

			     Due Date : Monday 10 Sep, 5.00 PM.

Write an application having the following features using servlets & JDBC :

1. When a user first connects (new session), ask for a userid and
   password and check if it is valid by looking up a table (also create this
   table with sample data).  

2. If a user is authenticated, then (and only then) show a page with
   two options, and execute whatever option the user chooses.

    a) Show database schema:
         Print out all relations in the database along with their attribute
         names and types.  Use JDBC metadata features to do this.

    b) Take an arbitrary query (assume its not an update), execute it 
       and show the result as a HTML table.  
       Use the JDBC metadata features for formatting the table output.

3.  Provide for a logout button on each screen, and also a timeout of say 
    10 minutes for sessions.

References :
~~~~~~~~~~

1) Servlet tutorial on the course web page

2) http://jserv.java.sun.com/products/java-server/documentation/webserver1.1/servlets/servlet_tutorial.html

3) http://www.cs.bham.ac.uk/~tmw/servlet_tutorial/

4) http://www.doofus.org/Java/Jeeves/servlet_tutorial/examples.html