Chapter 5, Problem 14E

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

Open Database Connectivity (ODBC) 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.
• To print the result in a tabular format with the attribute names as table header, this method executes a query “select * from r”...

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.out.println("");

            //create "for" loop

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

                //Print the column header

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

            //Print new line

            System.out.println("");

        }

        //Close the statement

        st.close();

        //close the connection

        con.close();

    }

    //Catch the exception if found

    catch(SQLException e)

    {

        //Handle the exception

        System...