⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 schecktestpaper.jsp

📁 基于java的jsp开发的在线考试系统 基于java的jsp开发的在线考试系统
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="../Err.jsp" %>
<%@include file="../notLoginTuiChu.jsp"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<jsp:useBean id="ConnectBean" class="javaBeanClass.DatabaseConn" scope="page"/>
<link rel="stylesheet" href="../menu/css/ioa.css" type="text/css">
<%! String classId = null; %>
<%! String stuId = null; %>
<%! Connection con = null; %>
<% 
     classId = (String)session.getAttribute("classId");
	 stuId = (String)session.getAttribute("stuId");
	 if(classId==null||stuId==null){
	 	out.println("<div align='center'>会话失效!请重新登录!</div>");
		out.println("<div align='center'><a href='../../index.jsp'>返回登录页</a></div>");
		return;
	 }
	 con = ConnectBean.connectToDB();
	 CallableStatement stat = con.prepareCall("{?=call pr_readTestPaper(?,?)}");
	 stat.registerOutParameter(1,java.sql.Types.INTEGER);
	 stat.setInt(2,Integer.parseInt(stuId));
	 stat.setInt(3,Integer.parseInt(classId));
	 stat.executeUpdate();
	 int returnValue=stat.getInt(1);
	 if(returnValue==-1){
	 		throw new SQLException("该班尚无激活试卷!");
	 }
	 if(returnValue==-2){
	 		throw new SQLException("此次考试你已交卷!不能再次读取试卷!");
	 }
	 else{
			session.setAttribute("testIndexID",String.valueOf(returnValue));
			%>
			<html>
			<head>
			<title>检索激活试卷</title>
			</head>
			<body>
			<div align="center">开始考试请<a href="javascript:window.open('STest_View.jsp','TestMain','fullscreen,scrollbars');history.back();">点击此处</a>
			</div>
			</body>
	 		</html>
	<% } %>
	

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -