login_do.jsp

来自「校友录管理系统。校友进行注册」· JSP 代码 · 共 43 行

<%@page import="java.sql.*,java.io.*,school.*" contentType="text/html; charset=gb2312"  %>
<%
  String name = request.getParameter("name");
  String password = request.getParameter("password");
  %>
  <%String r=request.getParameter("check");
  session.setAttribute("error","0");
    Connection con = null;
    String ck=request.getParameter("check");
      if(ck.equals(session.getAttribute("rand"))){
        try {
          con=DataBaseConnection.getConnection();
          Statement statement = con.createStatement();
          String isCorrect = "select * from register  where name='" + name +
          "'and password='" + password + "'";
          ResultSet result = statement.executeQuery(isCorrect);
          session.setAttribute("isLogin", new String("0"));
          if (!result.next()) {
            session.setAttribute("error","2");
            response.sendRedirect("login.jsp");
            statement.close();
          }
          else {
            session.setAttribute("nickname",result.getString("name"));
            session.setAttribute("realname", result.getString("realname"));
            session.setAttribute("email", result.getString("email"));
            session.setAttribute("isLogin", new String("true"));
            session.setAttribute("level",(new Integer(result.getInt("level"))).toString());
            session.setAttribute("grade",(new Integer(result.getInt("grade"))).toString());
            statement.close();
            con.close();
            response.sendRedirect("viewAll");
          }
        }
        catch (Exception e) {
          out.println(e.toString());
        }
      }else{
        session.setAttribute("error","1");
         response.sendRedirect("login.jsp");
      }
%>