how to find whether a result set is null or not
hi guys...i am new to jsp...does any one know how to detect whether a result set in null or not....here i was writing a small prog on jsp..and in that prog i hve to check for a value which is there in the database or not..i hve executed the query using
rs=statement.executeQuery("SELECT * from user_accounts WHERE id='"+record_id+"'");
here record_id id the primery key
and i hve written a statement
try
{
rs.next();
}catch(SQLException e)
{
flag=true;
}
and sometimes it doest works that is it doesnt detects if the result set is null
is the any other way to the same procedure