?? user_management.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>歡迎光臨企業(yè)辦公平臺</title>
<jsp:useBean scope="page" id="User" class="com.chapter15.User" />
<jsp:useBean scope="page" id="pages" class="com.chapter15.SplitPage" />
<jsp:useBean scope="page" id="Department" class="com.chapter15.Department" />
</head>
<%
//獲取所有員工信息
ResultSet rs = User.show_users();
//初始化分頁顯示類
pages.initialize(rs,10);
String strPage=null;
int showPage = 1;
//獲取跳轉(zhuǎn)到的目的頁面
strPage=request.getParameter("showPage");
if (strPage==null)
{
showPage=1;
}
else
{
try
{
showPage=Integer.parseInt(strPage);
}
catch(NumberFormatException e)
{
showPage = 1;
}
if(showPage<1)
{
showPage=1;
}
if(showPage>pages.getPageCount())
{
showPage=pages.getPageCount();
}
}
//獲取要顯示的數(shù)據(jù)集合
Vector vData=pages.getPage(showPage);
%>
<body bgcolor="#F2F2F2">
<div align="center">
<form name="form1" method="post" action="delete_user.jsp" target="_self">
<input type="hidden" name="showPage" value="<%=showPage%>">
<table width="95%" border="0" cellpadding="0" cellspacing="1">
<tr bgcolor="#CC99FF">
<th width="10%" height="30" align="center">選中</th>
<th width="10%" height="30" align="center">員工號</th>
<th width="30%" height="30" align="center">用戶名</th>
<th width="25%" height="30" align="center">姓名</th>
<th width="15%" height="30" align="center">所屬部門</th>
<th width="10%" height="30" align="center">修改</th>
</tr>
<%
//循環(huán)顯示當(dāng)前頁的員工信息
for(int i=0;i<vData.size();i++)
{
//顯示數(shù)據(jù)
String[] sData=(String[])vData.get(i);
%>
<tr>
<td width="10%" height="25" align="center"> <input type="checkbox" name="DeleteID" value="<%=sData[0]%>"></td>
<td width="10%" height="25" align="center"><%=sData[4]%></td>
<td width="30%" height="25" align="left"> <a href="./user_detail.jsp?UserID=<%=sData[0]%>" target="_self"><font color="#0000FF"><%=sData[1]%></font></a></td>
<td width="25%" height="25" align="left"> <%=sData[2]%></td>
<td width="15%" height="25" align="left">
<%
long lDepartmentID = Long.parseLong(sData[3]);
Department.setDepartmentID(lDepartmentID);
if(Department.init())
{
out.println(Department.getDepartmentName());
}
else
{
out.println("無部門");
}
%>
</td>
<td width="10%" height="25" align="center"> <a href="modify_user_form.jsp?UserID=<%=sData[0]%>&showPage=<%=showPage%>" target="_self"><font color="#0000FF">修改</font></a></td>
</tr>
<%
}
%>
</table>
<p><input type="submit" name="sub" value="刪除選中的員工">
<input type="button" name="btn" value="添加新員工" onClick="javascript:window.location='add_user_form.jsp'">
</p>
</form>
<p>
<form action="user_management.jsp" method="post" target="_self">
第<font color="#FF0000"><%=showPage%></font>頁/共<font color=red><%=pages.getPageCount()%></font>頁
<a href="user_management.jsp?showPage=1" target="_self"><font color="#0000FF">[首頁]</font></a>
<%
//判斷"上一頁"鏈接是否要顯示
if(showPage > 1)
{
%>
<a href="user_management.jsp?showPage=<%=showPage-1%>" target="_self"><font color="#0000FF">[上一頁]</font> </a>
<%
}
else
{
out.println("[上一頁] ");
}
//判斷"下一頁"鏈接是否要顯示
if(showPage < pages.getPageCount())
{
%>
<a href="user_management.jsp?showPage=<%=showPage+1%>" target="_self"><font color="#0000FF">[下一頁]</font> </a>
<%
}
else
{
out.println("[下一頁] ");
}
%>
<a href="user_management.jsp?showPage=<%=pages.getPageCount()%>" target="_self"><font color="#0000FF">[尾頁]</font> </a>
轉(zhuǎn)到
<select name="showPage">
<%
for(int x=1;x<=pages.getPageCount();x++)
{
%>
<option value="<%=x%>" <%if(showPage==x) out.println("selected");%> ><%=x%></option>
<%
}
%>
</select>
頁
<input type="submit" name="go" value="提交"/>
</form>
</p>
<%rs.close();%>
</div>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -