📄 department_management.jsp

📁 jsp动态网站开发技术与实践电子工业出版社随书附赠源代码

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<!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">
		<link rel=stylesheet type=text/css href="../lib/enterprise.css">
		<title>欢迎光临企业办公平台</title>
		<jsp:useBean scope="page" id="Department" class="com.chapter15.Department" />
		<jsp:useBean scope="page" id="User" class="com.chapter15.User" />
	</head>
	<body bgcolor="#F2F2F2">
	<div align="center">
	<form name="form1" action="delete_department.jsp" method="post">
	<table width="60%" border="0" cellpadding="0" cellspacing="1">
		<tr bgcolor="#CC99FF">
		<th width="10%" height="30" align="center">选中</th>
		<th width="30%" height="30" align="center">部门名称</th>
		<th width="20%" height="30" align="center">部门经理</th>
		<th width="20%" height="30" align="center">部门人数</th>
		<th width="20%" height="30" align="center">修改名称</th>
		</tr>
<%
	//获取所有部门信息
	ResultSet rs = Department.show_departments();
	//显示部门信息
	while(rs.next())
	{
		//获取部门经理的索引号
		long lManagerID = rs.getLong("ManagerID");
		User.setDepartmentID(rs.getLong("DepartmentID"));
%>
		<tr>
		<td width="10%" height="25" align="center"><input type="checkbox" name="DeleteID" value='<%=rs.getLong("DepartmentID")%>'></td>
		<td width="30%" height="25" align="left">&nbsp;<a href='department_user_list.jsp?DepartmentID=<%=rs.getLong("DepartmentID")%>' target="_self"><font color="#0000FF"><%=rs.getString("DepartmentName")%></font></a></td>
		<td width="20%" height="25" align="left">&nbsp;
		<%
			//判断当前部门是否有部门经理
			if(lManagerID > 0)
			{
				User.setUserID(lManagerID);
				User.init();
				out.println(User.getRealName());
			}
			else
				out.println("暂无");
		%>
		</td>
		<td width="20%" height="25" align="center"><a href='department_user_list.jsp?DepartmentID=<%=rs.getLong("DepartmentID")%>' target="_self"><font color="#0000FF"><%=User.count_department_users()%></font></a></td>
		<td width="20%" height="25" align="center"><a href='modify_department_form.jsp?DepartmentID=<%=rs.getLong("DepartmentID")%>' target="_self"><font color="#0000FF">修改</font></a></td>
		</tr>
<%
	}
%>
	</table>
	<p><input type="submit" name="sub" value="删除选中的部门">&nbsp;&nbsp;
	<input type="button" name="btn" value="添加新部门" onClick="javascript:window.location='add_department_form.html'">
		</p>
	</form>
	</div>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -