how to get total number of rows contained in a resultset

  • Thread starter Praveen homkar via JavaKB.com
  • Start date
J

Joan

Praveen homkar via JavaKB.com said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top