how to find whether a result set is null or not

[vsorc]

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

[consultoriajava]

Use this sentence previously to rs.next():


if (rs!=null)
{
while(rs.next())
{
//Do whatever
}
}

Answer provided by http://www.consultoriajava.com