📄 point.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="conn.jsp"%>
<%
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);
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE>TD {
FONT-SIZE: 9pt; LINE-HEIGHT: 140%
}
BODY {
FONT-SIZE: 9pt; LINE-HEIGHT: 140%
}
A:link {
COLOR: #000000; TEXT-DECORATION: none
}
A:visited {
COLOR: #000000; TEXT-DECORATION: none
}
A:active {
COLOR: #ff0000; TEXT-DECORATION: none
}
A:hover {
COLOR: #ff0000; TEXT-DECORATION: underline
}
.header {
font-family: Tahoma, Verdana; font-size: 9pt; color: ffffff; background-color: rgb(128,128,192)
}
.category{
font-family: Tahoma, Verdana; font-size: 9pt; color: #000000; background-color: ffffff
}
</STYLE>
<title>排行榜</title>
</head>
<body text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0>
<%
if ((pages==1)||(pages==0)) {
%>
<table style="BORDER-COLLAPSE: collapse" borderColor=#808080 align=center cellPadding=1 width=80% border=1>
<tr><td align="center" class="header" colspan=3>排行榜</td></tr>
<tr align=center class="category"><td width=180>版面名称</td><td>用户名称</td><td>点击次数</td></tr>
<%String sql="select * from scott.sport,scott.bbsuser where sport.infouser=bbsuser.userid order by sport.times desc";
i=0;
ResultSet rs=stmt.executeQuery(sql);
while(i<10 && rs.next()){
%>
<tr><td align=left>
<a href=sportlist.jsp?title="<%=rs.getString("title")%>" onclick=javascript:showdetail(<%=rs.getString("sportid")%>);><%=rs.getString("title")%></a>
</td><td align=center><a href=userlist.jsp?id=<%=rs.getString("userid")%> title="查看<%=rs.getString("username")%>的个人信息"><%=rs.getString("username")%></a></td>
<td align=center><%=rs.getString("times")%></td>
<%i++;
}
rs.close();
%>
</table>
<%} %>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -