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

📄 department_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 'department_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="<%=basePath %>styles/list.css">

  </head>
  
<body>
<% 
	String type=request.getParameter("type");
	
	String t=request.getParameter("t");
	String departmentNum=request.getParameter("departmentNum");
	
	int ty=-1;
	int dn=-1;
	if(departmentNum!=null&&!(departmentNum.equals("")))dn=Integer.parseInt(departmentNum);
	if(t!=null&&!(t.equals("")))ty=Integer.parseInt(t);
	
	
	DepartmentService ds=ServiceFactory.getDepartmentService();
	PlaceService ps=ServiceFactory.getPlaceService();
	
	StaffService ss=ServiceFactory.getStaffService();
	List<Department> all=ds.getAllDepartments();
	
	List<Department> searchResult=ds.searchDepartment(dn,ty);
%>
<div id="container">
	<div id="header">
		<a href="<%=basePath %>jsp/department_list.jsp">公寓</a>
		<% if(type!=null && type.equals("0")){%>
			--><a href="<%=basePath %>jsp/department_list.jsp?type=0">单间公寓</a>
		<%} %>
		<% if(type!=null && type.equals("1")){%>
			--><a href="<%=basePath %>jsp/department_list.jsp?type=1">集体公寓</a>
		<%} %>
	</div>
	
	<div id="search">
		<form action="<%=basePath%>jsp/department_list.jsp" method="post">
			<label for="t">公寓类型</label>
			<select name="t">
				<option value="0">单间公寓</option>
				<option value="1">集体公寓</option>
			</select>
			<label for="departmentNum">公寓号</label><input type="text" name="departmentNum" size="10"/>
			<input type="submit" name="search" value="Go"/>
		</form>
	</div>
	
	<div id="content">
		<table border="1">
			<tr>
				<td>类别</td>
				<td>公寓号</td>
				<td>公寓名</td>
				<td>地址</td>
				<td>电话</td>
				<td>管理员</td>
				<td>床位数</td>
				<td colspan="2">操作</td>
			</tr>
		<%
		if(type==null&&departmentNum==null&&all!=null){
			for(Department d:all){
				String s=null; 
				if(d.getType()==0)s="单间公寓";
				else s="集体公寓"; 
				List<Place> pl=ps.getPlacesByDepartmentNumAndType(d.getDepartmentNum(),d.getType());
		%>
			<tr>
				<td><%=s%></td>
				<td><a href="<%=basePath%>jsp/place_list.jsp?departmentNum=<%=d.getDepartmentNum()%>&type=<%=d.getType()%>"><%=d.getDepartmentNum()%></a></td>
				<td><a href="<%=basePath%>jsp/place_list.jsp?departmentNum=<%=d.getDepartmentNum()%>&type=<%=d.getType()%>"><%=d.getDepartmentName()%></a></td>
				<td><%=d.getAddress()%></td>
				<td><%=d.getPhoneNumber()%></td>
				<td><%out.println(ss.getStaffByStaffNum(d.getSupervisor()).getLname()+ss.getStaffByStaffNum(d.getSupervisor()).getFname());%></td>
				<td><%=pl.size() %></td>
				<td><a href="<%=basePath %>jsp/edit_department.jsp?departmentNum=<%=d.getDepartmentNum()%>&type=<%=d.getType()%>">编辑</a></td>
				<td><a href="<%=basePath %>deleteDepartment.do?departmentNum=<%=d.getDepartmentNum()%>&type=<%=d.getType()%>" onclick="{if(confirm('确定要删除吗?')){return true;}return false;}">删除</a></td>
			</tr>
		<%}} %>
		
	
		
		<% 
			if(searchResult!=null&&departmentNum!=null){ 
				for(Department d:searchResult){	
					String x=null; 
					if(d.getType()==0)x="单间公寓";
					else x="集体公寓"; 
					List<Place> pl=ps.getPlacesByDepartmentNumAndType(d.getDepartmentNum(),d.getType());
		%>
			<tr>
				<td><%=x%></td>
				<td><a href="<%=basePath%>jsp/place_list.jsp?departmentNum=<%=d.getDepartmentNum()%>&type=<%=d.getType()%>"><%=d.getDepartmentNum()%></a></td>
				<td><a href="<%=basePath%>jsp/place_list.jsp?departmentNum=<%=d.getDepartmentNum()%>&type=<%=d.getType()%>"><%=d.getDepartmentName()%></a></td>
				<td><%=d.getAddress()%></td>
				<td><%=d.getPhoneNumber() %></td>
				<td><%out.println(ss.getStaffByStaffNum(d.getSupervisor()).getLname()+ss.getStaffByStaffNum(d.getSupervisor()).getFname()); %></td>
				<td><%=pl.size() %></td>
				<td><a href="<%=basePath %>jsp/edit_department.jsp?departmentNum=<%=d.getDepartmentNum()%>&type=<%=d.getType()%>">编辑</a></td>
				<td><a href="<%=basePath %>deleteDepartment.do?departmentNum=<%=d.getDepartmentNum()%>&type=<%=d.getType()%>" onclick="{if(confirm('确定要删除吗?')){return true;}return false;}">删除</a></td>
			</tr>
		<%}} %>
		</table>
	</div>
</div>
</body>
</html>

⌨️ 快捷键说明

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