Chapter 16.3, Problem 16.20CP

Explanation of Solution

ResultSet:

• The “SELECT” statement is been used for selecting data from a database.
• The result table is stored with data and is termed as “ResultSet”.
• A “ResultSet” object contains a set of rows as well as columns.
• All the fields present in table could be selected using “SELECT” statement.
• Specific fields can be selected by giving particular field names in “SELECT” statement.

Method to retrieve column 3 as a string:

• The method “getString(columnIndex)” of “ResultSet” object is invoked for retrieving “columnIndex” column as a String.
• Let “res” be a “ResultSet” class object.
• To retrieve column 3 as String from “ResultSet” object the method used is “res.getString(3)”.
• The method retrieves value of column 3 as a string...