📄 gamecoupleselect.jsp.svn-base
字号:
int score = pageRs.getInt(2);
String phonenum = pageRs.getString(3);
try{
/*------------------------------------------------------------------------------------------------
* 促弗 荤恩捞 急琶沁阑 版快
-------------------------------------------------------------------------------------------------*/
query1="select idx from GT_GameCoupleLog where phonenum ='"+phonenum+"' ";
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
if(rs.next())
{
idx = rs.getInt("idx");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* 富巢扁扁 魄窜
-------------------------------------------------------------------------------------------------*/
query1="select idx from GT_GameGuestBookLog where guest_phone=? and phonenum =? ";
pstmt = con.prepareStatement(query1);
pstmt.setLong(1,Long.parseLong(phonenum));
pstmt.setLong(2,mmphone);
rs = pstmt.executeQuery();
if(rs.next())
{
nidx = rs.getInt("idx");
}
rs.close();
pstmt.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(con != null) try{ con.close(); }catch(Exception se){}
}
%>
<!-- 咯归 矫累 -->
<tr>
<td height="3"></td>
</tr>
<!-- 咯归 场 -->
<!--搬苞 冠胶1 矫累-->
<tr>
<td>
<table width="176" bgcolor="#dae6e8" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="54" align="top">
<!--酒官鸥 矫累-->
<table width="54" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="3"></td>
</tr>
<tr>
<td width="3"></td>
<td align="top">
<img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>&gphone=<%=phonenum%>" width="48" height="54" border="0"></td>
<td width="3"></td>
</tr>
<tr>
<td colspan="3" height="3"></td>
</tr>
</table>
<!--酒官鸥 场-->
</td>
<td bgcolor="#ffffff" width="3"></td>
<td width="119">
<!--郴侩 矫累-->
<table width="119" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="5"></td>
</tr>
<tr>
<td width="7"></td>
<td align="left" height="17">
<%if(idx!=1)
{
%>
<a href=" <%=url_path%>/ranking/GameAlert.jsp?mphone=<%=mphone %>&gphone=<%=gphone %>&type=2&name=<%=java.net.URLEncoder.encode(name)%>">
<%
}
else if(idx == 1)
{
if(nidx==-1){
%>
<a href="<%=url_path%>/ranking/GameCouple.jsp?mphone=<%=mphone %>&gphone=<%=phonenum %>&name= <%=java.net.URLEncoder.encode(name)%>&game_idx=<%=game_idx%>&gamePlayType=<%=gamePlayType%>&sex=<%=sex%>&nickname=<%=java.net.URLEncoder.encode(nickname)%>&game_title=<%=java.net.URLEncoder.encode(game_title)%>">
<%
}
else if(nidx!=-1)
{
%>
<a href="<%=url_path%>/ranking/game_start.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=phonenum%>&gamePlayType=<%=gamePlayType%>">
<%
}
%>
<%
}
%>
<font color="#616667"><%=name %></font></a></td>
<td width="7"></td>
</tr>
<tr>
<td width="7"></td>
<td align="left" height="17"><font color="#616667"><%=score %></font></td>
<td width="7"></td>
</tr>
<tr>
<td colspan="3" height="5"></td>
</tr>
</table>
<!-- 郴侩 场 -->
</td>
</tr>
</table>
</td>
</tr>
<!-- 搬苞 冠胶1 场 -->
<%
if(pageRs.isLast())
{ //盖 付瘤阜 饭内靛 老版快
break;
}
else
{
pageRs.next();
}
}
pageRs.close();
pstmt.close();
%>
<!-- 咯归 矫累 -->
<tr>
<td height="3"></td>
</tr>
<!-- 咯归 场 -->
<tr>
<td>
<!--其捞瘤 傅农 矫累-->
<table width="176" bgcolor="#e5ecff" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="16" colspan="6" bgcolor="#FEF4C2" valign="bottom" align="center">
<%//其捞瘤 备泅何
int limit = 5 ; //其捞瘤 府胶飘 俺荐 瘤沥
int temp =(pageNUM-1) % limit ; //矫累 其捞瘤 备窍扁
int startPage = pageNUM - temp;
%>
<%// [捞傈] 傅农 眠啊窍扁
if ((startPage-limit)>0){ %>
<a href="<%=pageurl%>&pageNUM=<%=startPage-1%>"><font color="#DB1A00">捞傈</font></a>
<%}
//其捞瘤 锅龋 唱凯窍扁
if(isNoPage == 0)
{
for(int i=startPage ; i<(startPage+limit);i++)
{
if( i == pageNUM)
{%>
<font color="#DB1A00"><b><%=i%></b></font>
<% }
else
{ %>
<a href="<%=pageurl%>&pageNUM=<%=i%>"><font color="#DB1A00"><%=i%></font></a>
<% }
if(i >= pagecount) break;
}
}
else
out.println("钎矫 且 郴侩捞 绝嚼聪促.");
//[促澜] 傅农 眠啊
if((startPage+limit)<=pagecount){ %>
<a href="<%=pageurl%>&pageNUM=<%=(startPage+limit)%>"><font color="#DB1A00">促澜</font></a>
<%}
%>
</td>
</tr>
</table>
<!--其捞瘤 傅农 场-->
</td>
</tr>
<!--咯归 矫累-->
<tr>
<td height="5"></td>
</tr>
<!--咯归 场-->
<!--葱匙烙 八祸 矫累-->
<tr>
<td>
<form name="form1" action="<%=url_path%>/ranking/GameCoupleSelect.jsp" method="post">
<input type="hidden" name="mphone" value="<%= mphone%>"/>
<input type="hidden" name="gphone" value="<%= gphone%>"/>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td width="36" height="17" align="right">葱匙烙</td>
<td width="4"></td>
<td width="78" align="center"><input type="text" name="name1" size="13" maxlength="13"></td>
<td width="2"></td>
<td width="35" bgcolor="#a8bfff"><p align="center"><a href="javascript:form1.submit()"><font color="#ffffff">八祸</font></a></p></td>
<td></td>
</tr>
</table>
</form>
</td>
</tr>
<!--葱匙烙 八祸 场-->
<!--咯归 矫累-->
<tr>
<td height="8"></td>
</tr>
<!--咯归 场-->
<!--滚瓢 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td width="75" height="16" bgcolor="#a8bfff" align="center"><a href="<%=url_path%>/ranking/game_result_couple.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&game_idx=<%=game_idx %>"><font color="#ffffff">目敲珐欧</font></a></td>
<td></td>
</tr>
<tr>
<td colspan="3" height="2"></td>
</tr>
<tr>
<td></td>
<td width="75" height="16" bgcolor="#a8bfff" align="center"><a href="<%=url_path%>/ranking/game.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#ffffff">霸烙皋牢啊扁</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!--滚瓢 场-->
<!--咯归 矫累-->
<tr>
<td height="11"></td>
</tr>
<!--咯归 场-->
<!--窍窜 版肺钎矫 矫累-->
<tr>
<td>
<table width="176" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td width="156" bgcolor="#DAE6E8" height="19"> <a href="<%=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone%>"> 权</a>> <a href="<%=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&linkFlag=0"%>">霸烙皋牢</a>>目敲霸烙</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--窍窜 版肺钎矫 场-->
</table>
<!--窍窜 版肺钎矫 矫累-->
<%@ include file="../newbottom.jsp"%>
<!--窍窜 版肺钎矫 场-->
</body>
</html>
<%
}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(con != null) try{ con.close(); }catch(Exception se){}
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -