How get the number of rows count by ResultSet in Java

Question

I want to get the row count of a ResultSet.

ResultSet rs;
Statement s;
rs=s.executeQuery("SELECT * FROM mytable");

//rs.getRowCount; ???

You can also try looking at these similar articles: http://stackoverflow.com/questions/7886462/get-row-count-of-a-resultset-in-java http://stackoverflow.com/questions/8292256/get-number-of-rows-returned-by-resultset-in-java — Zexus, Aug 17 '14 at 17:02

score 3 · Accepted Answer · edited Sep 18 '19 at 20:33

3

You can go to the last row of the resultset and get the row number like this:

resultSet.last()
int count = resultSet.getRow()

But this is inefficient because it has to read all the table data. Better to execute the query:

SELECT COUNT(*) FROM mytable

edited Sep 18 '19 at 20:33

gtiwari333

answered Aug 17 '14 at 17:01

enrico.bacis

score 0 · Answer 2 · answered Aug 17 '14 at 17:01

0

I think we can get count as given below:

int size = 0;
try {
    while(rs.next()){
        size++;
    }
}
catch(Exception ex) { }

or we can use

ResultSet.getRow()

answered Aug 17 '14 at 17:01

Raj Bhatta

2 Answers2