?? ranking_myknowranking.jsp.svn-base
字號(hào):
<!--------------------------------------------------------------------------------------------------------------
*@鷗款琺歐>瘤僥琺歐>穿利磊腳
*@Author : 冠惑辣(2007-10-24)
*@Images : 其撈瘤 救俊 甸絹啊綽 撈固瘤
1) bg_01.png - 拋撈喉 彌惑竄 硅版撈固瘤
2) tab_01.png - 坷疵,林埃,穿利 滾瓢 劇糠 角急釬矯
3) tab_02.png - 俏農(nóng)禍 痢急扼牢 釬矯
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;
}
// 其撈瘤 URL , 醚飯內(nèi)靛 墨款飄, 泅犁其撈瘤 逞滾, 醚墨款飄
public static String pagePathRanking(String pageurl,int dbcount, int pageNUM, int pagecount)
{
String pagePathStr = "";
if(dbcount > 0)
{
// [撈傈] 傅農(nóng) 眠啊竅扁
if (pageNUM>1)
{
pagePathStr += "⒏<a href="+"'"+pageurl+"&pageNUM="+(pageNUM-1)+"'"+" accesskey=7 >(7) 撈傈</a> ";
}
else
{
pagePathStr += "⒏(7) 撈傈";
}
// 其撈瘤 泅犁 困摹
// pagePathStr += pageNUM+"/"+pagecount;
//[促瀾] 傅農(nóng) 眠啊
if(pageNUM<pagecount)
{
pagePathStr += " <a href="+"'"+pageurl+"&pageNUM="+(pageNUM+1)+"'"+" accesskey=9 >促瀾 (9)</a>⒑";
}
else
{
pagePathStr += "促瀾 (9)⒑";
}
}
else
pagePathStr += "⒏(7) 撈傈 促瀾 (9)⒑";
return pagePathStr;
}
%>
<%
//牢磊藹==================================================================
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")); }
//==========================================================================
Connection con = null;
PreparedStatement pstmt=null;
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;
PreparedStatement pstmt2=null;
ResultSet rs2 = null;
String query2 = null;
// int maxRank = 300; //300困鱉瘤 八禍
int cnt = 0;
int rankCnt = 0;//鑒困 釬矯
String query1=null;
String dateColName = null;//函版 拿煩 撈撫
//郴 拿煩 歷厘 函薦
int myranker_idx = 0;
int mygong_cnt = 0;
String mycalumCnt = null;
String mynikename = "Guest";
String myphonenum = null;
int myrankCnt = 0;
//阿 拿煩 歷厘 函薦
String nikename = null;
String calumCnt = null;
String phonenum = null;
// 其撈瘤 備泅 眠啊 函薦 =====================
int pagesize = 5; // 茄其撈瘤寸 4俺 免仿拱
int pageNUM=1; // 其撈瘤 鍋齲
int pagecount=1 ; // 其撈瘤 骯薦 瘤瀝 函薦
int absolutepage=0; //例措 困摹 其撈瘤 鍋齲
int dbcount=0 ; // DB 救俊 臂 骯薦 歷厘 函薦
//============================================
String link2=url_path+"/ranking/ranking_main.jsp?mphone="+mphone+"&gphone="+mphone;//鷗款琺歐啪
//鷗款琺歐 皋春 傅農(nóng)=====
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";//墨其
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 = "kthema_cnt_day";
else//翠函爐
dateColName = "kthema_re_cnt_day";
break;
case 2://林埃
if(rankType == 1)
dateColName = "kthema_cnt_week";
else
dateColName = "kthema_re_cnt_week";
break;
case 3://
if(rankType == 1)
dateColName = "kthema_cnt";
else
dateColName = "kthema_re_cnt";
break;
}
%>
<html>
<head>
<title>瘤僥琺歐(my)</title>
<link href="mobile.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<!-- 惑竄 官 -->
<table width="240" 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="240"><font color="#ffffff"> 瘤僥琺歐</font></td>
</tr>
</table>
<!-- 惑竄 官 場(chǎng) -->
</td>
</tr>
<tr>
<td height="12"></td>
</tr>
<tr>
<td align="center"><font color="#909090">墨拋絆府甫 急琶竅矯擱<br>弊 墨拋絆府狼 琺歐闌 焊角 薦 樂(lè)絹夸~<br><!--∝ 300困鼻 觀籃 焊咯瘤瘤 臼嚼聰促--></font></td>
</tr>
<tr>
<td height="12"></td>
</tr>
<tr>
<td width="240">
<form name="form" method="post" action="<%=url_path%>/ranking/ranking_myknowranking.jsp">
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<table width="240" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="58"></td>
<td width="90" 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="34" bgcolor="#ffaec5" align="center"><font color="#ffffff"><a href="javascript:form.submit()">焊扁</a></font></td>
<td width="58"></td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td height="8"></td>
</tr>
<tr>
<td height="49" bgcolor="#ff9dac" align="center"><font color="#ffffff">
<%
if(rankType == 1)//雀盔爐
out.println("龍鞏爐籃 啊厘 腹籃<br>龍鞏闌 棵赴 雀盔琺歐 澇聰促.");
else//霸矯爐
out.println("翠函爐籃 啊厘 腹籃 翠函 盲琶闌<br>罐籃 雀盔琺歐 澇聰促.");
%>
</font></td>
</tr>
<tr>
<td width="240" height="2" background="<%=img_path%>images/ranking/tab_02.png"></td>
</tr>
<tr>
<td height="15"></td>
</tr>
<tr>
<td width="240">
<%
String datePath = url_path+"/ranking/ranking_myknowranking.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType="+rankType+"&dateFlag=";
%>
<table align="center" border="0" cellpadding="0" cellspacing="0" width="240"><tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="240">
<tr height="1">
<td width="37"></td>
<td width="166" bgcolor="#909090"></td>
<td width="37"></td>
</tr>
<tr>
<td align="center" colspan="3">
<table border="0" cellpadding="0" cellspacing="0" width="167">
<tr height="18">
<td width="1" bgcolor="#909090"></td>
<% if(dateFlag != 1){%>
<td width="54" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=datePath%>1"><font color="#606060">坷疵</font></a>
</td>
<% }else{ %>
<td width="54" bgcolor="#ffffff" align="center" valign="middle">
<font color="#606060">坷疵</font>
</td>
<% } %>
<td width="1" bgcolor="#909090"></td>
<% if(dateFlag != 2){%>
<td width="54" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=datePath%>2"><font color="#606060">林埃</font></a>
</td>
<% }else{ %>
<td width="54" bgcolor="#ffffff" align="center" valign="middle">
<font color="#606060">林埃</font>
</td>
<% } %>
<td width="1" bgcolor="#909090"></td>
<% if(dateFlag != 3){%>
<td width="54" bgcolor="#ffa7b5" align="center" valign="middle">
<a href="<%=datePath%>3"><font color="#606060">穿利</font></a>
</td>
<% }else{ %>
<td width="54" 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="240" bgcolor="#909090" colspan="3"></td>
</tr>
</table>
</td>
</tr>
</tbody></table>
</td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="5" align="center"><a href="<%=url_path%>/ranking/ranking_knowrank.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&rankType=<%=rankType%>&dateFlag=<%=dateFlag%>"><font color="#FF9DAC">惑困</font></a><font color="#FF9DAC"> | </font><font color="#F60000">磊腳</font></td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="5"></td>
</tr>
<%
try
{
//=========================== 傍烹函券累訣 : 2008-01-21 ===========================
/**
* 公豐霸烙鷗款 矯膠袍痢八 棺 喉發(fā)蠟歷 八免
*
* @ 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");
// 矯膠袍 痢八 眉農(nóng)
//
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;
}
}
// 喉發(fā)蠟歷牢瘤 眉農(nóng),
//
boolean isBlackUser = DBConnector.chkBlackList( con, SYSTEM_PHONE_NUMBER );
if( isBlackUser )
{
response.sendRedirect(url_path+"/bad_member.jsp"+SYSTEM_PARAMETER_SET);
return;
}
//=========================== 傍烹函券累訣 : 2008-01-21 ===========================
//郴鑒困 備竅扁
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -