?? exam2.jsp
字號:
<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="test.ConnOracle"/>
<%@ include file="/public/checkvalidstudent.jsp"%>
<%!
ResultSet rs = null; // 執行Sql語句返回的結果集
String sql = "";
String classid = "";
String classname = ""; // 測試班級名稱
int examtime = 0; // 考試時間
int total_question_in_paper; // 每份試卷中的考題數目
int total_paper_num=0; // 試卷總數
int paper_array[];
int curr_paperid=0; // 當前命中的試卷號
%>
<%
classid = request.getParameter("classid");
if(classid == null) {
out.println("系統錯誤, 無正確的班級ID號！");
return;
}
sql = "select * from test_classinfo where classid='" + classid + "'";
try {
rs = conn.executeQuery( sql );
}catch(Exception ee) {
out.println("<center>");
out.println("訪問課程信息出錯！請將以下信息告知系統管理員。<br>");
out.println(ee.toString() + "<br>");
out.println("<a href=javascript:history.back()>單擊這里返回</a>");
out.println("</center>");
}
if(!rs.next()) {
out.println("數據庫中沒有課程信息，無法進行考試！");
return;
}
classname = rs.getString("classname");
examtime = rs.getInt("totaltime");
total_question_in_paper = rs.getInt("totalques");
total_paper_num = rs.getInt("totalpaper");
// 下面從班級代碼為classid的試卷中隨機抽取一套，進行考試
sql = "select distinct paper_id from test_paper_info where classid='" + classid + "'";
rs = conn.executeQuery( sql );
if(!rs.next()) {
out.println("還沒有班級代號為 " + classid + " 的試題，請聯系管理員！");
return;
}
paper_array = new int[total_paper_num];
int index=0;
do{
paper_array[index++] = rs.getInt("paper_id");
}while(rs.next());
curr_paperid = paper_array[(int)Math.floor(Math.random()*total_paper_num)];
session.setAttribute("paperid",""+curr_paperid);
session.setAttribute("classid",""+classid);
sql = "select * from TEST_PAPER_INFO where paper_id=" + curr_paperid;
rs = conn.executeQuery( sql );
%>
<html>
<head>
<script language="JavaScript">
var hours
hours=0
var minutes
minutes=0
var seconds
seconds=1
function show1(){
var Digital=new Date()
var shours=Digital.getHours()
var sminutes=Digital.getMinutes()
var sseconds=Digital.getSeconds()
var dn="AM"
if (shours>12){
dn="PM"
shours=shours-12
}
if (shours==0)
shours=12
if (sminutes<=9)
sminutes="0"+sminutes
if (sseconds<=9)
sseconds="0"+sseconds
var sctime="<b><font face='Verdana' color='#8000FF'>"+shours+":"+sminutes+":"+sseconds+" "+dn+"</font></b>"
if (!document.all)
document.write(sctime)
else
tick1.innerHTML=sctime
}
function show2(){
seconds=parseInt(seconds)+1
minutes=parseInt(minutes)+0
hours=parseInt(hours)+0
if (parseInt(seconds)==60){
minutes=parseInt(minutes)+1
seconds=0
}
if (parseInt(minutes)==<%=examtime%>){
alert("考試時間到!")
document.form1.submit()
return;
}
if (parseInt(minutes)==60){
hours=parseInt(hours)+1
minutes=0
}
if (minutes<=9){
if (seconds<=9){
var ctime="<b><font face='Verdana' color='#8000FF'>0"+hours+":0"+minutes+":0"+seconds+"</font></b>"
}else{
var ctime="<b><font face='Verdana' color='#8000FF'>0"+hours+":0"+minutes+":"+seconds+"</font></b>"
}
}else{
if (seconds<=9){
var ctime="<b><font face='Verdana' color='#8000FF'>0"+hours+":"+minutes+":0"+seconds+"</font></b>"
}else{
var ctime="<b><font face='Verdana' color='#8000FF'>0"+hours+":"+minutes+":"+seconds+"</font></b>"
}
}
if (!document.all)
document.write(ctime)
else
tick2.innerHTML=ctime
}
function loadclock(){
if (document.all)
show1()
setInterval("show2()",1000)
}
if (!document.all)
show2()
</script>
<Script Language=javascript >
function Click(){
if(event.button==2){alert
('您不需要使用右鍵！');
}}
document.onmousedown=Click;
</Script>
<title>入學測試試題</title>
<link rel="stylesheet" href="../public/style.css">
</head>
<body bgcolor="#FFFFFF" onload="Javascript:loadclock()" background="../images/bg3.gif">
<center>
<table width="756" border="0">
<tr>
<td rowspan="2" valign="bottom"><b><font size="4" color="#FF0000"><%=classname%>入學測試</font></b>
</td>
<td width="125">
<div align="left"><b>考試時間</b>：<br>
<b><font face="Verdana" color="#8000FF" size="2"><%=examtime%> </font></b><font face="Verdana" color="#8000FF"><b>minutes</b></font></div>
</td>
<td width="125"> <b>開始時間</b>：<br>
<span id=tick1></span> </td>
<td width="125"> <b>使用時間:</b><br>
<span id=tick2></span> </td>
</tr>
</table>
<hr size="1">
<form name="form1" method="post" action="getscore.jsp" target="_top">
<table width="400" border="0" align="center">
<tr>
<td><%=classname%>入學測試</td>
</tr>
</table>
<%
int question_index=1;
int tmp_questionid=0;
while(rs.next()) {
tmp_questionid=rs.getInt("QUESTIONID");
%>
<table width="75%" border="0">
<%
if(rs.getInt("selectid")==1) {
%>
<tr>
<td width="15%" align="left" valign="top">答案</td>
<td width="85%"><%="<font color=blue>(" + question_index + ")</font> " + rs.getString("qname")%>(單選題)</td>
</tr>
<tr>
<td> <input type="radio" name="<%=tmp_questionid%>" value="A">A</td><td><%=rs.getString("choice1")%></td></tr>
<tr>
<td> <input type="radio" name="<%=tmp_questionid%>" value="B">B</td><td><%=rs.getString("choice2")%></td></tr>
<tr>
<td> <input type="radio" name="<%=tmp_questionid%>" value="C">C</td><td><%=rs.getString("choice3")%></td></tr>
<tr>
<td> <input type="radio" name="<%=tmp_questionid%>" value="D">D</td><td><%=rs.getString("choice4")%></td></tr>
<%
}else {
%>
<tr>
<td width="15%" align="left" valign="top">答案</td>
<td width="85%"><%="<font color=blue>(" + question_index + ")</font> " + rs.getString("qname")%><font color=red>(多選題)</font></td>
</tr>
<tr>
<td> <input type="checkbox" name="<%=tmp_questionid%>" value="A">A</td><td><%=rs.getString("choice1")%></td></tr>
<tr>
<td> <input type="checkbox" name="<%=tmp_questionid%>" value="B">B</td><td><%=rs.getString("choice2")%></td></tr>
<tr>
<td> <input type="checkbox" name="<%=tmp_questionid%>" value="C">C</td><td><%=rs.getString("choice3")%></td></tr>
<tr>
<td> <input type="checkbox" name="<%=tmp_questionid%>" value="D">D</td><td><%=rs.getString("choice4")%></td></tr>
<%}%>
</table><p></p>
<%
question_index++;
}
%>
<p align="center">
<input type="hidden" name="totaltime" value="0">
<input type="button" name="submita" value="提交答卷" onclick="JavaScript:subit()">
</p>
</form>
</center>
</body>
</html>
<script language="JavaScript">
function subit(){
if ((confirm("你確定提交試卷嗎？\n點“確定”提交，點“取消”返回檢查"))==true){
document.form1.totaltime.value = minutes;
document.form1.submit();
}
}
</script>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -