rs_add_all_result.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 207 行
JSP
207 行
<%@ 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/0871.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_add_all.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;}
String old_all=request.getParameter("old_all");if(old_all==null){old_all="";true_false=false;}
String checkcondition="select BH from ZGXX";
ResultSet rs_check=null;
%>
<%if(true_false==true){%><center>添加前数据库中在职正式职工<%=old_all%>人</center><%}%>
<% 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="INSERT INTO ZGXX (BH ,BM ,XM ,XB ,XRZW,CSNY,MZ,JG,ZZMM,ZC,WHCD,JKZK,HYZK,CJGZSJ,JBDWSJ,GZ,GZBT,JTZZ,JTCS,DLMM,DZYJ,JTDH,SJHM,GRCF,BZ)VALUES ('"+bh+"','"+bm+"','"+xm+"','"+xb+"','"+xrzw+"',to_timestamp('"+csny_year+"-"+csny_month+"-"+csny_day+"','yyyy-mm-dd'),'"+mz+"','"+jg+"','"+zzmm+"','"+zc+"',"+Integer.parseInt(whcd)+",'"+jkzk+"','"+hyzk+"',to_timestamp('"+cjgzsj_year+"-"+cjgzsj_month+"-"+cjgzsj_day+"','yyyy-mm-dd'),to_timestamp('"+jbdwsj_year+"-"+jbdwsj_month+"-"+jbdwsj_day+"','yyyy-mm-dd'),"+gz+","+gzbt+",'"+jtzz+"','"+jtcs+"','"+dlmm+"','"+dzyj+"','"+jtdh+"','"+sjhm+"','"+grcf+"','"+bz+"')";
conn.setcondition(newcondition);
String zg_yes_no=conn.update();
String gz_yes_no="";
if(zg_yes_no.equals("更新成功"))
{ out.print("<center>'职工数据'"+zg_yes_no+"</center>");
newcondition="INSERT INTO BZGZ VALUES('"+bh+"','"+bm+"','"+xm+"',"+gz+","+gzbt+",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'未领取',to_timestamp('"+jbdwsj_year+"-"+jbdwsj_month+"-"+jbdwsj_day+"','yyyy-mm-dd'))";
conn.setcondition(newcondition);
gz_yes_no=conn.update();
if(gz_yes_no.equals("更新成功")){out.print("<center>'工资数据'"+gz_yes_no+"</center>");}
}
conn.setcondition(checkcondition);
rs_check=conn.getrs();
rs_check.last();
int new_all=rs_check.getRow();
if(new_all<=Integer.parseInt(old_all)){out.print("更新失败，请与管理员联系！");}
if(new_all>Integer.parseInt(old_all)+1){out.print("系统出现问题，请与管理员联系！");}
if(new_all==Integer.parseInt(old_all)+1&&!zg_yes_no.equals("更新成功")&&!gz_yes_no.equals("更新成功")){out.print("<center>添加已经成功，请不要随意刷新此页！</center>");}
%>
<center>添加后数据库中在职正式职工<%=new_all%>人</center>
</p>
</div>
<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"><%=dlmm%></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>
<%}%>
<div align="center">
<table border="0">
<tr>
<td nowrap>|<a href="<%=meb%>">返回添加页面继续添加</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_add_grjl=response.encodeURL("../add/rs_add_grjl.jsp");%>href="<%=meb_rs_add_grjl%>?bh=<%=bh%>">添加此人的个人简历</a>|</td>
<td nowrap><a <%String meb_update=response.encodeURL("../update/rs_update.jsp");%>href="<%=meb_update%>?bh=<%=bh%>">发现错到修改页进行修改</a>|</td>
</tr>
</table>
</div>
<%}%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?