📄 gamematch.jsp
字号:
<!--------------------------------------------------------------------------------------------------------------
*@霸烙皋牢
*@Author : zhou peng(2008-05-23)
--------------------------------------------------------------------------------------------------------------->
<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.Vector, java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.*' contentType='text/html;charset=euc-kr'%>
<%@ include file="../imgpath.jsp"%>
<%@ include file="../common_func.jsp"%>
<%!
public static String isNull(String str)
{
if (str == null)
return "";
else
return str;
}
%>
<%
/**
*
*
* @ version : 1.0.0
* @ author : zhou peng ( pengzhou@isoftstone.com )
* @ last modified : 2008-05-23
*/
/*------------------------------------------------------------------------------------------------------
+ 扁夯 颇扼固磐
-------------------------------------------------------------------------------------------------------*/
String mphone= request.getParameter("mphone");
//if(mphone==null){
// mphone="1051697";
//}
String gphone= request.getParameter("gphone");
//mphone = "13269404";
//String gphone = "1051697";
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
String szCount = null;
String strNickname = null;
String gScore = null;
String myScore = null;
String boardname = null;
String gametitle = null;
String game_text = null;
String game_img_path = null;
String YourStrname = "";
int gpoint = 0;
int game_idx = 0; //霸烙 绊蜡锅龋
//0724
if(!isNull(request.getParameter("game_idx")).equals("") )//茫扁肺 甸绢柯 版快促.
{
game_idx = Integer.parseInt(request.getParameter("game_idx"));
}
else {game_idx = 1;}
boardname = "GT_gamerank_"+game_idx; //柳楼
String gamePlayType = null;
if(request.getParameter("gamePlayType")!=null) gamePlayType=request.getParameter("gamePlayType"); else gamePlayType="0";
/*------------------------------------------------------------------------------------------------------
+ DB 包访 函荐
-------------------------------------------------------------------------------------------------------*/
Connection con = null;
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
try
{
/*------------------------------------------------------------------------------------------------
* DB 目池记
-------------------------------------------------------------------------------------------------*/
%><%@ include file="../getConnection.jsp"%><%
/*------------------------------------------------------------------------------------------------
* opponent's score
-------------------------------------------------------------------------------------------------*/
String query1 = "select nickname,sex from GT_user_info where phonenum = '"+gphone+"'";
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
if(rs.next())
{
YourStrname = rs.getString("nickname");
}
rs.close();
szCount = "select gamerank_score from GT_gamerank_"+game_idx+" where phonenum='"+gphone+"'";
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
if( rs.next() )
{
gScore = rs.getString("gamerank_score");
}
rs.close();
szCount = "select point from GT_gameranking"+" where phonenum='"+gphone+"'";
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
if( rs.next() )
{
gpoint = rs.getInt("point");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* my score
-------------------------------------------------------------------------------------------------*/
szCount = "select gamerank_score from GT_gamerank_"+game_idx+" where phonenum='"+mphone+"'";
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
if( rs.next() )
{
myScore = rs.getString("gamerank_score");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* opponent's nickName
-------------------------------------------------------------------------------------------------*/
szCount = " select nickname from GT_User_Info WHERE phonenum='"+gphone+"'" ;
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
if( rs.next() )
{
strNickname = rs.getString("nickname");
}
rs.close();
pstmt.close();
/**************************************
gameInfo
***************************************/
szCount = " select game_title ,game_text,game_img_path from GT_game where game_idx = ? ";
pstmt = con.prepareStatement(szCount);
pstmt.setInt(1,game_idx);
rs = pstmt.executeQuery();
if(rs.next())
{
gametitle = rs.getString("game_title");
game_text = rs.getString("game_text");
game_img_path = rs.getString("game_img_path");
}
rs.close();
}
catch(Exception e)
{
throw e;
}
finally
{
if ( rs != null ) { try { rs.close(); } catch ( Exception e ) { } }
if ( stmt != null ) { try { stmt.close(); } catch ( Exception e ) { } }
if ( con != null ) { try { con.close(); } catch ( Exception e ) { } }
}
%>
<html>
<head>
<link href="http://entaz.mugeta.com/client/mugeta_v2_test/web/user/mobile.css" rel="stylesheet" type="text/css">
<title>档傈霸烙</title>
</head>
<body>
<Form name="form1" action="GameGuestBook_proc.jsp" method="post">
<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="gametype" value="1">
<input type="hidden" name="gamePlayType" value="2">
<input type="hidden" name="name" value="<%=strNickname%>">
<input type="hidden" name="matchtype" value=0>
<!--剧侥
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
</tr>
</table>
</td>
</tr>
-->
<table width="176" border="0" cellspacing="0" cellpadding="0">
<!--鸥捞撇 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" height="2" bgcolor="#a8bfff"></td>
</tr>
<tr>
<td width="6" height="14" bgcolor="#6a76f2"></td>
<td height="14" bgcolor="#6a76f2"><font color="#ffffff">档傈 霸烙</font></td>
</tr>
<tr>
<td colspan="2" height="2" bgcolor="#a8bfff"></td>
</tr>
<tr>
<td colspan="2" height="1" bgcolor="#6a76f2"></td>
</tr>
</table>
</td>
</tr>
<!--鸥捞撇 场-->
<!--咯归 矫累-->
<tr>
<td height="5"></td>
</tr>
<!--咯归 场-->
<tr>
<td>
<!--膏飘 冠胶 矫累-->
<table width="176" bgcolor="#9fb7f8" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="8" height="64"></td>
<td align="center">
<font color="#ffffff">惑措狼 扁废俊 档傈钦聪促.<br>
捞辨 版快 惑措狼 珐欧 器牢飘甫 化绢可聪促.窍瘤父 龙 版快 <br>
器牢飘甫 化扁霸 邓聪促.</font></td>
<td width="8"></td>
</tr>
</table>
<!--膏飘 冠胶 场-->
</td>
</tr>
<!--咯归 矫累-->
<tr>
<td height="3"></td>
</tr>
<!--咯归 场-->
<!--且肺扩 莆莆 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3"></td>
<td width="27" valign="top">
<!--且肺扩 莆莆 捞固瘤 矫累-->
<table border="0" bgcolor="#c5d0d1" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="2"></td>
</tr>
<tr>
<td width="2"></td>
<td width="23" valign="top"><img src="<%=img_path%>images/game/<%=game_img_path%>" width="23" height="23"></td>
<td width="2"></td>
</tr>
<tr>
<td colspan="3" height="2"></td>
</tr>
</table>
<!--且肺扩 莆莆 捞固瘤 场-->
</td>
<td width="3"></td>
<!--且肺扩 莆莆 膏飘 矫累-->
<td valign="top">
<font color="#6a76f2"><b><%=gametitle%></b></font><br>
<font color="#616667" size="3"><%=game_text%></font>
</td>
<!--且肺扩 莆莆 膏飘 场-->
</tr>
<!--痢急 矫累-->
<tr>
<td align="center" colspan="4">
<font color="#cccccc" size="3" align="center">··········································</font>
</td>
</tr>
<!--痢急 场-->
<!--扁废 郴侩 矫累-->
<%if( gScore == null || "".equals(gScore)){ %>
<tr>
<td width="3"></td>
<td colspan="3"><font color="#ff5066"> 惑措 弥绊 扁废 : 0 痢</font></td>
</tr>
<%}else{ %>
<tr>
<td width="3"></td>
<td colspan="3"><font color="#ff5066"> 惑措 弥绊 扁废 : <%=gScore%>痢</font></td>
</tr>
<%} %>
<%if( myScore == null || "".equals(myScore)){ %>
<tr>
<td width="3"></td>
<td colspan="3"><font color="#ff5066"> 郴 弥绊 扁废 : 0 痢</font></td>
</tr>
<%}else{ %>
<tr>
<td width="3"></td>
<td colspan="3"><font color="#ff5066"> 郴 弥绊 扁废 : <%=myScore%>痢</font></td>
</tr>
<%} %>
<!--扁废 郴侩 场-->
</table>
</td>
</tr>
<!--且肺扩 莆莆 场-->
<!--咯归 矫累-->
<tr>
<td height="5"></td>
</tr>
<!--咯归 场-->
<!--舅覆 冠胶 矫累-->
<tr>
<td>
<table width="176" bgcolor="#dae6e8" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="5"></td>
</tr>
<!--膏飘 矫累-->
<tr>
<td width="8"></td>
<td align="center">
<font color="#545454">惑措狼 规疙废俊 巢辨<br>
富阑 利绢 林技夸. 殿废窍搁<br>
官肺 霸烙捞 矫累邓聪促.</font>
</td>
<td width="8"></td>
</tr>
<!--膏飘 场-->
<tr>
<td colspan="3" height="5"></td>
</tr>
<!--酒官鸥 郴侩 冠胶 矫累-->
<tr>
<td width="8"></td>
<td>
<table width="160" border="0" cellspacing="0" cellpadding="0">
<tr>
<!--酒官鸥 矫累-->
<td width="48" align="top" ><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>" width="48" height="54"></td>
<!--酒官鸥 场-->
<td width="8"></td>
<!--郴侩 矫累-->
<td width="108">
<table width="108" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="17"><font color="#6466ff"><b>罐绰捞 :</b></font></td>
</tr>
<tr>
<td height="17"><a href="<%=url_path%>/ranking/game_start.jsp?game_idx=<%=game_idx%>&mphone=<%=mphone%>&gphone=<%=gphone%>&gamePlayType=<%=gamePlayType%>"><font color="#6466ff"><%=strNickname%></font></a></td>
</tr>
<%if( gScore == null || "".equals(gScore)){ %>
<tr>
<td height="17"><font color="#6466ff">捞秦档 0</font></td>
</tr>
<%}else{ %>
<tr>
<td height="17"><font color="#6466ff">捞秦档 <%=gpoint%></font></td>
</tr>
<%} %>
</table>
</td>
<!--郴侩 场-->
</tr>
</table>
</td>
<td width="8"></td>
</tr>
<!--酒官鸥 郴侩 冠胶 场-->
<tr>
<td colspan="3" height="3"></td>
</tr>
<!--涝仿 冠胶 矫累-->
<tr>
<td width="8"></td>
<td>
<table width="160" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center">
<textarea name="guestbook" rows="85" cols="27" maxlength="300"></textarea>
</td>
</tr>
</table>
</td>
<td width="8"></td>
</tr>
<!--涝仿 冠胶 场-->
<tr>
<td colspan="3" height="5"></td>
</tr>
</table>
</td>
</tr>
<!--舅覆 冠胶 场-->
<!--咯归 矫累-->
<tr>
<td height="3"></td>
</tr>
<!--咯归 场-->
<!--滚瓢 矫累-->
<tr>
<td>
<table width="176" height="16" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td width="55" height="16" bgcolor="#a8bfff" align="center"><a href="javascript:form1.submit()"><font color="#ffffff">殿废窍扁</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!--滚瓢 场-->
<!--咯归 矫累-->
<tr>
<td height="10"></td>
</tr>
<!--咯归 场-->
<!--窍窜 版肺钎矫 矫累-->
<tr>
<td>
<table width="176" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td width="176" bgcolor="#DAE6E8" height="19"> <a href="<%=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone%>"> 权</a>> <a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=0<%=gphone%>"><%=YourStrname%>丛 迄乔</a>><a href="<%=url_path%>/ranking/game_yourspage.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>">霸烙</a>>档傈霸烙</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--窍窜 版肺钎矫 场-->
</table>
<!--窍窜 版肺钎矫 矫累-->
<%@ include file="../newbottom.jsp"%>
<!--窍窜 版肺钎矫 场-->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -