Oh, I should have mentioned, that using simple SQL, you can also use the
COUNT operator to test how many rows will be returned. Like this:
select count(*) from employees where city='San Jose'
select * from employees where city='San Jose'
The first query will return a single row in its ResultSet that consists of
one Numeric value equal to the number of rows that the second query will
return (Assuming that no updates happen between the two invocations).
(*Chris*)
----- Original Message -----
From: Chris Pratt <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, June 28, 1999 2:42 PM
Subject: Re: Number of rows a query retrieved?
> In standard JDBC, there is no way to tell this before you have read the
last
> row. There are packages, like Village or Town, that do have this
> capability, but I have not tested them. You could also use a true OODB,
> like CloudScape, which has this type of capability.
> (*Chris*)
>
> ----- Original Message -----
> From: Xizhen Wang <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, June 28, 1999 12:44 AM
> Subject: Number of rows a query retrieved?
>
>
> > Hi! In jdbc, how to know the number of rows a query retrieved? Is there
> > a good way other than using ResultSet.next()?
> >
> > Thanks!
> >
> >
>
___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
