📄 play_gameranking.jsp

📁 用手机浏览的一个类似于聊天室博克 homepage 等对这方面有兴趣的朋友有所帮助的
💻 JSP
📖 第 1 页 / 共 3 页
字号:
上一页 1 23
			<td width="85" bgcolor="#C789FF" align="center" valign="middle">
				<a href="<%=url_path%>/ranking/start_game.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#FFFFFF">霸烙促矫窍扁</font></a>
			</td>
			<td width="2"></td>
			<td width="85" bgcolor="#C789FF" align="center" valign="middle">
				<a href="<%=url_path%>/ranking/game.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#FFFFFF">霸烙权栏肺</font></a>
			</td>
			<td width="34"></td>
		</tr>

		<tr height="10">
			<td width="34"></td>
			<td width="85"></td>
			<td width="2"></td>
			<td width="85"></td>
			<td width="34"></td>
		</tr>
	</table>

	<!--// today's ranking //-->
	<!--// #1. title //-->
	<table width="240" border="0" cellspacing="0" cellpadding="0">
		<tr height="15">
			<td width="5"></td>
			<td width="235" align="left" valign="middle">
				<font color="#ECAAFF">≮</font>&nbsp;<font color="#9819E9">坷疵狼 珐欧</font>
			</td>
		</tr>
	</table>

	<!--// #2. separator line(dotted) //-->
	<table width="240" border="0" cellspacing="0" cellpadding="0">
		<tr height="2">
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
			<td width="2"></td><td width="2" bgcolor="#E8DCFF"></td><td width="2"></td><td width="2" bgcolor="#E8DCFF"></td>
		</tr>
	</table>


<%
try
{
	query1 = "select count(gamerank_idx) from "+boardname;
	pageset = stmt.executeQuery(query1);

	if(pageset.next()){
		dbcount = pageset.getInt(1);  // 臂 醚 肮荐
		pageset.close();
		if(dbcount > 100) dbcount = 100;	//弥措 100俺父 备茄促.
	}

	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;
	}

	String str = "select top 100 gamerank_idx, "+boardname+".phonenum, GT_user_info.nickname, gamerank_today ";
	str = str + " from GT_user_info,"+boardname+" where GT_user_info.phonenum="+boardname+".phonenum order by gamerank_today desc, gamerank_date desc";

	rs = stmt.executeQuery(str);	
	if(!rs.next()) // 蔼捞 绝阑锭
	{
		isNoPage = 1;
		pagesize=0;
	}
	else         // 蔼捞 乐阑锭	//rs.absolute(absolutepage);
	{				
		for(int s=0; s<absolutepage-1; s++)
			rs.next();
		rankCnt = absolutepage;
	}

	int count = 0 ; //其捞瘤 墨款磐 函荐
	while(count < pagesize)
	{ 
		gamerank_idx=rs.getInt(1);			//霸烙id
		phonenum=rs.getString(2);
		nickname=rs.getString(3);
		gamerank_score=rs.getInt(4);
		
		goUserHome = url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+phonenum;	//蜡历狼 葛喉肺弊肺 捞悼
%>




	<table width="240" border="0" cellspacing="0" cellpadding="0">
		<tr height="3">
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="48" bgcolor="#DAE6E8"></td>
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="3"></td>
			<td width="183" bgcolor="#DAE6E8"></td>
		</tr>

		<tr height="54">
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="48">
				<img src="<%=ava_path%>display_thumb.jsp?mphone=<%=phonenum%>" width="48" height="54" border="0">
			</td>
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="3"></td>
			<td width="183" bgcolor="#DAE6E8">
				<table width="183" border="0" cellspacing="0" cellpadding="0">
					<tr height="12">
						<td width="8"></td>
						<td width="80"></td>
						<td width="87"></td>
						<td width="8"></td>
					</tr>

					<tr height="15">
						<td width="8"></td>
						<td width="80" align="left" valign="middle">
							<font color="#000000"><%=rankCnt%>困</font>
						</td>
						<td width="87" align="right" valign="middle">
							<font color="#000000"><%=gamerank_score%>痢</font>
						</td>
						<td width="8"></td>
					</tr>

					<tr height="15">
						<td width="8"></td>
						<td width="80" align="left" valign="middle">
							<font color="#000000"><a href="<%=goUserHome%>"><%=nickname%></a></font>
						</td>
						<td width="87"></td>
						<td width="8"></td>
					</tr>
					
					<tr height="12">
						<td width="8"></td>
						<td width="80"></td>
						<td width="87"></td>
						<td width="8"></td>
					</tr>
				</table>
			</td>
		</tr>

		<tr height="3">
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="48" bgcolor="#DAE6E8"></td>
			<td width="3" bgcolor="#DAE6E8"></td>
			<td width="3"></td>
			<td width="183" bgcolor="#DAE6E8"></td>
		</tr>

		<tr height="3">
			<td width="3"></td>
			<td width="48"></td>
			<td width="3"></td>
			<td width="3"></td>
			<td width="183"></td>
		</tr>
	</table>


<%
		if(rs.isLast())
		{ //盖 付瘤阜 饭内靛 老版快
			 break;
		}
		else
		{
			rs.next();
			rankCnt++;
		}
		count++;
	}//end_while
	
	if(rs != null) rs.close();
	if(stmt != null) stmt.close();
	if(con != null) con.close();
}
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 es){}
	if(stmt != null)    try{stmt.close();}catch(Exception es){}
	if(con != null)		try{con.close();}catch(Exception es){}
}
%>



	<table width="240" border="0" cellspacing="0" cellpadding="0">
		<tr>
			<td width="240" height="19" bgcolor="#EEE2FF" align="center">
