how get length or size of Resultset in java [duplicate]

Question

I want to know how many rows in result set after executing the particular query

ResultSet rs = ps.executeQuery();

how get the size of rs??? thanx in advance

Answer 1

If you just want the number of rows in the ResultSet, you can do :

int size= 0;
if (rs != null)   
{  
  rs.beforeFirst();  
  rs.last();  
  size = rs.getRow();  
}  

Answer 2

by doing while loop:

int size=0;
while (rs.next()) {
    size++;
}