dispatch.jsp

这是用jsp技术编写的一个网上测试系统。

<%@page import="java.sql.*"%>
<%
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection conn=DriverManager.getConnection("jdbc:odbc:myAccess");
	Statement stmt=conn.createStatement();
	String sql="select pwd from sysuser where uid='" + request.getParameter("uid") + "' and usertype=" + request.getParameter("type");
	ResultSet rs=stmt.executeQuery(sql);
	if(!rs.next()){
		response.sendRedirect("error.jsp?info=uid error");
	}else{
		String pwd=request.getParameter("pwd");
		if(rs.getString("pwd").equals(pwd)){
			session.setAttribute("uid",request.getParameter("uid"));
			response.sendRedirect("teacher/main.jsp");
		}
		else
			response.sendRedirect("error.jsp?info=pwd error");
	}
	rs.close();
	conn.close();
%>