Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?

April 26, 2017API getcolumncount JDBC method rows similar

0

Posted

There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?

1 Answer

0

Posted

No, but it is easy to find the number of rows. If you are using a scrollable result set, rs, you can call the methods rs.last and then rs.getRow to find out how many rows rs has. If the result is not scrollable, you can either count the rows by iterating through the result set or get the number of rows by submitting a query with a COUNT column in the SELECT clause.