WebRoot/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 kehu where yhm='"+yhm+"' and mm='"+mm+"' ";

}else if(qx.equals("商家")){
sql="select * from shangjia where yhm='"+yhm+"' and mm='"+mm+"' ";
}else{
sql="select * from admin 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("khid"));
}else if(qx.equals("商家")){
session.setAttribute("id",rs.getString("sjid"));
}

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

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