📄 ranking_game.jsp
字号:
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(2);
if(page_cafe_phonenum.equals(mphone)){
if(i> pagesize && i % pagesize == 0){
pageNUM2 = i/pagesize;
break;
}else if(i> pagesize && i % pagesize != 0){
pageNUM2 = i/pagesize+1;
break;
}else if (i<= pagesize){
pageNUM2 = 1;
break;
}
}
i++;
}
String sqlsql = "select gamerank_idx, phonenum,nickname,"+columnName+ " from "+boardname+" where " +
"gamerank_idx not in(select Top 1 gamerank_idx from "+boardname+")";
szCount ="select count(gamerank_idx) from("+sqlsql+")countNum";
pstmt = con.prepareStatement(szCount);
pageset = pstmt.executeQuery();
if(pageset.next()){
dbcount = pageset.getInt(1); // 臂 醚 肮荐
pageset.close();
}
if(dbcount%pagesize == 0)
pagecount = dbcount/(pagesize); // 醚 其捞瘤荐 备窍扁
else
pagecount = dbcount/(pagesize)+1; // 醚 其捞瘤荐 备窍扁
if(request.getParameter("pageNUM")!=null)
{
pageNUM=Integer.parseInt(request.getParameter("pageNUM"));//瘤沥等 其捞瘤 焊咯林扁
absolutepage=(pageNUM-1)*pagesize+1;
}
}
%>
<html>
<head>
<link href="http://entaz.mugeta.com/client/mugeta_v2_test/web/user/mobile.css" rel="stylesheet" type="text/css">
<title>ranking_game</title>
</head>
<body>
<form name="form" method="post" action="<%=url_path%>/ranking/ranking_game.jsp">
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<input type="hidden" name="own_field" value="<%=own_field%>">
<!--剧侥
<tr>
<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="right">
<select name="game_idx">
<option value = "0" >辆钦珐欧</option>
<%
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></td>
<td width="150" align="center"><font color="#ffffff">葛电 霸烙 扁废阑</font></td>
<td></td>
</tr>
<tr>
<td></td>
<td width="150" align="center"><font color="#ffffff">醚钦茄 烹钦 珐欧涝聪促.</font></td>
<td></td>
</tr>
<tr>
<td colspan="3" height="7"></td>
</tr>
<!--痢急扼牢 矫累-->
<tr height="2">
<td colspan="3" width="150" background="<%=img_path %>/images/game/tab_02.png"></td>
</tr>
<!--痢急扼牢 场-->
</table>
</td>
</tr>
<!--膏飘 郴侩 矫累-->
<tr>
<td height="13"></td>
</tr>
<!-- 坷疵/穿利 & 惑困 / 磊脚 官 矫累-->
<tr>
<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="<%=img_path %>/images/game/ico_02.png"></a></td>
<% }else{ %>
<td width="55" align="center"><img src="<%=img_path %>/images/game/ico_02.png"></td>
<% } %>
<% if(searchRange != 3){%>
<td width="55" align="center"><a href="<%=RangeLink3%>"><img src="<%=img_path %>/images/game/ico_06.png"></a></td>
<% }else{ %>
<td width="55" align="center"><img src="<%=img_path %>/images/game/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 colspan="2" align="center">
<%
if (own_field==1)
{
out.println("<a href='"+url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange="+searchRange+"&own_field=0'><font color='#f60000' size='3'><b>惑困</b></font></a>"
+" <font color='#ff788f' size='3'> | </font> " +
"<font color='#ff788f' size='3'>磊脚</font>");
}
else
{
out.println("<font color='#ff788f' size='3'>惑困</font>"
+" <font color='#ff788f' size='3'> | </font> " +
"<a href='"+url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange="+searchRange+"&own_field=1&pageNUM="+pageNUM2+"'><font color='#f60000' size='3'><b>磊脚</b></font></a>");
}
%>
</td>
<td></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<!-- 坷疵/穿利 & 惑困 / 磊脚 官 矫累-->
<tr>
<td height="5"></td>
</tr>
<tr>
<td>
<!--捞傈/促澜 傅农 冠胶 矫累-->
<table width="240" bgcolor="#fee0e4" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td bgcolor="#FFe0e4" align="center">
<%
pageurl=url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&searchRange="+searchRange+"&own_field="+own_field;
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="<%=img_path %>/images/game/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="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>&gphone=0<%=topPhone%>" width="48" height="54" border="0"></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="<%=img_path %>/images/game/temp_05.png"></td>
</tr>
<tr>
<td align="left" height="20" ><a href='<%=url_path+"/mypage/my_confirm.jsp?"+"mphone="+mphone+"&gphone=0"+topPhone %>'><%=topNickname %></a></td>
</tr>
<tr>
<td align="left" height="20"><font color="#b4b4b4"><%=topScore %>痢</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">
<% if (topIntro == null ){
out.println("钎矫且 郴侩捞 绝嚼聪促");
}else{ out.println(topIntro);}
%></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="<%=img_path %>/images/game/tab_02.png"></td>
</tr>
<tr>
<td colspan="5" height="7" bgcolor="#ff9dac"></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -