chklogin.jsp

来自「高校毕业生答辩安排管理系统」· JSP 代码 · 共 27 行

<%@page contentType="text/html;charset=gb2312"%>
<%@ include file="incoming/common.jsp"%>
<%	
	String userid = new String(request.getParameter("userid").trim().getBytes("ISO-8859-1"));
	String password = new String(request.getParameter("password").trim().getBytes("ISO-8859-1"));
	String sql = "SELECT * FROM student WHERE number='"+userid+"' AND pwd='"+password+"'";
 	DBSQLManager dbsm = new DBSQLManager();
 	dbsm.setSqlStr(sql);
	dbsm.executeQuery();
	ResultSet rs =  dbsm.getRs();
	if (!rs.next()) 
    	{
  		String errmsg="error1";
  		response.sendRedirect("login.jsp?errmsg="+errmsg);
  		return;
    	} 
 	request.getSession(true);
	String chk="true";
	String stu="ok";
	session.putValue("Enter",chk);
	session.putValue("student",stu);
	session.putValue("xuesheng",userid);
	response.sendRedirect("search.jsp");
	dbsm.close(); 

%>