📄 ranking_mycaferanking.jsp
字号:
<!--------------------------------------------------------------------------------------------------------------
*@鸥款珐欧>墨其珐欧>雀盔炉>坷疵磊脚
*@Author : 冠惑辣(2007-10-30)
*@Images : 其捞瘤 救俊 甸绢啊绰 捞固瘤
1) bg_01.png - 抛捞喉 弥惑窜 硅版捞固瘤
2) tab_01.png - 坷疵,林埃,穿利 滚瓢 剧糠 角急钎矫
3) tab_02.png - 俏农祸 痢急扼牢 钎矫
4) temp_02.png - 沥荤阿屈 某腐磐 弊覆
5) ico_01.png - 坷疵滚瓢 厚劝己 酒捞能
6) ico_02.png - 坷疵滚瓢 劝己 酒捞能
7) ico_03.png - 林埃滚瓢 厚劝己 酒捞能
8) ico_04.png - 林埃滚瓢 劝己 酒捞能
9) ico_05.png - 穿利滚瓢 厚劝己 酒捞能
10) ico_06.png - 穿利滚瓢 劝己 酒捞能
--------------------------------------------------------------------------------------------------------------->
<%@ 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="../common_func.jsp"%>
<%!
public static String isNull(String str)
{
if (str == null)
return "";
else
return str;
}
%>
<%
//牢磊蔼==================================================================
String mphone = request.getParameter("mphone");
String gphone = request.getParameter("gphone");
int rankType=Integer.parseInt(request.getParameter("rankType"));//雀盔炉 1, 霸矫炉 2.
int dateFlag = 1;//坷疵 1, 林埃 2, 穿利 3
if(!isNull(request.getParameter("dateFlag")).equals("")){ dateFlag= Integer.parseInt(request.getParameter("dateFlag")); }
int pageType = 0;//绢叼辑 吭绰瘤(珐欧, 墨其)
if(!isNull(request.getParameter("pageType")).equals("")){ pageType= Integer.parseInt(request.getParameter("pageType")); }
//==========================================================================
Connection con = null;
PreparedStatement pstmt=null;
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;
int maxRank = 300; //300困鳖瘤 八祸
int [] mycafe_idx = null;//郴墨其 格废
String [] mycafe_cnt = null;//啊涝磊荐, 霸矫拱荐
String [] mycafe_name = null;//墨其 捞抚
int mycafeCnt = 0;//郴 墨其 肮荐
int cnt = 0;
int rankCnt = 0;//鉴狼 钎矫
String query1=null;
String dateColName = null;//函版 拿烦 捞抚
//阿 拿烦 历厘 函荐
int cafe_idx = 0;
String cafe_name = null;
String cafe_intro = null;
String calumCnt = null;
String cafe_phonenum = null;
// 其捞瘤 备泅 眠啊 函荐 =====================
int pagesize = 5; // 茄其捞瘤寸 5俺 免仿拱
int pageNUM=1; // 其捞瘤 锅龋
int pagecount=1 ; // 其捞瘤 肮荐 瘤沥 函荐
int absolutepage=0; //例措 困摹 其捞瘤 锅龋
int dbcount=0 ; // DB 救俊 臂 肮荐 历厘 函荐
//============================================
//登倒酒哎 傅农
String link2=null;
String pageurl=null;
if(pageType == 0)
link2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;
else
link2=url_path+"/cafe/cafe_town_main.jsp?mphone="+mphone+"&gphone="+mphone;
//鸥款珐欧 皋春 傅农=====
String goGameLink =url_path+"/ranking/ranking_game.jsp?mphone="+mphone+"&gphone="+gphone;//霸烙珐欧
String goMyLink =url_path+"/ranking/ranking_people.jsp?mphone="+mphone+"&gphone="+gphone+"&subto=1";//myranking
String goCafeLink =url_path+"/ranking/ranking_mycaferanking.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1&pageType="+pageType;//墨其
String goKnowLink =url_path+"/ranking/ranking_myknowranking.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1";//瘤侥
String goGongLink =url_path+"/ranking/ranking_mygongamranking.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType=1";//傍埃
//===================================
//辆幅喊 拿烦 搬沥
switch(dateFlag)
{
case 1://老埃
if(rankType == 1)//雀盔炉
dateColName = "cafe_join_number_day";
else//霸矫炉
dateColName = "cafe_book_count_day";
break;
case 2://林埃
if(rankType == 1)
dateColName = "cafe_join_number_week";
else
dateColName = "cafe_book_count_week";
break;
case 3://
if(rankType == 1)
dateColName = "cafe_join_number";
else
dateColName = "cafe_book_count";
break;
}
%>
<html>
<head>
<title>墨其珐欧(my)</title>
<link href="mobile.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<!-- 惑窜 官 -->
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="<%=img_path%>images/ranking/bg_01.png" width="8" height="19"></td>
<td background="<%=img_path%>images/ranking/bg_01.png" width="176"><font color="#ffffff">墨其珐欧</font></td>
</tr>
</table>
<!-- 惑窜 官 场 -->
</td>
</tr>
<tr>
<td height="9"></td>
</tr>
<tr>
<td align="center"><font color="#909090">墨抛绊府甫 急琶窍矫搁 弊<br>墨抛绊府狼 珐欧阑 焊角 荐 乐绢夸~<br>∝300困鼻 观篮 焊咯瘤瘤 臼嚼聪促</font></td>
</tr>
<tr>
<td height="8"></td>
</tr>
<tr>
<td width="176">
<form name="form" method="post" action="<%=url_path%>/ranking/ranking_mycaferanking.jsp">
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<input type="hidden" name="pageType" value="<%=pageType%>">
<table width="176" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="39"></td>
<td width="69" align="center">
<select name="rankType" size="1">
<option value=1 <% if(rankType==1) out.println("selected"); %>>雀盔炉</option>
<option value=2 <% if(rankType==2) out.println("selected"); %>>霸矫炉</option>
</select>
</td>
<td width="30" bgcolor="#ffaec5" align="center"><a href="javascript:form.submit()"><font color="#ffffff">焊扁</font></a></td>
<td width="38"></td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td height="6"></td>
</tr>
<tr>
<td height="6" bgcolor="#ff9dac"></td>
</tr>
<tr>
<td bgcolor="#ff9dac" align="center"><font color="#ffffff">
<%
if(rankType == 1)//雀盔炉
out.println("雀盔炉篮 雀盔荐啊 腹篮<br>墨其珐欧涝聪促.");
else//霸矫炉
out.println("霸矫炉篮 霸矫拱荐啊 腹篮<br>墨其珐欧涝聪促.");
%>
</font></td>
</tr>
<tr>
<td height="6" bgcolor="#ff9dac"></td>
</tr>
<tr>
<td width="176" height="2" background="<%=img_path%>images/ranking/tab_02.png"></td>
</tr>
<tr>
<td height="11"></td>
</tr>
<!-- 坷疵滚瓢 劝己拳 -->
<tr>
<td width="176">
<%
String datePath = url_path+"/ranking/ranking_mycaferanking.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType="+rankType+"&pageType="+pageType+"&dateFlag=";
%>
<table align="center" border="0" cellpadding="0" cellspacing="0" width="176"><tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="176">
<tr height="1">
<td width="20"></td>
<td width="136" bgcolor="#909090"></td>
<td width="20"></td>
</tr>
<tr>
<td align="center" colspan="3">
<table border="0" cellpadding="0" cellspacing="0" width="137">
<tr height="18">
<td width="1" bgcolor="#909090"></td>
<% if(dateFlag != 1){%>
<td width="44" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=datePath%>1"><font color="#606060">坷疵</font></a>
</td>
<% }else{ %>
<td width="44" bgcolor="#ffffff" align="center" valign="middle">
<font color="#606060">坷疵</font>
</td>
<% } %>
<td width="1" bgcolor="#909090"></td>
<% if(dateFlag != 2){%>
<td width="44" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=datePath%>2"><font color="#606060">林埃</font></a>
</td>
<% }else{ %>
<td width="44" bgcolor="#ffffff" align="center" valign="middle">
<font color="#606060">林埃</font>
</td>
<% } %>
<td width="1" bgcolor="#909090"></td>
<% if(dateFlag != 3){%>
<td width="44" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=datePath%>3"><font color="#606060">穿利</font></a>
</td>
<% }else{ %>
<td width="44" bgcolor="#ffffff" align="center" valign="middle">
<font color="#606060">穿利</font>
</td>
<% } %>
<td width="1" bgcolor="#909090"></td>
</tr>
</table>
</td>
</tr>
<tr height="1">
<td width="176" bgcolor="#909090" colspan="3"></td>
</tr>
</table>
</td>
</tr>
</tbody></table>
</td>
</tr>
<tr>
<td height="4"></td>
</tr>
<tr>
<td align="center"><a href="<%=url_path%>/ranking/ranking_cafe.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&rankType=<%=rankType%>&pageType=<%=pageType%>&dateFlag=<%=dateFlag%>"><font color="#FF9DAC">惑困</font></a><font color="#FF9DAC"> | </font><font color="#F60000">磊脚</font></td>
</tr>
<tr>
<td height="8"></td>
</tr>
<!-- 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;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -