Chapter 5, Problem 13E

a.

Explanation of Solution

To print the result as a tabular format:

• Given that the method “static void printTable(String r)” is contained in a class “MetaDisplay”.
• A relation name “r” is considered as the input to this method...

b.

Explanation of Solution

Java Database Connectivity (JDBC) methods:

• Given that the method “static void printTable(String r)” is contained in a class “MetaDisplay”.
• A relation name “r” is considered as the input to this method...

c.

Explanation of Solution

 “static void printTable(String r)” method:

The Java method “printTable(String r)” using JDBC Application Programming Interface (API) is given below,

//Define a method

static void printTable(String r)

{

    //Execute "try" block

    try

    {

/*Call the method to return the objects of the class with the given string name*/

        Class.forName("oraclejdbc.driver.OracleDriver");

        //Connect the database

Connection con=DriverManager.getConnecction("Jdbc:oracle:thin:@db.bnd:2001:bnddb",user,password);

/*Create Statement object to send SQL statements to the database*/

        Statement st=con.createStatement();

        //Execute select query

        ResultSet rst=st.executeQuery(r);

        //Get the metadata

        ResultSetMetaData meta_data=rst.getMetaData();

        //Get the column count from the database

        int cnt=meta_data.getColumnCount();

        //Print new line

        System.out.println("");

  //Create “for” loop

  for(int i; i<cnt; i++)

  //Print column header

System.out.println(""+meta_data.getColumnName(i)+"");

        //Print new line

        System.out.println("");

        //Execute "while" loop for current record

        while(rst.next())

        {

            //Print new line

            System...