teacher_permit.jsp

网上考试系统文件版

<%@ page contentType="text/html;charset=GBK" import="java.sql.*" %>
<jsp:useBean id="Operate" scope="page" class="todb.Operate"/>
<%
String teachername=new String(request.getParameter("teachername").getBytes("ISO8859_1"));
String password=new String(request.getParameter("password").getBytes("ISO8859_1"));

String sql="select * from teacher where teacher_name='"+teachername+"'&& teacher_password='"+password+"'";
ResultSet rs =Operate.executeQuery(sql);

	if(rs.next()){
		rs.close();
		session.setAttribute("admin","admin"); 
		response.sendRedirect("admin_index.jsp");
		}
	else
	{
	rs.close();
	out.println("<script language=javascript>");
	out.println("window.alert('用户名和密码错误！');");
	out.println("location.href='teacher_login.jsp'");
	out.println("</script>");
	}
%>