rs_cx_jjtx.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 91 行
JSP
91 行
<%@ 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>
<title>本年内退休的职工</title>
<%
String page_type=(String)session.getAttribute("page_type");
String page_name=(String)session.getAttribute("page_name");
if(page_type==null){page_type="";}
if(session.isNew()){response.sendRedirect("../index.jsp");}
else
{ if(!(page_type.equals("rs")) && !page_type.equals("srs"))
{response.sendRedirect("../index.jsp");}
}
%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body {
background-image: url(../img/adminbg.gif);
}
-->
</style></head>
<body>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<div align="center">
<%@ page import="java.util.Calendar"%>
<% Calendar Today=Calendar.getInstance();
int manyear=Today.get(Today.YEAR)-60;
int wumanyear=Today.get(Today.YEAR)-55;
String newcondition="select * from zgxx where (xb='男' and csny<=to_timestamp('"+manyear+"-12-31','yyyy-mm-dd')) or (xb='女' and (ZC!='高级工程师' and ZC!='副教授' and ZC!='教授') and csny<=to_timestamp('"+wumanyear+"-12-31','yyyy-mm-dd')) or (xb='女' and (ZC='高级工程师' or ZC='副教授' or ZC='教授')and csny<=to_timestamp('"+manyear+"-12-31','yyyy-mm-dd'))";
conn.setcondition(newcondition);
ResultSet rs=conn.getrs();
rs.last();
int all=rs.getRow();
if(all==0){out.print("<center>没有会在"+Today.get(Today.YEAR)+"内退休的职工</center>");}
else
{out.print("<center>在"+Today.get(Today.YEAR)+"内退休的职工共"+all+"人，如出现'应已退休'职工请执行'增加退休职工'操作</center>");}
rs.beforeFirst();%>
<a <%String meb_rs_main=response.encodeURL("../index/rs_index.jsp");%>href="<%=meb_rs_main%>">返回主菜单</a></div>
<table border="1" align="center" cellspacing="1" bordercolor="#FF99CC">
<%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>
<% if(rs.getString("ZC").equals("高级工程师")||rs.getString("ZC").equals("副教授")||rs.getString("ZC").equals("教授"))
{ if((rs.getString("XB").equals("男")&&age>=60)||(rs.getString("XB").equals("女")&&age>=60))
{out.print("应已退休");}
else
{out.print("即将退休");}
}
else
{ if((rs.getString("XB").equals("男")&&age>=60)||(rs.getString("XB").equals("女")&&age>=55))
{out.print("应已退休");}
else
{out.print("即将退休");}
}
%>
</td>
<td nowrap><a href="rs_cx_all_xxxx.jsp?bh=<%=rs.getString("BH")%>" target="_blank">详细信息...</a></td>
</tr>
<%}%>
</table>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?