新人问题........

Question

rs=stm.executeQuery("SELECT * FROM students");
if(!rs.isAfterLast()){
while(rs.next())
{if((rs.getString(1).equals(name))&&(rs.getString(2).equals(pwd)))
{session.setAttribute("login", "OK");
response.sendRedirect("index.jsp");}}}else out.println("wrong");
为什么一打开就显示出"wrong"?

Answer 1

if(!rs.isAfterLast())这个不用写吧
然后else写到while ｛｝里面去和if对应着试试

Answer 2

rs=stm.executeQuery("SELECT * FROM students");
boolean hasData = false;
while(rs.next())
{
   if(!hasData)
   {
       hasData = true;
   }
   if((rs.getString(1).equals(name))&&(rs.getString(2).equals(pwd)))
   {
      session.setAttribute("login", "OK");
      response.sendRedirect("index.jsp");   }
}if(!hasData)
{
  out.println("wrong");
}