querymyreward.jsp

培训考试系统代码

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

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

<!--title>查询考评规则</title -->
<script src="/public/scripts/cal.js"></script>

<script>

function submit1()

{

    TeachmngForm.submit();

    return true;

}



</script>

<form name="TeachmngForm" method="post" action="/TeachmngAction.do" >
      

<input type="hidden" name="teacherid" value = "<%= request.getAttribute("teacherid")%>">

<input type="hidden" name="teachername" value = "<%= request.getAttribute("teachername")%>">

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

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

    <tr>

      <td width="80" height="25" align="center" class="td-cs1">课程</td>

      <td class="td-cs2"> <select name="lessonid" class="input3">

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

        SysDbConn aplcoms = null;

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


        aplcoms.preparedQuery("");

        SysResultSet rs1 =aplcoms.csCommonQuery("SQL_AGT_QueryLessonList","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>
    <%

        }

     }

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

    %>
      </select> </td>

      </td>

  </tr>

    <tr>

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

      <td class="td-cs2"> 
 
        <input name="searchbegintime" class="input1" onClick="javascript:calDate(this);"  onKeypress="javascript:calDate(this);" size="20" readonly>

      </td>
    </tr>

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

      <td class="td-cs2"> 
        <input name="searchendtime" class="input1" onClick="javascript:calDate(this);"  onKeyPress="javascript:calDate(this);" size="20" readonly>

      </td>

    </tr>



</table>

                    <table width="539" height="30" border="0" cellpadding="0" cellspacing="0">
                      <tr> 
                        <td align="center"> <table width="324" height="30" border="0" cellpadding="0" cellspacing="0">
                            <tr> 
                              <td width="2">&nbsp; </td>
                              <td width="112"> 
                                <input name="search" type="image" onclick="submit1();return false;" src="/agt/public/images/search.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'"></td>
                              <td width="340"> 
                                <input name="reset" type="image" onclick="TeachmngForm.reset();return false;" src="/agt/public/images/reset.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'"></td>
                            </tr>
                          </table>
</td>
                      </tr>
                    </table>
                    <p>&nbsp; </p>

</form>



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