📄 department_user_list.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="User" class="com.chapter15.User" />
	</head>
	<body bgcolor="#F2F2F2">
		<div align="center">
		<table width="80%" border="0" cellpadding="0" cellspacing="1">
			<tr bgcolor="#CC99FF">
			<th width="15%" height="30" align="center">员工号</th>
			<th width="30%" height="30" align="center">用户名</th>
			<th width="30%" height="30" align="center">姓名</th>
			<th width="25%" height="30" align="center">性别</th>
			</tr>
<%			
	//获取部门的索引号
	String sDepartmentID = request.getParameter("DepartmentID");
	long lDepartmentID = Long.parseLong(sDepartmentID);	
	//获取所有员工信息
	User.setDepartmentID(lDepartmentID);
	ResultSet rs = User.show_department_users();	
	//显示员工信息
	while(rs.next())
	{
%>
		<tr>
			<td width="15%" height="25" align="center"><%=rs.getString("UserSN")%></td>
			<td width="30%" height="25" align="left">&nbsp;<a href='./user_detail.jsp?UserID=<%=rs.getLong("UserID")%>' target="_self"><font color="#0000FF"><%=rs.getString("UserName")%></font></a></td>
			<td width="30%" height="25" align="left">&nbsp;<%=rs.getString("RealName")%></td>
			<td width="25%" height="25" align="left">&nbsp;<%=rs.getString("Sex")%></td>
		</tr>
<%
		
	}
%>
		</table>		
		<%rs.close();%>
	</div>
	</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -