Chapter 16, Problem 3FTE

Explanation of Solution

Given SQL statement:

String sql = “SELECT * FROM Coffee”;

Statement stmt = conn.createStatement();

ResultSet result = stmt.execute(sql);

executeQuery:

• The “executeQuery” method returns one “ResultSet” object.
• It runs given SQL statement and returns a single object.
• It combines the functionality of “execute()” and “getResultSet()” methods in single call.
• A “ResultSet” has accessor method set that allows to return data from database.

Example:

The example for “executeQuery” statement is shown below:

executeQuery(sqlStatement);

Here, “sqlStatement” denotes SQL statement...