examscorelist.jsp

培训考试系统代码

<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="/agt/public/jsp/top.jsp" %>

<%    Object sessionRs         =  session.getAttribute("SCORE-QUERY-RESULTSET");
      SysResultSet turnOrderRs =  sessionRs == null ?null:(SysResultSet)sessionRs;
       String[] isPass ={"不通过","通过"};

%>
<%@ include file="/agt/public/jsp/Order.jsp"   %>
<!-- title>考试安排查询列表页面 </title -->
   <form method="post" name="examForm" action="/ExamMan.do">

   <%
      //获取查询条件,并传送到下一页面
     
      String queryTerm = "";
      
    %>
    
    <%if(pageNum == 1)
    {%>

<table width="539" border="0" cellpadding="3" cellspacing="1" class="table-cs1">
  <tr align="center" class="td-cs1"> 
    <td width="20%" height="25">最高分数</td>
    <td width="20%" height="25">最低分数</td>
    <td width="20%" height="25">平均分数</td>   
    <td width="20%" height="25">总参加人数</td>
  
  </tr>
  <tr align="center" class="td-cs2"> 
    <td height="25"> <%=session.getAttribute("maxScore")%></td> 
    <td height="25"> <%=session.getAttribute("minScore")%></td> 
    <td height="25"> <%=session.getAttribute("aveScore")%></td> 
    <td height="25"> <%=session.getAttribute("partCount")%></td> 
    </tr>
  
 </table>
 <%}%>
  
                    <table width="539" border="0" cellpadding="3" cellspacing="1" class="table-cs1">
      
                         <td width="25%" height="25" align="center" nowrap class="td-cs1"> <a href="/agt/exam/ExamScoreList.jsp?orderColum=1&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk">考试名称
                          </a></td>
                          
            <td width="15%" height="25" align="center"  nowrap class="td-cs1"> <a href="/agt/exam/ExamScoreList.jsp?orderColum=4&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk">考生工号</a>
                        </td>
                        <td width="25%" height="25" align="center" nowrap class="td-cs1"> <a href="/agt/exam/ExamScoreList.jsp?orderColum=1&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk">考生姓名
                          </a></td>
                          <td width="40%" height="25" align="center" nowrap class="td-cs1"> <a href="/agt/exam/ExamScoreList.jsp?orderColum=1&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk">所在地市
                          </a></td>
                        
                        <td width="15%" height="25" align="center"  nowrap class="td-cs1"> <a href="/agt/exam/ExamScoreList.jsp?orderColum=2&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk">考试时间
                          </a></td>

                     

                        <td width="15%" height="25" align="center"  nowrap class="td-cs1"> <a href="/agt/exam/ExamScoreList.jsp?orderColum=3&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk">成绩</a>
                        </td>
                      <td width="15%" height="25" align="center"  nowrap class="td-cs1"> <a href="/agt/exam/ExamScoreList.jsp?orderColum=5&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk">是否通过</a>
                        </td>
                        <td width="15%" height="25" align="center"  nowrap class="td-cs1"> <a href="/agt/exam/ExamScoreList.jsp?orderColum=5&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk">操作</a>
                        </td>
            
     </tr>

       <%

            if( turnOrderRs != null && turnOrderRs.getMetaData().getRecordCount() != 0 )
            {
                //此处是用来显示结果
                for(int i=(pageNum-1)*pageRecoder; turnOrderRs.setRecord(i)&&(i<pageNum*pageRecoder); i++)
                {
        %>

    <tr class="td-cs2">
      
      
      
      <td height="25" style="word-break:break-all"><a href="/OnlineExam.do?opeType=<%=OperatorFlagCode.ONLINEEXAM_GETEXAMRESULT%>&examName=<%=turnOrderRs.getString(1) %>&paperId=<%=turnOrderRs.getString(6) %>&recordId=<%=turnOrderRs.getString(7) %>"><%=turnOrderRs.getString(1) %></a></td>
            
       <td height="25" align="center"><%=turnOrderRs.getString(4) %></td>
       <td height="25" align="center"><%=turnOrderRs.getString(8) %></td>
       <td height="25" align="center"><%=turnOrderRs.getString(9) %></td>
    
      <td height="25"><%=turnOrderRs.getString(2) %></td>

      <td height="25" align="center"><%=turnOrderRs.getString(3) %></td>
      <%
         if(turnOrderRs.getInt(5)==0){
      %>
       <td height="25" align="center" ><font color="red"><%=isPass[turnOrderRs.getInt(5)] %></font></td>
      <%
      } else { 
      %>
       <td height="25" align="center" ><%=isPass[turnOrderRs.getInt(5)] %></td>
       
      
      <%
      }
      %> 
      <td>
      <a href="/ExamMan.do?opeType=24&recordid=<%=turnOrderRs.getString("recordid")%>">
       <image name="del" 
        style="cursor:hand"
       src="/agt/public/images/del.gif" width="82" height="22" border="0" 
       onmouseover="this.src='/agt/public/images/'+ this.name + '_2.gif';" 
       onmouseout="this.src='/agt/public/images/'+ this.name + '.gif'"></a></td>

          </tr>
        <%
                 }
             }
        %>
        
        <!-- huangyuyuan add 2004-06-22 -->
        <tr>
            <td>
                <a href="/agt/exam/ExamScoreExport.jsp">
                <image name="export" 
                    style="cursor:hand"
                    src="/agt/public/images/export.gif" width="82" height="22" border="0" 
                    onmouseover="this.src='/agt/public/images/'+ this.name + '_2.gif';" 
                    onmouseout="this.src='/agt/public/images/'+ this.name + '.gif'">
                </a>
            </td>
        </tr>
       <!-- end -->
   
   </table>
   
   </form>
   <form method="post" name="changePageForm">
  <table width="539" border="0" cellpadding="0" cellspacing="0">
    <tr>

   <td>总共有<font color="#FF0000"><%=recordCount%></font>条记录,<font color="#FF0000"><%=maxPage%></font>页</td>
   <td>当前第<font color="#FF0000"><%=pageNum%></font>页</td>
   <td><%if(pageNum != 1) {%><a href="/agt/exam/ExamScoreList.jsp?pageNum=1&orderFlag=<%=isOrderFlag%><%=queryTerm%>">首页 </a><%} else {%>首页 <%}%></td>
   <td><%if(pageNum != 1) {%><a href="/agt/exam/ExamScoreList.jsp?pageNum=<%=frontPageNum%>&orderFlag=<%=isOrderFlag%><%=queryTerm%>">上一页 </a><%} else {%>上一页  <%}%></td>
   <td ><%if(pageNum < maxPage) {%><a href="/agt/exam/ExamScoreList.jsp?pageNum=<%=backPageNum%>&orderFlag=<%=isOrderFlag%><%=queryTerm%>">下一页 </a><%} else {%> 下一页<%}%></td>
   <td><%if(pageNum < maxPage) {%><a href="/agt/exam/ExamScoreList.jsp?pageNum=<%=maxPage%>&orderFlag=<%=isOrderFlag%><%=queryTerm%>">末页 </a><%} else {%>末页  <%}%></td>
      <td>
	  <table width="113" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td width="44"> 跳转到 </td>
                      <td width="37">
