check.jsp

JSP制作的图书管理系统

<%@ page language="java" import="java.util.*" pageEncoding="GB2312" errorPage="../error.jsp"%>
<jsp:useBean id="myRs" scope="page" class="utils.DBManager" />
<%
	String sql = null;
	java.sql.ResultSet rs = null;
%>
<%
request.setCharacterEncoding("GB2312");
String userid=request.getParameter("userid");
String password=request.getParameter("password");
out.println(password);
%>
<%  if(userid=="")response.sendRedirect("../index.jsp?error=2");
    sql="select * from users where userid='"+userid+"'";
    try{rs=myRs.executeQuery(sql);}
    catch (Exception e){e.printStackTrace();response.sendRedirect("../error.jsp");}
    while(rs.next()){   
    String p=rs.getString("password");
    Integer l=Integer.valueOf(rs.getInt("levels"));
    out.println(p);
    p=p.trim();
    password=password.trim();
    if(p.equals(password))
    {session.setAttribute("userid",userid);
     session.setAttribute("level",l);   
     response.sendRedirect("../Main.jsp");}   
    else response.sendRedirect("../index.jsp?error=1");
}
 %>