📄 mn_test_rs.jsp
字号:
out.print("<br>"+se.toString());
}
catch(Exception e){
out.print("<br> query mn_scores error sql="+sql);
out.print("<br>"+e.toString());
}
if(have_test==sub_num){
//如果完成了模拟考试，则在mn_history中增加记录，表明学生完成了这次测试
sql="select * from mn_history where stu_id='"+studentID+"' and mn_test_id="+mn_testID;
try{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
rs.close();
stmt.close();
}else{
rs.close();
stmt.close();
//查询这次模拟考试的总分及积各科目分数
sql=" SELECT `subject`.`id` AS `subid`,`subject`.`Name` AS `subname`, "+
" FORMAT(`test`.`mark`,0) AS `totalmark`, FORMAT(`mn_scores`.`score`,0) AS `score` "+
" FROM `mn_scores` LEFT OUTER JOIN `subject` ON (`mn_scores`.`sub_id` = `subject`.`ID`)"+
" LEFT JOIN `test` ON (`mn_scores`.`test_id` = `test`.`id`)"+
" WHERE (`mn_test_id` = "+mn_testID+") AND (`stu_id` = '"+studentID+"')"+
" ORDER BY `subid`";
int his_subnum=0;
int hisreal=0;
sb=new StringBuffer();//化学:50#物理:20#英语:40#
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
his_subnum++;
hisreal+=rs.getInt("score");
sb.append(rs.getString("subname")+":"+rs.getString("score")+"#");
}
rs.close();
stmt.close();
sql="insert into mn_history(stu_id,mn_test_id,test_date,totalmark,submark,sub_num) "+
" values('"+studentID+"',"+mn_testID+",CURRENT_DATE,"+hisreal+",'"+sb.toString()+"',"+
his_subnum+")";
stmt=con.createStatement();
stmt.executeUpdate(sql);
}
if(debug){
out.print("<br>insert into mn_history sql="+sql);
}
}
catch(SQLException se){
out.print("<br>insert into mn_history sql="+sql);
out.print("<br>"+se.toString());
}
catch(Exception e){
out.print("<br>insert into mn_history sql="+sql);
out.print("<br>"+e.toString());
}
//增加参加考试的人数
//获取参加模拟考试的总人数,而且必须完成这次模拟考试的全部测试
int testPeople=0;
sql="SELECT count(*) as tested from mn_history where mn_test_id="+mn_testID;
try{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
testPeople=rs.getInt("tested");
}
else{
testPeople=0;
}
rs.close();
stmt.close();
}
catch(SQLException se){
out.print("<br> query mn_history error sql="+sql);
out.print("<br>"+se.toString());
}
catch(Exception e){
out.print("<br> query mn_history error sql="+sql);
out.print("<br>"+e.toString());
}
//有人做完模拟考试
//将参加模拟考试的总人数写入数据库
try{
sql="update mn_test set testpeople="+testPeople+" where id="+mn_testID;
stmt=con.createStatement();
stmt.executeUpdate(sql);
stmt.close();
}
catch(SQLException se){
out.print("<br> update mn_test.testpeople error sql="+sql);
out.print("<br>"+se.toString());
}
catch(Exception e){
out.print("<br> update mn_test.testpeople error sql="+sql);
out.print("<br>"+e.toString());
}
if(debug){
out.print("<br>mn_test totalpeople sql="+sql);
out.print("<br>mn_test totalpeople="+testPeople);
}
}//end if(have_test==sub_num)
}
}catch(SQLException se){
out.print("<br> query mn_scores error sql="+sql);
out.print("<br>"+se.toString());
}
catch(Exception e){
out.print("<br> query mn_scores error sql="+sql);
out.print("<br>"+e.toString());
}
}//end if(valid=1)
//试题记录集
sql=testIDs.toString().substring(0,testIDs.length()-1);
sql="select id,questtext,tip,mark from question where id in ("+sql+") order by id";
pstmt=con.prepareStatement(sql);
rs=pstmt.executeQuery();
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>成绩查询 | 考试成绩 | | 单项选择题</title>
<link rel="stylesheet" type="text/css" href="../css.css">
</head>
<body>
<center>
<table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2" height="25">
<tr>
<td width="100%" height="29" style="border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; border-top-style: solid; border-top-width: 0; border-bottom: 1px solid #000000">
<img border="0" src="../images/cxcj.gif"></td>
</tr>
<tr>
<p> </p>
</tr>
</table>
<p> </p>
</center>
<div align="center">
<center>
<table cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="469" id="AutoNumber2" border="1">
<form method="POST" action=""><tr>
<td width="100%" height="25" bgcolor="#6699CC" background="images/admin_bg_1.gif" bordercolor="#799AE1">
<p align="center"><b> <font color="#FFFFFF">成绩单</font></b></td>
</tr>
<tr>
<td width="100%" height="160" bgcolor="#FFFDE8" bordercolor="#799AE1">
<p align="center"> </p>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="202">
<tr>
<td width="8%" height="28"> <p align="right">考生编号：</td>
<td height="28" colspan="4"> <%=studentID%></td>
</tr>
<tr>
<td width="8%" height="29"> <p align="right">姓
名：</td>
<td height="29" colspan="4"><%=name%> </td>
</tr>
<tr>
<td width="8%" height="29"> <p align="right">得 分：</td>
<td width="13%" height="29">卷面分：</td>
<td width="23%"><%=testmark%> </td>
<td width="15%">百分制：</td>
<td width="41%">
<% DecimalFormat df=new DecimalFormat("###");
String r=df.format(testmark/totalmark*100);
out.print(r);
%>
</td>
</tr>
<tr>
<td width="8%" height="29"> <p align="right">答 错：</td>
<td height="29" colspan="4"><%=error%> </td>
</tr>
<tr>
<td width="8%" height="29"> <p align="right">答 对：</td>
<td height="29" colspan="4"><%=correct%> </td>
</tr>
<tr>
<td height="29"> <p align="right">正确答案：</p></td>
<td height="29" colspan="4"><%=Answer.toString() %> </td>
</tr>
<tr>
<td height="29"><p align="right">您的答案：</p></td>
<td height="29" colspan="4"><%=SubAns.toString()%> </td>
</tr>
</table>
<p align="center"> </p>
</td>
</tr>
<tr>
<td width="100%" height="25" bgcolor="#FFFFFF" bordercolor="#799AE1"> <p align="center">
<INPUT class="s02" onclick="window.close()" type=button value=返回 name=close2>
<span lang="en-us"> </span></td>
</tr></form>
</table>
</center>
</div>
<center><form name="viewdatabase" ACTION="" method="post">
<table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber1" height="82">
<tr class="trh">
<td width="44" align="center" bgcolor="#799AE1" height="24">
<font color="#FFFFFF"><b>序号</b></font></td>
<td align="center" bgcolor="#799AE1" width="592" height="24"> <p align="center"><font color="#FFFFFF">
<b>单项选择题（共<%=testnum%> 题,<%=totalmark%>分）</b></font></td>
</tr>
<% testNumber=0;
while(rs.next()){%>
<tr class="trh1">
<td align="center" height="35" width="44">
<center>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <div align="center">
<%out.print(testNumber+1);%>.
</div></td>
</tr>
<tr>
<td><div align="center">(<%=arrMark[testNumber]%>分)</div></td>
</tr>
</table>
</center> </td>
<td align="left" width="592" height="35"><br>
<%
out.print("正确答案是"+arrAnswer[testNumber]+", ");
if(arrTF[testNumber].equals("T")){
out.print("您的答案是"+arrSubAns[testNumber] +"<br>");
}else{
out.print("<font color=Red>您的答案是"+arrSubAns[testNumber] +"</font><br>");
}
out.print("原题目:<br>"+rs.getString("questtext"));
out.print("<br>提示：<br>"+""+rs.getString("tip"));
testNumber++;
%>
</td>
</tr>
<%}
rs.close();
pstmt.close();
%>
<tr>
<td align="center" bgcolor="#FFFFFF" height="16" width="640" colspan="2" bordercolor="#FFFFFF">
<p align="center">
<INPUT class="s02" onclick="window.close()" type=button value=返回 name=close>
</p>
</td>
</tr>
</table>
</form>
</center>
<center> <form ACTION="" METHOD="GET">
<table style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr>
<td width="576">
<p ALIGN="center"> </p>
<p> </td>
</tr>
</table>
</form>
</center>
</body>
</html>
<%}
catch (Exception e){
if(debug){
Tools.debugmsg("<BR>Exception:"+e.toString() ,out);
}
}
finally{
DBCon.dropConnection();
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -