stu_permit.jsp

来自「网上考试系统文件版」· JSP 代码 · 共 57 行

<%@page import="java.lang.reflect.Array"%>
<%@page import="java.io.*"%>
<%@ page contentType="text/html;charset=GBK" import="java.sql.*" %>
<jsp:useBean id="Operate" scope="page" class="todb.Operate"/>
<%
String studentname=new String(request.getParameter("stuname").getBytes("ISO8859_1"));
String studentnum=new String(request.getParameter("stunum").getBytes("ISO8859_1"));
String studentpermit=new String(request.getParameter("stupermit").getBytes("ISO8859_1"));
ResultSet rs = null; 
String re="";

//获得结果集
rs = Operate.executeQuery("select * from student where student_name='"+studentname+"'&& student_num='"+studentnum+"'&&student_permit='"+studentpermit+"'");
if(rs.next()){
	String name=rs.getString("student_name");
    String stunum=rs.getString("student_num");
	String studentid=Integer.toString(rs.getInt("ID"));
		rs.close();
		
		//判断是否是第二次进入考试系统		
File file=new File("C:\\Tomcat 5.0\\webapps\\ROOT\\line\\sj");
if(file.isDirectory()){
//文件的建立、检查与删除
File f=new File(file,stunum+".txt");
File fl=new File(file,stunum+"l.txt");
		if(fl.exists())
		{
		out.println("<script language=javascript>");
		out.println("window.alert('该考生已经参加过考试，不能进入考试系统！');");
		out.println("location.href='stu_logon.jsp'");
		out.println("</script>");
		}
		else
		{
			if(f.exists()){	re="T";	}
			else  			{re="R";}
			
		session.setAttribute("retest",re);
		session.setAttribute("student",name);
        session.setAttribute("studentnum",stunum); 
		session.setAttribute("studentid",studentid);
		//out.println(session.getAttribute("retest"));
		response.sendRedirect("welcome.jsp");
		}
}
	}
else
	{
	rs.close();
	out.println("<script language=javascript>");
	out.println("window.alert('请正确输入学生姓名、学号和准考证号！');");
	out.println("location.href='stu_logon.jsp'");
	out.println("</script>");
	}
%>