aaa
String u =request.getParameter("username");
String p =request.getParameter("passwd");
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//得到链接
Connection ct =DriverManager.getConnection("jdbc:mysql://localhost:3306/goods",
"root","123");
//创建Statement
Statement sm=ct.createStatement();
//查询
ResultSet rs =sm.executeQuery("select passwd from user where username='"+u+"'");
//根据结果做判断
if(rs.next()){
//说明用户名存在
//再与输入的密码相比较
if(rs.getString(1).equals(p)){
//为合法用户
response.sendRedirect("wel.jsp?user="+u);
}
else{
//密码错误
response.sendRedirect("login.jsp?errNo=1");
}
}else{
//用户名都不存在
response.sendRedirect("login.jsp?errNo=2");
}
%>