📄 ranking_gong.jsp
字号:
}
//1困 备窍扁
//query1 = "select * from (select Top 1 "+dateColName+",phonenum,nickname,ranker_idx from GT_ranker where "+dateColName+">0 order by "+dateColName+" desc, ranker_idx desc union all ";
//query1 = query1 + "select Top "+pagesize+" "+dateColName+",phonenum,nickname,ranker_idx from GT_ranker where "+dateColName+">0 and ranker_idx not in(select Top "+absolutepage+" ranker_idx from GT_ranker where "+dateColName+">0 order by "+dateColName+" desc, ranker_idx desc) order by "+dateColName+" desc, ranker_idx desc)tempTable";
//1困 备窍扁
query1 = "select * from (select * from(select Top 1 "+dateColName+",phonenum,nickname,ranker_idx from GT_ranker order by "+dateColName+" desc, ranker_idx desc)tempTable1 union all ";
//促澜 其捞瘤 备窍扁
query1 = query1 + "select * from(select Top "+pagesize+" "+dateColName+",phonenum,nickname,ranker_idx from GT_ranker where ranker_idx not in(select Top "+absolutepage+" ranker_idx from GT_ranker order by "+dateColName+" desc, ranker_idx desc) order by "+dateColName+" desc, ranker_idx desc)tempTable2)tempTable";
//out.println(query1);
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
//1殿 免仿
if(rs.next())
{
calumCnt = "傍皑"+rs.getInt(1)+"痢";
phonenum = rs.getString(2);
nikename = rs.getString(3);
query2 = "select intro from GT_user_info where phonenum='"+phonenum+"'";
pstmt2 = con.prepareStatement(query2);
rs2 = pstmt2.executeQuery();
rs2.next();
intro = rs2.getString(1);
pstmt2.close();
rs2.close();
%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f">
<%
String pageurl=url_path+"/ranking/ranking_gong.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType="+rankType+"&dateFlag="+dateFlag;
out.println(pagePath(pageurl, dbcount, pageNUM, pagecount));
%>
</font></td>
</tr>
<tr>
<td height="3"></td>
</tr>
<tr>
<td height="5" bgcolor="#ff9dac"></td>
</tr>
<tr>
<td width="176" height="2" background="<%=img_path%>images/ranking/tab_02.png"></td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="38"></td>
<td width="54" bgcolor="#ffe0e4" align="center"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=phonenum%>&gphone=<%=phonenum%>" border="0"></td>
<td width="7"></td>
<td width="77">
<table border="0" cellpadding="0" cellspacing="0">
<tr><td><font color="#ff4759">1困</font> <img pictosrc="32" src="<%=img_path%>images/ranking/temp_03.png"></td></tr>
<tr><td><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=phonenum%>"><font color="#000000"><%=nikename%></font></a></td></tr>
<tr><td><font color="#7c8889"><%=calumCnt%></font></td></tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="5"></td>
</tr>
<!-- 痢急 冠胶 持绢具 且镑 矫累 -->
<tr>
<td>
<table width="176" border="0" cellpadding="0" cellspacing="0">
<tr height="2">
<td width="5"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="164" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="4"></td>
</tr>
<tr height="6">
<td width="5"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="164"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="4"></td>
</tr>
<tr>
<td width="5"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="164" align="center"><%=intro%></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="4"></td>
</tr>
<tr height="6">
<td width="5"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="164"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="4"></td>
</tr>
<tr height="2">
<td width="6"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="164" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="2" background="<%=img_path%>images/ranking/tab_03.png"></td>
<td width="4"></td>
</tr>
</table>
</td>
</tr>
<!-- 痢急 冠胶 持绢具 且镑 场 -->
<tr>
<td height="4"></td>
</tr>
<tr>
<td width="176" height="2" background="<%=img_path%>images/ranking/tab_02.png"></td>
</tr>
<tr>
<td height="5" bgcolor="#ff9dac"></td>
</tr>
<tr>
<td height="4"></td>
</tr>
<!-- 1锅掳 府胶飘 矫累 -->
<%
rankCnt = absolutepage+1;
while(rs.next())
{
String bgColor = "#dae6e8";
calumCnt = "傍皑"+rs.getInt(1)+"痢";
phonenum = rs.getString(2);
nikename = rs.getString(3);
if(phonenum.equals(mphone))
bgColor = "#fff999";
%>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<!-- 酒官鸥 矫累 -->
<td width="57" align="left" valign="top" bgcolor="<%=bgColor%>">
<table width="57" height="63" 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%>&gphone=<%=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"><%=rankCnt%>困</font>
</td>
<td width="18">
<% if(rankCnt==2) out.println("<img pictosrc='33' src='"+img_path+"images/ranking/temp_04.png' width=11 height=14>");
else if(rankCnt==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="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=phonenum%>"><font color="#000000"><%=nikename%></font></a></td>
</tr>
<tr>
<td width="5"></td>
<td width="114" colspan="2" height="15"><font color="#7c8889"><%=calumCnt%></font></td>
</tr>
</table>
</td>
<!-- 郴侩 场 -->
</tr>
</table>
</td>
</tr>
<tr>
<td height="3"></td>
</tr>
<%
rankCnt++;
//茄拌 鉴困甫 逞栏搁 风橇甫 狐柳促.
if(maxRank < rankCnt)
break;
}
%>
<!-- 1锅掳 府胶飘 场 -->
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f">
<%
out.println(pagePath(pageurl, dbcount, pageNUM, pagecount));
%>
</font></td>
</tr>
<%
}
else
{
%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f">钎矫且 郴侩捞 绝嚼聪促.</font></td>
</tr>
<%
}
}
catch (Exception e)
{
out.println(e);
}
finally
{
if(pstmt2 != null) try{ pstmt2.close(); }catch(Exception se){}
if(rs2 != null) try{ rs2.close(); }catch(Exception se){}
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 se){}
if(stmt != null) try{ stmt.close(); }catch(Exception se){}
if(con != null) try{ con.close(); }catch(Exception se){}
}
%>
<tr>
<td height="19"></td>
</tr>
<tr>
<td align="center"><b><a href="<%=goMyLink%>"><font color="#ff4759">牢拱珐欧</font></a><font color="#ff4759"> | </font><a href="<%=goCafeLink%>"><font color="#ff4759">墨其珐欧</font></a></b></td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td align="center"><b><a href="<%=goKnowLink%>"><font color="#ff4759">瘤侥珐欧</font></a><font color="#ff4759"> | </font><a href="<%=goGongLink%>"><font color="#ff4759">傍皑珐欧</font></a><font color="#ff4759"> | </font><a href="<%=goGameLink%>"><font color="#ff4759">霸烙珐欧</font></a></b></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr align="center">
<td>
<table width="176" border="0" cellpadding="0" cellspacing="0">
<tr height="16">
<td width="47"></td>
<td width="85" bgcolor="#FF8EAB" align="center"><a href="<%=link2%>"><font color="#FFFFFF">鸥款珐欧权栏肺</font></a></td>
<td width="47"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="11"></td>
</tr>
</table>
<!-- 窍窜 匙厚霸捞记 -->
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone;//权
String step2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;//鸥款珐欧
%>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<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>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -