<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.sql.ResultSet" %>
<jsp:useBean id="Login" class="Common.DBConnect" scope="page"/>
<jsp:useBean id="MD5" scope="page" class="Common.MD5" />
<% request.setCharacterEncoding("gb2312");%>
<%
String SelectType=Login.inStr(request.getParameter("SelectType"));
String LoginID=Login.inStr(request.getParameter("loginid"));
String PSW=MD5.getMD5ofStr(request.getParameter("password"));
String sql="";
//out.print(PSW);
if(SelectType.equals("Teacher"))
{sql="select * from Teacher where TeaCode like '"+LoginID+"' and TeaPSW like '"+PSW+"'";
// out.print(sql);
}
if(SelectType.equals("Student"))
{sql="select * from Student where StuCode like '"+LoginID+"' and StuPSW like '"+PSW+"'";
// out.print(sql);
}
if(SelectType.equals("Admin"))
{sql="select * from Admin where AdminCode like '"+LoginID+"' and AdminPSW like '"+PSW+"'";
// out.print(sql);
}
ResultSet Rs=Login.executeQuery(sql);
try{
out.print(sql);
if(Rs.next())
{
out.print("验证成功");
if(SelectType.equals("Teacher")) {
session.setAttribute("TeaID",Rs.getString("TeaID"));
session.setAttribute("Name",Rs.getString("TeaName"));
}
if(SelectType.equals("Student"))
{session.setAttribute("StuID",Rs.getString("StuID"));
session.setAttribute("Name",Rs.getString("StuName"));
}
if(SelectType.equals("Admin"))
{session.setAttribute("AdminID",Rs.getString("AdminID"));
session.setAttribute("Name",Rs.getString("AdminName"));
}
session.setAttribute("SelectType",SelectType);
//out.print(session.getAttribute("TeaID"));
out.print("<script>alert('用户名登录成功!!!');window.location='Main.jsp'</script>");
}
else
{
out.print("验证失败");
out.print("<script>alert('用户名或密码错误!!!');window.location='index.htm'</script>");
}
}catch(Exception e)
{
e.printStackTrace();
}
finally{
try{
Rs.close();
Login.closeStmt();
Login.closeConn();
}catch(Exception e){
e.printStackTrace();
}
}
%>
执行到ResultSet Rs=Login.executeQuery(sql);出现问题 没能反倒sql 而是直接显示出选admin的sql语句 求助!