<input name="pageNum" type="text" class="input1-2" size="3" onKeyPress="GoPageKeyPress();" <%if(maxPage < 2) { %> readonly <%}%>>
                      </td>
                      <td width="32">
<input name="go" type="image" onClick="changePageSubmit();return false;" <%if(maxPage < 2) { %> disabled <%}%> src="/agt/public/images/go.jpg" width="21" height="21" border="0" onMouseOver="this.src='/agt/public/images/'+ this.name + '_2.jpg';" onMouseOut="this.src='/agt/public/images/'+ this.name + '.jpg'"></td>
                    </tr>
                  </table>
	        </td>

  </tr>
  </table> 		     <input type="hidden" name="orderFlag" value="<%=isOrderFlag%>">    </form>
 <script src="/agt/public/js/scriptfuns.js" type="text/javascript"></script>
 <script  language="JavaScript">

 //跳页的检查与提交
 function changePageSubmit()
 {

   var pageNum = document.changePageForm.pageNum;

     if(pageNum==null || trim(pageNum.value)=="" || !isNumber(pageNum.value) )
     {
        alert("跳转到的页数参数输入有误,请重新输入。");
        pageNum.value = "";
        pageNum.focus();
        return;
     }

     var maxPage = <%=maxPage%>;  //Order.jsp文件中已计算出maxPage
     var goPageNum = parseInt(pageNum.value) ;
     var maxNum = parseInt(maxPage) ;

     if(goPageNum < 1 || goPageNum > maxNum)
     {

         alert("跳转到的页数参数输入范围不正确,请重新输入。");
         pageNum.value = "";
         pageNum.focus();
         return;
     }
     document.changePageForm.action="/agt/exam/ExamScoreList.jsp?orderFlag=<%=isOrderFlag%><%=queryTerm%>";
     document.changePageForm.submit();
 }


</script>

<%@ include file="/agt/public/jsp/bot.jsp" %>