📄 memberlist.jsp
字号:
<%
/*##################################################################**
**# 程序名称：LyBBS『凌云论坛』 #**
**# #**
**# 程序开发: teddy 『星语凌』 #**
**# #**
**# 版权所有: 凌云创作室 (原流星电脑工作室) #**
**# #**
**# 主页地址: http://www.lybbs.net #**
**# 电邮地件: horseye@sina.com #**
**# #**
**##################################################################*/
%>
<%@ include file="include/config.jsp"%>
<%@ page contentType="text/html;charset=GBK" %>
<%
int forumID=0;
String tempSTR="",
a="",
query="",
errorInfo="";
ParameterUtils.setCharacterEncoding(request);
a=ParameterUtils.getString(request,"a");
if(a.equals("")) a="1";
%>
<%@ include file="include/boardprepare.jsp"%>
<!--//html from here-->
<%@ include file="include/head.jsp"%>
<script language="JavaScript">
function changePages(){
var URL = document.changepages.pages.options[document.changepages.pages.selectedIndex].value;
location.href = URL; target = '_self';
}
</script>
<body <%=lbbody%>>
<%@ include file="include/userheader.jsp"%>
<%
int infosOpen=forumStyle.getInfosOpen();
forumStatus.getForumStats();
int totalAuthorNumber=forumStatus.getTotalAuthorNumber(),
totalPostsNumber=forumStatus.getTotalPostsNumber();
//分页变量定义
int e=20; //'每页显示的记录数
int totalpage=0; //'页面总数
int pages=1; //'显示的当前页面
int count=0; //'库中数据的总记录数
int from=0,to=0; //'从from篇到to篇
int p=0; //'数据库查询从p开始
//取页数
tempSTR=request.getParameter("pages");
if(tempSTR!=null && !tempSTR.equals(""))
pages=Integer.parseInt(tempSTR);
//分页预备
count=totalAuthorNumber;
totalpage=((count%e==0)?(count/e):(count/e+1));
if(totalpage==0) totalpage=1;
if(pages>totalpage) pages=totalpage;
else if(pages<1) pages=1;
if(count!=0)
from=(pages-1)*e+1;
if(totalpage==pages)
to=count;
else if(count!=0)
to=from+e-1;
p= (pages-1)*e;
%>
<br>
<table cellpadding=0 cellspacing=0 border=0 width=<%=tablewidth%> align=center>
<tr>
<td width=30% rowspan=2 valign=top>
<img src="images/<%=boardlogo%>" border=0>
</td>
<td valign=top align=left>
<font face="宋体" color=<%=fontcolormisc%>>
<img src="images/closedfold.gif" border=0> <a href="index.jsp"><%=boardname%></a><br>
<img src="images/bar.gif" border=0><img src="images/openfold.gif" border=0> 用户列表
</font>
</td>
</tr>
</table>
<br>
<%
if(infosOpen==2 && cookieMode.compareTo("3")<0)
errorInfo="管理员设置了这个页面只有版主可以查看";
else if(infosOpen==1 && cookieMode.equals("0"))
errorInfo="管理员设置了这个页面只有注册用户可以查看";
if(!errorInfo.equals("")) {
%>
<table cellpadding=0 cellspacing=0 border=0 width=<%=tablewidth%> bgcolor=<%=tablebordercolor%> align=center>
<tr>
<td>
<table cellpadding=6 cellspacing=1 border=0 width=100%>
<tr>
<td bgcolor=<%=miscbacktwo%> align=center><font color=<%=fontcolormisc%>><b>用户列表查看错误</b></font></td>
</tr>
<tr>
<td bgcolor=<%=miscbackone%>>
<font color=<%=fontcolormisc%>>
<b>关于查看资料出错的可能原因：</b>
<ul>
<li><b><%=errorInfo%></b>
</ul>
</font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
}
else {
%>
<table width=<%=tablewidth%> align=center cellspacing=0 cellpadding=1 border=0 bgcolor=<%=tablebordercolor%>>
<tr>
<td>
<table cellpadding=6 cellspacing=1 border=0 width=100%>
<tr bgcolor=<%=forumcolorone%>>
<td colspan=5 valign=top>
>> <B>
<%
if(a.equals("2"))
out.print("发贴总数前 15 名");
else if(a.equals("5"))
out.print("最新 15 名注册用户");
else if(a.equals("3"))
out.print("以用户名排序");
else if(a.equals("1"))
out.print("以发贴总数排序");
else if(a.equals("4"))
out.print("以注册时间排序");
else if(a.equals("6"))
out.print("监狱中的犯人");
%>
</B> <<<BR><BR>
总注册用户数： <%=totalAuthorNumber%> 人 发贴总数： <%=totalPostsNumber%> 篇</font>
</td>
<td colspan=5 align=right>
<form method=get action=memberlist.jsp>
<select name=a>
<option value=2 <%if(a.equals("2")) out.print("selected");%>>发贴总数前 15 名</option>
<option value=5 <%if(a.equals("5")) out.print("selected");%>>最新 15 名注册用户</option>
<option value=3 <%if(a.equals("3")) out.print("selected");%>>以用户名排序</option>
<option value=1 <%if(a.equals("1")) out.print("selected");%>>以发贴总数排序</option>
<option value=4 <%if(a.equals("4")) out.print("selected");%>>以注册时间排序</option>
<option value=6 <%if(a.equals("6")) out.print("selected");%>>监狱中的犯人</option>
</select>
<input type=submit value="排 序"><br>
</td>
</form>
</tr>
<tr bgcolor=<%=titlecolor%>>
<td align=center><b>用户名</b></td>
<td align=center><b>Email</b></td>
<td align=center><b>ICQ</b></td>
<td align=center><b>OICQ</b></td>
<td align=center><b>主页</b></td>
<td align=center><b>短消息</td>
<td align=center><b>最后发贴</td>
<td align=center><b>注册时间</b></td>
<td align=center><b>等级状态</b></td>
<td align=center><b>发贴总数</b></td>
</tr>
<%
query="select username,email,icq,qq,homepage,registertime,grade,nposts,usermode from author where usermode!=0 and usermode!=7";
if(a.equals("1"))
query+=" order by nposts desc limit "+p+","+e;
else if(a.equals("2"))
query+=" order by nposts desc limit 15";
else if(a.equals("3"))
query+=" order by username limit "+p+","+e;
else if(a.equals("4"))
query+=" order by registertime desc limit "+p+","+e;
else if(a.equals("5"))
query+=" order by registertime desc limit 15";
else if(a.equals("6"))
query+=" and (status='1' or status='2') order by id limit "+p+","+e;
ArrayList userVector=(new UserFactory()).getUserFactory(query);
for(int i=0;i<userVector.size();i++) {
user=(User)userVector.get(i);
int allPostNumber=user.getAllPostNumber(),
lastPostForum=user.getLastPostForum(),
lastPostTopic=user.getLastPostTopic();
String username=user.getUserName(),
email=user.getEmail(),
icq=user.getIcq(),
qq=user.getQQ(),
homepage=user.getHomePage(),
registertime=user.getRegisterTime(),
gradeTitle=user.getGradeTitle(),
lastPostTitle=user.getLastPostTitle();
%>
<tr bgcolor=<%=forumcolortwo%>>
<td> <a href=profile.jsp?action=show&member=<%=username%>><%=username%></a></td>
<td align=center><%if(email.equals("")) out.println("没有"); else {%><a href=mailto:<%=email%>><img border=0 src=images/email.gif></a><%}%></td>
<td align=center><%if(icq.equals("")) out.println("没有"); else {%><a href="javascript:openScript('misc.jsp?action=icq&UIN=<%=icq%>',450,300)"><img src=images/icq.bmp border=0 width=16 height=16></a><%}%></td>
<td align=center><%if(qq.equals("")) out.println("没有"); else {%><a href=http://search.tencent.com/cgi-bin/friend/user_show_info?ln=<%=qq%> target=_blank><img src=images/oicq.gif alt="查看 QQ:<%=qq%> 的资料" border=0 width=16 height=16></a><%}%></td>
<td align=center><%if(homepage.equals("")) out.println("没有"); else {%><a href=<%=homepage%> target=_blank><img border=0 src=images/homepage.gif></a><%}%></td>
<td align=center><a href=javascript:openScript('messanger.jsp?action=msgsend&toname=<%=username%>',420,320)><img src=images/message.gif border=0></a></td>
<td align=center>
<%if(lastPostForum!=0) {%><a href="topic.jsp?forumID=<%=lastPostForum%>&topic=<%=lastPostTopic%>"><img border=0 src=images/openfold.gif alt="<%=lastPostTitle%>"></a><%} else out.println("没有");%>
</td>
<td align=center><%=registertime%></td>
<td align=center><a href="lookinfo.jsp?action=style" target="_blank"><%=gradeTitle%></a></td>
<td align=center><%=allPostNumber%></td>
</tr>
<%
}
%>
</table>
</td>
</tr>
</table>
<%
if(!a.equals("2") && !a.equals("5")) {
%>
<br>
<table width=<%=tablewidth%> align=center cellspacing=0 cellpadding=1 border=0 bgcolor=<%=tablebordercolor%>>
<tr>
<td>
<table cellpadding=0 cellspacing=0 border=0 width=100%>
<form name=changepages>
<tr bgcolor=<%=menubackground%>>
<td>
<font face=宋体 color=<%=fontcolormisc%>>
共<b><%=totalpage%></b>页
当前第<b><%out.print(from+"-"+to);%></b>个
第<b><%=pages%></b>页
</font>
</td>
<%
if(totalpage!=1) {
%>
<td>
<A href=memberlist.jsp?a=<%=a%>&pages=1><IMG alt=首页 border=0 src=images/first.gif width=11 height=10></A>
<A href=memberlist.jsp?a=<%=a%>&pages=<%=(pages<2)?pages:(pages-1)%>><IMG alt=上一页 border=0 src=images/previous.gif width=11 height=10></A>
<A href=memberlist.jsp?a=<%=a%>&pages=<%=(pages>totalpage-1)?totalpage:(pages+1)%>><IMG alt=下一页 border=0 src=images/next.gif width=11 height=10></A>
<A href=memberlist.jsp?a=<%=a%>&pages=<%=totalpage%>><IMG alt=末页 border=0 src=images/last.gif width=11 height=10></A>
</td>
<td align=right>
转到：
<SELECT name=pages size=1 onchange="changePages()">
<%
int pagesFrom=1,pagesTo=totalpage;
if(pages<=5 && totalpage-pages>5)
pagesTo=totalpage>=10?10:totalpage;
else if(pages>5 && totalpage-pages>5) {
pagesFrom=pages-4;
pagesTo=pages+5;
}
else if(pages>5 && totalpage-pages<=5)
pagesFrom=totalpage>=10?totalpage-9:1;
if(pagesFrom!=1)
out.println("<OPTION value='memberlist.jsp?a="+a+"&pages="+pagesFrom+"'>--more--</OPTION>");
for(int i=pagesFrom;i<=pagesTo;i++) {
if(i==pages) {
out.println("<OPTION value='memberlist.jsp?a="+a+"&pages="+i+"' selected>第"+i+"页</OPTION>");
}
else
out.println("<OPTION value='memberlist.jsp?a="+a+"&pages="+i+"'>第"+i+"页</OPTION>");
}
if(pagesTo!=totalpage)
out.println("<OPTION value='memberlist.jsp?a="+a+"&pages="+pagesTo+"'>--more--</OPTION>");
%>
</SELECT>
</td>
<%
}
%>
</tr>
</form>
</table>
</td>
</tr>
</table>
<%
}
}
%>
<br>
<%@ include file="include/foot.jsp"%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -