game_ranking.jsp

用手机浏览的一个类似于聊天室 博克 homepage 等 对这方面有 兴趣的朋友 有所帮助的

			play_game[6]=rs.getInt("play_7");
			play_game[7]=rs.getInt("play_8");
			play_game[8]=rs.getInt("play_9");
			play_game[9]=rs.getInt("play_10");

			for(loop=0;loop<10;loop++)
			{
				if(play_game[loop] > 0)
					dbcount++;
			}

			if(request.getParameter("pageNUM")!=null)
			{
				pageNUM=Integer.parseInt(request.getParameter("pageNUM"));//瘤沥等 其捞瘤 焊咯林扁
			}

			if(dbcount%pagesize == 0)
				pagecount = dbcount/(pagesize); // 醚 其捞瘤荐 备窍扁
			else
				pagecount = dbcount/(pagesize)+1; // 醚 其捞瘤荐 备窍扁

			int limit = 0;

			if(pageNUM == 1)
			{
				if(dbcount > pagesize)
				{
					limit = 5;
				}
				else
				{
					limit = dbcount;
				}
			}
			else
			{
				limit = dbcount;
			}

			for(loop=((pageNUM-1)*pagesize);loop<limit;loop++)
			{
				query2 = "select game_title from GT_game where game_idx = "+play_game[loop];
				rs2=stmt2.executeQuery(query2);
				rs2.next();
				game_title = rs2.getString(1);
				rs2.close();

				query2 = "select gamerank_score from GT_gamerank_"+play_game[loop]+" where phonenum = '"+mphone+"'";
				rs2=stmt2.executeQuery(query2);

				if(rs2.next())
					score = rs2.getInt(1);
				else
					score = 0;
				rs2.close();


				query2 = "select count(*)+1 from GT_gamerank_"+play_game[loop]+" where "+score+" < gamerank_score or ("+score+" = gamerank_score and '"+mphone+"' < phonenum )";

				rs2=stmt2.executeQuery(query2);

				if(rs2.next())
				{
					rnaking = rs2.getInt(1);
					grade = rankGrade(rnaking);
				}
				else
				{
					grade = "[檬焊C]";
				}
	%>
  <tr>
     <td>
          <table width="176" border="0" cellspacing="0" cellpadding="0">
             <tr>  
		<td width="5"></td>
  	    <td height="25" align="left"><font color="#558c95"><b><a href="<%=url_path+"/ranking/game_gamename.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+play_game[loop]%>"><%=game_title%></a></b></font></td>
		<td width="37" height="25" align="center"><font color="#ff3300"><%=grade%></font></td>
  	    <td width="50" height="25" align="right"><font color="#999999">	
			<a href="<%=url_path%>/ranking/game_result.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&game_idx=<%=play_game[loop]%>">珐欧⒑</a>
		</font></td>
		<td width="5"></td>
      	   </tr>
          </table>
     </td>
  </tr>

<!--痢急 矫累-->
  <tr>
     <td>
          <table width="176" border="0" cellspacing="0" cellpadding="0">
             <tr>  
  	    <td width="3" height="1"></td>
              <td background="<%=img_path%>images/game/dot_01.png" width="168" height="1"></td>
  	    <td width="5" height="1"></td>
      	   </tr>
          </table>
     </td>
  </tr>
<%
				rs2.close();
			}
		}

		/*------------------------------------------------------------------------------------------------------
		+	目敲 府胶飘 免仿
		-------------------------------------------------------------------------------------------------------*/
		else
		{
			if(rs.next())
			{
				dbcount = 1;

				game_idx = rs.getInt(2);
				game_title = rs.getString(3);
				score = rs.getInt(4);


				query2 = "select count(*)+1 from GT_gamecouple where "+score+" < (gamescore_man+gamescore_woman) or ("+score+" = (gamescore_man+gamescore_woman) and '"+mphone+"' < phonenum_man )";


				rs2=stmt2.executeQuery(query2);

				if(rs2.next())
				{
					rnaking = rs2.getInt(1);
					grade = rankGrade(rnaking);
				}
				else
				{
					grade = "[檬焊C]";
				}
%>
  <tr>
     <td>
          <table width="176" border="0" cellspacing="0" cellpadding="0">
             <tr>  
		<td width="5"></td>
  	    <td height="25" align="left"><font color="#558c95"><b><a href="<%=url_path+"/ranking/game_gamename.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&gamePlayType=1"%>"><%=game_title%></a></b></font></td>
		<td width="37" height="25" align="center"><font color="#ff3300"><%=grade%></font></td>
  	    <td width="50" height="25" align="right"><font color="#999999">
			<a href="<%=url_path%>/ranking/game_result_couple.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&game_idx=<%=game_idx%>">珐欧⒑</a>
		</font></td>
		<td width="5"></td>
      	   </tr>
          </table>
     </td>
  </tr>

<!--痢急 矫累-->
  <tr>
     <td>
          <table width="176" border="0" cellspacing="0" cellpadding="0">
             <tr>  
  	    <td width="3" height="1"></td>
              <td background="<%=img_path%>images/game/dot_01.png" width="168" height="1"></td>
  	    <td width="5" height="1"></td>
      	   </tr>
          </table>
     </td>
  </tr>
<%
				rs2.close();
			}
		}


		if(dbcount <= 0)
		{
%>
  <tr>
     <td align="center" height="30">
          <b>柳青茄 霸烙捞 绝嚼聪促.</b>
     </td>
  </tr>
<%
		}

		if(rs != null)  rs.close(); 
		if(pstmt != null)  pstmt.close(); 
		if(stmt != null)  stmt.close(); 
		if(rs2 != null)  rs2.close(); 
		if(stmt2 != null)  stmt2.close(); 
		if(con != null)  con.close(); 
	}
	catch(Exception e)
	{
		out.println(e);
	}
	finally
	{
		if(rs != null) try{ rs.close(); }catch(Exception se){}
		if(pstmt != null) try{ pstmt.close(); }catch(Exception se){}
		if(stmt != null) try{ stmt.close(); }catch(Exception se){}
		if(rs2 != null) try{ rs2.close(); }catch(Exception se){}
		if(stmt2 != null) try{ stmt2.close(); }catch(Exception se){}
		if(con != null) try{ con.close(); }catch(Exception se){}
	}
