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