📄 rs_jtcy_update_sav.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%
String page_type=(String)session.getAttribute("page_type");
String page_name=(String)session.getAttribute("page_name");
if(page_type==null){page_type="";}
boolean page_ok=false;
if(session.isNew()){response.sendRedirect("../index.jsp");}
else
{ if(!page_type.equals("srs"))
{response.sendRedirect("../index.jsp");}
else
{ page_ok=true;
}
}
%>
<title>添加家庭成员</title>
<style type="text/css">
<!--
.style3 {color: #8080FF}
.style5 {font-size: 12px}
.style6 {
color: #FF55AA;
font-style: italic;
}
.style7 {
color: #C0C0C0;
font-weight: bold;
}
body {
background-image: url(../img/038.jpg);
}
-->
</style>
</head>
<body>
<%if(page_ok==true){%>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<div align="center">
<jsp:include page="../index/jtcy_entry_muen.jsp">
</jsp:include>
<%@ page import="java.util.Calendar"%>
<%@ page import="java.text.*"%>
<span class="style3">修改家庭成员结果页面<br></span>
<%String pageNO=request.getParameter("pageNO");
boolean true_false=true;
String bh=request.getParameter("bh");if(bh==null){bh="";true_false=false;}
String xm=request.getParameter("xm");if(xm==null){xm="";true_false=false;}
String cyxm=request.getParameter("cyxm");if(cyxm==null){cyxm="";true_false=false;}
String jsgx=request.getParameter("jsgx");if(jsgx==null){jsgx="";true_false=false;}
String csny_year=request.getParameter("csny_year");if(csny_year==null){csny_year="";true_false=false;}
String csny_month=request.getParameter("csny_month");if(csny_month==null){csny_month="";true_false=false;}
String csny_day=request.getParameter("csny_day");if(csny_day==null){csny_day="";true_false=false;}
String hyzk=request.getParameter("hyzk");if(hyzk==null){hyzk="";true_false=false;}
String whcd=request.getParameter("whcd");if(whcd==null){whcd="";true_false=false;}
String zzmm=request.getParameter("zzmm");if(zzmm==null){zzmm="";true_false=false;}
String gzdw=request.getParameter("gzdw");if(gzdw==null){gzdw="";true_false=false;}
String zwgz=request.getParameter("zwgz");if(zwgz==null){zwgz="";true_false=false;}
String gz=request.getParameter("gz");if(gz==null){gz="";true_false=false;}
String jjly=request.getParameter("jjly");if(jjly==null){jjly="";true_false=false;}
String ycyxm=request.getParameter("ycyxm");if(ycyxm==null){ycyxm="";true_false=false;}
String yjsgx=request.getParameter("yjsgx");if(yjsgx==null){yjsgx="";true_false=false;}
String ycsny=request.getParameter("ycsny");if(ycsny==null){ycsny="";true_false=false;}
String yhyzk=request.getParameter("yhyzk");if(yhyzk==null){yhyzk="";true_false=false;}
String ywhcd=request.getParameter("ywhcd");if(ywhcd==null){ywhcd="";true_false=false;}
String yzzmm=request.getParameter("yzzmm");if(yzzmm==null){yzzmm="";true_false=false;}
String ygzdw=request.getParameter("ygzdw");if(ygzdw==null){ygzdw="";true_false=false;}
String yzwgz=request.getParameter("yzwgz");if(yzwgz==null){yzwgz="";true_false=false;}
String ygz=request.getParameter("ygz");if(ygz==null){ygz="";true_false=false;}
String yjjly=request.getParameter("yjjly");if(yjjly==null){yjjly="";true_false=false;}
if(true_false==true)
{ conn.setcondition(bh);bh=conn.toChinese();
conn.setcondition(xm);xm=conn.toChinese();
String csny=csny_year+"-"+csny_month+"-"+csny_day;
float cygz=0;
if(gz.equals("无"))
{ cygz=0;}
else
{ cygz=Float.parseFloat(gz);}
String check_condition="select * from jtcy where bh='"+bh+"' and cyxm='"+cyxm+"' and jsgx='"+jsgx+"' and csny=to_timestamp('"+csny+"','yyyy-mm-dd') and hyzk='"+hyzk+"' and whcd='"+whcd+"' and zzmm='"+zzmm+"' and gzdw='"+gzdw+"' and zwgz='"+zwgz+"' and gz="+cygz+" and jjly='"+jjly+"'";
conn.setcondition(check_condition);
check_condition=conn.toChinese();
conn.setcondition(check_condition);
ResultSet rs_check=conn.getrs();
rs_check.last();
int all=rs_check.getRow();
if(all>0){out.print("已经有"+all+"条与要修改记录完全相同的记录请检查!请不要刷新此页");}
if(all==0)
{ String newcondition="UPDATE JTCY SET BH='"+bh+"',CYXM='"+cyxm+"' ,JSGX='"+jsgx+"' ,CSNY=to_timestamp('"+csny+"','yyyy-mm-dd') ,HYZK='"+hyzk+"' ,WHCD='"+whcd+"' ,ZZMM='"+zzmm+"' ,GZDW='"+gzdw+"' ,ZWGZ='"+zwgz+"' ,GZ="+cygz+" ,JJLY='"+jjly+"'where BH='"+bh+"' and CYXM='"+ycyxm+"' and JSGX='"+yjsgx+"' and CSNY=to_timestamp('"+ycsny+"','yyyy-mm-dd') and HYZK='"+yhyzk+"' and WHCD='"+ywhcd+"' and ZZMM='"+yzzmm+"' and GZDW='"+ygzdw+"' and ZWGZ='"+yzwgz+"' and GZ="+ygz+" and JJLY='"+yjjly+"'";
conn.setcondition(newcondition);
newcondition=conn.toChinese();out.print(newcondition);
conn.setcondition(newcondition);
String add_jtcy=conn.update();
out.print("<center>"+add_jtcy+"请检查!</center>");
String checkcondition="select * from jtcy where bh='"+bh+"'";
conn.setcondition(checkcondition);
ResultSet rs=conn.getrs();
%>
</div>
<table border="1" align="center" bordercolor="#FF99CC">
<% while(rs.next())
{
%>
<tr bordercolor="#FFFFFF">
<td height="0" colspan="12" nowrap>
<%if(bh.equals(rs.getString("BH"))&&cyxm.equals(rs.getString("CYXM"))){%>
<span class="style6">new</span>
<%}else{%>
<span class="style7">old</span>
<%}%>
</td>
</tr>
<tr>
<td nowrap bgcolor="#FF99CC"><span class="style5">职工编号:</span></td>
<td nowrap><span class="style5"><%=rs.getString("BH")%></span></td>
<td nowrap bgcolor="#FF99CC"><span class="style5">职工姓名:</span></td>
<td nowrap><span class="style5"><%=xm%></span></td>
<td nowrap bgcolor="#FF99CC"><span class="style5">成员姓名:</span></td>
<td nowrap><span class="style5"><%=rs.getString("CYXM")%></span></td>
<td nowrap bgcolor="#FF99CC"><span class="style5">家属关系:</span></td>
<td nowrap><span class="style5"><%=rs.getString("JSGX")%></span></td>
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">出生年月:</div></td>
<td nowrap><span class="style5"><%=rs.getDate("CSNY")%></span></td>
<td nowrap bgcolor="#FF99CC"><span class="style5">婚姻状况:</span></td>
<td nowrap><span class="style5"><%=rs.getString("HYZK")%></span></td>
</tr>
<tr>
<td nowrap bgcolor="#FF99CC"><span class="style5">文化程度:</span></td>
<td nowrap><span class="style5"><%=rs.getString("WHCD")%></span></td>
<td nowrap bgcolor="#FF99CC"><span class="style5">政治面目:</span></td>
<td nowrap><span class="style5"><%=rs.getString("ZZMM")%></span></td>
<td nowrap bgcolor="#FF99CC"><span class="style5">工作单位:</span></td>
<td nowrap><span class="style5"><%=rs.getString("GZDW")%></span></td>
<td nowrap bgcolor="#FF99CC"><span class="style5">职务工种:</span></td>
<td nowrap><span class="style5"><%=rs.getString("ZWGZ")%></span></td>
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">成员工资:</div></td>
<td nowrap><span class="style5"><%=rs.getString("GZ")%></span></td>
<td nowrap bgcolor="#FF99CC"><span class="style5">经济来源:</span></td>
<td nowrap><span class="style5"><%=rs.getString("JJLY")%></span></td>
</tr>
<% }%>
</table>
<% }
}
%>
<table border="0" align="center">
<tr>
<td nowrap>|<a <%String meb_rs_add_jtcy=response.encodeURL("../add/rs_add_jtcy.jsp");%>href="<%=meb_rs_add_jtcy%>?bh=<%=bh%>">继续添加此人家庭成员</a>|</td>
<td nowrap><a <%String meb_rs_add_shgx=response.encodeURL("../add/rs_add_shgx.jsp");%>href="<%=meb_rs_add_shgx%>?bh=<%=bh%>">添加此人的社会关系</a>|</td>
<td nowrap><a <%String meb_rs_add_grjl=response.encodeURL("../add/rs_add_grjl.jsp");%>href="<%=meb_rs_add_grjl%>?bh=<%=bh%>">添加此人的个人简历</a>|</td>
<td nowrap><a <%String meb_rs_jtcy_update=response.encodeURL("../update/rs_jtcy_update.jsp");%>href="<%=meb_rs_jtcy_update%>?bh=<%=bh%>&pageNO=<%=pageNO%>">修改有误到修改页进行修改</a>|</td>
</tr>
</table>
<%}%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -