How to get the number of rows from a JDBC ResultSet?

Question

I'm trying to get the row count from ResultSet/ResultSetMetaData but its not giving row count methods. Can anyone help to find the row count of resultSet?

I took all the value from database table Using selenium.

@ScaryWombat - Its not giving as list. Giving as ResultSet rs= statement.executeQuery(query); — tsr_qa, Feb 09 '18 at 08:46
Thanks for the revenge downvote. This kind of behavior really makes being on this site and helping such outstanding individuals as yourself worthwhile. — Oleg, Feb 09 '18 at 09:11

Senior Pomidor · Accepted Answer · 2018-02-09T08:51:47.367

2

resultSet.last();
int size = resultSet.getRow();
resultSet.beforeFirst();
System.out.println("row size is" + size);

But will be better to use SELECT COUNT(*) FROM table

edited Feb 09 '18 at 08:51

answered Feb 09 '18 at 08:48

Senior Pomidor

1,823
1
14
23

Its working ! Thanks. – tsr_qa Feb 09 '18 at 08:51

How to get the number of rows from a JDBC ResultSet?

1 Answers1