📄 schecktestpaper.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 + -