📄 rs_update_grjl_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/BK155.GIF);
}
-->
</style>
</head>
<body>
<%if(page_ok==true){%>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<div align="center">
<jsp:include page="../index/grjl_entry_menu.jsp">
</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 qzny_min_year=request.getParameter("qzny_min_year");if(qzny_min_year==null){qzny_min_year="";true_false=false;}
String qzny_min_month=request.getParameter("qzny_min_month");if(qzny_min_month==null){qzny_min_month="";true_false=false;}
String qzny_max_year=request.getParameter("qzny_max_year");if(qzny_max_year==null){qzny_max_year="";true_false=false;}
String qzny_max_month=request.getParameter("qzny_max_month");if(qzny_max_month==null){qzny_max_month="";true_false=false;}
String gzdw=request.getParameter("gzdw");if(gzdw==null){gzdw="";true_false=false;}
String zmr=request.getParameter("zmr");if(zmr==null){zmr="";true_false=false;}
String yqzny=request.getParameter("yqzny");if(yqzny==null){yqzny="";true_false=false;}
String ygzdw=request.getParameter("ygzdw");if(ygzdw==null){ygzdw="";true_false=false;}
//out.print();
if(true_false==true)
{ conn.setcondition(bh);bh=conn.toChinese();
conn.setcondition(xm);xm=conn.toChinese();
conn.setcondition(gzdw);gzdw=conn.toChinese();
conn.setcondition(zmr);zmr=conn.toChinese();
conn.setcondition(ygzdw);ygzdw=conn.toChinese();
conn.setcondition(yqzny);yqzny=conn.toChinese();
String qzny=qzny_min_year+"年"+qzny_min_month+"月至"+qzny_max_year+"年"+qzny_max_month+"月";
String check_condition="select * from grjl where bh='"+bh+"' and gzdw='"+gzdw+"' and qzny='"+qzny+"'";
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 grjl set BH='"+bh+"',QZNY='"+qzny+"',GZDW='"+gzdw+"',ZMR='"+zmr+"' where BH='"+bh+"' and QZNY='"+yqzny+"' and GZDW='"+ygzdw+"'";
conn.setcondition(newcondition);
String add_grjl=conn.update();
out.print("<center>"+add_grjl+"请检查!</center>");
String checkcondition="select * from grjl 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="10" nowrap>
<%if(bh.equals(rs.getString("BH"))&&gzdw.equals(rs.getString("GZDW"))){%>
<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">曾工作单位:</td>
<td nowrap><span class="style5"><%=rs.getString("GZDW")%></span></td>
<td nowrap bgcolor="#FF99CC">起止年月:</td>
<td nowrap><span class="style5"><%=rs.getString("QZNY")%></span></td>
<td nowrap bgcolor="#FF99CC">证明人:</td>
<td nowrap><span class="style5"><%=rs.getString("ZMR")%></span></td>
</tr>
<% }%>
</table>
<% }
}
%>
<table border="0" align="center">
<tr>
<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_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_update_grjl=response.encodeURL("../update/rs_update_grjl.jsp");%>href="<%=meb_rs_update_grjl%>?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 + -