📄 free_test_paper.jsp

📁 在线考试软件。在线考试软件详细设计说明书：说明在线测试这一模块各部分的功能和结构
💻 JSP
📖 第 1 页 / 共 2 页
字号:
上一页 12
        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@答案@分数@难易度;     一道试题的格式，以#号结束
        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>共创学堂-错题本在线测验</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><img src="../student/images/test_pop_01.gif" width="102" height="27"></td>
      <td align="right"><img src="../student/images/test_pop_02.gif" width="134" height="27"></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>
                                共创学堂-自由测验
                                    </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=80 bgcolor=#eaeaea><b>序号</b></td>
        <td align=middle bgcolor=#eaeaea> <p align=center><b>共<%=testnum%>题,<%=testmark%>分</b></p></td>
      </tr>
	  <%while(rs.next()){%>
      <tr class=trh1 bgcolor="#FFFFFF">
          <td width=80 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="60%" align="right">
<div align="right"><font size="-1">难度:</font></div></td>
                  <td width="40%" 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">&nbsp;</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>
        &nbsp;&nbsp;
        <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 -->
  <TABLE
style="BORDER-TOP: #dbdbdb 1px solid; MARGIN-TOP: 10px; MARGIN-BOTTOM: 10px; BACKGROUND-COLOR: #f6f6f6"
cellSpacing=0 cellPadding=0 width="100%" border=0>
  <TBODY>
  <TR>
    <TD align=middle colSpan=2 height=30>
      <TABLE cellSpacing=0 cellPadding=0 width=750 border=0>
        <TBODY>
        <TR>
          <TD><A href="http://jsptestonline.cosoft.org.cn/index.html"
            target=_blank>关于我们</A> | <A
            href="http://jsptestonline.cosoft.org.cn/contact/3_ywhz.html"
            target=_blank>联系方式</A> | 网站地图 | <A
            href="http://jsptestonline.cosoft.org.cn/about/service.html"
            target=_blank>服务条款</A> | <A
            href="http://jsptestonline.cosoft.org.cn/about/privacy.html"
            target=_blank>隐私权保护</A> | <A
            href="http://jsptestonline.cosoft.org.cn/about/copyright.html"
            target=_blank>版权声明</A></TD>
          <TD align=middle width=220>版权所有：<A href="http://jsptestonline.cosoft.org.cn/"
            target=_blank>共创教育机构</A></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><!--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();
}
%>
上一页 12
💿 文件大小 5156 K
👤 上传用户 supertruman
📂 所属分类教育系统应用
🏷️ 相关标签

#软件 #详细设计 #在线测试 #分
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -