queryresult.jsp

培训考试系统代码

<%@ page contentType="text/html;charset=gb2312"%>

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



<%@ page import = "java.net.*"%>

<title>查询考评得分</title>

<script src="/public/scripts/cal.js"></script>

<form name="ExecForm" method="post" action="/ExecAction.do" >

<input type="hidden" name="operatorflag" value ="EVALUATE_QUERY">



  <table width="539" height="25" border="0" cellpadding="3" cellspacing="1" class="table-cs1">

    <tr>

      <td width="100" height="25" align="center" class="td-cs1">业务代表工号</td>

      <td class="td-cs2">

        <input name="staffno" type="text" class="input2" maxlength=10>

        </td>

  </tr>

  <tr>

      <td width="100" height="25" align="center" class="td-cs1">考评规则</td>

      <td class="td-cs2">

        <select name="ruleid" class="input3" >

          <option value="" selected>--不限--</option>

   <%

        SysDbConn aplcoms = null;

        aplcoms = SysConnPool.getInstance().getAplComs();

        aplcoms.preparedQuery("");

        SysResultSet rs1 =aplcoms.csCommonQuery("SQL_AGT_QueryRuleTitle","1","-1").getResultSet();



       if (rs1 != null)

       {

      for (int k = 0; k < rs1.getMetaData().getRecordCount(); k++)

       {

         rs1.setRecord(k);

    %>

       <option value=<%= rs1.getString(0) %> > <%=  rs1.getString(1) %>  </option>



      <%

        }

     }

    %>

  </select>



      </td>

  </tr>

  <tr>

      <td width="100" height="25" align="center" class="td-cs1">考评名称</td>

      <td class="td-cs2">

        <input name="title" type="title" class="input2" maxlength=10>

     </td>

  </tr>

    <tr>

      <td width="100" height="25" align="center" class="td-cs1">考评类型</td>

      <td class="td-cs2">

        <select name="evatypeid" class="input3" >

          <option value="" selected>--不限--</option>

   <%

        aplcoms.preparedQuery("");

        SysResultSet rs2 =aplcoms.csCommonQuery("SQL_AGT_QueryEvatype","1","-1").getResultSet();



       if (rs2 != null)

       {

      for (int k = 0; k < rs2.getMetaData().getRecordCount(); k++)

       {

         rs2.setRecord(k);

    %>

       <option value=<%= rs2.getString(0)%> > <%=  rs2.getString(1) %>  </option>



      <%

        }

     }

          if(aplcoms != null)
          {
             aplcoms.close();
          }

    %>

  </select>



      </td>

  </tr>

  <tr>

      <td width="100" height="25" align="center" class="td-cs1">查询起始日期</td>

      <td class="td-cs2">

        <input name="querybegindate" type="text" class="input2" onClick="javascript:calDate(this);"  onKeypress="javascript:calDate(this);"

      readonly>

      </td>

  </tr>

  <tr>

      <td width="100" height="25" align="center" class="td-cs1">查询结束日期</td>

      <td class="td-cs2">

        <input name="queryenddate" type="text" class="input2" onClick="javascript:calDate(this);"  onKeypress="javascript:calDate(this);"

      readonly>

      </td>

  </tr>





</table>

  <table width="539" height="30" border="0" cellpadding="0" cellspacing="0">
                      <tr> 
                        <td align="center"> <table width="424" height="30" border="0" cellpadding="0" cellspacing="0">
                            <tr> 
                              <td width="25%">&nbsp; </td>
                              <td width="25%"><a href="javascript:doSubmit();" onMouseOver="MM_swapImage('Image12','','/agt/public/images/search_2.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="/agt/public/images/search.gif" name="Image12" width="82" height="22" border="0" id="Image12"></a></td>
                              <td><a href="javascript:ExecForm.reset();" onMouseOver="MM_swapImage('Image6','','/agt/public/images/reset_2.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="/agt/public/images/reset.gif" name="Image6" width="82" height="22" border="0" id="Image6"></a></td>
                            </tr>
                          </table>
                         </td>
                      </tr>
                    </table>
                  </form>



 <script src="/agt/public/js/scriptfuns.js" type="text/javascript"></script>

 <script  language="JavaScript">


 function doSubmit()

 {

    document.ExecForm.submit();

 }

 </script>

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