File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Meteor in Action
this week in the
JDBC and Relational Databases
total records in a result set
Joined: Aug 26, 2000
Mar 12, 2001 23:18:00
How to get the total no. of records present in a resultset?
and is there any limit on the number of records in a resultset?
Joined: Feb 01, 2001
Mar 13, 2001 06:29:00
Use ResultSet.last() which will move to the last row and then use ResultSet.getRow() which will return the row number (number of rows). This is available in
2.0 and above, and this cannot be a FORWARD_ONLY cursor.
Hope this helps.
I agree. Here's the link:
subject: total records in a result set
Is it possible to get rowCount from ResultSet Object?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015