⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 zg.jsp

📁 JSP页面和oracle9i数据库的源代码
💻 JSP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<%@ 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");
String page_bh=(String)session.getAttribute("page_bh");
if(page_type==null){page_type="";}
if(session.isNew()){response.sendRedirect("ptyg.jsp");}
else
 {	if(!(page_type.equals("zg")))
	{response.sendRedirect("ptyg.jsp");}	
 }
%>
<title>职工</title>
<style type="text/css">
<!--
.style2 {font-size: 24px;color:}
.style9 {color: ; font-size: 14px; }
body {background-image: url(tu/mainbg.gif);}
-->
</style>



</head>

<body>
<center>
<table width="900" height="30">
  <!--DWLayoutTable-->
  <tr>
  <td width="91" height="24"  align="center"valign="middle"><a href="ptyg.jsp">主页</a></td>
  <td width="75" align="center"valign="middle"><a href="changepw.jsp">修改密码</a></td>
  <td width="81" align="center"valign="middle">留言</td>
  <td width="87" align="center"valign="middle"><a href="wjmm.jsp">联系我们</a></td>
  </tr>
</table>
<hr align="center" width="900">
<jsp:useBean id="conn" scope="page" class="beans.conn" />
<%@page import="java.util.Calendar"%>

<%	out.print(page_bh);out.print("号");out.print(page_name);out.print("你好:下表是你的人事信息如有错误请与管理员联系");
%>
 <%	String condition="select * from zgxx where bh='"+page_bh+"'";
	String bh=null;
	conn.setcondition(condition);
	ResultSet rs=conn.getrs();
	rs.last();
	int all=rs.getRow();
	if(all==1)
	{	rs.last();
%>
<table width="900" border="1" align="center" cellspacing="1" bordercolor="#FF99CC">
  <tr bgcolor="#FF99CC">
    <td height="30" colspan="8"><div align="center" class="style2"><%=rs.getString("XM")%>基本信息表</div></td>
  </tr>
  <tr>
    <td width="112" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">编号：</span></div></td>
    <td width="109" height="20"><%=rs.getString("BH")%></td>
    <td width="109" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">姓名：</span></div></td>
    <td width="109" height="20"><%=rs.getString("XM")%></td>
    <td width="109" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">性别：</span></div></td>
    <td width="112" height="20"><%=rs.getString("XB")%></td>
    <td width="112" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">年龄：</span></div></td>
    <td width="112" height="20">
      <% 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);
	  %>
      <%=age%></td>
  </tr>
  <tr>
    <td width="80" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">所在部门：</span></div></td>
    <td width="100" height="20"><%=rs.getString("BM")%></td>
    <td width="80" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">现任职务：</span></div></td>
    <td width="100" height="20"><%=rs.getString("XRZW")%></td>
    <td width="120" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">出生年月：</span></div></td>
    <td width="100" height="20"><%=rs.getDate("CSNY")%></td>
    <td width="120" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">民族：</span></div></td>
    <td width="100" height="20"><%=rs.getString("MZ")%></td>
  </tr>
  <tr>
    <td width="80" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">籍贯：</span></div></td>
    <td width="100" height="20"><%=rs.getString("JG")%></td>
    <td width="80" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">政治面目：</span></div></td>
    <td width="100" height="20"><%=rs.getString("ZZMM")%></td>
    <td width="120" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">职称：</span></div></td>
    <td width="100" height="20"><%=rs.getString("ZC")%></td>
    <td width="120" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">文化程度：</span></div></td>
    <td width="100" height="20">
      <%  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")%></td>
  </tr>
  <tr>
    <td width="80" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">健康状况：</span></div></td>
    <td width="100" height="20"><%=rs.getString("JKZK")%></td>
    <td width="80" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">婚姻状况：</span></div></td>
    <td width="100" height="20"><%=rs.getString("HYZK")%></td>
    <td width="120" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">参加工作时间：</span></div></td>
    <td width="100" height="20"><%=rs.getDate("CJGZSJ")%></td>
    <td width="120" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">进本单位时间：</span></div></td>
    <td width="100" height="20"><%=rs.getDate("JBDWSJ")%></td>
  </tr>
  <tr>
    <td width="80" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">基本工资：</span></div></td>
    <td width="100" height="20"><%=rs.getString("GZ")%></td>
    <td width="80" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">各种补贴：</span></div></td>
    <td width="100" height="20"><%=rs.getString("GZBT")%></td>
    <td width="120" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">个人成份：</span></div></td>
    <td width="100" height="20"><%=rs.getString("GRCF")%></td>
    <td width="120" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">家庭电话号码：</span></div></td>
    <td width="100" height="20"><%=rs.getString("JTDH")%></td>
  </tr>
  <tr>
    <td width="80" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">手机号码：</span></div></td>
    <td width="100" height="20"><%=rs.getString("SJHM")%></td>
    <td width="80" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">家庭出身：</span></div></td>
    <td width="100" height="20"><%=rs.getString("JTCS")%></td>
    <td width="120" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">电子邮件地址：</span></div></td>
    <td height="20" colspan="3"><div align="left"><%=rs.getString("DZYJ")%></div></td>
  </tr>
  <tr>
    <td width="80" height="20" bgcolor="#FF99CC"><div align="left" class="style4"><span class="style9">家庭住址：</span></div></td>
    <td height="20" colspan="7"><%=rs.getString("JTZZ")%></td>
  </tr>
  <tr bgcolor="#FF99CC">
    <td height="20" colspan="8"><div align="center" class="style9">备注：</div></td>
  </tr>
  <tr>
    <td colspan="8"><%=rs.getString("BZ")%></td>
  </tr>
