rs_cx_card.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 1,807 行 · 第 1/5 页
JSP
1,807 行
.style4 {font-size: 14px}
.style5 {color: #FFFFFF; font-size: 14px; }
body {
background-image: url(../img/BK060.GIF);
}
-->
</style>
</head>
<body>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<%@ page import="java.util.Calendar"%>
<%String meb=response.encodeURL("rs_cx_card.jsp");%>
<div align="center">
<select name="cx_way" onChange="MM_jumpMenu('parent',this,0)">
<option value="" selected>请选择查询方式</option>
<option value="<%=meb%>?way=tj_bh">按编号查询</option>
<option value="<%=meb%>?way=tj_xm">按姓名查询</option>
<option value="<%=meb%>?way=tj_jtzz">按家庭住址查询</option>
<option value="<%=meb%>?way=tj_jtdh">按家庭电话查询</option>
<option value="<%=meb%>?way=tj_dzyj">按电子邮件查询</option>
<option value="<%=meb%>?way=tj_sjhm">按手机号码查询</option>
<option value="<%=meb%>?way=tj_zhtj">按综合条件查询</option>
<option value="<%=meb%>?way=all">查询全部</option>
</select>
<a <%String meb_rs_main=response.encodeURL("../index/rs_index.jsp");%>href="<%=meb_rs_main%>">返回主菜单</a></div>
<div align="center">
<%
String way=request.getParameter("way");
if(way==null){way="";}
conn.setcondition(way);
way=conn.toChinese();
if(way.equals("")){}
else
{int i=0;
%>
</div>
<form name="cx_tj" method="post" action="<%=meb%>?way=<%=way%>" onsubmit="return <%=way%>()">
<div align="center">
<%if(way.equals("tj_bh"))
{%>请输入职工编号:
<input name="bh" type="text" id="bh" size="15" maxlength="15">
<input type="submit" name="Submit" value="查询">
<%}%>
<%if(way.equals("tj_xm"))
{%>请输入职工姓名:
<input name="xm" type="text" id="bh" size="8" maxlength="8">
部门:
<select name="bm" id="bm">
<option value="0">--不限定--</option>
<%String condition_bm="select * from BM";
conn.setcondition(condition_bm);
ResultSet rs_bm=conn.getrs();
while(rs_bm.next())
{
%>
<option value="<%=rs_bm.getString("BM")%>"><%=rs_bm.getString("BM")%></option>
<%}%>
</select>
<input type="submit" name="Submit" value="查询">
<%}%>
<%if(way.equals("tj_jtzz"))
{%>请输入职工的家庭住址:
<input name="jtzz" type="text" id="bh" size="50" maxlength="50">
部门:
<select name="bm" id="bm">
<option value="0">--不限定--</option>
<%String condition_bm="select * from BM";
conn.setcondition(condition_bm);
ResultSet rs_bm=conn.getrs();
while(rs_bm.next())
{
%>
<option value="<%=rs_bm.getString("BM")%>"><%=rs_bm.getString("BM")%></option>
<%}%>
</select>
<input type="submit" name="Submit" value="查询">
<%}%>
<%if(way.equals("tj_jtdh"))
{%>请输入职工的家庭电话:
<input name="jtdh" type="text" id="bh" size="12" maxlength="12" >
部门:
<select name="bm" id="bm">
<option value="0">--不限定--</option>
<%String condition_bm="select * from BM";
conn.setcondition(condition_bm);
ResultSet rs_bm=conn.getrs();
while(rs_bm.next())
{
%>
<option value="<%=rs_bm.getString("BM")%>"><%=rs_bm.getString("BM")%></option>
<%}%>
</select>
<input type="submit" name="Submit" value="查询">
<%}%>
<%if(way.equals("tj_dzyj"))
{%>请输入职工的电子邮件地址:
<input name="dzyj" type="text" id="bh" size="30" maxlength="30">
部门:
<select name="bm" id="bm">
<option value="0">--不限定--</option>
<%String condition_bm="select * from BM";
conn.setcondition(condition_bm);
ResultSet rs_bm=conn.getrs();
while(rs_bm.next())
{
%>
<option value="<%=rs_bm.getString("BM")%>"><%=rs_bm.getString("BM")%></option>
<%}%>
</select>
<input type="submit" name="Submit" value="查询">
<%}%>
<%if(way.equals("tj_sjhm"))
{%>请输入职工的手机号码:
<input name="sjhm" type="text" id="bh" size="11" maxlength="11" onchange="onsjhm()">
部门:
<select name="bm" id="bm">
<option value="0">--不限定--</option>
<%String condition_bm="select * from BM";
conn.setcondition(condition_bm);
ResultSet rs_bm=conn.getrs();
while(rs_bm.next())
{
%>
<option value="<%=rs_bm.getString("BM")%>"><%=rs_bm.getString("BM")%></option>
<%}%>
</select>
<input type="submit" name="Submit" value="查询">
<%}%>
<%if(way.equals("tj_zhtj"))
{%>请输入职工的综合条件(如某项条件不填或不选择则为不限定该条件):
<table border="0" align="center" cellspacing="2">
<tr>
<td nowrap><div align="right">部门:
<select name="bm" id="bm">
<option value="0">--不限定--</option>
<%String condition_bm="select * from BM";
conn.setcondition(condition_bm);
ResultSet rs_bm=conn.getrs();
while(rs_bm.next())
{
%>
<option value="<%=rs_bm.getString("BM")%>"><%=rs_bm.getString("BM")%></option>
<%}%>
</select>
</div></td>
<td nowrap><div align="center"></div>
<div align="right">性别:
<select name="xb" id="xb">
<option value="0">--不限定--</option>
<option value="男">男</option>
<option value="女">女</option>
</select>
</div></td>
<td nowrap><div align="left">年龄范围:
<input name="nl_min" type="text" id="nl_min2" size="2" maxlength="2" onchange="onnl()">
至
<input name="nl_max" type="text" id="nl_max2" size="2" maxlength="2" onchange="onnl()">
岁</div></td>
<td nowrap><div align="left">文化程度:
<select name="whcd" id="select13">
<option value="0">--不限定--</option>
<%String condition_xl="select * from XL";
conn.setcondition(condition_xl);
ResultSet rs_xl=conn.getrs();
while(rs_xl.next())
{
%>
<option value="<%=rs_xl.getInt("XLBH")%>"><%=rs_xl.getString("XLMC")%></option>
<%}%>
</select>
<select name="whcd_fw" id="whcd_fw">
<option value="1">唯一</option>
<option value="2">以上</option>
<option value="0">以下</option>
</select>
</div></td>
</tr>
<tr>
<td nowrap><div align="right">籍贯:
<select name="jg" id="select5">
<option value="0">--不限定--</option>
<option value="北京">北京</option>
</select>
</div></td>
<td nowrap><div align="right">民族:
<select name="mz" id="select">
<option value="0">--不限定--</option>
<option value="汉">汉</option>
<option value="满">满</option>
<option value="回">回</option>
<option value="蒙古">蒙古</option>
<option value="维吾尔">维吾尔</option>
</select>
</div></td>
<td nowrap><div align="left">健康状况:
<select name="jkzk" id="jkzk">
<option value="0">--不限定--</option>
<option value="良好">良好</option>
</select>
</div></td>
<td nowrap><div align="left">婚姻状况:
<select name="hyzk" id="hyzk">
<option value="0">--不限定--</option>
<option value="未婚">未婚</option>
<option value="已婚">已婚</option>
<option value="离异">离异</option>
</select>
</div></td>
</tr>
<tr>
<td nowrap>职称:
<select name="zc" id="select3">
<option value="0">--不限定--</option>
<%String condition_zc="select * from ZC";
conn.setcondition(condition_zc);
ResultSet rs_zc=conn.getrs();
while(rs_zc.next())
{
%>
<option value="<%=rs_zc.getString("ZC")%>"><%=rs_zc.getString("ZC")%></option>
<%}%>
</select></td>
<td nowrap><div align="left">家庭出身:
<select name="jtcs" id="jtcs">
<option value="0">--不限定--</option>
<option value="工人">工人</option>
<option value="贫农">贫农</option>
<option value="中农">中农</option>
<option value="富农">富农</option>
<option value="地主">地主</option>
<option value="资本家">资本家</option>
</select>
</div></td>
<td nowrap><div align="left">政治面目:
<select name="zzmm" id="select2">
<option value="0">--不限定--</option>
<option value="党员">党员</option>
<option value="团员">团员</option>
<option value="群众">群众</option>
<option value="少先队员">少先队员</option>
</select>
</div></td>
<td nowrap><div align="left">个人成份:
<select name="grcf" id="grcf">
<option value="0">--不限定--</option>
<option value="工人">工人</option>
<option value="农民">农民</option>
<option value="知识分子">知识分子</option>
<option value="资本家">资本家</option>
</select>
</div></td>
</tr>
<tr>
<td colspan="4" nowrap>
<div align="center">
<input name="csny" type="checkbox" id="csny" value="checkbox" onchange="oncsny()">
职工出生年月:
<input name="csny_min_year" type="text" id="csny_min_year" size="4" maxlength="4" onchange="oncsny()">
年
<select name="csny_min_month" id="csny_min_month" onchange="oncsny()">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
月
<select name="csny_min_day" id="csny_min_day" onchange="oncsny()">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
日至
<input name="csny_max_year" type="text" id="csny_max_year" size="4" maxlength="4" onchange="oncsny()">
年
<select name="csny_max_month" id="csny_max_month" onchange="oncsny()">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
月
<select name="csny_max_day" id="csny_max_day" onchange="oncsny()">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
日之间</div></td></tr>
<tr>
<td colspan="4" nowrap>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?