Re: howto figure out if ResultSet is empty

thanx. helped me a lot.

On 2002.08.09 12:15 "McCallion, Martin" wrote:
> Mihael Knezevic wrote:
>
> > howto figure out if ResultSet is empty ?
> >
> > my code looks like this:
> >
> > Statement statement;
> > ResultSet rs;
> >
> > String stm = "Select xxx from xxx.xxx where xxx";
> >
> > rs = statement.executeQuery(stm);
> >
> > while(rs.next())
> > {
> >     do.something();
> > }
>
> I'm not entirely sure, but I think that if no rows are returned, rather
> than an empty ResultSet you get a null one; so just test it for null
> first.  As well as that, if there is no row available (presumably, even
> if there are no rows to begin with) next() should return false.
>
> Cheers,
>
> Martin.
>
> --
> Martin McCallion
> Senior Technical Consultant
> Work:  martin.mccallion@misys.com
> Home: martin.mccallion@ukonline.co.uk
> Misys International Banking Systems
> 1 St George's Road, London, SW19 4DR, UK
> T +44 (0)20 8486 1951
> F +44 (0) 20 8947 3373
> www.misys.com
> This email message is intended for the named recipient only. It may be
> privileged and/or confidential. If you are not the  intended named
> recipient of this email then you should not  copy it or use it for any
> purpose, nor disclose its contents to any other person. You should
> contact Misys International Banking Systems as shown below so that we
> can take appropriate action at no cost to yourself.
> Misys International Banking Systems Ltd,1 St
> George's Road, London, SW19 4DR, UK. Email: ibs.postmaster@misys.com.
> Tel: +44 (0) 20 8879 1188 Fax: +44 (0) 20 8947 3373
> Misys International Banking Systems Ltd is
> registered in England and Wales under company no. 971479
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L) mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>