Search code examples
javasqljdbcresultsetrecord-count

How do I get the size of a java.sql.ResultSet?

Shouldn't this be a pretty straightforward operation? However, I see there's neither a size() nor length() method.

Solution

  • Do a SELECT COUNT(*) FROM ... query instead.

    OR

    int size =0;
if (rs != null) 
{
  rs.last();    // moves cursor to the last row
  size = rs.getRow(); // get row id 
}

    In either of the case, you won't have to loop over the entire data.