how to get total number of rows contained in a resultset  
Author Message
Praveen homkar via JavaKB.com





PostPosted: 2005-8-5 18:33:00 Top

java-programmer, how to get total number of rows contained in a resultset Hi friends

how to get the number of rows contained in filteredrowset or a simple
resultset.

Thanx in advance

praveen

--
praveen homkar


Message posted via JavaKB.com
http://www.javakb.com/Uwe/Forums.aspx/java-general/200508/1
 
Joan





PostPosted: 2005-8-6 0:58:00 Top

java-programmer >> how to get total number of rows contained in a resultset
"Praveen homkar via JavaKB.com" <email***@***.com> wrote in
message news:email***@***.com...
> Hi friends
>
> how to get the number of rows contained in filteredrowset or a
> simple
> resultset.
>
> Thanx in advance
>
> praveen

for MySQL
rec = st.getResultSet();
d.numCols = rec.getMetaData().getColumnCount();
rec.last(); // move to last row
d.numRows = rec.getRow();
rec.beforeFirst(); // reset to top