Need to find record count in a resultset returned by a SQL query | Selenium Forum
  • Home
  • Forum
  • Selenium Forum
  • Need to find record count in a resultset returned by a SQL query
M
 Murali Katragadda Posted on 19/11/2019

I need to find the record count in a resultset returned by a SQL query...I don't want to use SQL query like Select count(*) from table_name. I need java code like

 

stmt = con.createStatement();

rs = stmt.executeQuery(query);
//rs.last();
//counter = rs.getRow();
while(rs.next()) {
counter = rs.getInt(0);

A

Instructor

Ashish Thakur Replied on 27/11/2019

This post discusses the same

https://stackoverflow.com/questions/8292256/get-number-of-rows-returned-by-resultset-in-java