querylessonstaff.jsp

来自「培训考试系统代码」· JSP 代码 · 共 122 行

<%@ page contentType="text/html;charset=gb2312"%> 
<%@ include file="/agt/public/jsp/top.jsp" %>
<!--<title>查询人员列表</title>-->
<script>
function submit1()
{   
    TrnmngForm.submit();
    return true;
}

</script>
<form name="TrnmngForm" method="post" action="/TrnmngAction.do" >
<input type="hidden" name="operatorflag" value = "TRNMNG_QUERYLESSONSTAFF">
                    <table width="539" border="0" cellpadding="3" cellspacing="1" class="table-cs1">
                      <tr>
      <td width="80" align="center" class="td-cs1">工号</td>
                        <td class="td-cs2"> 
                          <input name="staffno" type="text" class="input2" maxlength=10>
                        </td>
  </tr>
  <tr>
      <td width="80" align="center" class="td-cs1">姓名</td>
      <td class="td-cs2"> 
        <input name="staffname" type="text" class="input2" maxlength=10>
      </td>
  </tr>
  <tr>
      <td width="80" align="center" class="td-cs1">部门</td>
      <td class="td-cs2"> 
        <select name="department" class="input3">
          <option value="" selected>--不限--</option>
      <%
        SysDbConn aplcoms = null;
        aplcoms = SysConnPool.getInstance().getAplComs();
        aplcoms.preparedQuery("");
        SysResultSet rs1 =aplcoms.csCommonQuery("SQL_AGT_QueryOrgaList","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="80" align="center" class="td-cs1">分组</td>
      <td class="td-cs2"> 
        <select name="group" class="input3">
          <option value="" selected>--不限--</option>
      <%
        aplcoms.preparedQuery("");
        SysResultSet rs2 =aplcoms.csCommonQuery("SQL_AGT_QueryGroup","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>

      <%
        }
     }
    %>
         </select>
      </td>
  </tr>
  <tr>
      <td width="80" align="center" class="td-cs1">技能</td>
      <td class="td-cs2"> 
        <select name="skill" class="input3">
          <option value="" selected>--不限--</option>
      <%
        aplcoms.preparedQuery("");
        SysResultSet rs3 =aplcoms.csCommonQuery("SQL_AGT_QuerySkills","1","-1").getResultSet();

       if (rs3 != null)
       {
      for (int k = 0; k < rs3.getMetaData().getRecordCount(); k++)
       {
         rs3.setRecord(k);
    %>
       <option value=<%= rs3.getString(0) %> > <%=  rs3.getString(1) %>  </option>

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

    %>
         </select>      
         </td>
  </tr>
</table>
                    <table width="539" height="35" border="0" cellpadding="0" cellspacing="0">
                      <tr> 
                        <td><table width="226" border="0" align="center" cellpadding="0" cellspacing="0">
                            <tr> 
                              <td width="150"> 
                                <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="150">
                                <input name="reset" type="image" onclick="TrnmngForm.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>
                  </form>
<%@ include file="/agt/public/jsp/bot.jsp" %>