?? sp2.jsp
字號(hào):
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>學(xué)生試卷</title>
<script language="JavaScript">
var intLeft =7;
function leavePage()
{
if (intLeft==20)
{
window.alert("時(shí)間到了，請(qǐng)交卷，如果沒有交卷，為空白卷");
}
if (intLeft==5)
{
window.alert("時(shí)間到了，考試結(jié)束!!");
}
if (1 == intLeft)
{
/*window.location="end.html";*/
document.form23.submit();
}
else
{
intLeft -= 1;
m=intLeft/3600; /*小時(shí)*/
n=(intLeft-m)/60;
s=intLeft%60;
document.all.countdown.innerText = intLeft+" ";
setTimeout("leavePage()", 1000);
}
}
leavePage();
</script>
</head>
<BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" onload="setTimeout('leavePage()', 1000);">
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="db" scope="page" class="exam.exam"/>
<jsp:useBean id="db1" scope="page" class="exam.exam"/>
<jsp:useBean id="db2" scope="page" class="exam.exam"/>
<jsp:useBean id="db3" scope="page" class="exam.exam"/>
<jsp:useBean id="db4" scope="page" class="exam.exam"/>
<jsp:useBean id="db5" scope="page" class="exam.exam"/>
<jsp:useBean id="db6" scope="page" class="exam.exam"/>
<%
String sid=(String)session.getAttribute("sid");
String dep=(String)session.getValue("dep");
String pnum=request.getParameter("pnum");
String sbnum=request.getParameter("sbnum");
String sql="select sbname,sbnum from subject where dep='"+dep+"'";
ResultSet rs=db.executeQuery(sql);
rs.next();
String sbname=rs.getString("sbname");
//String sbnum=rs.getString("sbnum");
rs.close();
String sql1="select * from pap where dep='"+dep+"' and pnum='"+pnum+"' and sbnum='"+sbnum+"'";
ResultSet rsPap=db1.executeQuery(sql1);
rsPap.next();
String phead=rsPap.getString("phead");
int wproper=rsPap.getInt("wproper");
String wnum=rsPap.getString("wnum");
rsPap.close();
String sql2="select tname from administrators where wnum='"+wnum+"'";
ResultSet rs2=db2.executeQuery(sql2);
rs2.next();
String tname=rs2.getString("tname");
rs2.close();
String sql3="select depname from departmen where dep='"+dep+"'";
ResultSet rs3=db3.executeQuery(sql3);
rs3.next();
String depname=rs3.getString("depname");
rs3.close();
String sql19="select sname,grade from student where snum='"+sid+"'";
ResultSet rs19=db6.executeQuery(sql19);
rs19.next();
String spsname=rs19.getString("sname");
int spgrade=rs19.getInt("grade");
rs19.close();
%>
<br>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="396">
<tr>
<td>
<table width="731" height="422" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top">
<table width="725" height="15" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="420" height="15"><img src="images/temp_01.jpg" width="420" height="15"></td>
<td width="305"><img src="images/temp_02.jpg" width="330" height="15"></td>
</tr>
</table>
<table width="747" height="57" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="223" background="images/left_top.jpg"> </td>
<td width="524" background="images/main_bg.jpg"><img src="images/blank_banner.gif" width="468" height="60"></td>
</tr>
</table>
<table width="747" height="89" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="89">
<table width="271" border="1" cellspacing="1" cellpadding="0">
<tr>
<td width="40" align="center" valign="middle" class="ccc">系別</td>
<td>
<div align="center" class="ccc"><font color="#ffff00"><%=depname%></font></div>
</td>
<td width="40" align="center" valign="middle" class="ccc">學(xué)號(hào)</td>
<td>
<div align="center" class="ccc"><font color="#ffff00"><%=sid%></font></div>
</td>
</tr>
<tr>
<td align="center" valign="middle">
<div align="center" class="ccc">科目</div>
</td>
<td>
<div align="center" class="ccc"><font color="#ffff00"><%=sbname%></font></div>
</td>
<td width="40" align="center" valign="middle" class="ccc">姓名</td>
<td>
<div align="center" class="ccc"><font color="#ffff00"><%=spsname%></font></div>
</td>
</tr>
<tr>
<td align="center" valign="middle">
<div align="center" class="ccc">性質(zhì)</div>
</td>
<td>
<div align="center" class="ccc">
<% if(wproper==1) {%>
<font color="#ffff00">標(biāo)準(zhǔn)考試 </font>
<%} else {%>
<font color="#ffff00">補(bǔ)考 </font>
<%}%>
</div>
</td>
<td width="40" align="center" valign="middle" class="ccc">班級(jí)</td>
<td>
<div align="center" class="ccc"><font color="#ffff00"><%=spgrade%>班</font></div>
</td>
</tr>
</table>
<!--/********************時(shí)間********************-->
<font color="#000099">考試時(shí)間倒計(jì)時(shí)<b><font color="red" size="7">
<span id="countdown">
<!-- Output initial amount of time. -->
<script language="JavaScript">
document.write(intLeft);
</script>
</span></font></b>秒，將自動(dòng)關(guān)閉！
</font>
<!--/********************時(shí)間********************-->
</td>
</tr>
</table>
<table width="709" height="62" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle">
<div align="center" class="aaa"><font color="#ffff00"><%=phead%></font></div>
</td>
</tr>
</table>
<%
String sql4="select distinct qnum,question,mark,type,diff from question where sbnum='"+sbnum+"' and pnum='"+pnum+"'order by qnum";
ResultSet rs4=db4.executeQuery(sql4);
while(rs4.next())
{
int qnum=rs4.getInt("qnum");
String question=rs4.getString("question");
int mark=rs4.getInt("mark");
int type=rs4.getInt("type");
int diff=rs4.getInt("diff");
%>
<table width="716" height="130" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="114" height="5" valign="top">
<div align="right" class="ccc"><%=qnum%>.</div>
</td>
<td width="540" class="ccc" height="5" valign="top"><%=question%> <strong>題類:</strong>
<% if (type==1)
{%>
<font color="#FFCCCC">單選題</font>
<%}
if (type==2)
{%>
<font color="#FFCCCC">多選題</font>
<%}
if (type==3){%>
<font color="#FFCCCC">判斷題</font>
<%}
if (type==4)
{%>
<font color="#FFCCCC">填空題</font>
<%} %>
</td>
<td width="62" class="ccc" height="5">(<%=mark%>分)</td>
</tr>
<tr>
<td height="18"> </td>
<%
if (type==1)
{
String sql5="select * from storer where question='"+question+"' and sbnum='"+sbnum+"' order by knum";
ResultSet rs5=db5.executeQuery(sql5);
while(rs5.next())
{
int knum=rs5.getInt("knum");
String answer1=rs5.getString("answer");
int keys=rs5.getInt("keys");
%>
<td valign="top" class="ccc">
<input type="radio" name="<%=question%>" >
(<%=knum%>)<%=answer1%>
</td>
<td> </td>
</tr>
<tr>
<td height="18"> </td>
<%
}rs5.close();
}
if(type==2)
{
String sql6="select * from storer where question='"+question+"' and sbnum='"+sbnum+"' order by knum";
ResultSet rs6=db5.executeQuery(sql6);
while(rs6.next())
{
int knum=rs6.getInt("knum");
String answer1=rs6.getString("answer");
int keys=rs6.getInt("keys");
%>
<td valign="top" class="ccc">
<input type="checkbox" name="checkbox2">
(<%=knum%>)<%=answer1%>
</td>
<td> </td>
</tr>
<tr>
<td height="16"> </td>
<%
}rs6.close();
}
if(type==3)
{
String sql6="select * from storer where question='"+question+"' and sbnum='"+sbnum+"'";
ResultSet rs6=db5.executeQuery(sql6);
while(rs6.next())
{
int key=rs6.getInt("keys");
%>
<td class="ccc" valign="top">
<input type="radio" name="true1" value="1"> 正確
<input type="radio" name="true1" value="0"> 錯(cuò)誤
</td>
<td> </td>
</tr>
<tr>
<td height="16"> </td>
<%
}rs6.close();
}
if (type==4)
{
String sql6="select * from storer where question='"+question+"' and sbnum='"+sbnum+"'";
ResultSet rs6=db5.executeQuery(sql6);
while(rs6.next())
{
String key=rs6.getString("keys");%>
<td valign="top">
<textarea name="textarea" cols="50" ></textarea>
</td>
<td> </td>
<%
}rs6.close();
}
}rs4.close(); %>
</tr>
</table>
<table width="717" height="46" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<div align="center">
<form name="form23" method="post" action="end.jsp" >
<input type="hidden" name="sbnum" value="<%=sbnum%>">
<input type="hidden" name="pnum" value="<%=pnum%>">
姓名： <input type="text" name="name2" value="123">
<input type="submit" name="Submit" value="交 卷">
</form>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="747" height="15" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="420"><img src="images/temp_01.jpg" width="420" height="15"></td>
<td width="327"><img src="images/temp_02.jpg" width="330" height="15"></td>
</tr>
</table>
<div align="center"></div>
</td>
</tr>
</table>
<p> </p>
<div align="center"></div>
</BODY>
</HTML>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -