?? usermanager.jsp
字號:
<%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="conn.jsp"%><head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href=../css.css rel=STYLESHEET type=text/css>
</head>
<%!
boolean IsInt(String NInt)
{
try {
int n;
n=Integer.parseInt(NInt);
return true;
}
catch(NumberFormatException e){
return false;
}
}
%>
<%
if(session.getAttribute("admin_name")==null){
response.sendRedirect("main.jsp");}
else{
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#808080" height="77">
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr bgcolor="688cb8">
<td width="7%" height="17" bgcolor="#808080">
<div align="center"><font color="#FFFFFF">ID</font></div>
</td>
<td width="7%" height="17" bgcolor="#808080">
<div align="center"><font color="#FFFFFF">用戶名</font></div>
</td>
<td width="7%" height="17" bgcolor="#808080">
<div align="center"><font color="#FFFFFF">密碼</font></div>
</td>
<td width="7%" height="17" bgcolor="#808080">
<div align="center"><font color="#FFFFFF">性別</font></div>
</td>
<td width="8%" height="17" bgcolor="#808080">
<div align="center"><font color="#FFFFFF">出生日期</font></div>
</td>
<td width="8%" height="17" bgcolor="#808080">
<div align="center"><font color="#FFFFFF">保密郵箱</font></div>
</td>
<td width="8%" height="17" bgcolor="#808080">
<div align="center"><font color="#FFFFFF">聯系地址</font></div>
</td>
<td width="8%" bgcolor="#808080" height="17">
<div align="center"><font color="#FFFFFF">聯系方式</font></div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<%
String mypage;
int intpage=1;
mypage=request.getParameter("page");
if(mypage=="")
intpage=1;
if(!IsInt(mypage))
intpage=1;
if(IsInt(mypage))
intpage=Integer.parseInt(mypage);
if(intpage<1)
intpage=1;
mypage=Integer.toString(intpage);
sql="select * from b_user order by user_id desc";
rs=mdb.executeQuery(sql);
if(!rs.next()){
%>
<td colspan="9">暫且沒有任何用戶注冊</td>
</tr>
<%}else{
int PageSize =20; //設置每張網頁顯示兩條記錄
int ShowPage = 1; //設置欲顯示的頁數
int RowCount = 0; //ResultSet的記錄數目
int PageCount = 0; //ResultSet分頁后的總頁數
int duoyu=0;
if(rs.next())
{
//建立ResultSet(結果集)對象，并執行SQL語句
rs.last(); //將指標移至最后一筆記錄
RowCount=rs.getRow();
duoyu=RowCount % PageSize;
if(duoyu==0)
{
PageCount=RowCount/PageSize;
}
else{
PageCount=(RowCount-duoyu)/PageSize;
PageCount++;
}
// PageCount=((RowCount % PageSize) == 0?(RowCount/PageSize) : (RowCount/PageSize)+1);
//計算顯示的頁數
//String ToPage = request.getParameter("ToPage");
//if(ToPage==""){ToPage="1";}
//判斷是否可正確取得ToPage參數,
//可取得則表示JSP網頁應顯示特定分頁記錄的語句
//if(ToPage!=""){
ShowPage=intpage; //取得指定顯示的分頁頁數
//下面的if語句將判斷用戶輸入的頁數是否正確
if(ShowPage>PageCount)
{ //判斷指定頁數是否大于總頁數, 是則設置顯示最后一頁
ShowPage=PageCount;
}
else if(ShowPage<=0)
{ //若指定頁數小于0, 則設置顯示第一頁的記錄
ShowPage = 1;
}
}
rs.absolute((ShowPage - 1) * PageSize + 1);
int i=1;
rs.previous();
while(rs.next()&&i<=PageSize){
i++;
int user_id=rs.getInt("u_id");
String user_name=rs.getString("u_name");
String user_pass=rs.getString("u_pass");
String user_sex=rs.getString("u_sex");
String user_birthday=rs.getString("u_birthday");
String user_mail=rs.getString("u_mail");
String user_address=rs.getString("u_address");
String user_phone=rs.getString("u_phone");
%>
<tr bgcolor="#FFFFFF">
<td width="7%" height="15"><%=user_id%>
<div align="center"></div>
</td>
<td width="7%" height="15"><%=user_name%>
<div align="center"></div>
</td>
<td width="7%" height="15"><%=user_pass%>
<div align="center"></div>
</td>
<td width="7%" height="15"><%=user_sex%>
<div align="center"></div>
</td>
<td width="7%" height="15"><%=user_birthday%>
<div align="center"></div>
</td>
<td width="7%" height="15"><%=user_mail%>
<div align="center"></div>
</td>
<td width="7%" height="15"><%=user_address%>
<div align="center"></div>
</td>
<td width="8%" height="15">
<div align="center"><%=user_phone%></div>
</td>
<td width="8%" height="15">
<div align="center"><a href="viewuser.jsp?user_id=<%=user_id%>&action=deluser">刪除</a></div>
</td>
</tr>
<%}
%>
<tr bgcolor="#FFFFFF" align="right">
<td colspan="9" height="2">
<p align="left">共<font color=red><%=PageCount%></font>頁 第<%=intpage%>頁
<font color=666666>
<%if(intpage-1>0){%>
<a href="usermanage.jsp?page=<%=intpage-1%>">上一頁</a>
<%}else{%>
<font color=666666>上一頁</font>
<%}%>
<%if(intpage+1<=PageCount){%>
<a href="usermanage.jsp?page=<%=intpage+1%>">下一頁</a>
<%}else{%>
<font color=666666>下一頁</font>
<%}%>
</font></p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
}
mdb.Close();}
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -