Testing for empty ResultSet

[Jason Stockmann]

I need to test to see if a returned resultset is empty in order to trigger a message being displayed...how do i test for an empty resultset?
(Need this ASAP if anyone can help!)
Thanks!

[James Swan]

Statement s = myConnection.createXXX();
ResultSet r = s.executeQuery("select * from XXX");
if (r.next()) {
    // we have some results
} else {
    // we have no results
}

[ June 25, 2002: Message edited by: James Swan ]

[Jason Stockmann]

OK, i tried this:

  rs.last();
  int numRows = rs.getRow();
  rs.beforeFirst();

and then using

   if (!rs.next())

but when i serve it up to my jsp, it displays it with one less row (the first i believe)...any suggestions anyone?

[James Swan]

Ok well rs.next() etc. actually moves the db cursor from its current position, so that why you are getting results off by 1.
How about trying something like this instead then:

boolean hasData = false;
ResultSet rs = ...;
while (rs.next()) {
    hasData = true;
    // process found records
}
if (!hasData) {
    // handle no data found
}