Chapter 15, Problem 16AW

Explanation of Solution

Result set:

• The “SELECT” statement is been used for selecting data from a database.
• The result table is stored with data and is termed as result set.
• 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.

Example:

The example for computing “ResultSet” statement is shown below:

ResultSet res = stmt.executeQuery(sql)

Here, “stmt” denotes a valid “Statement” object and “sql” denotes a SQL statement...