📄 ranking_cafe.jsp
字号:
stmt = con.createStatement();
pageset = stmt.executeQuery(query1);
if(pageset.next())
{
dbcount = pageset.getInt(1); //臂 醚 肮荐
if(dbcount > maxRank)
dbcount = maxRank;
if(dbcount > 1)
dbcount = dbcount-1; //1殿阑 猾促
pageset.close();
}
if(dbcount%pagesize == 0 && dbcount > 0)
pagecount = dbcount/pagesize; // 醚 其捞瘤荐 备窍扁
else
pagecount = dbcount/pagesize+1; // 醚 其捞瘤荐 备窍扁
if(request.getParameter("pageNUM")!=null)
{
pageNUM=Integer.parseInt(request.getParameter("pageNUM"));//瘤沥等 其捞瘤 焊咯林扁
if(pageNUM > pagecount)//乐绰 其捞瘤 焊促 奴 蔼捞 甸绢吭阑 锭 贸府
pageNUM = pagecount;
absolutepage=(pageNUM-1)*pagesize+1;//1殿 锭巩俊 1阑 歹窃
}
else
{
absolutepage = 1;
}
//1困 备窍扁
query1 = "select * from (select * from(select Top 1 c.cafe_idx, c.cafe_name, c.cafe_intro,c.phonenum, c.cafe_date , d.gamerank_score from GT_cafe as c Right join "+boardname+" as d on convert(int,c.phonenum)=convert(int,d.phonenum) order by d.gamerank_score desc,"+dateColName+" desc, cafe_date desc)tempTable1 union all ";
//促澜 其捞瘤 备窍扁
query1 = query1 + "select * from(select Top "+pagesize+" c.cafe_idx, c.cafe_name, c.cafe_intro, c.phonenum, c.cafe_date , d.gamerank_score from GT_cafe as c Right join "+boardname+" as d on convert(int,c.phonenum)=convert(int,d.phonenum) where c.cafe_idx not in(select Top "+absolutepage+" cafe_idx from GT_cafe order by gamerank_score desc,"+dateColName+" desc, cafe_date desc) order by gamerank_score desc,"+dateColName+" desc, cafe_date desc)tempTable2)tempTable";
if(pstmt != null) pstmt.close();
if(rs != null) rs.close();
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
//1殿 免仿
if(rs.next())
{
cafe_idx = rs.getInt(1);
cafe_name = rs.getString(2);
cafe_intro = rs.getString(3);
gamerank_score = rs.getInt(6);
if(rankType == 1)
calumCnt = "雀盔"+rs.getInt(4)+"疙";
else
calumCnt = "霸矫"+rs.getInt(4)+"扒";
cafe_phonenum = rs.getString(5);
%>
<tr>
<td height="5"></td>
</tr>
<tr>
<td>
<!--捞傈/促澜 傅农 冠胶 矫累 fen ye@@@@@@@@@@@@@@@ -->
<table width="240" bgcolor="#fee0e4" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f">
<%
String pageurl=url_path+"/ranking/ranking_cafe.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType="+rankType+"&pageType="+pageType+"&dateFlag="+dateFlag;
out.println(pagePath(pageurl, dbcount, pageNUM, pagecount));
%>
</font>
</td>
</tr>
</table>
<!--捞傈/促澜 傅农 冠胶 场-->
</td>
</tr>
<!--咯归 矫累-->
<tr>
<td height="3"></td>
</tr>
<!--咯归 场-->
<!--珐欧 1困 冠胶 矫累-->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<!--痢急扼牢 矫累-->
<tr>
<td colspan="5" height="7" bgcolor="#ff9dac"></td>
</tr>
<tr height="2">
<td colspan="5" width="150" background="http://entaz.mugeta.com/client/FTP_Working_Folder//web/images/ranking/tab_02.png"></td>
</tr>
<tr>
<td colspan="5" height="5"></td>
</tr>
<!--痢急扼牢 场-->
<tr>
<td></td>
<td width="54" align="top">
<!--酒官鸥 矫累-->
<table width="54" bgcolor="#fee0e4" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="3"></td>
</tr>
<tr>
<td width="3"></td>
<td width="48" align="top"><img src="http://entaz.mugeta.com/client/FTP_Working_Folder/STEP6/temp/img/tit_03.png" width="48" height="54"></td>
<td width="3"></td>
</tr>
<tr>
<td colspan="3" height="3"></td>
</tr>
</table>
<!--酒官鸥 场-->
</td>
<td width="15"> </td>
<td width="30">
<!--珐欧鉴困 矫累-->
<table width="40" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="40" align="left" height="20" ><font color="#ff4877">1困</font> <img src="http://entaz.mugeta.com/client/FTP_Working_Folder/STEP6/web/game/img/temp_05.png"></td>
</tr>
<tr>
<td align="left" height="20" ><a href="<%=url_path%>/cafe/cafe_master.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&cafe_idx=<%=cafe_idx%>">
<%=cafe_name%></a></td>
</tr>
<tr>
<td align="left" height="20"><font color="#b4b4b4"><%=gamerank_score%>痢</font></td>
</tr>
</table>
<!--珐欧鉴困 场-->
</td>
<td></td>
</tr>
<tr>
<td colspan="5" height="5"></td>
</tr>
<tr>
<td colspan="5">
<!--郴侩冠胶 矫累-->
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="10"></td>
<td>
<table width="220" bgcolor="#c2c2c5" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" height="1"></td>
</tr>
<tr>
<td width="1"></td>
<td width="15" bgcolor="#ffffff"></td>
<td height="5" bgcolor="#ffffff"></td>
<td width="15" bgcolor="#ffffff"></td>
<td width="1"></td>
</tr>
<tr>
<td width="1"></td>
<td width="15" bgcolor="#ffffff"></td>
<td width="188" bgcolor="#ffffff"><%=cafe_intro%></td>
<td width="15" bgcolor="#ffffff"></td>
<td width="1"></td>
</tr>
<tr>
<td width="1"></td>
<td width="15" bgcolor="#ffffff"></td>
<td height="5" bgcolor="#ffffff"></td>
<td width="15" bgcolor="#ffffff"></td>
<td width="1"></td>
</tr>
<tr>
<td colspan="5" height="1"></td>
</tr>
</table>
</td>
<td width="10"></td>
</tr>
</table>
<!--郴侩冠胶 场-->
</td>
</tr>
<!--痢急扼牢 矫累-->
<tr>
<td colspan="5" height="5"></td>
</tr>
<tr height="2">
<td colspan="5" width="150" background="http://entaz.mugeta.com/client/FTP_Working_Folder//web/images/ranking/tab_02.png"></td>
</tr>
<tr>
<td colspan="5" height="7" bgcolor="#ff9dac"></td>
</tr>
<!--痢急扼牢 场-->
</table>
</td>
</tr>
<!--珐欧 1困 冠胶 场-->
<!--咯归 矫累-->
<tr>
<td height="5"></td>
</tr>
<!--咯归 场-->
<!--珐欧2困 冠胶 矫累-->
<%
rankCnt = absolutepage+1;
while(rs.next())
{
cafe_idx = rs.getInt(1);
cafe_name = rs.getString(2);
cafe_intro = rs.getString(3);
gamerank_score = rs.getInt(6);
if(rankType == 1)
calumCnt = "雀盔"+rs.getInt(4)+"疙";
else
calumCnt = "霸矫"+rs.getInt(4)+"扒";
cafe_phonenum = rs.getString(5);
String bgColor = "#dae6e8";
cnt = 0;
while(mycafeCnt > cnt)
{
if(mycafe_idx[cnt] == cafe_idx)
{
bgColor = "#fff999";
break;
}
cnt++;
}
%>
<tr>
<td>
<table width="240" bgcolor="#dae6e8" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="54" align="top" bgcolor="<%=bgColor%>">
<!--酒官鸥 矫累-->
<table width="54" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=bgColor%>">
<tr>
<td colspan="3" height="3" bgcolor="<%=bgColor%>"></td>
</tr>
<tr>
<td width="3" bgcolor="<%=bgColor%>"></td>
<td align="top" bgcolor="<%=bgColor%>"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=cafe_phonenum%>&gphone=<%=cafe_phonenum%>" width="48" height="54"></td>
<td width="3" bgcolor="<%=bgColor%>"></td>
</tr>
<tr>
<td colspan="3" height="3" bgcolor="<%=bgColor%>"></td>
</tr>
</table>
<!--酒官鸥 场-->
</td>
<td bgcolor="<%=bgColor%>" width="3"></td>
<td width="183" bgcolor="<%=bgColor%>">
<!--珐欧郴侩 矫累-->
<table width="183" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=bgColor%>">
<tr>
<td colspan="4" height="5"></td>
</tr>
<tr>
<td width="7"></td>
<td align="left">
<font color="#ff4877"><%=rankCnt%>困</font>
<a href="<%=url_path%>/cafe/cafe_master.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&cafe_idx=<%=cafe_idx%>"><font color="#000000"><%=cafe_name%>
</a>
</td>
<td width="10" align="right" >
<% if(rankCnt==2) out.println("<img pictosrc='33' src='http://entaz.mugeta.com/client/FTP_Working_Folder/STEP6/web/game/img/temp_06.png' width=11 height=14> ");
else if(rankCnt==3) out.println("<img pictosrc='34' src='http://entaz.mugeta.com/client/FTP_Working_Folder/STEP6/web/game/img/temp_07.png' width=11 height=14> "); %>
</td>
<td width="7"></td>
</tr>
<tr>
<td colspan="4" height="3"></td>
</tr>
<tr>
<td width="7"></td>
<td align="left">
<font color="#b4b4b4" size="3"><%=gamerank_score%>痢</font></td>
<td width="10" align="right" ><img src=""></td>
<td width="7"></td>
</tr>
</table>
<!--珐欧郴侩 场-->
</td>
</tr>
</table>
</td>
</tr>
<!--珐欧2困 冠胶 场-->
<!--咯归 矫累-->
<tr>
<td height="3"></td>
</tr>
<!--咯归 场-->
<%
rankCnt++;
//茄拌 鉴困甫 逞栏搁 风橇甫 狐柳促.
if(maxRank < rankCnt)
break;
}
%>
<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(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){}
}
%>
<%
if(pageType == 0)
{
%>
<tr>
<td height="17"></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="4"></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>
<%
if(pageType == 0)
{
%>
<table width="240" border="0" cellpadding="0" cellspacing="0">
<tr height="17">
<td width="72"></td>
<td width="96" bgcolor="#FF8EAB" align="center"><font color="#FFFFFF">
<a href="<%=link2%>">鸥款珐欧权栏肺</a>
</font></td>
<td width="72"></td>
</tr>
</table>
<%
}
else
{
%>
<table width="240" border="0" cellpadding="0" cellspacing="0">
<tr height="17">
<td width="29"></td>
<td width="90" bgcolor="#FF8EAB" align="center"><font color="#FFFFFF">
<a href="<%=link2%>">鸥款墨其皋牢</a></font>
</td>
<td width="2"></td>
<td width="90" bgcolor="#FF8EAB" align="center"><font color="#FFFFFF">
<a href="<%=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone%>">鸥款珐欧权栏肺</a></font>
</td>
<td width="29"></td>
</tr>
</table>
<%
}
%>
</td>
</tr>
<tr>
<td height="11"></td>
</tr>
</table>
<!-- 窍窜 匙厚霸捞记 -->
<table width="240" 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="19">
<td>
<%
if(pageType == 0)
{
%>
<a href="<%=url_path%>/main.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>">权</a> >
<a href="<%=url_path%>/ranking/ranking_main.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>">鸥款珐欧</a> > 墨其珐欧
<%
}
else
{
%>
<a href="<%=url_path%>/main.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>">权</a> >
<a href="<%=url_path%>/cafe/cafe_town_main.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>">鸥款墨其</a> > 牢扁墨其
<%
}
%>
</td>
</tr>
</table>
</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
<%@ include file="../newbottom.jsp"%>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -