📄 user_manage.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<jsp:useBean id="connManager" scope="application" class="bbs.ConnManager" />
<%
Connection con = connManager.getConnection("mysql");
if(con==null)
{
%>对不起，现在数据库忙，请稍后再试<%
}
Statement stmt = con.createStatement();
request.setcharacterEncoding("gb2312");
%>
<html>
<meta http-equiv="refresh" content="10">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
a {
font-size: 12px;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.style1 {
color: #6600CC;
font-weight: bold;
}
.style2 {
color: #FFFFFF;
font-weight: bold;
}
-->
</style></head>
<body>
<%
String UserName=new String(session.getAttribute("Admin").getBytes("ISO8859_1"),"GBK");
if (UserName==null)
response.sendRedirect("admin/login.jsp");
%>
<%
int PageSize=5; //一页显示的记录数
int RowCount; //记录总数
int PageCount; //总页数
int Page; //待显示页码
int i,j;
String strPage = request.getParameter("page");
if (strPage==null){
//表明在QueryString中没有page这一个参数，此时显示第一页数据
Page = 1;
}
else{
//将字符串转换成整型
Page = Integer.parseInt(strPage);
if(Page<1)
Page = 1;
}%>
<%
sql="select count(*) as RowCount from user_info ;
rs =stmt.executeQuery(sql);
rs.next();
rs.close();
PageCount = (RowCount+PageSize-1) / PageSize; //记算总页数
if(Page>PageCount) Page = PageCount; //调整待显示的页码
i = (Page-1) * PageSize; //将记录指针定位到待显示页的第一条记录上
for(j=0;j<i;j++)
rs.next();
String sql2 = "select UserName,IsManager from user_info;
rs2 =stmt.executeQuery(sql2);
%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="6"><img src="../images/part1_37.gif" width="5" height="28"></td>
<td width="709" background="../images/part1_38.gif"><div align="center" class="style2">：：： 用户管理 ：：：</div></td>
<td width="5"><img src="../images/part1_41.gif" width="8" height="28"></td>
</tr>
<tr>
<td width="6" height="45" background="../images/part1_44.gif"> </td>
<td>
<table width="80%" border="0" align="center" cellpadding="2" cellspacing="1">
<tr background="../images/bg_02.gif">
<td width="32%" height="23">
<div align="center" class="style1">用 户 名</div></td>
<td width="44%" height="23"><div align="center" class="style1">用 户 权 限</div></td>
<td height="23" colspan="2">
<div align="center" class="style1">操 作</div> </td>
</tr>
<%
int i = 0;
if(rs2.next())
{
String UserName=rs2.getString("UserName");
Boolean IsManager=rs2.getBoolean("IsManager");
if(IsManger)
String str="版主";
else
String str="普通用户";
while(i<PageSize && rs2.next()){
%>
<tr>
<td ><div align="center"><%=UserName%></div></td>
<td ><div align="center"><%=str%></div></td>
<td width="21%" ><div align="center"><a href="del_user.jsp?username=<%=UserName%>">删除</a></div></td>
</tr>
<%
i++;
}
}
else{
%>
无论坛分类信息!
<%}
rs2.close();
stmt.close();
connManager.releaseConnection("mysql",con);
%>
<tr bgcolor="#FFFFFF">
<td class="text1" colspan="4"><div align="right"> </div></td>
</tr>
</table> </td>
<td width="5" background="../images/part1_48.gif"> </td>
</tr>
<tr>
<td width="6"><img src="../images/part1_51.gif" width="5" height="14"></td>
<td background="../images/part1_52.gif"> </td>
<td width="5"><img src="../images/part1_55.gif" width="8" height="14"></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -