📄 ranking_result.jsp
字号:
sql = sql + " (SELECT COUNT(*)+1 FROM "+boardname;
sql = sql + " WHERE (a."+columnName+"<"+columnName+" or (a."+columnName+"="+columnName+" and a.phonenum<phonenum ))";
sql = sql + whereStr;
sql = sql + ")";
sql = sql + " FROM "+boardname+" a";
sql = sql + " WHERE gamerank_idx not in ";
sql = sql + "(SELECT TOP " + ((gotoPage - 1) * pagesize) + " gamerank_idx FROM "+boardname+" WHERE phonenum<>'1234' "+whereStr;
sql = sql + " ORDER BY "+columnName+" desc ,phonenum desc) and phonenum<>'1234' "+whereStr+" order by "+columnName+" desc ,phonenum desc";
rs = stmt.executeQuery(sql);
}
else
{
sql = "SELECT TOP " + pagesize + " gamerank_idx,phonenum,nickname,"+columnName;
sql = sql + ",Rank=";
sql = sql + " (SELECT COUNT(*)+1 FROM "+boardname;
sql = sql + " WHERE (a."+columnName+"<"+columnName+" or (a."+columnName+"="+columnName+" and a.phonenum<phonenum ))";
sql = sql + whereStr;
sql = sql + ")";
sql = sql + " FROM "+boardname+" a";
sql = sql + " WHERE gamerank_idx not in ";
sql = sql + "(SELECT TOP " + ((gotoPage - 1) * pagesize) + " gamerank_idx FROM "+boardname+" WHERE phonenum<>'"+topPhone+"' "+whereStr;
sql = sql + " ORDER BY "+columnName+" desc ,phonenum desc) and phonenum<>'"+topPhone+"' "+whereStr+" order by "+columnName+" desc ,phonenum desc";
rs = stmt.executeQuery(sql);
}
int count = 0 ; //其捞瘤 墨款磐 函荐
if (own_field==0){ //惑困
if (topHave==0 && recordCount==0){ //饭内靛啊 绝绰版快
%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f">钎矫且 郴侩捞 绝嚼聪促.</font></td>
</tr>
<tr>
<td height="3"></td>
</tr>
<%
}else{//饭内靛 唱坷搁 等促.
while(rs.next()){
gamerank_idx=rs.getInt(1); //霸烙id
phonenum=rs.getString(2);
nickname=rs.getString(3);
gamerank_score=rs.getInt(4);
Rank=rs.getInt(5);
goUserHome = url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+phonenum; //蜡历狼 葛喉肺弊肺 捞悼
if (mphone.equals(phonenum)) bgcolor="#fff999";
else bgcolor="#dae6e8";
%>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<!-- 酒官鸥 矫累 -->
<td width="57" align="left" valign="top" bgcolor="<%=bgcolor%>">
<table width="57" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3" height="3" bgcolor="<%=bgcolor%>"> </td>
<td width="48" bgcolor="<%=bgcolor%>"> </td>
<td width="3" bgcolor="<%=bgcolor%>"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="54" bgcolor="<%=bgcolor%>"></td>
<td width="48" bgcolor="#ffffff"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=phonenum%>" width="48" height="54" border="0"></td>
<td width="3" bgcolor="<%=bgcolor%>"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="3" bgcolor="<%=bgcolor%>"></td>
<td width="48" bgcolor="<%=bgcolor%>"></td>
<td width="3" bgcolor="<%=bgcolor%>"></td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
</table>
</td>
<!-- 酒官鸥 场 -->
<!-- 郴侩 矫累 -->
<td bgcolor="<%=bgcolor%>">
<table border="0" cellspacing="0" cellpadding="0" valign="top">
<tr>
<td width="5"></td>
<td width="96">
<font color="#ff4759"><%=Rank%>困</font>
</td>
<td width="18">
<%
if(Rank==1) out.println("<img pictosrc='32' src='"+img_path+"images/ranking/temp_03.png' width=11 height=14>");
else if(Rank==2) out.println("<img pictosrc='33' src='"+img_path+"images/ranking/temp_04.png' width=11 height=14>");
else if(Rank==3) out.println("<img pictosrc='34' src='"+img_path+"images/ranking/temp_05.png' width=11 height=14>"); %>
</td>
</tr>
<tr>
<td width="5"></td>
<td width="114" colspan="2" height="15"><a href="<%=goUserHome%>"><font color="#000000"><%=nickname%></font></a></td>
</tr>
<tr>
<td width="5"></td>
<td width="114" colspan="2" height="15"><font color="#7c8889"><%=gamerank_score%>痢</font>
</td>
</tr>
</table>
</td>
<!-- 郴侩 场 -->
</tr>
</table>
</td>
</tr>
<tr>
<td height="3"></td>
</tr>
<%
}//while
}
}else{ //磊脚
if (topHave==0 && recordCount==0){ //饭内靛啊 绝绰版快
%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f">钎矫且 郴侩捞 绝嚼聪促.</font></td>
</tr>
<tr>
<td height="3"></td>
</tr>
<%
}else{ //饭内靛啊 乐绰版快
if(member_join.equals("NO") || member_rank.equals("NO") ){ //雀盔 啊涝捞 救登绢 乐绰 版快唱 雀盔 啊涝篮 登绢 乐栏唱 霸烙阑 窍瘤 臼篮 版快
%>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<!-- 酒官鸥 矫累 -->
<td width="57" align="left" valign="top" bgcolor="#fff999">
<table width="57" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3" height="3" bgcolor="#fff999"> </td>
<td width="48" bgcolor="#fff999"> </td>
<td width="3" bgcolor="#fff999"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="54" bgcolor="#fff999"></td>
<td width="48" bgcolor="#ffffff"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>" width="48" height="54" border="0"></td>
<td width="3" bgcolor="#fff999"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="3" bgcolor="#fff999"></td>
<td width="48" bgcolor="#fff999"></td>
<td width="3" bgcolor="#fff999"></td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
</table>
</td>
<!-- 酒官鸥 场 -->
<!-- 郴侩 矫累 -->
<td bgcolor="#fff999">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5" colspan="2"></td>
</tr>
<tr>
<td width="5"></td>
<td height="15"><font color="#7c8889">霸烙阑 角青窍瘤 臼疽嚼聪促. 霸烙阑 窍脚 饶 珐欧阑 殿废秦林技夸</font></td>
</tr>
<tr>
<td height="5" colspan="2"></td>
</tr>
</table>
</td>
<!-- 郴侩 场 -->
</tr>
</table>
</td>
</tr>
<tr>
<td height="3"></td>
</tr>
<%
}else{ while(rs.next()){
gamerank_idx=rs.getInt(1); //霸烙id
phonenum=rs.getString(2);
nickname=rs.getString(3);
gamerank_score=rs.getInt(4);
Rank=rs.getInt(5);
goUserHome = url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+phonenum; //蜡历狼 葛喉肺弊肺 捞悼
if (mphone.equals(phonenum)) bgcolor="#fff999";
else bgcolor="#dae6e8";
%>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<!-- 酒官鸥 矫累 -->
<td width="57" align="left" valign="top" bgcolor="<%=bgcolor%>">
<table width="57" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3" height="3" bgcolor="<%=bgcolor%>"> </td>
<td width="48" bgcolor="<%=bgcolor%>"> </td>
<td width="3" bgcolor="<%=bgcolor%>"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="54" bgcolor="<%=bgcolor%>"></td>
<td width="48" bgcolor="#ffffff"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=phonenum%>" width="48" height="54" border="0"></td>
<td width="3" bgcolor="<%=bgcolor%>"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="3" bgcolor="<%=bgcolor%>"></td>
<td width="48" bgcolor="<%=bgcolor%>"></td>
<td width="3" bgcolor="<%=bgcolor%>"></td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
</table>
</td>
<!-- 酒官鸥 场 -->
<!-- 郴侩 矫累 -->
<td bgcolor="<%=bgcolor%>">
<table border="0" cellspacing="0" cellpadding="0" valign="top">
<tr>
<td width="5"></td>
<td width="96">
<font color="#ff4759"><%=Rank%>困</font>
</td>
<td width="18">
<%
if(Rank==1) out.println("<img pictosrc='32' src='"+img_path+"images/ranking/temp_03.png' width=11 height=14>");
else if(Rank==2) out.println("<img pictosrc='33' src='"+img_path+"images/ranking/temp_04.png' width=11 height=14>");
else if(Rank==3) out.println("<img pictosrc='34' src='"+img_path+"images/ranking/temp_05.png' width=11 height=14>"); %>
</td>
</tr>
<tr>
<td width="5"></td>
<td width="114" colspan="2" height="15"><a href="<%=goUserHome%>"><font color="#000000"><%=nickname%></font></a></td>
</tr>
<tr>
<td width="5"></td>
<td width="114" colspan="2" height="15"><font color="#7c8889"><%=gamerank_score%>痢</font>
</td>
</tr>
</table>
</td>
<!-- 郴侩 场 -->
</tr>
</table>
</td>
</tr>
<tr>
<td height="3"></td>
</tr>
<%
}//while
}
}
}
%>
<% if (!(own_field==1 && (member_join.equals("NO") || member_rank.equals("NO") )) && (recordCount!=0)){%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f"><%=pagePath(pageurl, recordCount, gotoPage, pagecount)%></font></td>
</tr>
<%}%>
<tr>
<td height="7"></td>
</tr>
<tr align="center">
<td>
<table width="176" border="0" cellpadding="0" cellspacing="0">
<tr height="17">
<td width="2"></td>
<td width="85" bgcolor="#FF8EAB" align="center"><a href='<%=url_path%>/ranking/start_game.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>'><font color="#FFFFFF">促矫窍扁</font></a></td>
<td width="2"></td>
<td width="85" bgcolor="#FF8EAB" align="center"><a href='<%=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+mphone%>'><font color="#FFFFFF">霸烙权栏肺</font></a></td>
<td width="2"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="11"></td>
</tr>
</table>
<!-- 窍窜 匙厚霸捞记 -->
<table width="176" border="0" cellspacing="0" cellpadding="0">
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+mphone;//权
String step2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;//鸥款珐欧
%>
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td bgcolor="#DAE6E8">
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr height="15">
<td><a href="<%=step1%>">权</a>><a href="<%=step2%>">鸥款珐欧</a>>霸烙搬苞</td>
</tr>
</table>
</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
<%@ include file="../newbottom.jsp"%>
</body>
</html>
<%
}
catch (Exception e)
{
out.println(e);
}
finally
{
if(rs != null) try{rs.close();}catch(Exception se){}
if(pageset != null) try{pageset.close();}catch(Exception se){}
if(pstmt != null) try{pstmt.close();}catch(Exception es){}
if(stmt != null) try{stmt.close();}catch(Exception es){}
if(con != null) try{con.close();}catch(Exception es){}
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -