web/logincheck.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import="com.util.DBO"%>
<%
DBO db=new DBO();
request.setCharacterEncoding("gb2312");
String yhm=(String)request.getParameter("yhm");
String mm=(String)request.getParameter("mm");
    String qx=(String)request.getParameter("qx");

String sql="";

if(qx.equals("学生")) {
    sql = "select * from xuesheng where yhm='" + yhm + "' and mm='" + mm + "' ";
}

    if(qx.equals("管理员")) {
        sql = "select * from gly where yhm='" + yhm + "' and mm='" + mm + "' ";
    }
    if(qx.equals("超级管理员")) {
        sql = "select * from cjgly where yhm='" + yhm + "' and mm='" + mm + "' ";
    }

System.out.println("sql="+sql);
db.open();
ResultSet rs=db.query(sql);
out.println("<script>");
if(rs.next()){
    if(qx.equals("学生")) {
        session.setAttribute("id",rs.getString("xsid"));
    }

    if(qx.equals("管理员")) {
        session.setAttribute("id",rs.getString("glyid"));
    }
    if(qx.equals("超级管理员")) {
        session.setAttribute("id",rs.getString("cjglyid"));
    }


session.setAttribute("yhm",rs.getString("yhm"));
session.setAttribute("mm",rs.getString("mm"));
session.setAttribute("qx",qx);
;

out.println("alert('登录成功');");
out.println("window.location='index/index.jsp'");
}else{
out.println("alert('用户名或者密码错误');");
out.println("window.location='login.jsp'");
}
out.println("</script>");
%>