agtmngstaffquery.jsp

培训考试系统代码

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

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

<!-- title>查询人员列表</title -->

<script>

function submit1()

{   

    AgtmngStaffForm.submit();

    return true;

}

</script>



<form name="AgtmngStaffForm" method="post" action="/AgtmngStaffAction.do" >

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

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

    <tr>

      <td width="19%" height="25" align="center" class="td-cs1">工　　号</td>

      <td width="81%" height="25" class="td-cs2">

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

      </td>

  </tr>

  <tr>

      <td height="25" align="center" class="td-cs1">姓　　名</td>

      <td height="25" class="td-cs2"> 

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

      </td>

  </tr>

  <tr>

      <td height="25" align="center" class="td-cs1">部　　门</td>

      <td height="25" 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 height="25" align="center" class="td-cs1">分　　组</td>

      <td height="25" 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 height="25" align="center" class="td-cs1">技　　能</td>

      <td height="25" 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="30" border="0" cellpadding="0" cellspacing="0">

    <tr> 

      <td height="35" align="center"> <table width="55%" height="25" border="0" cellpadding="0" cellspacing="0">

          <tr> 

                              <td width="28%"><input name="submit" 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="65%"> 
                                <input name="reset" type="image" onclick="AgtmngStaffForm.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" %>