savescore.jsp.svn-base

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

<%@ 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"%>

<%!
	public static String isNull(String str) 
	{ 
		if (str == null) 
		return ""; 
		else 
		return str;
	} 
%>

<%	//己龋
	Connection con = null;
	PreparedStatement pstmt=null;
	Statement stmt = null;
	ResultSet rs = null;
	ResultSet pageset = null;
	Date date = new Date();

	response.setHeader("cache-control","no-cache");
	response.setHeader("expires","0");
	response.setHeader("pragma","no-cache");
	
	String mphone = request.getParameter("mphone");
	String gphone = mphone;
	String game_idx = request.getParameter("game_idx");

	int score = 0;
	int beforeScore=0;
	int todayScore=0;
	int addClover = 0;
	
	String myNickname="";
	String query1=null, sql=null;
	String dayGap=null;

	int isMember = 0; //雀盔1, 厚雀盔0
	
	String game_title = "";

	String boardname = "GT_gamerank_"+game_idx;//历厘且 霸烙 珐欧 抛捞喉
	String cloverTable = "GT_moneybook"; //努肺滚 郴开.

	if(!isNull(request.getParameter("score")).equals("") )
	{
		score = Integer.parseInt(request.getParameter("score"));
	}
	if(!isNull(request.getParameter("addClover")).equals("") )
	{
		addClover = Integer.parseInt(request.getParameter("addClover"));
	}

%>

