📄 binfo.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="com.entity.*"%>
<%@ page language = "java" import = "java.sql.*,java.util.*"%>
<%@ page contentType="text/html;charset=gb2312" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%
String userdb = "triones";
String password = "tiger";
String url = "jdbc:oracle:thin:@10.0.5.25:1521:KUANGTU";
int pagesize = 10;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
StringBuffer userInfo = new StringBuffer();
StringBuffer pageInfo = new StringBuffer();
try{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn = DriverManager.getConnection(url,userdb,password);
conn.setAutoCommit(true);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
}catch(SQLException e){
System.err.println("数据库连接错误:"+e.getMessage());
}
try{
rs = stmt.executeQuery("select * from emp_info order by emp_id asc");
}catch(SQLException ex){
System.err.println("数据库查询错误: "+ex);
}
String paramPage = request.getParameter("page");
int currentPage = 1;
try{
currentPage = Integer.parseInt(paramPage);
}catch(Exception e){
currentPage = 1;
}
rs.last();
int totaluser = rs.getRow();
int pageCount = (int)Math.ceil((float)totaluser/(float)pagesize);
int i = 1;
rs.absolute((currentPage-1)*pagesize+1);
while(i<=pagesize&&!rs.isAfterLast()){
int id = Integer.parseInt(rs.getString("emp_id"));
userInfo.append("<tr bgcolor = #ffffff>\n");
//userInfo.append("<td align = center height='35'><input type='checkbox' name='empId' value='"+id+"'></td>");
userInfo.append("<td align = center>"+rs.getString("emp_id")+"</td>");
//System.out.println(rs.getString("emp_sex"));
//String temStr=rs.getString("emp_sex");
//byte [] temp=temStr.getBytes();
//temStr=new String(temp,"ISO-8859-1");
userInfo.append("<td align = center>"+rs.getString("emp_name")+"</td>");
userInfo.append("<td align = center>"+rs.getString("emp_sex")+"</td>");
userInfo.append("<td>"+rs.getString("emp_idenfy")+"</td>");
userInfo.append("<td>"+rs.getString("emp_birth")+"</td>");
userInfo.append("<td>"+rs.getString("emp_native")+"</td>");
userInfo.append("<td>");
userInfo.append("<a href=../servlet/Detail?method=queryEmpInfoById&EmpId");
userInfo.append("="+id+">");
userInfo.append("详细信息</td>");
userInfo.append("</tr>");
if(!rs.next())
break;
i++;
}
try{
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
System.err.println(e);
}
pageInfo.append("第"+currentPage+"页 共"+pageCount+"页，共"+totaluser+"个用户");
if(currentPage>1)
pageInfo.append(" <a href = '../form/binfo.jsp?page="+(currentPage-1)+"'><<上一页</a>");
else
pageInfo.append(" <<上一页");
if(currentPage<pageCount)
pageInfo.append(" <a href = '../form/binfo.jsp?page="+(currentPage+1)+"'>下一页>></a>");
else
pageInfo.append(" 下一页>>");
%>
<%List list = (List)request.getAttribute("list"); %>
<%String user = (String)session.getAttribute("userName"); %>
<%String partid=(String)session.getAttribute("partid"); %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>基本信息</title>
<style type="text/css">
</style>
</head>
<body>
<div id="Layer1"
style="position:absolute;
left:0px;
top:0px;
width:1000px;
height:100px;
z-index:1">
<table width="1000" height="100" border="0">
<tr bgcolor="#00A4D1">
<th colspan="3" scope="col"><div align="center"><img src="image/bu1.gif" width="299" height="70"><a href="IndexServlet?method=queryEmpInfo"><img src="image/zy-1-1.gif" width="56" height="70" border="0"></a><a href="MoveToServlet?method=queryEmpChange"><img src="image/zy-3.gif" width="56" height="70" border="0"></a><a href="trasort.htm"><img src="image/zy-6-6.gif" width="56" height="70" border="0"></a><a href="inslevel.htm"><img src="image/zy-8.gif" width="56" height="70" border="0"></a></div></th>
</tr>
<tr>
<td width="896" height="25" bgcolor="#EAEAEA"><div align="left"><img src="image/index-18.gif" width="20" height="20"> <span class="style1">用户名：<%=user %></span></div></td>
<td width="67" bgcolor="#EAEAEA"><a href="../form/index.jsp"><img src="image/index-19.gif" width="67" height="20" border="0"></a></td>
<td width="67" bgcolor="#EAEAEA"><a href="../form/denglu.jsp"><img src="image/1.gif" width="67" height="20" border="0"></a></td>
</tr>
</table>
</div>
<div id="Layer2"
style="position:absolute;
left:0px;
top:100px;
width:200px;
height:530px;
z-index:2">
<table width="200" border="0">
<tr>
<th height="50" colspan="2" scope="col"><div align="left" class="style2">人员档案</div></th>
</tr>
<tr>
<td width="22"><img src="image/tree_blank.gif" width="16" height="18"></td>
<td width="168"><a href="IndexServlet?method=queryEmpInfo">人员基本信息</a></td>
</tr>
<tr>
<td><img src="image/tree_blank.gif" width="16" height="18"></td>
<td><a href="FileDetailServlet?method=queryEmpRecord&recid=a">员工档案</a></td>
</tr>
<tr>
<td><img src="image/tree_blank.gif" width="16" height="18"></td>
<td><a href="RecordToServlet?method=queryEmpStory">员工履历</a></td>
</tr>
<tr>
<td><img src="image/tree_blank.gif" width="16" height="18"></td>
<td><a href="ContractDetailServlet?method=queryEmpBargain&barid=a">员工合同</a></td>
</tr>
<tr>
<td><img src="image/tree_blank.gif" width="16" height="18"></td>
<td><a href="AwardDetailServlet?method=queryRewManage&rewid=a">奖惩管理</a></td>
</tr>
<tr>
<td><img src="image/tree_blankln.gif" width="16" height="22"></td>
<td><a href="../form/Infosea.jsp">人员基本信息查询</a></td>
</tr>
</table>
</div>
<div id="Layer3"
style="position:absolute; left:200px; top:100px; width:800px; height:544px; z-index:3; background-color: #EAEAEA; layer-background-color: #EAEAEA; border: 1px none #000000;">
<div align="right"> </div>
<form name="form1" action="../servlet/BinfoServlet">
<strong> 人员基本信息</strong>
<table width="800" border = "1" align = "center" cellpadding = 5 cellspacing = 1 bgcolor = #eaeaea>
<td width="55" ></td>
<tr height = "40" align = "center" bgcolor = #eaeaea>
<td width = "10%">人员编号</td>
<td width = "10%">姓名</td>
<td width = "10%">性别</td>
<td width = "20%">身份证号</td>
<td width = "20%">出生日期</td>
<td width = "10%">籍贯</td>
<td width = "12%"></td>
</tr>
<%=userInfo %>
<div align="right"><input type="submit" name="Submit" value="add" ></div>
</table>
<table width = "80%" border = "0" align = "center">
<tr>
<td align = right><%=pageInfo %></td>
</tr>
</table>
</form>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -