This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Checking the results of a ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Checking the results of a ResultSet" Watch "Checking the results of a ResultSet" New topic

Checking the results of a ResultSet

Steve Dyke
Ranch Hand

Joined: Nov 16, 2004
Posts: 1541
I am making a connection to a remote data table. 9 times out of ten I expect to return more than one record. To get my result I use the while( function. But how do I check to see if there are no records returned. In situations where only one record is expected I use if( which works great. How do I handle the empty while condition?
Paul Clapham

Joined: Oct 14, 2005
Posts: 19719

I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Checking the results of a ResultSet
It's not a secret anymore!