examgroupscorelist.jsp

培训考试系统代码

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

<%    Object sessionRs         =  session.getAttribute("GROUP-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 = "";
      
    %>

<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>
  <%
  while(turnOrderRs.next())
  {
  	int numScores = turnOrderRs.getInt(1);
  	int numStaffs = turnOrderRs.getInt(2);
  	double aveScore = numScores/numStaffs;
  %>
  </tr>
  <tr align="center" class="td-cs2"> 
    <td height="25"> <%=turnOrderRs.getString(0) %></td> 
    <td height="25"> <%=numScores%></td> 
    <td height="25"> <%=numStaffs%></td> 
    <td height="25"> <%=aveScore%></td> 
  </tr>
  <%
  }
  %>  
  
 </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/ExamGroupScoreList.jsp?orderFlag=<%=isOrderFlag%><%=queryTerm%>";
     document.changePageForm.submit();
 }


</script>

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