Project 2: JDBC Querying the Java Package Database

In this project, you will write SQL queries (as parameterized JDBC queries) that will process at minimum the following set of queries, where parameter values are underlined.  Note your program should be able to allow ANY string inputs for these parameters, not just the values shown below:

• what are the public methods defined in class Lit?
• what methods reference member print of a class Lit?
• in which package(s) is class ClassInfo defined?
• in what methods is member ltree referenced?
• what are the names of classses and interfaces that are in package foo?

In addition to non-transitive queries (above), there are also interesting transitive queries:

• What are the public methods of a class Add?
• What are the subclasses of class Exp?
• What members may be referenced when method run is invoked?

You will need to consult the notes on Oracle's recursive queries (see lecture notes).  I suggest that you debug your queries with SQL Developer before you start coding.

Test your queries on the database that is the union of the data from ClassReader.jar and EPL.jar, which you formed in the last assignment.

You must submit a Java command line program that prompts for (a) the specific query to be executed, (b) accepts parametric inputs to be given, and (c) outputs the tuples that satisfy the query.

Note: your programs must be runnable on machines in the microlab.  If they don't run there, you get no credit.