queryplan1.jsp

培训考试系统代码

<%@ page contentType="text/html;charset=gb2312"%> 
<%@ include file="/agt/public/jsp/top.jsp" %>
<title>查询接受的学习计划 </title>
<form name="PlanmngForm" method="post" action="/PlanmngAction.do" >
<input type="hidden" name="operatorflag" value = "PLANMNG_QUERY_SYNLIST">
<input type="hidden" name="recieverid" value = "<%=request.getSession().getAttribute("staffno").toString()%>">
  <table width="539" border="0" cellpadding="3" cellspacing="1" class="table-cs1">
  <tr>
      <td width="90" height="25" align="center" class="td-cs1"><font size="-1">制订人工号</font></td>
      <td class="td-cs2"><font size="-1"> 
        <input name="senderid" type="text" class="input2" maxlength=10>
      </font></td>
  </tr>
   <tr>
      <td width="90" height="25" align="center" class="td-cs1"><font size="-1">责任人工号</font></td>
      <td class="td-cs2"><font size="-1"> 
        <input name="responseid" type="text" class="input2" maxlength=10>
     </font></td>
  </tr>
   <tr>
      <td width="90" height="25" align="center" class="td-cs1"><font size="-1">计划名称</font></td>
      <td class="td-cs2"><font size="-1"> 
        <input name="title" type="text" class="input2" maxlength=25>
     </font></td>
  </tr>
  <tr>
      <td width="90" height="25" align="center" class="td-cs1"><font size="-1">课程名称</font></td>
       
      <td class="td-cs2">  <input name="courseid" type="text" class="input2" size="50" maxlength=50>
      </td>
    </tr>
    
  <tr>
      <td width="90" height="25" align="center" class="td-cs1"><font size="-1">考试名称</font></td>
       
      <td class="td-cs2"> 
        <select name="testid" class="input3">
          <option value="" selected >--不限--</option>
   <%
        SysDbConn aplcoms = null;
        aplcoms = SysConnPool.getInstance().getAplComs();
        aplcoms.preparedQuery("");
        SysResultSet rs2 =aplcoms.csCommonQuery("SQL_AGT_QueryTestList","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="90" height="25" align="center" class="td-cs1"><font size="-1">计划状态</font></td>
      <td class="td-cs2"> 
        <select name="status" class="input3">
          <option value="" selected >--不限--</option>
       <option value="0"  >未下发</option>
       <option value="1"  >未反馈</option>
       <option value="2"  >已反馈</option>
       <option value="3"  >已归档</option>
       <option value="4"  >已取消</option>
      </select> </td>
 </tr>
 <tr>
      <td width="90" height="25" align="center" class="td-cs1"><font size="-1">反馈情况</font></td>
      <td class="td-cs2"> 
        <select name="feedback" class="input3">
          <option value="" selected >--不限--</option>
       <option value="0">未完成</option>
       <option value="1">已完成</option>
      </select> </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%"> 
                                <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> <a href="javascript:;" onMouseOver="MM_swapImage('Image6','','/agt/public/images/reset_2.gif',1)" onMouseOut="MM_swapImgRestore()"> 
                                <input name="reset" type="image" onClick="PlanmngForm.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'">
                                </a> 
                                <script>
function submit1()
{
    document.PlanmngForm.submit();
    return true;
}
</script>
                              </td>
          </tr>
        </table>
                        </td>
    </tr>
  </table>

</form>

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