📄 rs_update_result.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: #FF0080; font-size: 12px; }
.style5 {color: #000000}
.style7 {font-size: 14px}
body {
background-image: url(../img/bg1.gif);
}
-->
</style>
</head>
<body>
<%if(page_ok==true){%>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<%@ page import="java.util.Calendar"%>
<%String meb=response.encodeURL("rs_update.jsp");%>
<% boolean true_false=true;
String bh=request.getParameter("bh");if(bh==null){bh="";true_false=false;}
String bm=request.getParameter("bm");if(bm==null){bm="";true_false=false;}
String xm=request.getParameter("xm");if(xm==null){xm="";true_false=false;}
String xb=request.getParameter("xb");if(xb==null){xb="";true_false=false;}
String xrzw=request.getParameter("xrzw");if(xrzw==null){xrzw="";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 mz=request.getParameter("mz");if(mz==null){mz="";true_false=false;}
String jg=request.getParameter("jg");if(jg==null){jg="";true_false=false;}
String zzmm=request.getParameter("zzmm");if(zzmm==null){zzmm="";true_false=false;}
String zc=request.getParameter("zc");if(zc==null){zc="";true_false=false;}
String whcd=request.getParameter("whcd");if(whcd==null){whcd="";true_false=false;}
String jkzk=request.getParameter("jkzk");if(jkzk==null){jkzk="";true_false=false;}
String hyzk=request.getParameter("hyzk");if(hyzk==null){hyzk="";true_false=false;}
String jbgz=request.getParameter("jbgz");if(jbgz==null){jbgz="";true_false=false;}
String bt=request.getParameter("gzbt");if(bt==null){bt="";true_false=false;}
String cjgzsj_year=request.getParameter("cjgzsj_year");if(cjgzsj_year==null){cjgzsj_year="";true_false=false;}
String cjgzsj_month=request.getParameter("cjgzsj_month");if(cjgzsj_month==null){cjgzsj_month="";true_false=false;}
String cjgzsj_day=request.getParameter("cjgzsj_day");if(cjgzsj_day==null){cjgzsj_day="";true_false=false;}
String jbdwsj_year=request.getParameter("jbdwsj_year");if(jbdwsj_year==null){jbdwsj_year="";true_false=false;}
String jbdwsj_month=request.getParameter("jbdwsj_month");if(jbdwsj_month==null){jbdwsj_month="";true_false=false;}
String jbdwsj_day=request.getParameter("jbdwsj_day");if(jbdwsj_day==null){jbdwsj_day="";true_false=false;}
String jtzz=request.getParameter("jtzz");if(jtzz==null){jtzz="";true_false=false;}
String jtcs=request.getParameter("jtcs");if(jtcs==null){jtcs="";true_false=false;}
String jtdh=request.getParameter("jtdh");if(jtdh==null){jtdh="";true_false=false;}
String sjhm=request.getParameter("sjhm");if(sjhm==null){sjhm="";true_false=false;}
String grcf=request.getParameter("grcf");if(grcf==null){grcf="";true_false=false;}
String dzyj=request.getParameter("dzyj");if(dzyj==null){dzyj="";true_false=false;}
String dlmm=request.getParameter("dlmm");if(dlmm==null){dlmm="";true_false=false;}
String bz=request.getParameter("bz");if(bz==null){bz="";true_false=false;}
%>
<% if(true_false==true)
{ conn.setcondition(bm);bm=conn.toChinese();
conn.setcondition(xm);xm=conn.toChinese();
conn.setcondition(xb);xb=conn.toChinese();
conn.setcondition(xrzw);xrzw=conn.toChinese();
conn.setcondition(mz);mz=conn.toChinese();
conn.setcondition(jg);jg=conn.toChinese();
conn.setcondition(zzmm);zzmm=conn.toChinese();
conn.setcondition(zc);zc=conn.toChinese();
conn.setcondition(jkzk);jkzk=conn.toChinese();
conn.setcondition(hyzk);hyzk=conn.toChinese();
float gz=Float.parseFloat(jbgz);
float gzbt=Float.parseFloat(bt);
conn.setcondition(jtzz);jtzz=conn.toChinese();
conn.setcondition(jtcs);jtcs=conn.toChinese();
conn.setcondition(grcf);grcf=conn.toChinese();
conn.setcondition(dzyj);dzyj=conn.toChinese();
conn.setcondition(bz);bz=conn.toChinese();
String newcondition="UPDATE ZGXX SET BM='"+bm+"',XM='"+xm+"',XB='"+xb+"',XRZW='"+xrzw+"',CSNY=to_timestamp('"+csny_year+"-"+csny_month+"-"+csny_day+"','yyyy-mm-dd'),MZ='"+mz+"',JG='"+jg+"',ZZMM='"+zzmm+"',ZC='"+zc+"',WHCD="+Integer.parseInt(whcd)+",JKZK='"+jkzk+"',HYZK='"+hyzk+"',CJGZSJ=to_timestamp('"+cjgzsj_year+"-"+cjgzsj_month+"-"+cjgzsj_day+"','yyyy-mm-dd'),JBDWSJ=to_timestamp('"+jbdwsj_year+"-"+jbdwsj_month+"-"+jbdwsj_day+"','yyyy-mm-dd'),GZ="+gz+",GZBT="+gzbt+",JTZZ='"+jtzz+"',JTCS='"+jtcs+"',DZYJ='"+dzyj+"',JTDH='"+jtdh+"',SJHM='"+sjhm+"',GRCF='"+grcf+"',BZ='"+bz+"' where BH='"+bh+"'";
conn.setcondition(newcondition);
String zg_yes_no=conn.update();
if(zg_yes_no.equals("更新成功"))
{ out.print("<center>'职工数据'"+zg_yes_no+"</center>");
newcondition="UPDATE BZGZ SET BM='"+bm+"',XM='"+xm+"',GZ="+gz+",GZBT="+gzbt+",JCNY=to_timestamp('"+jbdwsj_year+"-"+jbdwsj_month+"-"+jbdwsj_day+"','yyyy-mm-dd') where BH='"+bh+"'";
conn.setcondition(newcondition);
String gz_yes_no=conn.update();
if(gz_yes_no.equals("更新成功")){out.print("<center>'工资数据'"+gz_yes_no+"</center>");}
}
%>
<table border="1" align="center" cellpadding="0" cellspacing="2" bordercolor="#D4D0C8">
<tr bordercolor="#FF99CC">
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">编号:</div></td>
<td width="18" nowrap class="style3"><%=bh%></td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">部门:</div></td>
<td nowrap><%=bm%></td>
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">姓名:</div></td>
<td nowrap><%=xm%></td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">性别:</div></td>
<td nowrap><%=xb%></td>
</tr>
<tr bordercolor="#FF99CC">
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">现任职务:</div></td>
<td nowrap><%=xrzw%></td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">出生年月:</div></td>
<td colspan="3" nowrap><%=csny_year%>年<%=csny_month%>月<%=csny_day%>日</td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">民族:</div></td>
<td nowrap><%=mz%></td>
</tr>
<tr bordercolor="#FF99CC">
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">籍贯:</div></td>
<td nowrap><%=jg%></td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">政治面目:</div></td>
<td nowrap><%=zzmm%></td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">职称:</div></td>
<td nowrap><%=zc%></td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">文化程度:</div></td>
<td nowrap>
<% int xl=Integer.parseInt(whcd);
String condition_xl="select * from XL where XLBH="+"'"+xl+"'";
conn.setcondition(condition_xl);
ResultSet rs_xl=conn.getrs();
rs_xl.next();
%>
<%=rs_xl.getString("XLMC")%></td>
</tr>
<tr bordercolor="#FF99CC">
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">健康状况:</div></td>
<td nowrap><%=jkzk%></td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">婚姻状况:</div></td>
<td nowrap><%=hyzk%></td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">基本工资:</div></td>
<td nowrap><%=gz%></td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">各种补贴: </div></td>
<td nowrap><%=gzbt%></td>
</tr>
<tr bordercolor="#FF99CC">
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">参加工作时间:</div></td>
<td colspan="3" nowrap><%=cjgzsj_year%>年<%=cjgzsj_month%>月<%=cjgzsj_day%>日</td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">进本单位时间:</div></td>
<td colspan="3" nowrap><%=jbdwsj_year%>年<%=jbdwsj_month%>月<%=jbdwsj_day%>日</td>
</tr>
<tr bordercolor="#FF99CC">
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">家庭住址:</div></td>
<td colspan="7" nowrap><%=jtzz%></td>
</tr>
<tr bordercolor="#FF99CC">
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">家庭出身:</div></td>
<td nowrap><%=jtcs%></td>
<td nowrap bgcolor="#FF99CC" class="style5">家庭电话:</td>
<td nowrap><%=jtdh%></td>
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">手机号码:</div></td>
<td nowrap><%=sjhm%></td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">个人成份:</div></td>
<td nowrap><%=grcf%></td>
</tr>
<tr bordercolor="#FF99CC">
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">电子邮件:</div></td>
<td colspan="5" nowrap><div align="left"><%=dzyj%></div></td>
<td nowrap bgcolor="#FF99CC" class="style5"><div align="right">登录密码:</div></td>
<td nowrap><span class="style3">**********</span></td>
</tr>
<tr bordercolor="#FF99CC">
<td nowrap bgcolor="#FF99CC"><div align="right" class="style5">备注:</div></td>
<td colspan="7" nowrap><%=bz%></td>
</tr>
</table>
<%}%>
<table border="0" align="center">
<tr>
<td><div align="center"><a href="<%=meb%>?bh=<%=bh%>">返回修改页面继续修改</a></div> </td>
<td width="50"></td>
<td><div <%String meb_add=response.encodeURL("../add/rs_add_all.jsp");%>align="center"><a href="<%=meb_add%>">返回添加页面继续添加</a></div> </td>
</tr>
</table>
<%}%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -