📄 ranking_mycaferanking.jsp
字号:
}
}
// 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 ===========================
//郴啊 啊涝茄 墨其荐 备窍扁
query1="select count(cafe_idx) from GT_mycafe where phonenum='"+mphone+"'";
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
if(rs.next())
{
dbcount = mycafeCnt = rs.getInt(1);
mycafe_idx = new int[mycafeCnt];
mycafe_cnt = new String[mycafeCnt];
mycafe_name = new String[mycafeCnt];
}
if(rs != null) rs.close();
if(pstmt != null) pstmt.close();
if(dbcount%pagesize == 0 && dbcount > 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(mycafeCnt > 0)
{
query1="select top "+pagesize+" a.cafe_idx, b."+dateColName+", b.cafe_name from GT_mycafe a inner join GT_cafe b on a.cafe_idx = b.cafe_idx where a.phonenum='"+mphone+"' and a.cafe_idx not in(select top "+absolutepage+" cafe_idx from GT_mycafe where phonenum='"+mphone+"') order by a.cafe_idx desc";
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
cnt = 0;
query1 = "";
while(rs.next())
{
mycafe_idx[cnt] = rs.getInt(1);
if(rankType == 1)
mycafe_cnt[cnt] = "雀盔"+rs.getInt(2)+"疙";
else
mycafe_cnt[cnt] = "霸矫"+rs.getInt(2)+"扒";
mycafe_name[cnt] = rs.getString(3);
query1=query1+"select count(*) from GT_cafe where "+dateColName+" >= (select "+dateColName+" from GT_cafe where cafe_idx="+mycafe_idx[cnt]+") and cafe_idx not in(select cafe_idx from GT_cafe where "+dateColName+" = (select "+dateColName+" from GT_cafe where cafe_idx="+mycafe_idx[cnt]+") and cafe_idx < "+mycafe_idx[cnt]+")";
if(!rs.isLast())
query1=query1+" union all ";
cnt++;
}
if(rs != null) rs.close();
if(pstmt != null) pstmt.close();
}
if(mycafeCnt > 0)
{
%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center">
<%
pageurl=url_path+"/ranking/ranking_mycaferanking.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType="+rankType+"&pageType="+pageType+"&dateFlag="+dateFlag;
out.println(pagePath(pageurl, dbcount, pageNUM, pagecount));
%>
</td>
</tr>
<tr>
<td height="3"></td>
</tr>
<%
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
cnt = 0;
while(rs.next())
{
%>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<!-- 酒官鸥 矫累 -->
<td width="57" align="left" valign="top" bgcolor="#fff999">
<table width="57" height="63" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3" height="3" bgcolor="#fff999"> </td>
<td width="48" bgcolor="#fff999"> </td>
<td width="3" bgcolor="#fff999"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="54" bgcolor="#fff999"></td>
<td width="48" bgcolor="#ffffff"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>" width="48" height="54" border="0"></td>
<td width="3" bgcolor="#fff999"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="3" bgcolor="#fff999"></td>
<td width="48" bgcolor="#fff999"></td>
<td width="3" bgcolor="#fff999"></td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
</table>
</td>
<!-- 酒官鸥 场 -->
<!-- 郴侩 矫累 -->
<td bgcolor="#fff999">
<table border="0" cellspacing="0" cellpadding="0" valign="top">
<tr>
<td width="5"></td>
<td width="89" height="16" valign="top" align="left">
<font color="#ff4759"><%=rs.getInt(1)%>困</font>
</td>
<td width="25"></td>
</tr>
<tr>
<td width="5"></td>
<td width="153" height="15"><a href="<%=url_path%>/cafe/cafe_master.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&cafe_idx=<%=mycafe_idx[cnt]%>"><font color="#000000"><%=mycafe_name[cnt]%></font></a></td>
<td width="25"></td>
</tr>
<tr>
<td width="5"></td>
<td width="153" height="15"><font color="#7c8889"><%=mycafe_cnt[cnt]%></font></td>
<td width="25"></td>
</tr>
</table>
</td>
<!-- 郴侩 场 -->
</tr>
</table>
</td>
</tr>
<tr>
<td height="3"></td>
</tr>
<%
cnt++;
}
%>
<!-- 1锅掳 府胶飘 场 -->
<tr height="19">
<td bgcolor="#FFe0e4" align="center">
<%
out.println(pagePath(pageurl, dbcount, pageNUM, pagecount));
%>
</td>
</tr>
<%
}
else
{
%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f">钎矫且 郴侩捞 绝嚼聪促.</font></td>
</tr>
<%
}
if(rs != null) rs.close();
if(pstmt != null) pstmt.close();
}
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){}
}
%>
<tr>
<td height="19"></td>
</tr>
<tr>
<td align="center"><b><a href="<%=goMyLink%>"><font color="#ff4759">牢拱珐欧</font></a><font color="#ff4759"> | </font><a href="<%=goCafeLink%>"><font color="#ff4759">墨其珐欧</font></a></b></td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td align="center"><b><a href="<%=goKnowLink%>"><font color="#ff4759">瘤侥珐欧</font></a><font color="#ff4759"> | </font><a href="<%=goGongLink%>"><font color="#ff4759">傍皑珐欧</font></a><font color="#ff4759"> | </font><a href="<%=goGameLink%>"><font color="#ff4759">霸烙珐欧</font></a></b></td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr align="center">
<td>
<table width="176" border="0" cellpadding="0" cellspacing="0">
<tr height="16">
<td width="47"></td>
<td width="85" bgcolor="#FF8EAB" align="center"><font color="#FFFFFF">
<a href="<%=link2%>">
<%
if(pageType == 0)
{
out.println("鸥款珐欧权栏肺");
}
else
{
out.println("倒酒啊扁");
}
%>
</a>
</font></td>
<td width="47"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="11"></td>
</tr>
</table>
<!-- 窍窜 匙厚霸捞记 -->
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td bgcolor="#DAE6E8">
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr height="15">
<td>
<%
if(pageType == 0)
{
%>
<a href="<%=url_path%>/main.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>">权</a> >
<a href="<%=url_path%>/ranking/ranking_main.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>">鸥款珐欧</a> > 墨其珐欧
<%
}
else
{
%>
<a href="<%=url_path%>/main.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>">权</a> >
<a href="<%=url_path%>/cafe/cafe_town_main.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>">鸥款墨其</a> > 牢扁墨其
<%
}
%>
</td>
</tr>
</table>
</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
<%@ include file="../newbottom.jsp"%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -