Chapter 24.4, Problem 8SC

Explanation of Solution

Efficient way to find the number of customers in Hawaii:

Consider the following query to know the number of customers in Hawaii:

//retrieving the customer’s data in Hawaii

ResultSet result = stat.executeQuery(

"SELECT COUNT(*) FROM Customer "

+ "WHERE State = 'HI'");

result.next();

int count = result.getInt(1);

Explanation:

In above query,

• The variable “result”, which represents the “ResultSet” object.
• The statement object “stat.executeQuery” retrieves the count of all data from the “Customer” table where “State” is equal to “HI”.
• After that, the method “result.next()” moves the cursor to the first row and read the numbers of customers in Hawaii using the “ResultSet” method “result.getInt(1)” and store the result into the variable “count”.
  • Here, the “getInt(1)” returns the element at the index “1”...