How to get row count using ResultSet in Java?

To get the row count using a ResultSet object in Java, you can use the last() method to move the cursor to the last row, and then use the getRow() method to get the row number:

ResultSet rs = statement.executeQuery("SELECT * FROM table");
int rowCount = rs.getRow();

Note that this approach is only accurate if the ResultSet object contains all the rows of the query result. If the ResultSet object is scrollable and does not contain all the rows, the row count may not be accurate.

Alternatively, you can use the getFetchSize() method to get the number of rows fetched from the database. This method returns the number of rows that are fetched from the database at a time when the ResultSet object is populated.

int rowCount = rs.getFetchSize();

I hope this helps. Let me know if you have any questions.