rs_add_tx.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 113 行
JSP
113 行
<%@ 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}
.style6 {color: #FF0080}
.style8 {font-size: 12px}
body {
background-image: url(../img/076.gif);
}
-->
</style>
</head>
<body>
<%//if(page_ok==true){%>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<%@ page import="java.util.Calendar"%>
<%@ page import="java.text.*"%>
<% Calendar Today=Calendar.getInstance();
int manyear=Today.get(Today.YEAR)-60;
int wumanyear=Today.get(Today.YEAR)-55;
int txmonth=Today.get(Today.MONTH)+1;
int txday=Today.get(Today.DATE);
String newcondition="select * from zgxx where (xb='男' and csny<=to_timestamp('"+manyear+"-"+txmonth+"-"+txday+"','yyyy-mm-dd')) or (xb='女' and (ZC!='高级工程师' and ZC!='副教授' and ZC!='教授') and csny<=to_timestamp('"+wumanyear+"-"+txmonth+"-"+txday+"','yyyy-mm-dd')) or (xb='女' and (ZC='高级工程师' or ZC='副教授' or ZC='教授')and csny<=to_timestamp('"+manyear+"-"+txmonth+"-"+txday+"','yyyy-mm-dd'))";
conn.setcondition(newcondition);
ResultSet rs=conn.getrs();
rs.last();
int all=rs.getRow();
if(all==0){out.print("<center>没有满足退休条件的职工</center>");}
rs.beforeFirst();
while(rs.next())
{ Calendar birthday=Calendar.getInstance();
birthday.setTime(rs.getDate("CSNY"));
Calendar day=Calendar.getInstance();
int age=0;
age=day.get(day.YEAR)-birthday.get(birthday.YEAR);
if(day.get(day.MONTH)<birthday.get(birthday.MONTH)){age--;}
if(day.get(day.MONTH)==birthday.get(birthday.MONTH))
{if(day.get(day.DATE)<birthday.get(birthday.DATE)){age--;}}
String condition_totxzg="INSERT INTO TXZGXX (BH ,XM ,XB ,CSNY,MZ,JG,ZZMM,ZC,WHCD,JKZK,HYZK,CJGZSJ,JBDWSJ,GZ,GZBT,JTZZ,JTCS,DLMM,DZYJ,JTDH,SJHM,GRCF,BZ,TXSJ)VALUES ('"+rs.getString("BH")+"','"+rs.getString("XM")+"','"+rs.getString("XB")+"',to_timestamp('"+rs.getDate("CSNY")+"','yyyy-mm-dd'),'"+rs.getString("MZ")+"','"+rs.getString("JG")+"','"+rs.getString("ZZMM")+"','"+rs.getString("ZC")+"',"+rs.getString("WHCD")+",'"+rs.getString("JKZK")+"','"+rs.getString("HYZK")+"',to_timestamp('"+rs.getDate("CJGZSJ")+"','yyyy-mm-dd'),to_timestamp('"+rs.getDate("JBDWSJ")+"','yyyy-mm-dd'),"+rs.getString("GZ")+","+rs.getString("GZBT")+",'"+rs.getString("JTZZ")+"','"+rs.getString("JTCS")+"','"+rs.getString("DLMM")+"','"+rs.getString("DZYJ")+"','"+rs.getString("JTDH")+"','"+rs.getString("SJHM")+"','"+rs.getString("GRCF")+"','"+rs.getString("BZ")+"',to_timestamp('"+(birthday.get(birthday.YEAR)+age)+"-"+(birthday.get(birthday.MONTH)+1)+"-"+birthday.get(birthday.DATE)+"','yyyy-mm-dd'))";
conn.setcondition(condition_totxzg);
String ok_no=conn.update();
out.print(condition_totxzg+ok_no);
if(ok_no.equals("更新成功"))
{ String del_condition="delete from zgxx where bh='"+rs.getString("BH")+"'";
conn.setcondition(del_condition);
ok_no=conn.update();
out.print(ok_no);
String update_condition="update bzk set LFDG=0,LT=0,FT=0,ZFT=0,DWT=0,GWX=0,BJ=0,YW=0,FANGTIE=0,JIAOTONG=0,SB=0,MT=0,WS=0,YB=0";
conn.setcondition(update_condition);
ok_no=conn.update();
out.print(rs.getString("BH")+"号-"+rs.getString("XM")+"被转为退休职工");
}
}
%>
<table border="1" align="center" cellspacing="1" bordercolor="#FF99CC">
<% rs.beforeFirst();
while(rs.next())
{
%>
<tr>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4"><span class="style1">编号:</span></div></td>
<td height="20" nowrap><%=rs.getString("BH")%></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4"><span class="style1">姓名:</span></div></td>
<td height="20" nowrap><%=rs.getString("XM")%></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4"><span class="style1">性别:</span></div></td>
<td height="20" nowrap><%=rs.getString("XB")%></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4"><span class="style1">年龄:</span></div></td>
<td height="20" nowrap>
<% Calendar birthday=Calendar.getInstance();
birthday.setTime(rs.getDate("CSNY"));
Calendar day=Calendar.getInstance();
int age=0;
age=day.get(day.YEAR)-birthday.get(birthday.YEAR);
if(day.get(day.MONTH)<birthday.get(birthday.MONTH)){age--;}
if(day.get(day.MONTH)==birthday.get(birthday.MONTH))
{if(day.get(day.DATE)<birthday.get(birthday.DATE)){age--;}}
%>
<%=age%></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4"><span class="style1">所在部门:</span></div></td>
<td height="20" nowrap><%=rs.getString("BM")%></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4"><span class="style1">现任职务:</span></div></td>
<td height="20" nowrap><%=rs.getString("XRZW")%></td>
<td nowrap bgcolor="#FF99CC">职称:</td>
<td nowrap><%=rs.getString("ZC")%></td>
<td nowrap><a href="../cx/rs_cx_tx_xxxx.jsp?bh=<%=rs.getString("BH")%>" target="_blank">详细信息...</a></td>
</tr>
<% }%>
</table>
<%//}%>
</body>
<jsp:include page="../checkout.jsp"></jsp:include>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?