📄 personcount.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="DIC.*,java.util.*,person.*" %>
<%@ page import="java.util.*" %>
<html>
<head>
<title> selectcardmes </title>
<script>
function change(){
var a=document.all["SUBAREA"].value;
//alert(a);
window.location="personcount.jsp?subarea="+a;
}
</script>
</head>
<body >
<form name="form1" method="post" action="personpage.jsp">
<table width="642" height="377" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" bgcolor="#ebe8e8">
<tr>
<td align="left" valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20"> </td>
</tr>
<tr>
<td><table width="523" height="20" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFCC">
<tr>
<td height="18" colspan="3"><font size="2" face="宋体"><strong> 从业人员信息多条件查询</strong></font><strong><font size="2">：</font></strong></td>
</tr>
</table></td>
</tr>
</table>
<br>
<table width="638" height="230">
<tr>
<td width="53" height="36" align="left"> </td>
<td width="105" align="left"><font size="2" face="宋体">所在区</font><font size="2" face="宋体">：</font></td>
<td width="464"><font size="2"><select name="SUBAREA" onchange="change()" >
<option value="">--请选区--</option>
<%
String subarea=request.getParameter("subarea");
DicOperate operate=new DicOperate();
DICBean db= new DICBean();
operate.setTableName("dic_subarea");
List lst=operate.QryRcdByValue("");
for(int i=0;i<lst.size();i++){
db=(DICBean)lst.get(i);
%>
<option value="<%=db.getDIC_CODE()%>" <%if(db.getDIC_CODE().equals(subarea)){%> selected <%}%>>--<%=db.getDIC_TEXT()%>--</option>
<%}
%>
</select></font></td>
</tr>
<tr>
<td width="53" height="31" align="left"> </td>
<td width="105" align="left"><font size="2">场所名称：</font></td>
<td><font size="2"><select name="FUNSERVERID">
<option value="">--请选场所--</option>
<%
PERSON person = new PERSON();
PersonBean pb = new PersonBean();
String sql="select * from FUNSERVER_LIST where SUBAREA='"+subarea+"'";
lst=person.GetRecordBySql(sql);
for(int i=0;i<lst.size();i++){
pb=(PersonBean)lst.get(i);
%>
<option value="<%=pb.getFUNSERVERID()%>"><%=pb.getFUNSERVERNAME()%></option>
<%
}
%>
<option></option>
</select></font></td>
</tr>
<tr>
<td height="31" align="left"> </td>
<td align="left"><font size="2" face="宋体">人员姓名：</font></td>
<td><font size="2">
<input name="PERSONNELNAME" type="text" class="personid" size="18" maxlength="6">
</font></td>
</tr>
<tr>
<td height="31" align="left"> </td>
<td align="left"><font size="2" face="宋体">身份证号：</font></td>
<td><font size="2">
<input name="IDCARD" type="text" class="personid" size="18" maxlength="18">
</font></td>
</tr>
<tr>
<td height="31" align="left"> </td>
<td align="left"><font size="2" face="宋体">人员类别：</font></td>
<td><select name="PTYPE">
<option value="">--请选人员类别--</option>
<%
// DicOperate operate=new DicOperate();
// DICBean db= new DICBean();
operate.setTableName("DIC_PTYPE");
lst=operate.QryRcdByValue("");
for(int i=0;i<lst.size();i++){
db=(DICBean)lst.get(i);
%>
<option value="<%=db.getDIC_CODE()%>">----<%=db.getDIC_TEXT()%>----</option>
<%}
%>
</select></td>
</tr>
<tr>
<td height="8" colspan="3" align="center"> </td>
</tr>
<tr>
<td height="44" colspan="3" align="center"> <input name="button" type="submit" class="Submit" value="查 询">
<input name="button " type="reset" class="Submit" value="重 置"></td>
</tr>
</table>
</td></tr></table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -