about Null in ResultSet

[saravana kumar]

hi friends,
i needs ur help. how to check wheather Result is null or Not.i have written a query which is selecting data from table with one condition. if there is none of a record satisfied the condition it should be returned null. how to check that one? any one knows please let me know with example.

thanks a lot friends...
saran

[sandeep balyan]

use
if(ResultSet.next())
{
do this
}
else
{
do that
}

njoy
regds

[Nandkishore Dhilde]

or you can do after firing query
int rowcount = rs.getRow(); //rs is ResultSet object
if(rowcount ==0) // then ur query returns null result and if more than 0 then go for rs.next()