📄 ranking_caferanking.jsp
字号:
<%@ page import='java.io.*, 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"%>
<% //4焙
Connection con = null;
PreparedStatement pstmt=null;
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;
//牢磊蔼==================================================================
String mphone = request.getParameter("mphone");
String gphone = request.getParameter("gphone");
String cafe_idx = request.getParameter("cafe_idx");
//==========================================================================
Random myRandom = new Random( );
int cafe_back_img = 0;//捞固瘤 锅龋
int category_idx = 0;
String query=null;//墨其沥焊
String query1=null;//雀盔荐
String query2=null;//霸矫臂荐
String cafe_name = "";//墨其 捞抚
int cafe_join_number = 0;//雀盔荐
int cafe_book_count = 0;//霸矫臂荐
int cafe_join_number_grade = 0;//雀盔荐 殿荐
int cafe_book_count_grade = 0;//霸矫臂荐 殿荐
String linkUrl=url_path+"/ranking/ranking_cafe.jsp?mphone="+mphone+"&gphone="+gphone;
String link1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone;//权
String link2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;//鸥款珐欧啪 栏肺
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 ===========================
query = "select cafe_name, cafe_join_number, cafe_book_count, category_idx, cafe_back_img from GT_cafe where cafe_idx = "+cafe_idx;
pstmt = con.prepareStatement(query);
rs = pstmt.executeQuery();
if(rs.next())
{
cafe_name = rs.getString(1);//墨其 捞抚
cafe_join_number = rs.getInt(2);//雀盔荐
cafe_book_count = rs.getInt(3);//霸矫臂荐
category_idx = rs.getInt(4);
cafe_back_img = rs.getInt(5);
}
query1 = "select count(*) from GT_cafe where cafe_join_number >= "+cafe_join_number+" and cafe_idx >= "+cafe_idx;//雀盔荐
query2 = "select count(*) from GT_cafe where cafe_book_count >= "+cafe_book_count+" and cafe_idx >= "+cafe_idx;//霸矫臂荐
//雀盔荐 殿荐
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
rs.next();
cafe_join_number_grade = rs.getInt(1);
//霸矫臂 殿荐
pstmt = con.prepareStatement(query2);
rs = pstmt.executeQuery();
rs.next();
cafe_book_count_grade = rs.getInt(1);
}
catch (Exception e)
{
out.println(e);
}
finally
{
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 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_qcif.css" rel="stylesheet" type="text/css" >
</head>
<body>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="8" height="19" 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>
<tr>
<td height="9" colspan="2"></td>
</tr>
<tr>
<td colspan="2" align="center">
<font color="#909090">墨抛绊府甫<br>
急琶窍矫搁 弊 墨抛绊府狼 珐欧阑<br>
焊角 荐 乐绢夸~ </font>
</td>
</tr>
<tr>
<td height="5" colspan="2" align="center"></td>
</tr>
<tr>
<td colspan="2" align="center">
<form name="form" method="post" action="<%=url_path%>/ranking/ranking_caferanking.jsp">
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<input type="hidden" name="cafe_idx" value="<%=cafe_idx%>">
<table width="120" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center">
<select name="cafe_category1" >
<option value=0 selected>墨其珐欧</option>
</select>
</td>
<td width="34" height="20" align="center" bgcolor="#FFAEC5"><font color="#FFFFFF"><a href="javascript:form.submit()">焊扁</a></font></td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td height="10" colspan="2"></td>
</tr>
<tr>
<td height="36" colspan="2" align="center" bgcolor="#FFE0E4">
<font color="#FF4759"><<a href="<%=url_path%>/cafe/cafe_master.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&cafe_idx=<%=cafe_idx%>"><%=cafe_name%></a>>墨其狼<br>
墨其 珐欧 涝聪促. </font>
</td>
</tr>
<tr>
<td height="3" colspan="2"></td>
</tr>
<tr>
<td colspan="2">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="3" colspan="3" bgcolor="#E1EEF1"></td>
<td width="3" rowspan="3"> </td>
<td width="119" rowspan="3" align="center" bgcolor="#E1EEF1">
<table width="110" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="98" height="16"><font color="#7C8889">雀盔炉 </font></td>
<td><img src="<%=img_path%>images/202img/202_ranking/medal_2.png" width="11" height="14" align="absmiddle"></td>
</tr>
<tr>
<td height="16" colspan="2"><font color="#FF4759"><%=cafe_join_number_grade%>困</font> 雀盔 <%=cafe_join_number%>疙 </td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="3" bgcolor="#E1EEF1"> </td>
<td width="48"><img src="<%=img_path%>images/202img/202_cafe/cafe_s_0<%=cafe_back_img%>_<%=category_idx%>.png" width="48" height="41"></td>
<td width="3" bgcolor="#E1EEF1"> </td>
</tr>
<tr>
<td height="3" colspan="3" bgcolor="#E1EEF1"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="3" colspan="2"></td>
</tr>
<tr>
<td colspan="2">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="3" colspan="3" bgcolor="#E1EEF1"></td>
<td width="3" rowspan="3"> </td>
<td width="119" rowspan="3" align="center" bgcolor="#E1EEF1">
<table width="110" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="16"><font color="#7C8889">霸矫炉</font></td>
</tr>
<tr>
<td height="16"><font color="#FF4759"><%=cafe_book_count_grade%>困</font> 霸矫臂 <%=cafe_book_count%>扒 </td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="3" bgcolor="#E1EEF1"> </td>
<td width="48"><img src="<%=img_path%>images/202img/202_cafe/cafe_s_0<%=cafe_back_img%>_<%=category_idx%>.png" width="48" height="41"></td>
<td width="3" bgcolor="#E1EEF1"> </td>
</tr>
<tr>
<td height="3" colspan="3" bgcolor="#E1EEF1"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="3" colspan="2"></td>
</tr>
<tr>
<td height="16" colspan="2" align="center" bgcolor="#FFE0E4"><font color="#FF6780">1</font> </td>
</tr>
<tr>
<td height="3" colspan="2"></td>
</tr>
<tr>
<td colspan="2" align="center">
<table width="85" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="14" align="center" bgcolor="#FF8EAB"><font color="#FFFFFF"><a href="<%=link2%>">鸥款珐欧权栏肺</a></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="11" colspan="2"></td>
</tr>
</table>
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone;//权
String step2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;//珐欧皋牢
%>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="15">
<td width="7" bgcolor="#BBC7C8"></td>
<td width="162" bgcolor="#DAE6E8"> <a href="<%=step1%>">权</a> > <a href="<%=step2%>">鸥款珐欧</a> > 墨其珐欧 </td>
<td width="7" bgcolor="#BBC7C8"></td>
</tr>
</table>
<%@ include file="../newbottom.jsp"%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -