📄 rs_update_shgx_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/bg5.gif);
}
-->
</style>
</head>
<body>
<%if(page_ok==true){%>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<jsp:include page="../index/shgx_entry_menu.jsp"></jsp:include>
<div align="center">
</jsp:include>
<%@ page import="java.util.Calendar"%>
<%@ page import="java.text.*"%>
<span class="style3">修改社会关系结果页面<br>
</span>
<%boolean true_false=true;
String pageNO=request.getParameter("pageNO");if(pageNO==null){pageNO="";true_false=false;}
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 gxxm=request.getParameter("gxxm");if(gxxm==null){gxxm="";true_false=false;}
String ybrgx=request.getParameter("ybrgx");if(ybrgx==null){ybrgx="";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 bz=request.getParameter("bz");if(bz==null){bz="";true_false=false;}
String ygxxm=request.getParameter("ygxxm");if(ygxxm==null){ygxxm="";true_false=false;}
String yybrgx=request.getParameter("yybrgx");if(yybrgx==null){yybrgx="";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 ybz=request.getParameter("ybz");if(ybz==null){ybz="";true_false=false;}
if(true_false==true)
{ conn.setcondition(bh);bh=conn.toChinese();
conn.setcondition(xm);xm=conn.toChinese();
String check_condition="select * from shgx where bh='"+bh+"' and gxxm='"+gxxm+"' and ybrgx='"+ybrgx+"' and zzmm='"+zzmm+"' and gzdw='"+gzdw+"' and zwgz='"+zwgz+"' and bz='"+bz+"'";
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 shgx SET bh='"+bh+"',gxxm='"+gxxm+"',ybrgx='"+ybrgx+"',zzmm='"+zzmm+"',gzdw='"+gzdw+"',zwgz='"+zwgz+"',bz='"+bz+"' where bh='"+bh+"' and gxxm='"+ygxxm+"' and ybrgx='"+yybrgx+"' and zzmm='"+yzzmm+"' and gzdw='"+ygzdw+"' and zwgz='"+yzwgz+"' and bz='"+ybz+"'";
conn.setcondition(newcondition);
newcondition=conn.toChinese();
conn.setcondition(newcondition);
String add_shgx=conn.update();
out.print("<center>"+add_shgx+"请检查!</center>");
String checkcondition="select * from shgx where bh='"+bh+"'";
conn.setcondition(checkcondition);
ResultSet rs=conn.getrs();
%>
</div>
<table border="1" align="center" bordercolor="#FF99CC">
<% conn.setcondition(gxxm);gxxm=conn.toChinese();
while(rs.next())
{
%>
<tr bordercolor="#FFFFFF">
<td height="0" colspan="12" nowrap>
<%if(bh.equals(rs.getString("BH"))&&gxxm.equals(rs.getString("GXXM"))){%>
<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"><div align="right"><span class="style5">职工姓名:</span></div></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("GXXM")%></span></td>
<td nowrap bgcolor="#FF99CC"><span class="style5">与本人关系:</span></td>
<td nowrap><span class="style5"><%=rs.getString("YBRGX")%></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>
</tr>
<tr>
<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"><span class="style5">备注:</span></div></td>
<td colspan="9" nowrap><span class="style5"><%=rs.getString("BZ")%></span>
<div align="right" class="style5"></div></td>
</tr>
<% }%>
</table>
<% }
}
%>
<table border="0" align="center">
<tr>
<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_jtcy=response.encodeURL("../add/rs_add_jtcy.jsp");%>href="<%=meb_rs_add_jtcy%>?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_update_shgx=response.encodeURL("../update/rs_update_shgx.jsp");%>href="<%=meb_rs_update_shgx%>?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 + -