?? free_test_rs.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="jinghua.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>
<%! boolean debug=false;%>
<jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
</jsp:useBean>
<%
//String testID=request.getParameter("testid");
String studentID=request.getParameter("studentid");
String paper=request.getParameter("testresult");
if(debug)
out.print("<br>studentID="+studentID);
//String mn_testID=request.getParameter("mn_testID");
//int valid=Integer.parseInt(request.getParameter("valid"));
//int old=Integer.parseInt(request.getParameter("old"));
//String testID="62";
//String studentID="1";
if(studentID==null){
Tools.showalert("您還沒有登錄，或連接超時，請重新登錄!",out);
Tools.showJS("window.open('../login.jsp','_self')",out);
}
if(paper==null){
Tools.showalert("沒有取得試卷信息，請重試!!",out);
Tools.goback(out);
}
else{
ResultSet rs=null;
String sql="";
String title="";
int testnum=0;
StringBuffer sb=new StringBuffer();
Statement stmt=null;
String name="";//考生姓名
int correct=0;
int error=0;
String correctAns="";
String youAns="";
StringBuffer dbmsg=new StringBuffer();
StringBuffer testIDs=new StringBuffer();
StringBuffer Answer=new StringBuffer();
StringBuffer Mark=new StringBuffer();
StringBuffer SubAns=new StringBuffer();
StringBuffer SubMark=new StringBuffer();
StringBuffer TF=new StringBuffer();
StringBuffer Dif=new StringBuffer();
int sub_num=0;
Vector explain=new Vector();
String [] arrMark=null;
String [] arrAnswer=null;
String [] arrSubAns=null;
String [] arrTestID=null;
String [] arrTF=null;
String temp="";
String subid="";//科目ID
String markPercent="";//百分制的分數
float testmark=0.0f;
float totalmark=0.0f;
int testNumber=0;
try{
Connection con=DBCon.getConnection();
if(paper!=null){
//分析試題：試題ID@答案@分數@難易度; 一道試題的格式，以#號結束
if(debug) out.print("<br>begin:");
String [] tests=paper.split("#");
testnum=tests.length;
if(debug) out.print("<br>paper="+paper+"<br>testnum="+testnum);
for(int i=0;i<testnum;i++){
//取回試題號
String [] test=tests[i].split("@");
if(debug) {
out.print("<BR>tests["+i+"]="+tests[i]);
}
testIDs.append(test[0]+",");//題號
Answer.append(test[1]+",");//答案
Mark.append(test[2]+",");
Dif.append(test[3]+",");
testmark+=Float.parseFloat(test[2]);//總分數
}
arrMark=Mark.toString().split(",");
arrAnswer=Answer.toString().split(",");
arrTestID=testIDs.toString().split(",");
//根據arrTestID提取考生提交的答案信息，不填寫的為"空";
if(debug){
out.print("<br>Mark="+Mark.toString());
out.print("<br>Answer="+Answer.toString());
out.print("<br>TestID="+testIDs.toString());
out.print("<br>Mark="+Mark.toString() );
out.print("<br>Dif="+Dif.toString());
}
//取回用戶提交的答案
for(int i=0;i<testnum;i++){
temp=request.getParameter("radio"+arrTestID[i]);
if (temp==null){
SubAns.append("空"+",") ;
//arrSubAns[i]=new String("@");
}else{
SubAns.append(temp+",");
//arrSubAns[i]=new String(temp);
}
}
if(debug){
out.print("<br>Mark="+Mark.toString());
out.print("<br>Answer="+Answer.toString());
out.print("<br>TestID="+testIDs.toString());
out.print("<br>SubAns="+SubAns.toString());
}
arrSubAns=SubAns.toString().split(",");
//評分
correct=0;
error=0;
testmark=0;
totalmark=0.0f;
for(int i=0;i<testnum;i++)
{
jinghua.T_Question.addUsedCount(con,Integer.parseInt(arrTestID[i]));
totalmark+=Float.parseFloat(arrMark[i]);
if(arrSubAns[i].equals(arrAnswer[i])){
jinghua.T_Question.addCorrectCount(con,Integer.parseInt(arrTestID[i]));
TF.append("T,");
SubMark.append(arrMark[i]+",");
correct++;
if(debug){
Tools.debugmsg("<br>arrMark["+i+"]="+arrMark[i],out);
}
testmark+=Float.parseFloat(arrMark[i]);
}else {
error++;
SubMark.append("0,");
if(arrSubAns[i].equals(" "))
TF.append("@,");
else
TF.append("F,");
}
}
if(debug){
out.print("<br>TF="+TF.toString() );
out.print("<br>SubMark="+SubMark.toString() );
out.print("<br>TF[2]="+TF.toString().charAt(2));
}
arrTF=TF.toString().split(",");
//考生信息
sql="select vcUserNo,vcName from UserInfo where vcUserNo="+"'"+studentID+"'";
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
name=""+rs.getString("vcName");
}
rs.close();
stmt.close();
//將錯題插入錯題本
for(int i=0;i<testnum;i++){
if(debug) out.println("<BR>question error id="+arrTestID[i]+
": result="+arrTF[i] );
if(!arrTF[i].equals("T")){
int count=0;
sql=" select count(*) as errcount from errorpad where stu_id='"+studentID+"'"+
" and question_id="+arrTestID[i];
try{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
count=rs.getInt("errcount");
}
rs.close();
stmt.close();
if(debug){
out.print("<br>errorpad question_id="+arrTestID[i]+
"<br>count="+count);
}
if(count==0){//插入新記錄
sql=" insert into errorpad(stu_id,question_id,add_date,errorcount,test_id,mn_test_id,sourcetype)"+
" values('"+studentID+"',"+arrTestID[i]+",CURRENT_TIMESTAMP,1,0,0,1) ";
stmt=con.createStatement();
stmt.executeUpdate(sql);
stmt.close();
}else{
sql=" update errorpad set errorcount=errorcount+1 where stu_id='"+studentID+"'"+
" and question_id="+arrTestID[i];
stmt=con.createStatement();
stmt.executeUpdate(sql);
stmt.close();
}
}
catch(SQLException se){
out.print("<br> query errorpad info error sql="+sql);
out.print("<br>"+se.toString());
}
catch(Exception e){
out.print("<br> query errorpad info error sql="+sql);
out.print("<br>"+e.toString());
}
}//end_if
}//end for errorpad
//試題記錄集
//sql="select id,questtext,tip,mark from question where id in ("+sql+") order by id";
}
%>
<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="../student/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(testNumber<testnum){%>
<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">(<%=Math.round(Float.parseFloat(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>");
}
sql="select id,questtext,tip,mark from question where id="+arrTestID[testNumber];
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
out.print("原題目:<br>"+rs.getString("questtext"));
out.print("<br>提示：<br>"+""+rs.getString("tip"));
}
rs.close();
stmt.close();
testNumber++;
%>
</td>
</tr>
<%}
%>
<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 + -