<%//其捞瘤 备泅何
	int limit = 4 ;   //其捞瘤 府胶飘 俺荐 瘤沥	
	int temp =(pageNUM-1) % limit ;	//矫累 其捞瘤 备窍扁
	int startPage = pageNUM - temp;
	String pageurl = url_path+"/ranking/play_gameranking.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx;
%>

<%// [捞傈] 傅农 眠啊窍扁
   if ((startPage-limit)>0){ %>
	<a href="<%=pageurl%>&pageNUM=<%=startPage-1%>"><font color="#DB1A00">捞傈</font></a>&nbsp;
   <%}
   //其捞瘤 锅龋 唱凯窍扁
   if(isNoPage == 0)
   {
	 for(int i=startPage ; i<(startPage+limit);i++)
     {
	   if( i == pageNUM)
	   {%>
			<font color="#DB1A00"><b><%=i%></b></font>&nbsp;
	<% }
	   else
	   { %>
			<a href="<%=pageurl%>&pageNUM=<%=i%>"><font color="#DB1A00"><%=i%></font></a>&nbsp;
    <% }
	   if(i >= pagecount) break;
	 }
   }
   else
	  out.println("钎矫 且 郴侩捞 绝嚼聪促.");
   //[促澜] 傅农 眠啊
   if((startPage+limit)<=pagecount){ %>
	<a href="<%=pageurl%>&pageNUM=<%=(startPage+limit)%>"><font color="#DB1A00">促澜</font></a>&nbsp;
   <%}
%>
			</td>
		</tr>
	</table>

	<!--// #4. button to links another page //-->
	<table width="240" border="0" cellspacing="0" cellpadding="0">
		<tr height="10">
			<td width="70"></td>
			<td width="100"></td>
			<td width="70"></td>
		</tr>
		<tr height="15">
			<td width="70"></td>
			<td width="100" bgcolor="#C789FF" align="center" valign="middle">
				<a href="<%=url_path%>/ranking/ranking_main.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#FFFFFF">鸥款珐欧栏肺</font></a>
			</td>
			<td width="70"></td>
		</tr>
		<tr height="10">
			<td width="70"></td>
			<td width="100"></td>
			<td width="70"></td>
		</tr>
	</table>

<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+mphone;//权
String step2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;//鸥款珐欧
%>
<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>
					<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>
上一页 1 23
💿 文件大小 8175 K
👤 上传用户 iamguest88
📂 所属分类通讯/手机编程
🏷️ 相关标签

#homepage #手机 #方面
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -