devxlogo

Retrieve the rowCount Without Looping

Retrieve the rowCount Without Looping

Use this code to obtain the rowcount in JDBC without looping through the resultset.

    try    {      // Create a scrollable result set.      stmt = conn.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE,                                   ResultSet.CONCUR_READ_ONLY);      // Set a string with the query      sqlString = "SELECT .....";      rs = stmt.executeQuery(sqlString);      // Point to the last row in resultset.      rs.last();      // Get the row position which is also the number of rows in theresultset.      int rowcount = rs.getRow();      // Reposition at the beginning of the ResultSet to take up rs.next()call.      rs.beforeFirst();      ...      ....    }    catch(..)    {	..    }

devx-admin

Share the Post: