game_search.jsp.svn-base

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

<!--------------------------------------------------------------------------------------------------------------
*@霸烙>霸烙八祸
*@Author : 冠惑辣(2007-12-23)
*@Images : 其捞瘤 救俊 甸绢啊绰 捞固瘤
	1) bg_01.png - 抛捞喉 弥惑窜 硅版捞固瘤
	2) bu_01.png - 劝己拳 喊葛剧
	3) bu_02.png - 馆父 劝己拳等 喊葛剧
	4) bu_03.png - 厚劝己拳 喊葛剧
	5) gameicon_3.png - 郡府胶墨靛罐扁 捞固瘤
	6) gameicon_6.png - 戳措弊匙鸥扁 捞固瘤
	7) gameicon_5.png - 具荐 倔澜柄扁 捞固瘤
	8) gameicon_4.png - 固款坷府臭捞朝扁 捞固瘤
	9) gameicon_10.png - 墨靛捍沥嘎洒扁 捞固瘤
--------------------------------------------------------------------------------------------------------------->
<%@ 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"%>

<%

	/***********************************************************************
	
	@ Page Description
	 	霸烙 茫扁
	
	@ Parameter

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

	/*------------------------------------------------------------------------------------------------------
	+	扁夯 颇扼固磐
	-------------------------------------------------------------------------------------------------------*/
	String vmtype = request.getParameter("vmtype") == null ? "":request.getParameter("vmtype").substring(0,1);
	String vGameTableName = null;
	if(vmtype.equals("b")){ vGameTableName = "GT_game_brew";	}else{ vGameTableName = "GT_game_wipi"; }


	String mphone= request.getParameter("mphone");
	String gphone= request.getParameter("gphone");
	String search_field = null;
	String orderby_field = null;
	int norderby_field = 0;
	int ngame_genre = 0;

	if(request.getParameter("search_field")!=null) search_field=convKOR(request.getParameter("search_field")); else search_field="";
	if(request.getParameter("orderby_field")!=null) orderby_field=request.getParameter("orderby_field"); else orderby_field="0";
	norderby_field = Integer.parseInt(orderby_field);
	if(request.getParameter("game_genre")!=null) ngame_genre=Integer.parseInt(request.getParameter("game_genre"));

	/*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/
	int loop = 0;

	int idxCnt = 0;
	int game_idx[] = new int [5] ;
	String game_title[] = new String [5];
	String game_text[] = new String [5];
	String game_img[] = new String [5];
	String game_type[] = new String [5];
	int game_diff[] = new int [5] ;

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

	/*------------------------------------------------------------------------------------------------------
	+	其捞瘤 备泅 眠啊 函荐
	-------------------------------------------------------------------------------------------------------*/
	int pagesize = 5;  // 茄其捞瘤寸 10俺 免仿拱
	int pageNUM=1;    // 其捞瘤 锅龋
	int pagecount=1 ; // 其捞瘤 肮荐 瘤沥 函荐
	int absolutepage=0;  // 例措 困摹 其捞瘤 锅龋
    int dbcount=0 ;   //  DB 救俊 臂 肮荐 历厘 函荐
	int isNoPage = 0;	//茄俺档 绝蠢衬.. 绝栏搁0, 乐栏搁1

	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 ===========================




//其捞隆-----------------------------------------------------

		String genre_query = ""; 

		if(norderby_field == 5)
		{
			genre_query = " and game_genre = "+ngame_genre+" "; 
		}

		stmt = con.createStatement();  
		pageset = stmt.executeQuery("select count(game_idx) as recCount from "+vGameTableName+" where game_new=2 "+genre_query+" and game_title like '%"+search_field+"%'");

		if(pageset.next()){
			dbcount = pageset.getInt(1);  // 臂 醚 肮荐
			pageset.close();
		}

		if(dbcount%pagesize == 0)
			pagecount = dbcount/(pagesize); // 醚 其捞瘤荐 备窍扁
		else
			pagecount = dbcount/(pagesize)+1; // 醚 其捞瘤荐 备窍扁

		if(request.getParameter("pageNUM")!=null)
		{
			pageNUM=Integer.parseInt(request.getParameter("pageNUM"));//瘤沥等 其捞瘤 焊咯林扁

			if(pageNUM > pagecount)
				pageNUM = pagecount;

			absolutepage=(pageNUM-1)*pagesize;
		}

		if(pageset != null)  pageset.close(); 

//其捞隆场-----------------------------------------------------
		String field_name = null;

		switch(norderby_field)
		{
			case 0:case 5://弥脚鉴
				field_name = " game_date desc";
				break;
			case 1://坷贰等鉴
				field_name = " game_date asc";
				break;
			case 2://啊唱促鉴
				field_name = " game_title asc";
				break;
			case 3://浆款鉴
				field_name = " game_diff asc";
				break;
			case 4://绢妨款鉴
				field_name = " game_diff desc";
				break;
		}

		query1 = "SELECT TOP " + pagesize + " game_Idx,game_title,game_text,qcif_img,game_type,game_diff FROM "+vGameTableName+" ";
		query1 = query1 + " WHERE game_Idx not in ";
		query1 = query1 + "(SELECT TOP " + absolutepage + " game_Idx FROM "+vGameTableName+" where game_new=2 "+genre_query+" and game_title like '%"+search_field+"%' ";
		query1 = query1 + " ORDER BY "+field_name+") and game_new=2 "+genre_query+" and game_title like '%"+search_field+"%' order by "+field_name+""; 
//out.println(query1);
		rs=stmt.executeQuery(query1);
		while(rs.next())
		{
			game_idx[idxCnt]=rs.getInt("game_idx");
			game_title[idxCnt]=rs.getString("game_title");
			game_text[idxCnt]=rs.getString("game_text");
			game_img[idxCnt]=rs.getString("qcif_img");
			game_type[idxCnt]=rs.getString("game_type");
			game_diff[idxCnt] = rs.getInt("game_diff");
			idxCnt++;
		}

		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){}
	}
%>

<html>
<head>
<title>霸烙_八祸</title>
<link href="mobile.css" rel="stylesheet" type="text/css">
</head>
<body>

<form name="form" method="post" action="<%=url_path%>/ranking/game_search.jsp">
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<input type="hidden" name="game_genre" value="0">

<table width="176" border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td>

			<table width="176" border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td height="3" bgcolor="#A8BFFF"></td>