这样的条件该怎么写？

[Mszzc]

String s;

Connection cn = DriverManager.getConnection(url,user,password);
Statement st = cn.createStatement();
ResultSet rs = st.executeQuery("select name from table");


如果我要判断 s 在不在rs中，应该怎么写呢？

[takecare]

select "exist" from table where name like "%s%"

[takecare]

select 1 from table where name = s

[takecare]

while (rs.next())
{
if (rs.getString(1).equals(s))
return true;
}
return false;