登录用户及密码验证方法？

Question

这样改后不知有没有问题 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
 Connection  con=DriverManager.getConnection("jdbc:oracle:thin:@softice:1521:oracle","system","manager");
 Statement stmt=con.createStatement();
 ResultSet rst=stmt.executeQuery("select * from mbl where MMMM='aaaa'");String ret;
if(rst.next())
{
    ret=rst.getString("MMMM");
}if (yhm.equals(ret)){
    session.setAttribute("login","1");
    response.sendRedirect("ly.jsp");
    return;
}else{
    out.println("密码错误");
}

Answer 1

不用那么费事
select * from usertable where username=request.getP***(user) and password=request.getP***(Pass)if(rs.next)
{
成功
}else
{
失败
}

Answer 2

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@softice:1521:oracle","system","manager");
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("select * from mbl where user='aaaa'");
if(rst.next())
{
   String ret=rst.getString("pwd");
   if (yhm.equals(ret)){
      session.setAttribute("login","1");
      response.sendRedirect("ly.jsp");
   }else{
   out.println("密码错误");
   }
}

Answer 3

大家有代码发给我吧！[email protected]