game_result_updown.jsp

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

<!-- ******************************************************************************************* -->
<!-- * 公霸鸥 霸烙 > 霸烙搬苞 > 模备甸 吝 郴 珐欧 * -->
<!-- * 内歹 : 全驱柳(hjhj) * -->
<!-- * 累己老 : 2007-12-21 * -->
<!-- ******************************************************************************************* -->

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

<%	
	/***********************************************************************
	
	@ Page Description
	 	档惯厘 惯价 咯何 魄窜
	
	@ Parameter

	***********************************************************************/

	/*------------------------------------------------------------------------------------------------------
	+	扁夯 颇扼固磐
	-------------------------------------------------------------------------------------------------------*/
	String mphone = request.getParameter("mphone");
	String gphone = request.getParameter("gphone");
	int game_idx=Integer.parseInt(request.getParameter("game_idx"));
	int before_score=Integer.parseInt(request.getParameter("before_score"));

	/*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/
	String myphonenum = null;
	String mynickname = null;
	int mygamerank_score = 0;

	/*------------------------------------------------------------------------------------------------------
	+	DB 包访 函荐
	-------------------------------------------------------------------------------------------------------*/
	PreparedStatement pstmt = null;
	Connection con = null;
	Statement stmt = null;
	ResultSet rs = null;
	ResultSet pageset = null;// 其捞瘤 备泅 眠啊 函荐 ---------
	String query1 = null;



	/*------------------------------------------------------------------------------------------------------
	+	
	-------------------------------------------------------------------------------------------------------*/
	try
	{



	//=========================== 傍烹函券累诀 : 2008-01-21 ===========================

	/**
	 * 公丰霸烙鸥款 矫胶袍痢八 棺 喉发蜡历 八免
	 * 
	 * @ date		?8-01-21
	 * @ version			1.2.0
	 */

	String SYSTEM_PARAMETER_SET = "?mphone="+request.getParameter("mphone")+"&gphone="+request.getParameter("mphone");
	String SYSTEM_PHONE_NUMBER = request.getParameter("mphone");

	// 矫胶袍 痢八 眉农
	//
	if(IS_SYSTEM_CHECK)
	{
		if( ! IS_TESTER_MODE )
		{
			response.sendRedirect(url_path+"/system_notice.jsp"+SYSTEM_PARAMETER_SET);
			return;
		}
	}
	// DB 楷搬捞 登瘤 臼阑 锭, 救郴芒栏肺 捞悼
	//
	con = DBConnector.getConnection(db_name);
	if( con == null )
	{
		response.sendRedirect(url_path+"/system_notice2.jsp"+SYSTEM_PARAMETER_SET);
		return;
	}
	// 矫胶袍痢八 吝捞咯档 抛胶磐绰 荤侩啊瓷
	//
	if( IS_TESTER_MODE )
	{
		boolean isTester = DBConnector.chkTester( con, SYSTEM_PHONE_NUMBER );
		if( ! isTester )
		{
			response.sendRedirect(url_path+"/system_notice.jsp"+SYSTEM_PARAMETER_SET);
			return;
		}
	}
	// 喉发蜡历牢瘤 眉农, 
	//
	boolean isBlackUser = DBConnector.chkBlackList( con, SYSTEM_PHONE_NUMBER );
	if( isBlackUser ) 
	{
		response.sendRedirect(url_path+"/bad_member.jsp"+SYSTEM_PARAMETER_SET);
		return;
	}

	//=========================== 傍烹函券累诀 : 2008-01-21 ===========================




		stmt = con.createStatement(); 
		/*------------------------------------------------------------------------------------------------------
		+	磊脚狼 痢荐客 珐欧
		-------------------------------------------------------------------------------------------------------*/

		query1 = "select gamerank_score,nickname,phonenum from GT_gamerank_"+game_idx+" where phonenum = '"+mphone+"'";
		//out.println(query1+"<br>");
		rs=stmt.executeQuery(query1);
		rs.next();

		myphonenum = rs.getString(3);
		mynickname = rs.getString(2);
		mygamerank_score = rs.getInt(1);


		rs.close();
		
		query1 = "select count(a.guest_phone) FROM GT_friend AS a INNER JOIN GT_gamerank_"+game_idx+" AS b ON a.guest_phone2 = CAST(b.phonenum as bigint) where a.friend_flag = 1 and a.phonenum2 = "+Long.parseLong(mphone)+" and datediff(week,gamerank_date,getdate())=0 and "+before_score+" < b.gamerank_score and "+mygamerank_score+" > b.gamerank_score";

		rs=stmt.executeQuery(query1);
		//out.println(query1+"<br>");
		rs.next();
		int cnt = rs.getInt(1);

		if(cnt > 0)//档惯厘栏肺 啊扁
			response.sendRedirect(url_path+"/ranking/game_dobaljang.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx+"&before_score="+before_score+"&mygamerank_score="+mygamerank_score+"&cnt="+cnt);
		else
			response.sendRedirect(url_path+"/ranking/game_result_friend.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx);

		rs.close();

		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>