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