×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




hello,

i know that it's a bit off-topic, so please forgive me.

the problem is exactly the subject line:

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();
}

till now if i get an SQLException i guess the resultset is empty. but that
is not very good (in german: unbefriedigend).

how do i exactly figure out if the resultset is empty (no results for this
query)?

thanx in advance.


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.