?? free_test_paper.jsp
字號:
"(`question`.`PreHard` = 'E')"+" ORDER BY RAND() "+" LIMIT "+numE;
else
sql="SELECT `question`.`ID` FROM `question` WHERE "+
sqlcon+" AND "+"(`question`.`PreHard` = 'E')"+" ORDER BY RAND() "+" LIMIT "+numE;
try{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
questIDs.addElement(new String(rs.getString("ID")));
}
if(debug)
out.print("<br>select numE sql="+sql);
}
catch(Exception e){
out.print("<br> query question hard E error sql="+sql);
out.print("<br>"+e.toString());
}
}
if(debug){
out.print("<br>vector number E="+questIDs.size());
}
//Else strQuestIDs
if(questIDs.size()<testnumber){
//if(numElse>0){
numElse=testnumber-questIDs.size();
StringBuffer sb=new StringBuffer();
for(i=0;i<questIDs.size();i++)
sb.append(questIDs.elementAt(i)+",");
if(sb.length()>0){
strQuestIDs=sb.toString().substring(0,sb.toString().length()-1);
}
else
strQuestIDs="-1";
sb=null;
if(sqlcon.equals(""))
sql="SELECT `question`.`ID` FROM `question` WHERE "+
"(`question`.`ID` NOT IN ("+strQuestIDs+"))"+" ORDER BY RAND() "+" LIMIT "+numElse;
else
sql="SELECT `question`.`ID` FROM `question` WHERE "+
sqlcon+" AND "+"(`question`.`ID` NOT IN ("+strQuestIDs+"))"+" ORDER BY RAND() "+" LIMIT "+numElse;
if(debug)
out.print("<br>query question numElse sql="+sql);
try{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
questIDs.addElement(new String(rs.getString("ID")));
}
}
catch(Exception e){
out.print("<br> query question hard Else error sql="+sql);
out.print("<br>"+e.toString());
}
}
if(debug){
out.print("<br>vector number Else="+questIDs.size());
}
switch(testorder){
case 1:
sqlorder=" ORDER BY RAND()";
break;
case 2:
sqlorder=" ORDER BY `question`.`PreHard` ASC,`question`.`ID` ASC";
break;
case 3:
sqlorder=" ORDER BY `question`.`PreHard` DESC,`question`.`ID` ASC";
break;
default:
break;
}
StringBuffer sb=new StringBuffer();
for(i=0;i<questIDs.size();i++)
sb.append(questIDs.elementAt(i)+",");
if(sb.length()>0){
strQuestIDs=sb.toString().substring(0,sb.toString().length()-1);
}
else
strQuestIDs="-1";
sb=null;
if(debug)
out.print("<br>strQuestIDs="+strQuestIDs);
sql="SELECT `question`.`ID`,`question`.`PreHard` , `question`.`QuestText`, "+
" `question`.`Mark`, `question`.`Answer`"+
" FROM `question` "+
" WHERE `question`.`ID` IN("+strQuestIDs+") "+sqlorder+" LIMIT "+testnumber;
if(debug)
out.print("<br>paper sql="+sql);
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
testmark=0;
testnum=0;
while(rs.next()){
testmark+=rs.getInt("Mark");
testnum++;
//試題ID@答案@分數(shù)@難易度; 一道試題的格式，以#號結(jié)束
testIDs.append(rs.getString("ID")+"@"+rs.getString("Answer")+"@"+rs.getString("Mark")+
"@"+ rs.getString("PreHard")+"#");
}
rs.beforeFirst();
if(debug){
out.print("<br>query question sql="+sql);
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0041)http://jsptestonline.cosoft.org.cn/senior/none_xt.jsp -->
<HTML><HEAD><TITLE>考試系統(tǒng)-錯題本在線測驗</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK
href="../student/style/style.css" type=text/css rel=stylesheet>
<SCRIPT src="../student/js/html.js"></SCRIPT>
<SCRIPT src="../student/js/gnb_menus_layer.js"></SCRIPT>
<SCRIPT src="../student/js/menu.js"></SCRIPT>
<SCRIPT src="../student/js/jumpmenu.js"></SCRIPT>
<SCRIPT src="../student/js/Valid.js"></SCRIPT>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<CENTER>
<form ACTION="free_test_rs.jsp" method="post" name="viewdatabase" target="_blank">
<table width="650" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
<td align="right"> </td>
</tr>
</table>
<!--begin test -->
<table width="650" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="title1" align="center"><font color="#74a8d1" size="+2">
<strong><B>
考試系統(tǒng)-自由測驗
</B>
</strong>
</font></td>
</tr>
</table>
<br>
<table id=AutoNumber1 style="BORDER-COLLAPSE: collapse"
height=82 cellspacing=1 width="650" border=0 cellpadding="2" bgcolor="#c1c1c1">
<tbody>
<tr class=trh>
<td align=center width=90 bgcolor=#eaeaea><b>序號</b></td>
<td width="549" align=middle bgcolor=#eaeaea> <p align=center><b>共<%=testnum%>題,<%=testmark%>分</b></p></td>
</tr>
<%while(rs.next()){%>
<tr class=trh1 bgcolor="#FFFFFF">
<td width=90 align=center valign="middle">
<table width="100%" border=0>
<tbody>
<tr align="center">
<td colspan="2">
<center>
<%=(++testNumber)%> .
</center></td>
</tr>
<tr>
<td colspan="2"> <center>
<font size="-1">
<%DecimalFormat df=new DecimalFormat("###");
String numNF=df.format(rs.getFloat("mark"));
out.print("("+numNF+"分)");%>
</font></center></td>
</tr>
<tr>
<td width="69%" align="right">
<div align="right"><font size="-1">難度:</font></div></td>
<td width="31%" align="left">
<div align="left"><font size="-1"><%=rs.getString("PreHard")%></font></div></td>
</tr>
<tr>
<td colspan="2"><div align="center"><%if(debug) out.print(rs.getString("ID"));%></div></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</tbody>
</table></td>
<td align=left>
<%=jinghua.TransformString.DeleteBR(rs.getString("questtext"))%>
</td>
</tr>
<%}
rs.close();
stmt.close();
%>
</tbody>
</table>
<table cellspacing=0 cellpadding=8 width=650 border=0>
<tbody>
<tr>
<td align=center>
<!--begin botton-->
<input class=s02 type=submit value=提交 name=submit1>
<input class=s02 type=reset value=重置 name=submit2>
<input name="studentid" type="hidden" id="studentid2" value="<%=studentID %>">
<input name="testresult" type="hidden" id="studentid2" value="<%=testIDs.toString()%>">
<!--end button-->
</td>
</tr>
</tbody>
</table>
<!--end test -->
<!--begin bottom -->
<!--end bottom --></form></CENTER></BODY></HTML>
<%
}catch(SQLException e){
out.print("<br>SQL Error:sql="+sql+"<br>"+e.toString());
}catch(Exception e){
out.print(e.toString() );
}
finally{
DBCon.dropConnection();
}
%>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -