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

📄 staff_list.jsp

📁 数据库系统教材中附录的课程设计accomodation宿舍管理系统源码
💻 JSP
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="cn.kmp.accommodation.domain.*" %>
<%@ page import="cn.kmp.accommodation.service.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'staff_list.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
	
	

  </head>
  
<body>
<% 
	StaffService staffService=ServiceFactory.getStaffService();
	DepartmentService ds=ServiceFactory.getDepartmentService();
	
	List<Staff> all=staffService.getAllStaffs();
	List<Staff> supervisors=staffService.getSupervisors();
	List<Staff> age=staffService.getStaffsByAge("1948-00-00");
	
%>

<div id="container">
	<div id="supervisors">
	<h3>管理员</h3>
		<table border="1">
			<tr>
				<td>职员号</td>
				<td>姓名</td>
				<td>性别</td>
				<td>生日</td>
				<td>职位</td>
				<td>办公地点</td>
				<td>住址</td>
				<td>管理的公寓号</td>
				<td>公寓类型</td>
				<td colspan="2">操作</td>
			</tr>
		<%for(Staff s:supervisors){
			String name=s.getLname()+s.getFname();
			String addr=s.getCity()+s.getStreet();
			Department d=ds.getDepartmentBySupervisor(s.getStaffNum());
		%>
			<tr>
				<td><%=s.getStaffNum() %></td>
				<td><%=name %></td>
				<td><%=s.getSex() %></td>
				<td><%=s.getBirthday() %></td>
				<td><%=s.getPosition() %></td>
				<td><%=s.getLocation() %></td>
				<td><%=addr %></td>
				<td><%=d.getDepartmentNum() %></td>
				<td><%if(d.getType()==0)out.println("单间公寓");else out.println("集体公寓"); %></td>
				<td><a href="<%=basePath%>jsp/edit_staff.jsp?staffNum=<%=s.getStaffNum() %>">编辑</a></td>
				<td><a href="<%=basePath%>deleteStaff.do?staffNum=<%=s.getStaffNum() %>" onclick="{if(confirm('确定要删除吗?')){return true;}return false;}">删除</a></td>
			</tr>
		<%} %>
		</table>
	</div>
	
	<div id="all">
	<h3>所有员工</h3>
		<table border="1">
			<tr>
				<td>职员号</td>
				<td>姓名</td>
				<td>性别</td>
				<td>生日</td>
				<td>职位</td>
				<td>办公地点</td>
				<td>住址</td>
				<td colspan="2">操作</td>
			</tr>
		<%for(Staff s:all){
			String name=s.getLname()+s.getFname();
			String addr=s.getCity()+s.getStreet();
		%>
			<tr>
				<td><%=s.getStaffNum() %></td>
				<td><%=name %></td>
				<td><%=s.getSex() %></td>
				<td><%=s.getBirthday() %></td>
				<td><%=s.getPosition() %></td>
				<td><%=s.getLocation() %></td>
				<td><%=addr %></td>
				<td><a href="<%=basePath%>jsp/edit_staff.jsp?staffNum=<%=s.getStaffNum() %>">编辑</a></td>
				<td><a href="<%=basePath%>deleteStaff.do?staffNum=<%=s.getStaffNum() %>" onclick="{if(confirm('确定要删除吗?')){return true;}return false;}">删除</a></td>
			</tr>
		<%} %>
		</table>
	</div>
	
	<div id="age">
	<h3>年龄大于60的职员</h3>
		<table border="1">
			<tr>
				<td>职员号</td>
				<td>姓名</td>
				<td>生日</td>
				<td>职位</td>
			</tr>
		<%for(Staff s:age){
			String name=s.getLname()+s.getFname();
		%>
			<tr>
				<td><%=s.getStaffNum() %></td>
				<td><%=name %></td>
				<td><%=s.getBirthday() %></td>
				<td><%=s.getPosition() %></td>
			</tr>
		<%} %>
		</table>
	</div>
	
</div>
</body>
</html>

⌨️ 快捷键说明

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