rs_cx_all_xxxx.jsp
来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 307 行
JSP
307 行
<%@ 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">
<title>无标题文档</title>
<style type="text/css">
<!--
.style6 {font-size: 12px}
.style1 {color: #FFFFFF}
.style2 {font-size: 24px;
color: #FFFFFF;
}
.style4 {font-size: 14px}
.style5 {color: #FFFFFF; font-size: 14px; }
body {
background-image: url(../img/bg6.gif);
}
-->
</style>
</head>
<body>
<%
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");}
}
%>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<%@ page import="java.util.Calendar"%>
<%
String bh=request.getParameter("bh");
if(bh==null){bh="";}
else
{ conn.setcondition(bh);
bh=conn.toChinese();
String newcondition="select * from ZGXX where BH='"+bh+"'";
conn.setcondition(newcondition);
ResultSet rs=conn.getrs();
%>
<table border="1" align="center" cellspacing="1" bordercolor="#FF99CC">
<% while(rs.next())
{
%>
<tr bgcolor="#FF99CC">
<td height="30" colspan="8" nowrap><div align="center" class="style2">职工基本信息表</div></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">编号:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("BH")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">姓名:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("XM")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">性别:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("XB")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">年龄:</span></div>
</div></td>
<td height="20" nowrap>
<div align="left">
<% 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%></div></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">所在部门:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("BM")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">现任职务:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("XRZW")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">出生年月:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getDate("CSNY")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">民族:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("MZ")%></div></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">籍贯:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("JG")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">政治面目:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("ZZMM")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">职称:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("ZC")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">文化程度:</span></div>
</div></td>
<td height="20" nowrap>
<div align="left">
<% int xl=rs.getInt("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")%></div></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">健康状况:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("JKZK")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">婚姻状况:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("HYZK")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">参加工作时间:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getDate("CJGZSJ")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">进本单位时间:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getDate("JBDWSJ")%></div></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">基本工资:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("GZ")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">各种补贴:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("GZBT")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">个人成份:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("GRCF")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">家庭电话号码:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("JTDH")%></div></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">手机号码:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("SJHM")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">家庭出身:</span></div>
</div></td>
<td height="20" nowrap><div align="left"><%=rs.getString("JTCS")%></div></td>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">电子邮件地址:</span></div>
</div></td>
<td height="20" colspan="3" nowrap><div align="left"><%=rs.getString("DZYJ")%></div></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
<div align="right"><span class="style1">家庭住址:</span></div>
</div></td>
<td height="20" colspan="7" nowrap><div align="left"><%=rs.getString("JTZZ")%></div></td>
</tr>
<tr bgcolor="#FF99CC">
<td height="20" nowrap bgcolor="#FF99CC"><div align="center" class="style5">备注：</div></td>
<td height="20" colspan="7" nowrap bgcolor="#FFFFFF"><div align="left"><%=rs.getString("BZ")%></div></td>
</tr>
<tr>
<td colspan="8">
<div align="center">
<%bh=rs.getString("BH");
int jtcy=0;
String newcondition2="select * from JTCY where BH="+"'"+bh+"'";
conn.setcondition(newcondition2);
ResultSet rs2=conn.getrs();
while(rs2.next())
{jtcy++;}
if(jtcy==0){out.print("无家庭成员记录！");}
else
{out.print(rs.getString("XM"));out.print("的家庭成员信息表：");}
conn.setcondition(newcondition2);
rs2=conn.getrs();
while(rs2.next())
{
%>
</div></td>
</tr>
<tr>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">成员姓名:</span></div></td>
<td nowrap><div align="left"><span class="style6"><%=rs2.getString("CYXM")%></span></div></td>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">家属关系:</span></div></td>
<td nowrap><div align="left"><span class="style6"><%=rs2.getString("JSGX")%></span></div></td>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">出生年月:</span></div></td>
<td nowrap><div align="left"><span class="style6"><%=rs2.getDate("CSNY")%></span></div></td>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">婚姻状况:</span></div></td>
<td nowrap><div align="left"><span class="style6"><%=rs2.getString("HYZK")%></span></div></td>
</tr>
<tr>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">文化程度:</span></div></td>
<td nowrap><div align="left"><span class="style6"><%=rs2.getString("WHCD")%></span></div></td>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">政治面目:</span></div></td>
<td nowrap><div align="left"><span class="style6"><%=rs2.getString("ZZMM")%></span></div></td>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">职务工种:</span></div></td>
<td nowrap><div align="left"><span class="style6"><%=rs2.getString("ZWGZ")%></span></div></td>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">工资:</span></div></td>
<td nowrap><div align="left"><span class="style6"><%=rs2.getString("GZ")%></span></div></td>
</tr>
<tr>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">工作单位:</span></div></td>
<td colspan="3" nowrap><div align="left"><span class="style6"><%=rs2.getString("GZDW")%></span></div></td>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6 style6">经济来源:</span></div></td>
<td colspan="3" nowrap><div align="left"><span class="style6"><%=rs2.getString("JJLY")%></span></div></td>
</tr>
<%}%>
<tr>
<td colspan="8">
<div align="center">
<%bh=rs.getString("BH");
int shgx=0;
String newcondition3="select * from SHGX where BH="+"'"+bh+"'";
conn.setcondition(newcondition3);
ResultSet rs3=conn.getrs();
while(rs3.next())
{shgx++;}
if(shgx==0){out.print("无社会关系记录！");}
else
{out.print(rs.getString("XM"));out.print("的社会关系表：");}
conn.setcondition(newcondition3);
rs3=conn.getrs();
while(rs3.next())
{
%>
</div></td>
</tr>
<tr>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6">关系人姓名:</span></div></td>
<td nowrap><div align="left"><span class="style6"><%=rs3.getString("GXXM")%></span></div></td>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6">二人关系:</span></div></td>
<td nowrap><div align="left"><span class="style6"><%=rs3.getString("YBRGX")%></span></div></td>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6">政治面目:</span></div></td>
<td nowrap><div align="left"><span class="style6"><%=rs3.getString("ZZMM")%></span></div></td>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6">职务工种:</span></div></td>
<td nowrap><div align="left"><span class="style6"><%=rs3.getString("ZWGZ")%></span></div></td>
</tr>
<tr>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6">工作单位:</span></div></td>
<td colspan="7" nowrap><div align="left"><span class="style6"><%=rs3.getString("GZDW")%></span></div></td>
</tr>
<tr>
<td nowrap bgcolor="#FF99CC"><div align="right"><span class="style6">备注：</span></div></td>
<td colspan="7" nowrap><div align="left"><span class="style6"><%=rs3.getString("BZ")%></span></div></td>
</tr>
<%}%>
<tr>
<td colspan="8">
<div align="center">
<%bh=rs.getString("BH");
int grjl=0;
String newcondition4="select * from GRJL where BH="+"'"+bh+"'";
conn.setcondition(newcondition4);
ResultSet rs4=conn.getrs();
while(rs4.next())
{grjl++;}
if(grjl==0){out.print("无个人简历！");}
else
{out.print(rs.getString("XM"));out.print("的个人简历：");}
conn.setcondition(newcondition4);
rs4=conn.getrs();
while(rs4.next())
{
%>
</div></td>
</tr>
<tr>
<td nowrap bgcolor="#FF99CC" class="style6"><div align="right">前工作单位:</div></td>
<td nowrap class="style6"><div align="left"><%=rs4.getString("GZDW")%></div></td>
<td nowrap bgcolor="#FF99CC" class="style6"><div align="right">起止年月:</div></td>
<td nowrap colspan="3" class="style6"><div align="left"><%=rs4.getString("QZNY")%></div></td>
<td nowrap bgcolor="#FF99CC" class="style6"><div align="right">证明人:</div></td>
<td nowrap class="style6"><div align="left"><%=rs4.getString("ZMR")%></div></td>
</tr>
<%}%>
</table>
<%}%>
<%}%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?