</table>
<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>
<table width="900" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#FF99CC">
  <tr>
    <td width="112"  height="20"bgcolor="#FF99CC"><span class="style9">成员姓名:</span></td>
    <td  width="109"height="20"><div align="left"><span class="style6"><%=rs2.getString("CYXM")%></span></div></td>
    <td width="109"height="20" bgcolor="#FF99CC"><span class="style9">家属关系:</span></td>
    <td width="109"height="20"><div align="left"><span class="style6"><%=rs2.getString("JSGX")%></span></div></td>
    <td width="109"height="20"bgcolor="#FF99CC"><span class="style9">出生年月:</span></td>
    <td width="112"height="20"><div align="left"><span class="style6"><%=rs2.getDate("CSNY")%></span></div></td>
    <td width="112" height="20"bgcolor="#FF99CC"><span class="style9">婚姻状况:</span></td>
    <td width="112"height="20"><div align="left"><span class="style6"><%=rs2.getString("HYZK")%></span></div></td>
  </tr>
  <tr>
    <td width="112" height="20"bgcolor="#FF99CC"><span class="style9">文化程度:</span></td>
    <td width="109"height="20"><div align="left"><span class="style6"><%=rs2.getString("WHCD")%></span></div></td>
    <td width="109"height="20" bgcolor="#FF99CC"><span class="style9">政治面目:</span></td>
    <td width="109"height="20"><div align="left"><span class="style6"><%=rs2.getString("ZZMM")%></span></div></td>
    <td width="109" height="20"bgcolor="#FF99CC"><span class="style9">职务工种:</span></td>
    <td width="112"height="20"><div align="left"><span class="style6"><%=rs2.getString("ZWGZ")%></span></div></td>
    <td width="112" height="20"bgcolor="#FF99CC"><span class="style9">工资:</span></td>
    <td width="112"height="20"><div align="left"><span class="style6"><%=rs2.getString("GZ")%></span></div></td>
  </tr>
  <tr>
    <td width="70" bgcolor="#FF99CC"><span class="style9">工作单位:</span></td>
    <td colspan="3"><div align="left"><span class="style6"><%=rs2.getString("GZDW")%></span></div></td>
    <td width="75" bgcolor="#FF99CC"><span class="style9">经济来源:</span></td>
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -