?? department_user_list.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"> <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"> <%=rs.getString("RealName")%></td>
<td width="25%" height="25" align="left"> <%=rs.getString("Sex")%></td>
</tr>
<%
}
%>
</table>
<%rs.close();%>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -