Count rows in JDBC ResultSet

Is there any method get the count of total number of rows retrieved from the ResultSet?
kulabhiAsked:
Who is Participating?
 
evijayConnect With a Mentor Commented:
There is no direct method to retrieve number of rows from ResultSet since the rows are fetched from database on demand.

The best way to solve this problem, is to maintain count the rows with the simple while loop

             count = 0;
             boolean more = rs.next ();
             while (more) {
                     // do the necessary saving/processing of the row here (since you may not get back this row after you call next
                    // for instance, you may add the row content in a vector

                     count ++;
                     more = rs.next ();
             }

            // now count has number of rows



You can control one thing. You can set the maximum number of rows in the result. by calling Statement.setMaxRows method.


0
All Courses

From novice to tech pro — start learning today.