📄 rs_jtcy_update.jsp
字号:
conn.setcondition(condition_bh);
ResultSet rs_zgxx=conn.getrs();
rs_zgxx.last();
int all_zgxx=rs_zgxx.getRow();
condition_bh="select * from txzgxx where bh='"+bh+"'";
conn.setcondition(condition_bh);
ResultSet rs_txzgxx=conn.getrs();
rs_txzgxx.last();
int all_txzgxx=rs_txzgxx.getRow();
all=all_zgxx+all_txzgxx;
if(all>1)
{out.print("<center>出现职工编号重复错误！请予管理员联系！</center>");}
else
{ if(all==0){if(bh.equals("")){out.print("<center>您还没有输入编号,请输入！</center>");}else{out.print("<center>没有编号为"+bh+"的职工,请重新填写</center>");}}
if(all==1)
{ if(all_zgxx==1){rs=rs_zgxx;}
if(all_txzgxx==1){rs=rs_txzgxx;}
}
}
}
if(bh.equals("")||all!=1)
{
%>
<form action="<%=meb%>" method="post" name="intobh" id="intobh" onSubmit="return check_bh()">
<div align="center">请填写所要修改'家庭成员信息'的'职工'的编号
<input name="bh" type="text" id="bh" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="15" maxlength="15">
<input type="submit" name="Submit3" value="确定">
</div></form>
<% }
else
{ rs.first();
String condition_jtcy="select * from jtcy where bh='"+bh+"'";
conn.setcondition(condition_jtcy);
ResultSet rs_jtcy=conn.getrs();
rs_jtcy.last();
int all_jtcy=rs_jtcy.getRow();
if(all_jtcy==0){out.print("<center>"+bh+"号"+rs.getString("xm")+"没有家庭成员</center>");}
else
{ out.print("<center>找到"+bh+"号"+rs.getString("xm")+"家庭成员记录共"+all_jtcy+"个</center>");
String pageNO=request.getParameter("pageNO");
if(pageNO==null){pageNO="1";}
int pageNO_c=Integer.parseInt(pageNO);
int pagecount=1,pageall=0,i=0;
if(all_jtcy<=pagecount){pageall=1;}
else
{ int lastcount=0;
lastcount=all_jtcy%pagecount;
if(lastcount==0){pageall=all_jtcy/pagecount;}
else{pageall=all_jtcy/pagecount+1;}
}
rs_jtcy.beforeFirst();
for(i=0;i<(pageNO_c-1)*pagecount;i++){rs_jtcy.next();}
%>
<div align="center">
第<%=pageNO_c%>页
<%if(pageNO_c>1){String page_send=Integer.toString(1);%>
<a href="<%=meb%>?pageNO=<%=page_send%>&bh=<%=bh%>">第一页</a>
<%}%>
<%if(pageNO_c>1){String page_send=Integer.toString(pageNO_c-1);%>
<a href="<%=meb%>?pageNO=<%=page_send%>&bh=<%=bh%>">上一页</a>
<%}%>
<%if(pageNO_c<pageall){String page_send=Integer.toString(pageNO_c+1);%>
<a href="<%=meb%>?pageNO=<%=page_send%>&bh=<%=bh%>">下一页</a>
<%}%>
<%if(pageNO_c<pageall){String page_send=Integer.toString(pageall);%>
<a href="<%=meb%>?pageNO=<%=page_send%>&bh=<%=bh%>">最末页</a>
<%}%>
共<%=pageall%>页
</div>
<%for(i=0;i<pagecount;i++)
{ if(!rs_jtcy.next()){break;}
%>
<form <%String meb_rs_jtcy_update_sav=response.encodeURL("rs_jtcy_update_sav.jsp");%>action="<%=meb_rs_jtcy_update_sav%>?pageNO=<%=pageNO%>" method=post name="add" id="add" onSubmit="return check()">
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td nowrap class="style12"><div align="right"> 编号:</div></td>
<td colspan="3" nowrap><div align="left"><span class="style14"><%=rs.getString("bh")%>
<input name="bh" type="hidden" id="bh" value="<%=bh%>">
</span></div></td>
</tr>
<tr>
<td nowrap class="style12"><div align="right">姓名:</div></td>
<td colspan="3" nowrap><div align="left"><%=rs.getString("xm")%>
<input name="xm" type="hidden" id="xm" value="<%=rs.getString("xm")%>">
</div></td>
</tr>
<tr>
<td class="style12" nowrapclass="f1"><div align="right">成员姓名:</div></td>
<td colspan="3" nowrap> <div align="left">
<input name="cyxm" type="text" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" value="<%=rs_jtcy.getString("CYXM")%>" maxlength="4">
<input name="ycyxm" type="hidden" value="<%=rs_jtcy.getString("CYXM")%>">
</div></td>
</tr>
<tr>
<td height="30" nowrap class="style12"><div align="right">家属关系:</div></td>
<td colspan="3" nowrap><div align="left">
<input name="jsgx" type="text" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" value="<%=rs_jtcy.getString("JSGX")%>" maxlength="3">
<input name="yjsgx" type="hidden" value="<%=rs_jtcy.getString("JSGX")%>">
</div></td>
</tr>
<tr>
<td height="30" nowrap class="style12"><div align="right">出生年月:</div></td>
<td colspan="3" nowrap>
<div align="left">
<% Calendar csny_date=Calendar.getInstance();
csny_date.clear();
csny_date.setTime(rs_jtcy.getDate("CSNY"));
int csny_year=csny_date.get(csny_date.YEAR);
int csny_month=csny_date.get(csny_date.MONTH)+1;
int csny_day=csny_date.get(csny_date.DATE);
%>
<input name="csny_year" type="text" id="csny_year2" 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" value="<%=csny_year%>" size="4" maxlength="4">
年
<select name="csny_month" id="select26" onChange="oncsny()">
<option value="<%=csny_month%>"><%=csny_month%></option>
<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="<%=csny_day%>"><%=csny_day%></option>
<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="ycsny" type="hidden" value="<%=rs_jtcy.getDate("CSNY")%>">
</div></td>
</tr>
<tr>
<td height="30" nowrap class="style12"><div align="right">婚姻状况:</div></td>
<td colspan="3" nowrap><div align="left">
<select name="hyzk" id="hyzk">
<option value="<%=rs_jtcy.getString("HYZK")%>"><%=rs_jtcy.getString("HYZK")%></option>
<option value="未婚">未婚</option>
<option value="已婚">已婚</option>
<option value="离异">离异</option>
</select>
<input name="yhyzk" type="hidden" value="<%=rs_jtcy.getString("HYZK")%>">
</div></td>
</tr>
<tr>
<td height="30" nowrap class="style12"><div align="right">文化程度:</div></td>
<td colspan="3" nowrap><div align="left">
<select name="whcd" id="select15">
<option value="<%=rs_jtcy.getString("WHCD")%>"><%=rs_jtcy.getString("WHCD")%></option>
<%String condition_xl="select * from XL";
conn.setcondition(condition_xl);
ResultSet rs_xl=conn.getrs();
while(rs_xl.next())
{
%>
<option value="<%=rs_xl.getString("XLMC")%>"><%=rs_xl.getString("XLMC")%></option>
<%}%>
</select>
<input name="ywhcd" type="hidden" value="<%=rs_jtcy.getString("WHCD")%>">
</div></td>
</tr>
<tr>
<td height="30" nowrap class="style12"><div align="right">政治面貌:</div></td>
<td colspan="3" nowrap><div align="left">
<select name="zzmm" id="select22">
<option value="<%=rs_jtcy.getString("ZZMM")%>"><%=rs_jtcy.getString("ZZMM")%></option>
<option value="党员">党员</option>
<option value="团员">团员</option>
<option value="群众">群众</option>
<option value="少先队员">少先队员</option>
</select>
<input name="yzzmm" type="hidden" value="<%=rs_jtcy.getString("ZZMM")%>">
</div></td>
</tr>
<tr>
<td height="30" nowrap class="style12"><div align="right">工作单位:</div></td>
<td colspan="3" nowrap><div align="left">
<input name="gzdw" type="text" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" value="<%=rs_jtcy.getString("GZDW")%>">
<input name="ygzdw" type="hidden" value="<%=rs_jtcy.getString("GZDW")%>">
</div></td>
</tr>
<tr>
<td height="30" nowrap class="style12"><div align="right">职务工种:</div></td>
<td colspan="3" nowrap><div align="left">
<input name="zwgz" type="text" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" value="<%=rs_jtcy.getString("ZWGZ")%>">
<input name="yzwgz" type="hidden" value="<%=rs_jtcy.getString("ZWGZ")%>">
</div></td>
</tr>
<tr>
<td height="27" nowrap class="style12"><div align="right">工资:</div></td>
<td colspan="3" nowrap><div align="left">
<input name="gz" type="text" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" value="<%=rs_jtcy.getString("GZ")%>" maxlength="9">
<input name="ygz" type="hidden" value="<%=rs_jtcy.getString("GZ")%>">
</div></td>
</tr>
<tr>
<td height="27" nowrap class="style12"><div align="right">经济来源:</div></td>
<td colspan="3" nowrap><div align="left">
<input name="jjly" type="text" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" value="<%=rs_jtcy.getString("JJLY")%>">
<input name="yjjly" type="hidden" value="<%=rs_jtcy.getString("JJLY")%>">
</div></td>
</tr>
<tr>
<td colspan="2" nowrap class="f1">
<div align="center">
<input type="submit" name="Submit" value="提交">
</div></td>
<td width="121" nowrap class="f1"><div align="center"></div></td>
<td width="62" nowrap class="f1"><div align="center">
<input type="reset" name="Submit2" value="重置">
</div></td>
</tr>
</table>
<br>
</center>
</form>
<% }
}
}
%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -