Assignment 4

Due Date : Monday 27 August 5.00 PM (not friday, since you have a quiz)

Create an JDBC application having following facilities :

1. Consider the same schema as in the previous assignment, and suppose
   a user wants total sales grouped by the three attributes 
           product id, client city and salesman city
   Display the results formatted as an HTML table

2. Now take input from the user of the form
           [p='pid'] [c='ccity'] [s='scity']
    with each of these being optional.    
    For instance, the user may type
            p='3'  c='IIT Powai'
    or      s='Atlanta'
    Output as an HTML table all results of the previous query that match
    the extra selection above.  In each case, you should create and execute 
    an appropriate query.  You should print out the user specified selections 
    once, and print out only the other columns.

There is no need for using a graphical user interface, just plain 
ascii input/output is fine.   You can view the output using a browser
to verify correctness of the generated HTML.