📄 emselect.jsp~8~
字号:
<%@page contentType="text/html; charset=gb2312"%>
<%@page import="com.domain.EmployeeVO"%>
<%@page import="com.dao.ManagerDao"%>
<%@page import="com.domain.ManagerVO"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css/style.css" rel="stylesheet" type="text/css">
<title>查询员工</title>
</head>
<%
List list = (List) request.getAttribute("list");
int number=Integer.parseInt((String)request.getAttribute("number"));
int maxPage=Integer.parseInt((String)request.getAttribute("maxPage"));
int pageNumber=Integer.parseInt((String)request.getAttribute("pageNumber"));
int start=number*5;//开始条数
int over=(number+1)*5;//结束条数
int count=pageNumber-over;//还剩多少条记录
if(count<=0){
over=pageNumber;
}
%>
<body>
<table width="80%" height="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#004C86" class="tableBorder_r">
<tr align="left" valign="top">
<td height="20%" colspan="3 " >
<jsp:include page="../top.jsp"/>
</td>
</tr>
<tr>
<td width="192" height="80%" scope="row" background="picture/left.jpg">
<jsp:include page="../ma.jsp"/>
</td>
<td width="635" height="80%" scope="row">
<div align="center">
<p> </p>
<p>
<%if (list == null) { %>
<strong>员工信息为空！！！</strong>
<%} else { %>
</p>
</div>
<table width="97%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolordark="#819BBC" bordercolorlight="#FFFFFF">
<tr align="center">
<td width="10%" height="28" colspan="8" bgcolor="#EFF6FE"><strong>查看员工信息</strong></td>
</tr>
<tr align="center">
<td width="10%" height="25" bgcolor="#EFF6FE">编号</td>
<td width="10%" bgcolor="#EFF6FE">姓名</td>
<td width="10%" bgcolor="#EFF6FE">性别</td>
<td width="10%" bgcolor="#EFF6FE">年龄</td>
<td width="10%" bgcolor="#EFF6FE">职位</td>
<td width="12%" bgcolor="#EFF6FE">出生日期</td>
<td width="12%" bgcolor="#EFF6FE">毕业学校</td>
<td width="17%" bgcolor="#EFF6FE">操作</td>
</tr>
<%
for (int i =start; i < over; i++) {
EmployeeVO em = (EmployeeVO) list.get(i);
%>
<tr align="center">
<td height="29"><%=em.getEm_number()%> </td>
<td><%=em.getEm_name()%> </td>
<td><%=em.getEm_sex()%> </td>
<td><%=em.getEm_age()%> 岁
</td>
<td><%=em.getEm_birthday()%> </td>
<td><%=em.getEm_business()%> </td>
<td><%=em.getEm_school()%> </td>
<%
ManagerDao dao = new ManagerDao();
ManagerVO manager = dao.managerSelect(em.getEm_number());
if (em.getEm_number().equals(manager.getMa_number())) {
%>
<td> 管理员
<a href="managerservlet?method=3&number=<%=em.getEm_number()%>">删除</a>
</td>
<%} else { %>
<td width="9%">
<a href="managerservlet?method=3&number=<%=em.getEm_number()%>">删除</a>
</td>
<%} %>
</tr>
<%} %>
</table>
<%}%>
<table width="88%" height="29" border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="center">
<td>共为<%=maxPage%>页</td>
<td>共有<%=pageNumber%>条记录</td>
<td>当前为第<%=number+1%>页</td>
<%if((number+1)==1){%> <td>上一页</td><%}else{%><td><a href="managerservlet?method=2&number=<%=session.getAttribute("number")%>&i=<%=number-1%>">上一页</a></td><%}%>
<%if(maxPage==(number+1)){%><td>下一页</td><%}else{%><td><a href="managerservlet?method=2&number=<%=session.getAttribute("number")%>&i=<%=number+1%>">下一页</a></td><%}%>
</tr>
</table><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -