ranking_school_tot.jsp

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

<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.Vector, java.util.*, 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; 
	} 
%>

<%
	String school_area_middle = null;
	int school_type_top = 0;
	int school_mam_cnt = 0;
	int school_book_cnt = 0;
	String school_join_name  = null;
	int school_join_week = 0;
	int school_idx_rank = 0;
	String school_name_rank = null;
	int rankNumber = 0;
	int school_idx_join = 0;
	int point = 0;

	String mphone= request.getParameter("mphone");
	String gphone= request.getParameter("gphone");
	String school_type = null;
	if(isNull(request.getParameter("school_type")).equals("") ){ school_type = "1";	}else{ school_type = request.getParameter("school_type"); }
	int school_type_int = Integer.parseInt(school_type);

	String school_img_name = null;
	String school_sex = null;
	String school_text = null;
	String school_text2 = null;

	String link2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;//鸥款珐欧啪 栏肺

	//叼厚 函荐
	PreparedStatement pstmt = null;
	Connection con = null;
	Statement stmt = null;
	ResultSet rs = null;
	ResultSet pageset = null;// 其捞瘤 备泅 眠啊 函荐 ---------
	String query1 = null;
	String queryJoin = null;

// 其捞瘤 备泅 眠啊 函荐 ------------------------------------------
	int pagesize = 4;  // 茄其捞瘤寸 10俺 免仿拱

	// 傈开 函荐肺 急攫.. 其捞瘤 备泅 何盒俊 犁荤侩
	int pageNUM=1;    // 其捞瘤 锅龋
	int pagecount=1 ; // 其捞瘤 肮荐 瘤沥 函荐

	int absolutepage=1;  // 例措 困摹 其捞瘤 锅龋
    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 ===========================



//其捞隆-----------------------------------------------------
		stmt = con.createStatement();  
		pageset = stmt.executeQuery("select count(*) from GT_school where school_type="+school_type);

		if(pageset.next()){
			dbcount = pageset.getInt(1);
			pageset.close();
			if(dbcount > 100) dbcount = 100;
			dbcount = dbcount-1;
		}

		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+1;
		}

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

//其捞隆场-----------------------------------------------------
		query1 = "select top 100 school_area_middle, school_type, school_mam_cnt, school_book_cnt, school_join_name, school_join_week, school_idx, school_name,  school_join_idx, (school_mam_cnt*1+school_book_cnt*0.5+school_book_re_cnt*0.3+school_guest_cnt*0.2)as point, school_sex from GT_school where school_type="+school_type+" order by point desc, school_idx desc";
//out.println(query1);
		pstmt = con.prepareStatement(query1);
		rs = pstmt.executeQuery();
		rs.next();//老殿 沥焊甫 啊廉柯促.
		rankNumber++;

		 school_area_middle = rs.getString(1);//瘤开
		 school_type_top = rs.getInt(2);//切背 鸥涝(吝.绊)
		 school_mam_cnt = rs.getInt(3);//啊涝磊 荐
		 school_book_cnt = rs.getInt(4);//霸矫臂 荐
		 school_join_name = rs.getString(5);//悼竿 切背 捞抚
		 school_join_week = rs.getInt(6);//悼竿 扁埃
		 school_idx_rank = rs.getInt(7);//磊扁切背 牢郸胶
		 school_name_rank = rs.getString(8);//磊扁切背 捞抚
		 school_idx_join = rs.getInt(9);//悼竿切背 牢郸胶
		 point = rs.getInt(10);//痢荐
		 school_sex = rs.getString(11);


		switch(school_type_top)
		{
			case 1:
				school_area_middle = school_area_middle+"/吝切背";
				school_img_name = "middle_";
				school_text = "吝切";
				school_text2 = "吝切背";
				break;
			case 2:
				school_area_middle = school_area_middle+"/绊殿切背";
				school_img_name = "high_";
				school_text = "绊殿";
				school_text2 = "绊殿切背";
				break;
			case 3:
				school_area_middle = school_area_middle+"/措切背";
				school_img_name = "university_";
				school_text = "措切";
				school_text2 = "措切背";
				break;
			case 4:
				school_area_middle = school_area_middle+"/檬殿切背";
				school_img_name = "public_";
				school_text = "檬殿";
				school_text2 = "檬殿切背";
				break;
		}

		if(school_sex.equals("咯磊"))
			school_img_name = school_img_name+"g";
		else if(school_sex.equals("巢磊"))
			school_img_name = school_img_name+"b";
		else
			school_img_name = school_img_name+"c";

//瘤沥 其捞瘤 鳖瘤 焊郴扁-----------------------------------------------------
		if(!rs.next()) // 蔼捞 绝阑锭
		{
			isNoPage = 1;
			pagesize=0;
		}
		else         // 蔼捞 乐阑锭	//rs.absolute(absolutepage);
		{				
			for(int s=0; s<absolutepage-1; s++)
			{
				rs.next();
				rankNumber++;
			}
		}
%>


<html>
<head>
<title>胶酿珐欧</title>
<link href="mobile.css" rel="stylesheet" type="text/css">
</head>
<body>

<table width="176" border="0" cellspacing="0" cellpadding="0">
	<!--惑窜扁夯官 矫累-->
	<tr>				
		<td height="19"> 
			<table cellpadding="0" cellspacing="0" >
				<tr>			
					<td width="8" height="20" background="<%=img_path%>images/202img/202_bar/red.png"></td>		
					<td width="168" background="<%=img_path%>images/202img/202_bar/red.png">
						<font color="#FFFFFF">胶酿珐欧</font></td>
				</tr>
			</table>
		</td>
	</tr>
	<!--惑窜 扁夯官 场-->

	<tr> 
		<td height="8"></td>
	</tr>

	<tr>
		<td align="center">
			<font color="#909090">墨抛绊府甫<br>急琶窍矫搁 弊 墨抛绊府狼 珐欧阑<br>焊角 荐 乐绢夸~</font></td>
	</tr>

	<tr> 
		<td height="3"></td>
	</tr>

	<tr>
		<td width="176">

<form method="post" name="form1" action="<%=url_path%>/ranking/ranking_school_tot.jsp">

<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
			<table width="176" border="0" align="center" cellpadding="0" cellspacing="0">
				<tr>
					<td width="35"></td>
					<td width="70">
						<select name="school_type" size="1">
							<option value="4" <% if(school_type_int == 4) out.println("selected"); %>>檬殿炉</option>
							<option value="1" <% if(school_type_int == 1) out.println("selected"); %>>吝切炉</option>
							<option value="2" <% if(school_type_int == 2) out.println("selected"); %>>绊殿炉</option>
							<option value="3" <% if(school_type_int == 3) out.println("selected"); %>>措切炉</option>
						</select> 
					</td>
					<td width="36" bgcolor="#ffaec5" align="center"><font color="#ffffff"><a href="javascript:document.form1.submit();">焊扁</a></font></td>
					<td width="35"></td>
				</tr>
			</table>

</form>

		</td>
	</tr>

	<tr> 
		<td height="9"></td>
	</tr>

	<tr> 
		<td height="30" align="center" bgcolor="#ffa7b5">
			<font color="#ffffff"><%=school_text%>炉篮 劝悼痢荐啊<br>啊厘 臭篮 <%=school_text2%> 珐欧涝聪促.</font></td>
	</tr>

	<tr>
		<td width="176" height="2" background="<%=img_path%>images/202img/202_dot/dot_pink3.png"></td>
	</tr>

	<tr> 
		<td height="5"></td>
	</tr>

	<tr height="15">
		<td align="center"><img src="<%=img_path%>images/202img/202_ranking/medal_1.png" width="11" height="14" border="0"><font color="#ff4759"><b> 1困</b></font></td>
	</tr>
	
	<tr> 
    		<td height="1"></td>
  	</tr>

	<tr>
		<td align="center"><font color="#ff0000"><b><a href="<%=url_path%>/school/school_master.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>&school_idx=<%=school_idx_rank%>"><%=school_name_rank%></a></b></font></td>
	</tr>

	<tr> 
		<td height="3"></td>
	</tr>

<!-- 啊款单 墨其 1困 何盒 -->
	<tr>
		<td>
			<table width="176" border="0" align="center" cellpadding="0" cellspacing="0">
				<tr>
					<td width="4" bgcolor="#ffffff"></td>