rs_add_all.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 692 行 · 第 1/2 页
JSP
692 行
.style5 {color: #000000}
.style6 {color: #FF0080}
.style8 {font-size: 12px}
body {
background-image: url(../img/0871.gif);
}
-->
</style>
</head>
<body>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<%@ page import="java.util.Calendar"%>
<%@ page import="java.text.*"%>
<% String meb=response.encodeURL("rs_add_all_result.jsp");%>
<% String newcondition="select * from zgxx";
conn.setcondition(newcondition);
ResultSet rs=conn.getrs();
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMddHHmmss");
Calendar nowtime=Calendar.getInstance();
String bh="Z"+formatter.format(nowtime.getTime());
String dlmm=formatter.format(nowtime.getTime());
int all=0;
while(rs.next()){all++;}
%>
<div align="center">
在数据库中找到在职正式职工信息共<%=all%>条<a <% String meb_main=response.encodeURL("../index/rs_index.jsp");%>href="<%=meb_main%>">返回主菜单</a></div>
<form name="add" method="post" action="<%=meb%>?old_all=<%=all%>" onsubmit="return check()">
<table width="706" border="0" align="center" cellpadding="0" cellspacing="2">
<tr>
<td nowrap bordercolor="#FF99CC"><div align="right" class="style5">编号:</div></td>
<td width="91" nowrap><span class="style6"><span class="style8">系统自动分配
<input name="bh" type="hidden" id="bh2" value="<%=bh%>">
</span>
</span></td>
<td width="63" nowrap class="style5"><div align="right">部门:</div></td>
<td width="91" nowrap><select name="bm" id="select12">
<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></td>
<td nowrap><div align="right" class="style5">姓名:</div></td>
<td width="91" nowrap><input name="xm" type="text" id="xm" size="12" maxlength="4" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid"></td>
<td nowrap class="style5"><div align="right">性别:</div></td>
<td width="91" nowrap><select name="xb" id="select14">
<option value="0">--未选择--</option>
<option value="男">男</option>
<option value="女">女</option>
</select></td>
</tr>
<tr>
<td nowrap bordercolor="#FF99CC"><div align="right" class="style5">现任职务:</div></td>
<td nowrap><input name="xrzw" type="text" id="xrzw" size="12" maxlength="5" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid"></td>
<td nowrap class="style5"><div align="right">出生年月:</div></td>
<td colspan="3" nowrap><input name="csny_year" type="text" id="csny_year" size="8" maxlength="4" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid">
年
<select name="csny_month" id="select26" 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_day" id="select27" 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>
日</td>
<td nowrap class="style5"><div align="right">民族:</div></td>
<td nowrap><select name="mz" id="select17">
<option value="0">--未选择--</option>
<option value="汉">汉</option>
<option value="满">满</option>
<option value="回">回</option>
<option value="蒙古">蒙古</option>
<option value="维吾尔">维吾尔</option>
</select></td>
</tr>
<tr>
<td nowrap bordercolor="#FF99CC"><div align="right" class="style5">籍贯:</div></td>
<td nowrap><select name="jg" id="select16">
<option value="0">--未选择--</option>
<option value="北京">北京</option>
<option value="上海">上海</option>
<option value="天津">天津</option>
</select></td>
<td nowrap class="style5"><div align="right">政治面目:</div></td>
<td nowrap><select name="zzmm" id="select22">
<option value="0">--未选择--</option>
<option value="党员">党员</option>
<option value="团员">团员</option>
<option value="群众">群众</option>
<option value="少先队员">少先队员</option>
</select></td>
<td nowrap class="style5"><div align="right">职称:</div></td>
<td nowrap><select name="zc" id="select20">
<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 class="style5"><div align="right">文化程度:</div></td>
<td nowrap><select name="whcd" id="select15">
<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></td>
</tr>
<tr>
<td nowrap bordercolor="#FF99CC"><div align="right" class="style5">健康状况:</div></td>
<td nowrap><select name="jkzk" id="select18">
<option value="0">--未选择--</option>
<option value="良好">良好</option>
</select></td>
<td nowrap class="style5"><div align="right">婚姻状况:</div></td>
<td nowrap><select name="hyzk" id="select19">
<option value="0">--未选择--</option>
<option value="未婚">未婚</option>
<option value="已婚">已婚</option>
<option value="离异">离异</option>
</select></td>
<td nowrap class="style5"><div align="right">基本工资:</div></td>
<td nowrap><input name="jbgz" type="text" id="jbgz" size="12" maxlength="7" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid"></td>
<td nowrap class="style5"><div align="right">各种补贴: </div></td>
<td nowrap><input name="gzbt" type="text" id="gzbt" size="12" maxlength="7" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid"></td>
</tr>
<tr>
<td nowrap bordercolor="#FF99CC"><div align="right" class="style5">参加工作时间:</div></td>
<td colspan="3" nowrap><input name="cjgzsj_year" type="text" id="cjgzsj_year" size="8" maxlength="4" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid">
年
<select name="cjgzsj_month" id="select24" onChange="oncjgzsj()">
<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="cjgzsj_day" id="select25" onChange="oncjgzsj()">
<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>
日</td>
<td nowrap class="style5"><div align="right">进本单位时间:</div></td>
<td colspan="3" nowrap><input name="jbdwsj_year" type="text" id="jbdwsj_year" size="8" maxlength="4" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid">
年
<select name="jbdwsj_month" id="select28" onChange="onjbdwsj()">
<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="jbdwsj_day" id="select29" onChange="onjbdwsj()">
<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>
日</td>
</tr>
<tr>
<td nowrap bordercolor="#FF99CC"><div align="right" class="style5">家庭住址:</div></td>
<td colspan="7" nowrap><input name="jtzz" type="text" id="jtzz" size="90" maxlength="25" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid"></td>
</tr>
<tr>
<td nowrap bordercolor="#FF99CC"><div align="right" class="style5">家庭出身:</div></td>
<td nowrap><select name="jtcs" id="select21">
<option value="0">--未选择--</option>
<option value="工人">工人</option>
<option value="贫农">贫农</option>
<option value="中农">中农</option>
<option value="富农">富农</option>
<option value="地主">地主</option>
<option value="资本家">资本家</option>
</select></td>
<td nowrap class="style5">家庭电话:</td>
<td nowrap><input name="jtdh" type="text" id="jtdh" size="12" maxlength="12" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid"></td>
<td nowrap><div align="right" class="style5">手机号码:</div></td>
<td nowrap><input name="sjhm" type="text" id="sjhm" size="12" maxlength="11" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid"></td>
<td nowrap class="style5"><div align="right">个人成份:</div></td>
<td nowrap><select name="grcf" id="select23">
<option value="0">--未选择--</option>
<option value="工人">工人</option>
<option value="农民">农民</option>
<option value="知识分子">知识分子</option>
<option value="资本家">资本家</option>
</select></td>
</tr>
<tr>
<td nowrap bordercolor="#FF99CC"><div align="right" class="style5">电子邮件:</div></td>
<td colspan="5" nowrap><div align="left">
<input name="dzyj" type="text" id="dzyj" size="65" maxlength="30" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid">
</div></td>
<td nowrap class="style5"><div align="right">登录密码:</div></td>
<td nowrap><span class="style3">
<span class="style6">系统自动分配</span>
<input name="dlmm" type="hidden" id="dlmm" value="<%=dlmm%>">
</span></td>
</tr>
<tr>
<td nowrap bordercolor="#FF99CC"><div align="right" class="style5">备注:</div></td>
<td colspan="7" nowrap><input name="bz" type="text" id="bz" size="90" maxlength="5" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(255,255,255) 0px solid; BORDER-RIGHT: rgb(255,255,255) 0px solid; BORDER-TOP: rgb(255,255,255) 0px solid"></td>
</tr>
<tr>
<td colspan="4" nowrap><div align="center">
<input type="submit" name="Submit" value="提交">
</div></td>
<td colspan="4" nowrap><div align="center">
<input type="reset" name="Submit2" value="重置">
</div></td>
</tr>
</table>
</form>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
<%
}
}
%>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?