📄 down.jsp
字号:
<html>
<head>
<title>排行榜</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="bbs.css">
</head>
<body bgcolor="#ff9900" leftMargin=0 topMargin=0>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="OPDB" scope="page" class="database.OPDB" />
<%
OPDB.connection();
Connection conn = OPDB.getConn();
String sql = "select username,experience,userlevel,usertype from t_bbs_user where rownum<=10 order by experience desc";
ResultSet rs = OPDB.select(conn,sql);
int id = 0;
%>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 width=100>
<TR>
<TD><IMG height=33 src="images/fen_1.gif" width=370></TD>
</TR>
<TR bgColor=#feee94>
<TD height=13><IMG height=1 src="images/spacer.gif"
width=1></TD>
</TR>
<TR align=middle bgColor=#ff9900 vAlign=center>
<TD height=20>
<TABLE bgColor=#ff4f00 border=0 cellPadding=0 cellSpacing=1 width="100%">
<%
while (rs.next()) {
id++;
String userName = OPDB.GBK(rs.getString("username"));
int experience = rs.getInt("experience");
String userlevel = OPDB.GBK(rs.getString("userlevel"));
String userType = rs.getString("usertype");
if (userType.equals("Y")) {
userType = "会员";
}
else {
userType = "非会员";
}
out.print("<TR bgColor=#ffffff align='center'>");
out.print("<TD width='10%'><img src='images/"+id+".gif'></td>");
out.print("<td width='20%'>"+userName+"</td>");
out.print("<td width='20%'>"+userlevel+"</td>");
out.print("<td width='30%'>"+experience+"</td>");
out.print("<td width='20%'>"+userType+"</td>");
out.print("</tr>");
}
rs.close();
OPDB.Close();
%>
</TABLE>
</TD>
</TR>
</TABLE>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -