📄 userlist.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="error.jsp" %>
<jsp:useBean id="dbConn" scope="page" class="com.alumni.bean.DBConnection"/>
<jsp:useBean id="rsc" scope="page" class="com.alumni.bean.ResultSetController"/>
<%
Connection conn=null;
Statement stmt=null;
//登陆用户的权限
String loginUserClass=null;
//获取访问该页面的用户权限
loginUserClass=(String)session.getAttribute("adminClass");
if(loginUserClass==null||loginUserClass.equals(""))
{
loginUserClass="0";
}
String userID=null;
String username=null;
String realname=null;
String email=null;
String qq=null;
String msn=null;
String exp=null;
String regDate=null;
String adminClass=null;
String totalPublish=null;
String totalVote=null;
String totalLogin=null;
String currentPage=(request.getParameter("page"));
if(currentPage==null||currentPage=="")
{
currentPage="1";
}
String sql="SELECT * FROM USERINFO ORDER BY ID";
conn=dbConn.getConnectionToAccess(application.getRealPath("/db/alumni.mdb"));
rsc.setConnectionObject(conn);
rsc.setQueryString(sql);
rsc.setCurrentPageNum(Integer.parseInt(currentPage));
rsc.setRowsPerPage(20);
rsc.run();
%>
<!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">
<title>班级成员列表</title>
<link href="css/index.css" rel="stylesheet" type="text/css">
</head>
<body>
<jsp:include page="include/top.htm"/>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><h4>注册成员</h4></td>
</tr>
</table>
<table width="95%" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td>当前页：<font color="#FF0000"><strong><%=rsc.getCurrentPageNum()%>/<%=rsc.getTotalPages()%></strong></font>，当前每页显示<font color="#FF0000"><strong><%=rsc.getRowsPerPage()%></strong></font>条记录，共有<font color="#FF0000"><strong><%=rsc.getTotalCounts()%></strong></font>位成员</td>
</tr>
</table>
<%
if(Integer.parseInt(loginUserClass)>0)
{
out.println("<form id='adminUserForm' name='adminUserForm' method='post' action='/servlet/AdminUserServlet'>");
}
%>
<table width="95%" border="0" align="center" cellpadding="8" cellspacing="1" bgcolor="#000000">
<tr align="center">
<td bgcolor="#99cc66">ID</td>
<td bgcolor="#99cc66">用户名</td>
<td bgcolor="#99cc66">真实姓名</td>
<td bgcolor="#99cc66">邮件</td>
<td bgcolor="#99cc66">QQ</td>
<td bgcolor="#99cc66">MSN</td>
<td bgcolor="#99cc66">经验值</td>
<td bgcolor="#99cc66">注册日期</td>
<td bgcolor="#99cc66">权限</td>
<td bgcolor="#99cc66">总发表</td>
<td bgcolor="#99cc66">总投票</td>
<td bgcolor="#99cc66">登陆</td>
<td bgcolor="#99cc66"> </td>
</tr>
<%while(rsc.isAvailable())
{
userID=rsc.getData("ID");
username=rsc.getData("USERNAME");
realname=rsc.getData("REALNAME");
email=rsc.getData("EMAIL");
qq=rsc.getData("QQ");
msn=rsc.getData("MSN");
exp=rsc.getData("EXP");
regDate=rsc.getData("REG_DATE");
adminClass=rsc.getData("ADMIN_CLASS");
totalPublish=rsc.getData("TOTAL_PUBLISH");
totalVote=rsc.getData("TOTAL_VOTE");
totalLogin=rsc.getData("TOTAL_LOGIN");
%>
<tr>
<td bgcolor="#e7e7e7"><%=userID%></td>
<td bgcolor="#e7e7e7"><%=username%></td>
<td bgcolor="#e7e7e7"><%=realname%></td>
<td bgcolor="#e7e7e7"><%=email%></td>
<td bgcolor="#e7e7e7"><%=qq%></td>
<td bgcolor="#e7e7e7"><%=msn%></td>
<td bgcolor="#e7e7e7"><%=exp%></td>
<td bgcolor="#e7e7e7"><%=regDate%></td>
<td bgcolor="#e7e7e7"><%=adminClass%></td>
<td bgcolor="#e7e7e7"><%=totalPublish%></td>
<td bgcolor="#e7e7e7"><%=totalVote%></td>
<td bgcolor="#e7e7e7"><%=totalLogin%></td>
<td bgcolor="#e7e7e7">
<%
if(Integer.parseInt(loginUserClass)>0)
{
out.println("<input name='userID' id='userID' type='checkbox' value='"+userID+"'>");
}
%></td>
</tr>
<%}%>
</table>
<%
if(Integer.parseInt(loginUserClass)>0)
{
out.print("<table width='95%' border='0' cellpadding='0' cellspacing='0'><tr><td align='right'><input name='delete' type='submit' value='删除该用户'></td></tr></table>");
out.println("</form>");
}
%>
<table width="95%" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td align="right">
<%
for(int i=1;i<=rsc.getTotalPages();i++)
{
out.print("<a target='_self' href='userlist.jsp?page="+i+"'>"+i+"</a> ");
}
%></td>
</tr>
</table>
<%
if(dbConn!=null)
{
dbConn.close();
}
%>
<jsp:include page="include/bottom.htm"/>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -