📄 ranking_mycaferanking.jsp
字号:
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
</tr>
</table>
</td>
</tr>
-->
<table width="240" border="0" cellspacing="0" cellpadding="0">
<!--鸥捞撇 矫累-->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" height="2" bgcolor="#ffaec5"></td>
</tr>
<tr>
<td width="8" height="14" bgcolor="#ff4759"></td>
<td height="15" bgcolor="#ff4759"><font color="#ffffff">霸烙珐欧</font></td>
</tr>
<tr>
<td colspan="2" height="3" bgcolor="#ffaec5"></td>
</tr>
<tr>
<td colspan="2" height="1" bgcolor="#ff4759"></td>
</tr>
</table>
</td>
</tr>
<!--鸥捞撇 场-->
<!--膏飘 郴侩 矫累-->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="7"></td>
</tr>
<tr>
<td></td>
<td width="190" align="center">
<font color="#9d9d9d">霸烙阑 急琶窍矫搁<br>
秦寸 霸烙狼 珐欧阑 焊角荐 乐绢夸~<br>
∝ 300困鼻 观篮 焊咯瘤瘤 臼嚼聪促.</font>
</td>
<td></td>
</tr>
<tr>
<td colspan="3" height="7"></td>
</tr>
</table>
</td>
</tr>
<!--膏飘 郴侩 矫累-->
<!--珐欧急琶 焊扁 矫累-->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="17">
<td width="25"></td>
<td width="4"></td>
<td align="center">
<select name="game_idx">
<%
gameArrIndex = 0;
while(gameArrIndex < gameNameCnt)
{
if(game_idx==gameIdx[gameArrIndex])
out.println("<option selected value='"+gameIdx[gameArrIndex]+"' >"+gameNameList[gameArrIndex]+"</option>");
else
out.println("<option value='"+gameIdx[gameArrIndex]+"'>"+gameNameList[gameArrIndex]+"</option>");
gameArrIndex++;
}
%>
</select>
</td>
<td width="35" bgcolor="#ff82ab"><div align="center"><a href="javascript:form.submit()"><font color="#ffffff">焊扁</font></a></div></td>
<td width="25"></td>
</tr>
</table>
</td>
</tr>
<!--珐欧急琶 焊扁 场-->
<tr>
<td height="8"></td>
</tr>
<!--膏飘 郴侩 矫累-->
<tr>
<td>
<table width="240" bgcolor="#ff9dac" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="7"></td>
</tr>
<tr>
<td colspan="3" height="7"></td>
</tr>
<!--痢急扼牢 矫累-->
<tr height="2">
<td colspan="3" width="150" background="http://entaz.mugeta.com/client/FTP_Working_Folder//web/images/ranking/tab_02.png"></td>
</tr>
<!--痢急扼牢 场-->
</table>
</td>
</tr>
<!--膏飘 郴侩 矫累-->
<tr>
<td height="13"></td>
</tr>
<!-- 坷疵/穿利 & 惑困 / 磊脚 官 矫累-->
<tr>
<%
String datePath = url_path+"/ranking/ranking_cafe.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType="+rankType+"&pageType="+pageType+"&dateFlag=";
%>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="22"></td>
<% if(searchRange != 1){%>
<td width="55" align="center"><a href="<%=RangeLink1%>"><img src="http://entaz.mugeta.com/client/FTP_Working_Folder//web/images/ranking/ico_02.png"></a></td>
<% }else{ %>
<td width="55" align="center"><img src="http://entaz.mugeta.com/client/FTP_Working_Folder//web/images/ranking/ico_02.png"></td>
<% } %>
<% if(searchRange != 2){%>
<td width="55" align="center"><a href="<%=RangeLink2%>"><img src="http://entaz.mugeta.com/client/FTP_Working_Folder//web/images/ranking/ico_06.png"></td>
<% }else{ %>
<td width="55" align="center"><img src="http://entaz.mugeta.com/client/FTP_Working_Folder//web/images/ranking/ico_06.png"></td>
<% } %>
<td></td>
</tr>
<tr>
<td height="1" bgcolor="#ff788f"></td>
<td width="55" align="center"></td>
<td width="55" align="center" bgcolor="#ff788f"></td>
<td bgcolor="#ff788f"></td>
</tr>
<tr>
<td height="17"></td>
<td width="40" align="center" colspan="2">
<font color="#f60000" size="3"><a href="<%=url_path%>/ranking/ranking_cafe.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&rankType=<%=rankType%>&pageType=<%=pageType%>&dateFlag=<%=dateFlag%>">
惑困</a></font>
<font color="#ff788f" size="3"> | </font>
<font color="#ff788f" size="3"><b>磊脚</b></font>
</td>
<td></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<!-- 坷疵/穿利 & 惑困 / 磊脚 官 矫累-->
<%
//霸矫拱 肮荐 备窍扁
query1="select count(*) from GT_cafe";
if(stmt != null) stmt.close();
if(pageset != null) pageset.close();
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;
}
//page========================
pagesql = "select c.phonenum ,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+" s.cafe_idx from GT_cafe as s right join "+boardname+" as g on convert(int,s.phonenum)=convert(int,g.phonenum)order by g.gamerank_score desc,"+dateColName+" desc, s.cafe_date desc) order by d.gamerank_score desc ";
if(pstmt != null) pstmt.close();
if(rs != null) rs.close();
pstmt = con.prepareStatement(pagesql);
rs = pstmt.executeQuery();
String page_cafe_phonenum = null;
int i = 1;
while(rs.next()){
page_cafe_phonenum = rs.getString(1);
if(page_cafe_phonenum == mphone){
if(i> pagesize && i % pagesize == 0){
pageNUM = i/pagesize;
break;
}else if(i> pagesize && i % pagesize != 0){
pageNUM = i/pagesize+1;
break;
}else if (i<= pagesize){
pageNUM = 1;
break;
}
}
i++;
}
//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);
cafe_phonenum = rs.getString(5);
if(cafe_phonenum == mphone){
pageNUM = 1;
}
%>
<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">
<%
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));
%>
</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>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -