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

Question

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

Answer 1

You can use any one of the following methods:

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 both cases, you don't have to loop over the entire data. 

If you want to learn Java, then enroll in this Java Certification Program by Intellipaat.