?? stu_test_free.jsp
字號:
<%@ page import="java.util.*,
java.sql.*,
java.lang.*" %>
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*" %>
<%@ page import="jinghua.*"%>
<jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
</jsp:useBean>
<%!Connection con;
boolean debug=false;
String studentID="";
String gradenote="";
Statement stmt=null;
ResultSet rs=null;
String sql="";
%>
<%
try{
studentID=(String)session.getAttribute("studentID");
if(studentID==null){
throw new Exception();
}
}catch(Exception e){
Tools.showalert("您還沒有登錄，或連接超時，請重新登錄!",out);
Tools.showJS("window.open('../login.jsp','_self')",out);
}
try{
con=DBCon.getConnection();
//獲取考生的計算機等級信息
//sql="select id,gradenote,grade.Name as gn "+
//"from student INNER JOIN grade ON (student.gradenote = grade.note) "+
//" where stuid='"+studentID+"'";
sql="select id,gradenote from UserInfo where vcUserNo='"+studentID+"'";
try{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
gradenote=rs.getString("gradenote");
rs.close();
stmt.close();
}
if(debug){
out.print("<br>stuID="+studentID+"<br>gradenote="+gradenote);
}
}
catch(SQLException se){
out.print("<br> query student error sql="+sql);
out.print("<br>"+se.toString());
}
catch(Exception e){
out.print("<br> query student error sql="+sql);
out.print("<br>"+e.toString());
}
//--計算機等級，科目，知識點三個下拉列表框聯動-->
out.print(Tools.sub_know(con));
out.print(Tools.grade_sub(con));
%>
<!--計算機等級，科目，知識點三個下拉列表框聯動-->
<script language="JavaScript">
function changegs(locationid){
document.myform.Subject.length =1;
document.myform.KnowPoint.length =1;
var locationid=locationid;
var i;
for (i=0;i < gscount; i++){
if (grade_sub[i][0] == locationid) {
document.myform.Subject.options[document.myform.Subject.length] = new Option(grade_sub[i][2], grade_sub[i][1]);
}
}
}
</script>
<script language="JavaScript">
function changesk(locationid){
document.myform.KnowPoint.length =1;
var locationid=locationid;
var i;
for (i=0;i < gskcount; i++){
if (grade_sub_know[i][1] == locationid){
document.myform.KnowPoint.options[document.myform.KnowPoint.length] = new Option(grade_sub_know[i][3], grade_sub_know[i][2]);
}
}
}
</script>
<script language="javascript">
function CheckForm(f)
{
if( f.testnumber.value.length<1)
{
alert("您還有輸入測驗的試題數!");
return false;
}
if(!isNumberString(f.testnumber.value,"1234567890."))
{
alert("嘿！您在試題數里填了東西,但怎么不是數字呢？\n");
return false;
}else if(f.testnumber.value<10){
alert("每次測驗至少要有10道試題!!");
return false;
}else if(f.testnumber.value>100){
alert("學堂提供最多100道試題的測驗!!");
return false;
}
if( !(f.testorder[0].checked || f.testorder[1].checked||f.testorder[2].checked) ) {
alert("您還沒有選擇測試順序!")
return false;
}
return true;
}
function isNumberString (InString,RefString)
{
if(InString.length==0) return (false);
for (Count=0; Count < InString.length; Count++) {
TempChar= InString.substring (Count, Count+1);
if (RefString.indexOf (TempChar, 0)==-1)
return (false);
}
return (true);
}
</script>
<HTML><HEAD><TITLE>考試系統</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK
href="../common/css/style.css" type=text/css rel=stylesheet>
<META content="MSHTML 6.00.2722.900" name=GENERATOR>
<style type="text/css">
<!--
.STYLE1 {
font-size: 9px;
font-weight: bold;
}
-->
</style>
</HEAD>
<BODY bgColor=#ffffff text=#000000 vlink="#0000FF" >
<CENTER>
<TABLE cellSpacing=0 cellPadding=0 width=770 border=0>
<TBODY>
<TR>
<TD width=620></TD>
<TD align=right width=150></TD></TR></TBODY></TABLE>
<!--begin 內容區 -->
<table width="770" border="0" cellspacing="0" cellpadding="0">
<tr valign="top" align="center">
<td> <p><br>
<br>
</p>
<FORM action="free_test_paper.jsp" method="post" name="myform" target="mainFrame" id="myform" onSubmit="return CheckForm(this)">
<table width="457" height="269" border="0" cellpadding="0" cellspacing="0" class="tboutline" style="BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 5px; PADDING-BOTTOM: 5px; BORDER-LEFT: #cccccc 1px solid; PADDING-TOP: 5px; BORDER-BOTTOM: #cccccc 1px solid; BACKGROUND-COLOR: #f3f3f3">
<tr>
<td height="48" colspan="5" align="center" valign="baseline" nowrap class="titlefont1">
<p><font ><strong>請選擇測驗內容
</strong></font></p>
<p> </p></td>
</tr>
<tr>
<td width="217" height="101" align="center" valign="baseline" nowrap>
<table width="203" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="99" height="26" nowrap><font class="word" ><strong>計算機等級:<br>
</strong></font></td>
<td width="7" nowrap><div align="center"><strong> </strong></div></td>
<td width="85" nowrap><font class="word" ><strong>科 目:</strong></font></td>
</tr>
<tr>
<td height="42"><select id=select6 name=Grade onClick="changegs(document.myform.Grade.options[document.myform.Grade.selectedIndex].value)" size="1">
<option value="temp">--未選擇--</option>
<%Tools.showGradeOption(con,out);%>
</select> </td>
<td> <div align="center"> </div></td>
<td><div align="left"><font size="+1"><strong>
<select name=Subject
size="1" id=select8 onclick="changesk(document.myform.Subject.options[document.myform.Subject.selectedIndex].value)">
<option value="-1" selected>全 部</option>
<%Tools.showGradeSubjectOption(con,gradenote,out);%>
</select>
</strong></font></div></td>
</tr>
</table></td>
<td width="146" align="center" valign="baseline" nowrap >
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="26" nowrap><font class="word" ><strong>知識點:</strong></font></td>
</tr>
<tr>
<td height="41"> <select name=KnowPoint id="select9">
<option value="-1" selected>----全 部----</option>
</select> </td>
</tr>
</table></td>
<td width="92" colspan="2" align="center" valign="baseline" nowrap>
<table height="69" border="0" cellpadding="0" cellspacing="0">
<tr>
<td nowrap><font class="word" ><strong>難易度:</strong></font></td>
</tr>
<tr>
<td> <select name=hard id="select10">
<option value="1" selected>任意</option>
<option value="2">容易</option>
<option value="3">中等</option>
<option value="4">較難</option>
</select> </td>
</tr>
</table></td>
</tr>
<tr valign="middle">
<td height="41" colspan="5" align="center" nowrap> <strong class="word">測試順序：</strong>
<input type="radio" name="testorder" value="1">
隨機順序
<input type="radio" name="testorder" value="2">
從難到易
<input type="radio" name="testorder" value="3">
從易到難</td>
</tr>
<tr valign="middle">
<td height="35" colspan="5" align="center" nowrap><font color="#000000"><strong>試題數</strong></font><strong>:</strong>
<input name="testnumber" type="text" id="testnumber2" value="10" size="10">
</td>
</tr>
<tr>
<td colspan="5" align="center" valign="baseline" nowrap>
<input name="testbegin" type="submit" class="s02" id="testbegin2" value="開 始">
</td>
</tr>
</table>
</FORM></td>
</tr>
</table>
<!--end 內容區 -->
<!--begin bottom -->
<!--end bottom --></CENTER></BODY></HTML>
<% }
catch(Exception e){
System.out.print(e.toString());
}
finally{
DBCon.dropConnection();
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -