gameuserment_proc.jsp

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

<%@ page import="java.lang.*, java.io.*, java.net.*, java.awt.*, java.util.Vector, javax.imageio.*, Acme.JPM.Encoders.GifEncoder, java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.*, com.entaz.changpa.movata.*" contentType="text/html;charset=euc-kr"%><%@ include file="../imgpath.jsp"%><%@ include file="../makeKOR.jsp"%><%@ include file="../common_func.jsp"%><%
   response.setHeader("cache-control","no-cache");
   response.setHeader("expires","0");
   response.setHeader("pragma","no-cache");
%><%
	/***********************************************************************
	
	@ Page Description
	 	目敲霸矫魄 贸府 何盒
	
	@ Parameter
	* | mphone			: 
	* | gphone			:
	* | sex					:	

	***********************************************************************/
	/*------------------------------------------------------------------------------------------------------
	+		扁夯 颇扼固磐
	-------------------------------------------------------------------------------------------------------*/
	String		mphone				= request.getParameter("mphone");
	String		gphone				= request.getParameter("gphone");
	String		szType				= request.getParameter("type");
	String		szGameIdx			=	request.getParameter("game_idx");
	String		szPlayType			=	request.getParameter("gamePlayType");
	String		szReferer			=	request.getParameter("refer");
	
	String		szDefaultParam	=	"?mphone="+mphone+"&gphone="+gphone+"&game_idx="+szGameIdx+"&gamePlayType="+szPlayType;
	String		szSQL				= null;
	
	

	Connection					con		= null;
	PreparedStatement		pstmt	= null;
	Statement					stmt		= null;
	ResultSet					rs			= 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 ===========================
		

		// 殿废
		//
		if("reg".equals( szType ))
		{
			String		szNickName	=	null;
			String		szText			=	request.getParameter("text");
			
			// 郴侩 绝澜
			if( "".equals(szText) || "null".equals(szText) || szText == null)
			{
%>
			<%@ include file="coupleBoard_err1.jsp"%>	 
<%
			return;
			}

			// 咆胶飘 函券
			//
			szText = makeKOR(szText);
			szText = szText.replaceAll("'", "''");
			
			szSQL = "INSERT INTO GT_GameUserMent( phonenum , gameIdx , text ) VALUES( ? , ? , ? )";
			pstmt=con.prepareStatement(szSQL);		
			pstmt.setLong(1, Long.parseLong(mphone) );
			pstmt.setInt(2, Integer.parseInt(szGameIdx) );
			pstmt.setString(3, szText );
			pstmt.executeUpdate();
			pstmt.close();
		}
		// 荐沥
		//
		else if("modify".equals( szType ))
		{
			int				nIdx				=	Integer.parseInt(request.getParameter("Idx"));
			String		szText			=	request.getParameter("text");
			
			// 郴侩 绝澜
			if( "".equals(szText) || "null".equals(szText) || szText == null )
			{
%>
			<%@ include file="coupleBoard_err1.jsp"%>	 
<%
			return;
			}
			
			// 咆胶飘 函券
			//
			szText = makeKOR(szText);
			szText = szText.replaceAll("'", "''");

			szSQL = "UPDATE GT_GameUserMent SET text = ? WHERE idx = ?";
			pstmt=con.prepareStatement(szSQL);		
			pstmt.setString(1, szText );
			pstmt.setInt(2, nIdx );
			pstmt.executeUpdate();			
			pstmt.close();
		}
		// 昏力
		//
		else if("del".equals( szType ))
		{
			int				nIdx				=	Integer.parseInt(request.getParameter("Idx"));

			szSQL = "DELETE FROM GT_GameUserMent WHERE idx = ?";
			pstmt=con.prepareStatement(szSQL);		
			pstmt.setInt(1, nIdx );
			pstmt.executeUpdate();			
			pstmt.close();

			// 肯丰
			//
			response.sendRedirect(url_path+"/game/GameUserMent_deleteOK.jsp"+szDefaultParam);
			return;
		}
		
		// 肯丰
		//
		if("1".equals(szReferer))
		{	
			response.sendRedirect(url_path+"/ranking/game_gamename.jsp"+szDefaultParam);
		}
		else if("2".equals(szReferer))
		{
			response.sendRedirect(url_path+"/ranking/game_result.jsp?mphone="+mphone+"&gphone="+mphone+"&game_idx="+szGameIdx+"&myFlag=1&dateFlag=1");
		}
		else
		{
			response.sendRedirect(url_path+"/ranking/game_gamename.jsp"+szDefaultParam);
		}

	}
	catch(Exception e)
	{
		out.println(e);
		throw e;
	}
	finally
	{
		if(rs !=null) try{rs.close();}catch(Exception se){}
		if(pstmt !=null) try{pstmt.close();}catch(Exception es){}
		if(stmt !=null) try{stmt.close();}catch(Exception es){}
		if(con !=null) try{con.close();}catch(Exception es){}
	}
%>