game_dobaljang_insert.jsp.svn-base

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

<%@ page import='java.io.*, 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="../makeKOR.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");
	String recordmsg = null;
	String game_idx = request.getParameter("game_idx");
	String before_score = request.getParameter("before_score");
	String mygamerank_score = request.getParameter("mygamerank_score");

	if(!isNull(request.getParameter("recordmsg")).equals("")){	recordmsg = makeKOR(request.getParameter("recordmsg")); }
	else{ recordmsg="模备啊 寸脚狼 痢荐甫 玻嚼聪促."; }

	/*------------------------------------------------------------------------------------------------------
	+	DB 包访 函荐
	-------------------------------------------------------------------------------------------------------*/
	PreparedStatement pstmt = null;
	Connection con = null;
	Statement stmt = null;
	ResultSet rs = 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 ===========================



		con.setAutoCommit(false);

		recordmsg = StrConvert(recordmsg);
		/*------------------------------------------------------------------------------------------------------
		+	傍归 犬牢
		-------------------------------------------------------------------------------------------------------*/
/*
		if(recordmsg.equals(""))//傍归涝仿
		{
			//response.sendRedirect(url_path+"/town_g/gong_error.jsp?mphone="+mphone+"&gphone="+gphone+"&type=3");
			return;
		}
*/
		/*------------------------------------------------------------------------------------------------------
		+	臂 涝仿
		-------------------------------------------------------------------------------------------------------*/
		query1 = "select gamemsg_idx from GT_gamemsg where phonenum='"+mphone+"'";

		pstmt = con.prepareStatement(query1);
		rs = pstmt.executeQuery();

		if(rs.next())
		{
			query1 = "update GT_gamemsg set phonenum=?,msg_text=? WHERE gamemsg_idx = "+rs.getInt("gamemsg_idx");//涝仿
		}
		else
		{
			query1 = "insert into GT_gamemsg (phonenum,msg_text) values(?,?)";//涝仿
		}

		pstmt = con.prepareStatement(query1);
		
		pstmt.setString(1,mphone);
		pstmt.setString(2,recordmsg);

		pstmt.executeUpdate();

		if(rs != null)  rs.close(); 
		if(pstmt != null)  pstmt.close(); 
		/*------------------------------------------------------------------------------------------------------
		+	档惯厘 惯价
		-------------------------------------------------------------------------------------------------------*/

		query1 = "select top 10 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 = ? and "+before_score+" < b.gamerank_score and "+mygamerank_score+" > b.gamerank_score";
		//out.println(query1);
		pstmt = con.prepareStatement(query1);
		pstmt.setLong(1,Long.parseLong(mphone));
		rs = pstmt.executeQuery();

		String SQL=null;
		stmt=con.createStatement();

		while(rs.next())
		{
			SQL="exec GT_SendMessage2"+" '"+mphone+"','"+rs.getString(1)+"','档惯厘', '"+recordmsg+"',"+"'0'";
			stmt.executeUpdate(SQL); 
			out.println(SQL);
		}

		response.sendRedirect(url_path+"/ranking/game_result_friend.jsp?mphone="+mphone+"&gphone="+gphone+"&game_idx="+game_idx);

		con.commit();
		if(rs != null)  rs.close(); 
		if(pstmt != null)  pstmt.close(); 
		if(stmt != null)  stmt.close(); 
//		if(con != null)  con.close(); 
	}
	catch(Exception e)
	{
		con.rollback();
		out.println(e);
		out.println("<font color=red size=10>DB Connect Failed </font>");
		//臂磊荐 檬苞 版绊芒 傅农
		response.sendRedirect(url_path+"/db_insert_error.jsp?mphone="+mphone+"&gphone="+gphone);
	}
	finally
	{
		con.setAutoCommit(true);
		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){}
	}

%>