欢迎来到虫虫下载站 | 资源下载 资源专辑 关于我们
虫虫下载站
上传资源

rs_cx_card_xxxx.jsp

JSP页面和oracle9i数据库的源代码
JSP
字号: 
<%@ 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">
<!--
body {
	background-image: url(../img/BK060.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();
	while(rs.next())
	{
	%>
	<table border="1" align="center" cellspacing="1" bordercolor="#FF99CC">
                  <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><%=rs.getString("BH")%></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><%=rs.getString("XM")%></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><%=rs.getString("XB")%></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>
					<%	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>
                  </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><%=rs.getString("BM")%></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><%=rs.getString("XRZW")%></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><%=rs.getDate("CSNY")%></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><%=rs.getString("MZ")%></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><%=rs.getString("JG")%></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><%=rs.getString("ZZMM")%></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><%=rs.getString("ZC")%></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>
					<%  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 height="20" nowrap bgcolor="#FF99CC"><div align="left" class="style4">
                      <div align="right"><span class="style1">健康状况：</span></div>
                    </div></td>
                    <td height="20" nowrap><%=rs.getString("JKZK")%></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><%=rs.getString("HYZK")%></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><%=rs.getDate("CJGZSJ")%></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><%=rs.getDate("JBDWSJ")%></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><%=rs.getString("GZ")%></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><%=rs.getString("GZBT")%></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><%=rs.getString("GRCF")%></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><%=rs.getString("JTDH")%></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><%=rs.getString("SJHM")%></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><%=rs.getString("JTCS")%></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="center"><%=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><%=rs.getString("JTZZ")%></td>
                  </tr>
                  <tr bgcolor="#FF99CC">
                    <td height="20" colspan="8" nowrap><div align="center" class="style5">备注：</div></td>
                  </tr>
                  <tr>
                    <td colspan="8"><%=rs.getString("BZ")%></td>
                  </tr>
	</table>
	<%}%>
<%}%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>

⌨️ 快捷键说明

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