![Big Java Late Objects](https://www.bartleby.com/isbn_cover_images/9781119330455/9781119330455_largeCoverImage.gif)
Big Java Late Objects
2nd Edition
ISBN: 9781119330455
Author: Horstmann
Publisher: WILEY
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 23.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”...
Expert Solution & Answer
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Chapter 23 Solutions
Big Java Late Objects
Ch. 23.1 - Prob. 1SCCh. 23.1 - Prob. 2SCCh. 23.2 - Prob. 3SCCh. 23.2 - Prob. 4SCCh. 23.3 - Prob. 5SCCh. 23.3 - Prob. 6SCCh. 23.4 - Prob. 7SCCh. 23.4 - Prob. 8SCCh. 23.5 - Prob. 9SCCh. 23.5 - Prob. 10SC
Ch. 23.5 - Prob. 11SCCh. 23.5 - Prob. 12SCCh. 23 - Prob. 1RECh. 23 - Prob. 2RECh. 23 - Prob. 3RECh. 23 - Prob. 4RECh. 23 - Prob. 5RECh. 23 - Prob. 6RECh. 23 - Prob. 7RECh. 23 - Prob. 8RECh. 23 - Prob. 9RECh. 23 - Prob. 10RECh. 23 - Prob. 11RECh. 23 - Prob. 12RECh. 23 - Prob. 13RECh. 23 - Prob. 14RECh. 23 - Prob. 15RECh. 23 - Prob. 16RECh. 23 - Prob. 17RECh. 23 - Prob. 18RECh. 23 - Prob. 19RECh. 23 - Prob. 20RECh. 23 - Prob. 21RECh. 23 - Prob. 22RECh. 23 - Prob. 23RECh. 23 - Prob. 1PECh. 23 - Prob. 2PECh. 23 - Prob. 5PECh. 23 - Prob. 6PE
Knowledge Booster
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education