?? 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 + -