?? point.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="incdb.jsp"%>
<jsp:useBean id="user" class="test.bbsuser" scope="page"/>
<jsp:useBean id="board" class="test.bbsboard" scope="page"/>
<%
String tempSTR,strSQL;// '執行的SQL語句
java.sql.ResultSet sqlRst;
java.sql.ResultSet sqlRst2;
int i,pages;
String errmsg=request.getParameter("errmsg");
tempSTR=request.getParameter("pages");
if (tempSTR==null){
pages=0;
}
else
{
pages=java.lang.Integer.parseInt(tempSTR);
}
//'
//'
//'pages=1 個人積分排行榜
//'pages=2 論壇點擊率
//'pages=3 論壇主題數
//'
//'
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 4</title>
<link rel="stylesheet" type="text/css" href="bbs03.css">
</head>
<body>
<%
if ((pages==1)||(pages==0)) {
%>
<div align="center">
<center>
<table border="1" width="90%" bordercolorlight="#000000" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" bgcolor="#000080" bordercolorlight="#000000" bordercolordark="#FFFFFF" colspan="6">
<p align="center"><font color="#FFFFFF"><b>個人積分排行榜</b></font></td>
</tr>
<tr>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>排名</b></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>姓名</b></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>積分</b></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>排名</b></td>
<td width="16%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>姓名</b></td>
<td width="16%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>積分</b></td>
</tr>
<%
i=1;
sqlRst=user.listUser(3);
while ((sqlRst.next())&&(i<=20)){
%>
<tr>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=i%></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=sqlRst.getString("username")%></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=sqlRst.getString("userclass")%></td>
<%
i++;
if (!sqlRst.next()){
continue;
}
%>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=i%></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=sqlRst.getString("username")%></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=sqlRst.getString("userclass")%></td>
</tr>
<%
i++;
} //' while ((strRst.next())&&(i<=20))
sqlRst.close();
%>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" width="90%">
<tr>
<td width="600" align="center">
<p align="right"> <a href="myinfo.jsp" target="_self">查看個人積分</a>
<a href="about.jsp" target="_self">關于積分</a></p>
</td>
</tr>
</table>
</center>
</div>
<p></p>
<%} //'end if%>
<!------------------------------------------------------------------>
<%
if ((pages==2)||(pages==0)) {
//'pages=2 論壇點擊率
%>
<div align="center">
<center>
<table border="1" width="90%" bordercolorlight="#000000" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" bgcolor="#000080" bordercolorlight="#000000" bordercolordark="#FFFFFF" colspan="6">
<p align="center"><b><font color="#FFFFFF">論壇點擊率排行榜</font></b></td>
</tr>
<tr>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>排名</b></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>版塊</b></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>點擊率</b></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>排名</b></td>
<td width="16%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>版塊</b></td>
<td width="16%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>點擊率</b></td>
</tr>
<%
i=1;
sqlRst=board.listBoard (2);
while ((i<=10)&&(sqlRst.next())) {
%>
<tr>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=i%></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<a href="bbslist.jsp?boardid=<%=sqlRst.getString("boardid")%>" target="rtop"><%=sqlRst.getString("boardname")%></a></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=sqlRst.getString("boardhits")%></td>
<!---------------------->
<%
if (!sqlRst.next()){
continue;
}
i++;
%>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=i%></td>
<td width="16%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<a href="bbslist.jsp?boardid=<%=sqlRst.getString("boardid")%>" target="rtop"><%=sqlRst.getString("boardname")%></a></td>
<td width="16%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=sqlRst.getString("boardhits")%></td>
</tr>
<%
i++;
} //end while
sqlRst.close();
%>
</table>
</center>
</div>
<p></p>
<%} //'end if%>
<!------------------------------------------------------------------>
<%
if ((pages==3)||(pages==0)) {
//'pages=3 論壇主題數
%>
<div align="center">
<center>
<table border="1" width="90%" bordercolorlight="#000000" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" bgcolor="#000080" bordercolorlight="#000000" bordercolordark="#FFFFFF" colspan="6">
<p align="center"><b><font color="#FFFFFF">熱門論壇排行榜</font></b></td>
</tr>
<tr>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>排名</b></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>版塊</b></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>主題數</b></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>排名</b></td>
<td width="16%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>版塊</b></td>
<td width="16%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<b>主題數</b></td>
</tr>
<%
i=1;
sqlRst=board.listBoard (3);
while ((i<=10)&&(sqlRst.next())) {
%>
<tr>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=i%></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<a href="bbslist.jsp?boardid=<%=sqlRst.getString("boardid")%>" target="rtop"><%=sqlRst.getString("boardname")%></a></td>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=sqlRst.getString("boardtopics")%></td>
<%//''''''''''''''
if (!sqlRst.next()){
continue;
}
i++;
%>
<td width="17%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=i%></td>
<td width="16%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<a href="bbslist.jsp?boardid=<%=sqlRst.getString("boardid")%>" target="rtop"><%=sqlRst.getString("boardname")%></a></td>
<td width="16%" bordercolorlight="#000000" bordercolordark="#FFFFFF" align="center">
<%=sqlRst.getString("boardtopics")%></td>
</tr>
<%
i++;
} //'end while
%>
</table>
</center>
</div>
<p></p>
<%} //'end if%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -