Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How to find out a total # of rows in a ResultSet object??

Posted on 2002-03-31
1
151 Views
Last Modified: 2012-05-04
Hi Guys,

   It seems ResultSet object does not have any member function to find out total number of rows??

stephen
0
Comment
Question by:zollen
1 Comment
 
LVL 35

Accepted Solution

by:
girionis earned 50 total points
ID: 6909686
 No there is not but you can always move to the last row in the ResultSet by using the last() method and get the count by calling the getRow() method straight after you move to the last row. This will give you the total number of rows. You have to define your ResultSet to be scrollable though (if you want to go back) by using the static TYPE_SCROLL_SENSITIVE.

  Hope it helps.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Viewers learn about the “while” loop and how to utilize it correctly in Java. Additionally, viewers begin exploring how to include conditional statements within a while loop and avoid an endless loop. Define While Loop: Basic Example: Explanatio…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question