%>
	<tr height="19">
		<td bgcolor="#e5ecff" align="center" >
		<% 													
			String pageurl = url_path+"/ranking/game_ranking.jsp?mphone="+mphone+"&gphone="+gphone+"&manFlag="+manFlag;
			out.println(pagePath(pageurl, dbcount, pageNUM, pagecount));
		%>
		</td>
	</tr>

	<tr>
		<td height="8"></td>
	</tr>


	<tr>
		<td>
			<table width="176" border="0" cellspacing="0" cellpadding="0">
				<tr height="17">
					<td width="36"></td>
					<td width="104" bgcolor="#9fb7f8" align="center"><a href="<%=url_path+"/ranking/game_level_view.jsp?mphone="+mphone+"&gphone="+gphone+"&manFlag="+manFlag%>"><font color="#ffffff">饭骇殿鞭傈眉焊扁</font></a></td>
					<td width="36"></td>
				</tr>
			</table>
		</td>
	</tr>

	<tr>
		<td height="3"></td>
	</tr>


	<tr>
		<td>
			<table width="176" border="0" cellspacing="0" cellpadding="0">
				<tr height="17">
					<td width="36"></td>
					<td width="104" bgcolor="#9fb7f8" align="center"><a href="<%=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&linkFlag=0"%>"><font color="#ffffff">霸烙皋牢啊扁</font></a></td>
					<td width="36"></td>
				</tr>
			</table>
		</td>
	</tr>

	<tr>
		<td height="15"></td>
	</tr>


</table>
<!-- 窍窜 匙厚霸捞记 -->
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone;//权
String step2=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&linkFlag=0";//霸烙皋牢
%>

<table width="176" border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td width="10" bgcolor="#BBC7C8"></td>
        <td bgcolor="#e5ecff">
			<table width="100%" border="0" cellspacing="3" cellpadding="0">
				<tr height="19">
					<td><a href="<%=step1%>">权</a>&gt;<a href="<%=step2%>">霸烙皋牢</a>&gt;霸烙珐欧</td>
				</tr>
			</table>
		</td>
        <td width="10" bgcolor="#BBC7C8"></td>
	</tr>
</table>

<%@ include file="../newbottom.jsp"%>	

</body>

</html>