Checking the results of a ResultSet

[Steve Dyke]

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(rs.next()) 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(rs.next()) which works great. How do I handle the empty while condition?

[Paul Clapham]

boolean recordsWereFound = false;
while (rs.next()) {
  recordsWereFound = true;
  // process this record;
}
if (! recordsWereFound) {
  // do this if no records were found
}