Chapter 5, Problem 2PE

Explanation of Solution

The Java method to display “ResultSet” as a table is given below,

“ResultSetTable()” method:

ResultSetTable(ResultSet rt) throws SQLException

{

    //Declare the variable for JDBC meta data

    ResultSetMetaData meta_data;

    //Declare the variable for number of columns in result

    int columns;

    //Get the meta data

    meta_data=rt.getMetaData();

    //Get the columns count

    columns=meta_data.getColumnCount();

    //Create "for" loop

    for (int i; i<=columns; i++)

    {

        //Get the column header and outputs them

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

    }

    //Print new line

    System.out.println();

    //Execute "while" loop for current record

    while(rt...