📄 game_result.jsp
字号:
else if(dateFlag == 2)
query1 = query1 + " and datediff(week,gamerank_date,getdate())=0 "+szSearchSQL2;
else
query1 = query1 + " "+szSearchSQL2;
query1 = query1 + " order by "+columnName+" desc,phonenum desc";
//out.println(query1);
rs=stmt.executeQuery(query1);
count = absolutepage+1;
String bgColor = null;
String szGameUserMent = null;
boolean isMine = false;
boolean isComment = false;
while(rs.next())
{
phonenum = rs.getString("phonenum");
nickname = rs.getString("nickname");
gamerank_score = rs.getInt(columnName);
szGameUserMent = rs.getString("Ment");
if("".equals(szGameUserMent) || "null".equals(szGameUserMent) || szGameUserMent == null)
{
szGameUserMent = "珐欧内膏飘啊 绝嚼聪促.\r\n累己秦林技夸";
isComment = false;
}
else
{
isComment = true;
}
if(mphone.equals(phonenum) || "01051767201".equals(phonenum))
{
isMine = true;
}
else
{
isMine = false;
}
szGameUserMent = StrConvert(szGameUserMent);
szGameUserMent = szGameUserMent.replaceAll("\n","<br>");
bgColor = "#dae6e8";
if(phonenum.equals(mphone))
bgColor = "#fff999";
// 八祸老 矫, 珐欧 备窍扁
//
if(! "".equals(szSearchWord) )
{
stmt2 = con.createStatement();
query1 ="select count(*)+1 from GT_gamerank_"+game_idx+" where";
if(dateFlag == 1)
query1 = query1 + " DATEDIFF (day,gamerank_date, getdate()) = 0 and";
if(dateFlag == 2)
query1 = query1 + " DATEDIFF (week,gamerank_date, getdate()) = 0 and";
query1 = query1 + " ("+gamerank_score+" < gamerank_score or ("+gamerank_score+" = gamerank_score and '"+phonenum+"' < phonenum ))";
//out.println(dateFlag);
rs2=stmt2.executeQuery(query1);
if(rs2.next())
{
count = rs2.getInt(1);
}
rs2.close();
stmt2.close();
}
%>
<!--￠珐欧鉴困馆汗 矫累 -->
<tr>
<td bgcolor="<%=bgColor%>">
<table width="176" cellpadding="0" cellspacing="0" border="0">
<tr>
<td width="3" height="3"></td>
<td width="48"></td>
<td width="3"></td>
<td width="3" bgcolor="#FFFFFF"></td>
<td width="119"></td>
</tr>
<tr>
<td></td>
<td height="54" bgcolor="#FFFFFF">
<!-- 捞固瘤免仿 --><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=phonenum%>" width="48" height="54" border="0">
</td>
<td></td>
<td bgcolor="#FFFFFF"></td>
<td>
<!--￠珐欧 郴侩 免仿 -->
<table width="119" cellpadding="0" cellspacing="0" border="0">
<tr>
<td width="5"></td>
<td width="90" height="18"><font color="#FF4759"><%=count%>困</font><br><a href="<%=url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+phonenum%>"><%=nickname%></a></td>
<td align="right">
<%
if(count==1) out.println("<img pictosrc='32' src='"+img_path+"images/ranking/temp_03.png' width=11 height=14>");
else if(count==2) out.println("<img pictosrc='33' src='"+img_path+"images/ranking/temp_04.png' width=11 height=14>");
else if(count==3) out.println("<img pictosrc='34' src='"+img_path+"images/ranking/temp_05.png' width=11 height=14>");
%>
</td>
<td width="5"></td>
</tr>
</table>
<table width="119" cellpadding="0" cellspacing="0" border="0">
<tr>
<td width="5"></td>
<td width="38" height="18"><font color="#FF3300"><b><% out.println(rankGrade(count)); %></b></font></td>
<td align="right"><font color="#7C8889"><%=gamerank_score%>痢</font></td>
<td width="5"></td>
</tr>
</table>
<!--¤珐欧 郴侩 免仿 -->
</td>
</tr>
<tr>
<td height="3"></td>
<td></td>
<td></td>
<td bgcolor="#FFFFFF"></td>
<td></td>
</tr>
<tr>
<td colspan="5" height="3" bgcolor="#FFFFFF"></td>
</tr>
</table>
</td>
</tr>
<!--¤珐欧鉴困馆汗 场 -->
<tr height="3">
<td bgcolor="#dae6e8"></td>
</tr>
<%
if(isComment && isMine) {
%>
<tr>
<td>
<table>
<tr height="16">
<td width="3" align="left"></td>
<td colspan="3" bgcolor="#ffffff"></td>
<td width="3" align="right"></td>
</tr>
<tr>
<td width="3" align="left"></td>
<td width="6" align="left" bgcolor="#ffffff"></td>
<td bgcolor="#ffffff">
<font color="#000000"><%=szGameUserMent%></font></td>
<td width="6" align="right" bgcolor="#ffffff"></td>
<td width="3" align="right"></td>
</tr>
<tr height="16">
<td width="3" align="left"></td>
<td colspan="3" bgcolor="#ffffff"></td>
<td width="3" align="right"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center" >
<table>
<tr height="17">
<td></td>
<td width="145" align="center" bgcolor="#f1f4f4">
<font color="#585f60"><a href="<%=url_path%>/game/GameUserMent_modify.jsp?mphone=<%=phonenum%>&game_idx=<%=game_idx%>">内膏飘 荐沥</a></font>
/
<font color="#585f60"><a href="<%=url_path%>/game/GameUserMent_delete.jsp?mphone=<%=phonenum%>&game_idx=<%=game_idx%>">内膏飘 昏力</a></font>
</td>
<td></td>
</tr>
</table>
</td>
</tr>
<%
}
else if (isMine)
{
%>
<tr>
<td align="center">
<table>
<tr height="17">
<td></td>
<td width="145" align="center" bgcolor="#f1f4f4">
<font color="#585f60"><a href="<%=url_path%>/game/GameUserMent_modify.jsp?mphone=<%=phonenum%>&game_idx=<%=game_idx%>">内膏飘 静扁</a></font>
</td>
<td></td>
</tr>
</table>
</td>
</tr>
<%
}
else if(isComment)
{
%>
<tr>
<td>
<table>
<tr height="16">
<td width="3" align="left"></td>
<td colspan="3" bgcolor="#ffffff"></td>
<td width="3" align="right"></td>
</tr>
<tr>
<td width="3" align="left"></td>
<td width="6" align="left" bgcolor="#ffffff"></td>
<td bgcolor="#ffffff">
<font color="#000000"><%=szGameUserMent%></font></td>
<td width="6" align="right" bgcolor="#ffffff"></td>
<td width="3" align="right"></td>
</tr>
<tr height="16">
<td width="3" align="left"></td>
<td colspan="3" bgcolor="#ffffff"></td>
<td width="3" align="right"></td>
</tr>
</table>
</td>
</tr>
<%
}
%>
<%
count++;
}
}
else
{
%>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<!-- 酒官鸥 矫累 -->
<td width="57" align="left" valign="top" bgcolor="#fff999">
<table width="57" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3" height="3" bgcolor="#fff999"> </td>
<td width="48" bgcolor="#fff999"> </td>
<td width="3" bgcolor="#fff999"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="54" bgcolor="#fff999"></td>
<td width="48" bgcolor="#ffffff"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>" width="48" height="54" border="0"></td>
<td width="3" bgcolor="#fff999"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="3" bgcolor="#fff999"></td>
<td width="48" bgcolor="#fff999"></td>
<td width="3" bgcolor="#fff999"></td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
</table>
</td>
<!-- 酒官鸥 场 -->
<!-- 郴侩 矫累 -->
<td bgcolor="#fff999">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5" colspan="2"></td>
</tr>
<tr>
<td width="5"></td>
<td height="15"><font color="#7c8889">霸烙阑 角青窍瘤 臼疽嚼聪促. 霸烙阑 窍脚 饶 珐欧阑 殿废秦林技夸</font></td>
</tr>
<tr>
<td height="5" colspan="2"></td>
</tr>
</table>
</td>
<!-- 郴侩 场 -->
</tr>
</table>
</td>
</tr>
<tr>
<td height="3"></td>
</tr>
<%
}
%>
</table>
</td>
</tr>
<tr>
<td height="20" bgcolor="#FEE0E4" align="center">
<!--￠捞傈/促澜 -->
<%
out.println(pagePath(pageurl, dbcount, pageNUM, pagecount));
%>
<!--¤捞傈/促澜 -->
</td>
</tr>
<!--------------------------------------------------------------------------------------------------------------
*@荐沥矫累
*@Author : 辑厘盔(2008-01-16)
*@荐沥郴侩: 八祸芒 眠啊 & 郴侩荐沥
--------------------------------------------------------------------------------------------------------------->
<tr>
<td height="8"></td>
</tr>
<!--霸烙疙 八祸 矫累-->
<tr>
<td>
<form method="post" name="form1" action="<%=url_path%>/ranking/game_result.jsp">
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<input type="hidden" name="game_idx" value="<%=game_idx%>">
<input type="hidden" name="myFlag" value="2">
<input type="hidden" name="dateFlag" value="<%=dateFlag%>">
<table width="240" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="38"></td>
<td width="44" height="21">
<table width="44" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="44" height="20" bgcolor="#ffffff" align="center">葱匙烙</td>
</tr>
</table>
</td>
<td width="72" align="right"><input height="24" width="72" type="text" name="word" size="17" defaultimemode="1" imemode="9" maxlength="20"></td>
<td width="3"></td>
<td width="40" height="14" valign="middle" align="center" bgcolor="#ff8eab"><font color="#ffffff"><a href="javascript:form1.submit()">八祸</a></font></td>
<td width="30"></td>
</tr>
</table>
</form>
</td>
</tr>
<!--霸烙疙 八祸 场-->
<!--------------------------------------------------------------------------------------------------------------
*@荐沥场
*@Author : 辑厘盔(2008-01-16)
*@荐沥郴侩: 八祸芒 眠啊 & 郴侩荐沥
--------------------------------------------------------------------------------------------------------------->
<tr>
<td height="54" align="center">
<table width="146" cellpadding="0" cellspacing="0" border="0">
<% if(vmtype.equals("b")){ %>
<tr>
<td height="18" colspan="3" align="center" bgcolor="#FF8EAB"><a href="<%=url_path%>/ranking/game_start.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#FFFFFF">捞霸烙矫累</font></a></td>
</tr>
<% }else{ %>
<tr>
<td height="18" align="center" bgcolor="#FF8EAB"><a href="<%=url_path+"/ranking/game_ranking.jsp?mphone="+mphone+"&gphone="+gphone%>"><font color="#FFFFFF">郴珐欧焊扁</font></a></td>
<td width="2"></td>
<td align="center" bgcolor="#FF8EAB"><a href="<%=url_path%>/ranking/game_start.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#FFFFFF">捞霸烙矫累</font></a></td>
</tr>
<% } %>
<tr>
<td colspan="3" height="2"></td>
</tr>
<tr>
<td height="18" colspan="3" align="center" bgcolor="#FF8EAB"><a href="<%=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&linkFlag=0"%>"><font color="#FFFFFF">霸烙皋牢啊扁</font></a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="10"></td>
</tr>
<tr>
<td bgcolor="#BBC7C8">
<%
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" cellpadding="0" cellspacing="0" border="0">
<tr>
<td height="20" width="10"></td>
<td bgcolor="#DAE6E8"><a href="<%=step1%>">权</a>><a href="<%=step2%>">霸烙皋牢</a>>霸烙搬苞</td>
<td width="10"></td>
</tr>
</table>
<%@ include file="../newbottom.jsp"%>
</td>
</tr>
</table>
<%
if(rs != null) rs.close();
if(pstmt != null) pstmt.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(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){}
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -