Re: how to count exactly the rows of a ResulSet

From:

Martin Gregorie <martin@see.sig.for.address>

Newsgroups:

comp.lang.java.programmer

Date:

Wed, 27 Jun 2007 12:44:55 +0100

Message-ID:

<p6v9l4-463.ln1@zoogz.gregorie.org>

Mariano wrote:

On 27 Giu, 06:03, ben...@gmail.com wrote:

On Jun 26, 7:11 pm, Martin Gregorie <mar...@see.sig.for.address>
wrote:

Mariano wrote:

Then, i have this need, i use this method, it seems works fine, but
for this method there are no differences if the resulSet contain one
row or if resultSet is empty, method return always 1 to me. For
resultSet larger than one row it works perfectly.
This is my semi-functionant code:
public int rowCount(ResultSet r) throws SQLException {
        r.last();
        int rc = r.getRow();
        r.beforeFirst();
        return rc;
    }
How can I modify it, to have rc=0 if rs is empty, rc=1 if there is one
row in rs, and so on????
Thank u to all...
Regards

last() returns a boolean. Use it.
--
martin@ | Martin Gregorie
gregorie. | Essex, UK
org |

I was just looking through the docs,

isn't r.getFetchSize() what you're looking for?

--------
public int getFetchSize()
                 throws SQLException

    Retrieves the fetch size for this ResultSet object.

    Returns:
        the current fetch size for this ResultSet object

--------
Benhttp://www.plink-search.com

using getFetchSize() the result is always 1. Someone help me
pleaseeeeee

I already told you an answer which should work with only minor changes
to your current code. If you ignore return values from methods such as
last() then of course your code won't work.

Hint: last() returns false if the result set is empty.

A quick look at the ResultSet documentation shows that getFetchSize()
(the opposite of setFetchSize() BTW - there's a clue!) shows how many
rows are retrieved from the database at a time, not how many rows there
are in the result set. getResultSet() is NOT the answer to your problem.

--
martin@ | Martin Gregorie
gregorie. | Essex, UK
org |