WebRoot/logincheck.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import="com.util.DBO"%>
<%
request.setCharacterEncoding("gb2312");
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="";
System.out.println("qx=="+qx);

if(qx.equals("教师")){
sql="select * from jiaoshi where yhm='"+yhm+"' and mm='"+mm+"' ";
qx="教师";
}else if(qx.equals("学生")){
sql="select * from xuesheng where yhm='"+yhm+"' and mm='"+mm+"' ";
qx="学生";
}else if(qx.equals("管理员")){
sql="select * from gly where yhm='"+yhm+"' and mm='"+mm+"' ";
qx="管理员";
}



System.out.println("sql="+sql);
db.open();
ResultSet rs=db.query(sql);
out.println("<script>");
if(rs.next()){

session.setAttribute("yhm",rs.getString("yhm"));
session.setAttribute("mm",rs.getString("mm"));
session.setAttribute("qx",qx);
if(qx.equals("教师")){
session.setAttribute("id",rs.getString("jsid"));
}else if(qx.equals("学生")){
session.setAttribute("id",rs.getString("xsid"));
}else if(qx.equals("管理员")){
session.setAttribute("id",rs.getString("glyid"));
}



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