<%
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);

	stmt=con.createStatement();
	
	//郴 喊疙 啊廉坷扁
	query1 = "select nickname from GT_user_info where phonenum='"+mphone+"'";
	rs=stmt.executeQuery(query1);
	if(rs.next())
	{
		isMember = 1;
		myNickname = rs.getString(1);
	}
	else
	{
		isMember = 0;
		myNickname = "厚雀盔";
	}


	if(isMember == 1)
	{
		//痢荐 历厘窍扁 ( 盔贰 乐带 版快 诀单捞飘, 脚痹捞搁 积己秦辑 历厘)
		sql = " select gamerank_idx, gamerank_score, gamerank_today,datediff(day,gamerank_date,getdate()) as dayGap ";
		sql = sql + " from "+boardname+" where phonenum='"+mphone+"'";	
		rs=stmt.executeQuery(sql);	

		if(!rs.next()) 
		{  
			sql = "Insert into "+boardname+" (phonenum, nickname, gamerank_score, gamerank_today) Values(?,?,?,?)";	
			pstmt = con.prepareStatement(sql);
			pstmt.setString(1,mphone);//傈拳锅龋
			pstmt.setString(2,myNickname);//喊疙
			pstmt.setInt(3,score);//痢荐
			pstmt.setInt(4,score);//痢荐
			pstmt.executeUpdate();
		}
		else 
		{
					beforeScore = rs.getInt("gamerank_score"); //扁粮弥绊痢荐 啊廉柯促.
					todayScore = rs.getInt("gamerank_today"); //坷疵痢荐 啊廉柯促.
					dayGap = rs.getString("dayGap"); //朝楼 gap阑 啊廉柯促 0 篮 坷疵...  
					
					if (dayGap.equals("0")){

								if(beforeScore < score)//捞锅俊 霸烙茄 痢荐啊 脚扁废焊促 歹 臭促.
								{
								
									sql = " UPDATE "+boardname;
									sql = sql + " SET gamerank_score="+score;
									sql = sql + " , gamerank_today="+score;
									sql = sql +" , gamerank_date=GETDATE() where phonenum='"+mphone+"'";
									pstmt = con.prepareStatement(sql);
									pstmt.executeUpdate();

									int scoregap = score - beforeScore;
									sql = "UPDATE GT_gameplay_info set play_totalscore=play_totalscore+"+scoregap+" where phonenum='"+mphone+"'";
									pstmt = con.prepareStatement(sql);
									pstmt.executeUpdate();
									
								}
								else //弥绊扁废焊促 泅犁 痢荐啊 撤栏搁
								{
										if(todayScore < score) //规陛茄 霸烙痢荐啊 坷疵 扁废茄 霸烙焊促 歹 臭促搁 坷疵弥绊痢荐甫 诀单捞飘 茄促.
										{
											sql = " Update "+boardname;
											sql = sql + " SET gamerank_today="+score;
											sql = sql + " , gamerank_date=GETDATE() ";
											sql = sql + " WHERE phonenum='"+mphone+"'";
											pstmt = con.prepareStatement(sql);
											pstmt.executeUpdate();
										}
								}
				   
				   }else{ //坷疵 贸澜 捞侩.....

								if(beforeScore < score)//捞锅俊 霸烙茄 痢荐啊 脚扁废焊促 歹 臭促.
								{
								
									sql = " UPDATE "+boardname;
									sql = sql + " SET gamerank_score="+score;
									sql = sql + " , gamerank_today="+score;
									sql = sql +" , gamerank_date=GETDATE() where phonenum='"+mphone+"'";
									pstmt = con.prepareStatement(sql);
									pstmt.executeUpdate();

									int scoregap = score - beforeScore;
									sql = "UPDATE GT_gameplay_info set play_totalscore=play_totalscore+"+scoregap+" where phonenum='"+mphone+"'";
									pstmt = con.prepareStatement(sql);
									pstmt.executeUpdate();
									
								}
								else //弥绊扁废焊促 泅犁 痢荐啊 撤栏搁
								{
								
									sql = " Update "+boardname;
									sql = sql + " SET gamerank_today="+score;
									sql = sql + " , gamerank_date=GETDATE() ";
									sql = sql + " WHERE phonenum='"+mphone+"'";
									pstmt = con.prepareStatement(sql);
									pstmt.executeUpdate();
					
								}
				   }
			
			


		}
			
		/*
		//霸烙捞抚 啊廉坷扁
		query1 = "select game_title from GT_game where game_idx="+game_idx;
		rs = stmt.executeQuery(query1);
		if(rs.next())
			game_title=rs.getString(1);
		else
			game_title="霸烙裙垫";


		//努肺滚 郴开俊 历厘茄促.
		if(addClover > 0)
		{
			query1 = "select max(moneybook_total_clover) from "+ cloverTable+" where phonenum='"+mphone+"'";//弥辟 焊蜡俺荐 啊廉坷扁
			pstmt = con.prepareStatement(query1);
			rs = pstmt.executeQuery();
			int totClover=0;
			if(rs.next())
				totClover = rs.getInt(1); 

			rs=stmt.executeQuery(query1);
			if(rs.next())
				myNickname = rs.getString(1);
			sql = "Insert into " + cloverTable + " (moneybook_itemname, moneybook_flag, moneybook_clover, moneybook_total_clover,phonenum)" + " Values(?,?,?,?,?) ";
			pstmt = con.prepareStatement(sql);
			pstmt.setString(1,game_title);//傈拳锅龋
			pstmt.setInt(2,1);//裙垫敲贰弊
			pstmt.setInt(3,addClover);//掘篮 努肺滚
			pstmt.setInt(4,totClover+addClover);//醚 努肺滚
			pstmt.setString(5,mphone);
			pstmt.executeUpdate();
		}
		*/

	}
	
// con.commit();

	if(rs != null) rs.close();
	if(stmt != null) stmt.close();
	if(pageset != null) try{pageset.close();}catch(Exception se){}
	if(pstmt != null)   try{pstmt.close();}catch(Exception es){}

}
catch (Exception e) 
{
// con.rollback();

	out.println(e);
}
finally
{
// con.setAutoCommit(true);

	if(rs != null)      try{rs.close();}catch(Exception se){}
	if(pageset != null) try{pageset.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){}
}

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

%>