?? ranking_myknowranking.jsp
字號:
int myFlag = 0;
query2 = "select ranker_idx, "+dateColName+", nickname from GT_ranker where phonenum='"+mphone+"'";
pstmt2 = con.prepareStatement(query2);
rs2 = pstmt2.executeQuery();
if(rs2.next())
{
myranker_idx = rs2.getInt(1);
mygong_cnt = rs2.getInt(2);
if(rankType == 1)
mycalumCnt = "龍鞏"+rs2.getInt(2)+"痢";
else
mycalumCnt = "翠函"+rs2.getInt(2)+"痢";
mynikename = rs2.getString(3);
myphonenum = mphone;
myFlag = 1;
}
pstmt2.close();
rs2.close();
if(myFlag == 1)
{
query1 = "select count(*) from GT_ranker where "+dateColName+" >= "+mygong_cnt+" and ranker_idx not in(select ranker_idx from GT_ranker where "+dateColName+" = "+mygong_cnt+" and ranker_idx < "+myranker_idx+")";
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
rs.next();
myrankCnt = rs.getInt(1);
pstmt.close();
rs.close();
//霸矯拱 骯薦 備竅扁
// int pluse = 0;
// query1="select count(*) from GT_ranker where phonenum <> '"+mphone+"'";
query1="select count(*) from GT_ranker";
stmt = con.createStatement();
pageset = stmt.executeQuery(query1);
if(pageset.next())
{
dbcount = pageset.getInt(1); //臂 醚 骯薦
// if(dbcount > maxRank)
// dbcount = maxRank;
pageset.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"));//瘤瀝等 其撈瘤 焊咯林扁
}
else//其撈瘤 絕撈 立加(彌檬 立加撈促)
{
if(myrankCnt%pagesize == 0)
pageNUM=myrankCnt/pagesize;//瘤瀝等 其撈瘤 焊咯林扁
else
pageNUM=myrankCnt/pagesize+1;//瘤瀝等 其撈瘤 焊咯林扁
}
if(pageNUM > pagecount)//樂綽 其撈瘤 焊促 奴 藹撈 甸絹吭闌 錠 貿府
pageNUM = pagecount;
absolutepage=(pageNUM-1)*pagesize;
// 郴 鑒困 第肺綽 1闌 歹茄促.
// if(absolutepage >= myrankCnt)
// pluse = 1;
//傈眉 鑒困 備竅扁
// query1 = "select Top "+pagesize+" "+dateColName+", phonenum,nickname,ranker_idx from GT_ranker where ranker_idx <> "+myranker_idx+" and ranker_idx not in(select Top "+(absolutepage+pluse)+" ranker_idx from GT_ranker order by "+dateColName+" desc, ranker_idx desc) order by "+dateColName+" desc, ranker_idx desc";
query1 = "select Top "+pagesize+" "+dateColName+",phonenum,nickname,ranker_idx from GT_ranker where ranker_idx not in(select Top "+absolutepage+" ranker_idx from GT_ranker order by "+dateColName+" desc, ranker_idx desc) order by "+dateColName+" desc, ranker_idx desc";
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f">
<%
String pageurl=url_path+"/ranking/ranking_myknowranking.jsp?mphone="+mphone+"&gphone="+gphone+"&rankType="+rankType+"&dateFlag="+dateFlag;
out.println(pagePathRanking(pageurl, dbcount, pageNUM, pagecount));
%>
</font></td>
</tr>
<!-- 1鍋擄 府膠飄 矯累 -->
<%
rankCnt = absolutepage+1;
// int pluseflag = 0;
String bgColor = null;
while(rs.next())
{
if(rankType == 1)
calumCnt = "龍鞏"+rs.getInt(1)+"痢";
else
calumCnt = "翠函"+rs.getInt(1)+"痢";
nikename = rs.getString(3);
phonenum = rs.getString(2);
bgColor = "#dae6e8";
if(phonenum.equals(mphone))
bgColor = "#fff999";
// 郴 鑒困 第肺綽 1闌 歹茄促.
// if(rankCnt >= myrankCnt && pluseflag == 0)
// {
// rankCnt++;
// pluseflag = 1;
// }
%>
<tr>
<td height="3"></td>
</tr>
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<!-- 酒官鷗 矯累 -->
<td width="57" align="left" valign="top" bgcolor="<%=bgColor%>">
<table width="57" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3" height="3" bgcolor="<%=bgColor%>"> </td>
<td width="48" bgcolor="<%=bgColor%>"> </td>
<td width="3" bgcolor="<%=bgColor%>"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="54" bgcolor="<%=bgColor%>"></td>
<td width="48" bgcolor="#ffffff"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=phonenum%>&gphone=<%=phonenum%>" width="48" height="54" border="0"></td>
<td width="3" bgcolor="<%=bgColor%>"> </td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td width="3" height="3" bgcolor="<%=bgColor%>"></td>
<td width="48" bgcolor="<%=bgColor%>"></td>
<td width="3" bgcolor="<%=bgColor%>"></td>
<td width="3" bgcolor="#ffffff"> </td>
</tr>
</table>
</td>
<!-- 酒官鷗 場 -->
<!-- 郴儈 矯累 -->
<td bgcolor="<%=bgColor%>">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5" colspan="3"></td>
</tr>
<tr>
<td width="5"></td>
<td width="173" height="14"><font color="#ff4759"><%=rankCnt%>困</font><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=phonenum%>"><font color="#000000"><%=nikename%></font></a>
</td>
<td width="5"></td>
</tr>
<tr>
<td height="5" colspan="3"></td>
</tr>
<tr>
<td width="5"></td>
<td width="173" height="15"><font color="#7c8889"><%=calumCnt%></font></td>
<td width="5"></td>
</tr>
<tr>
<td height="5" colspan="3"></td>
</tr>
</table>
</td>
<!-- 郴儈 場 -->
</tr>
</table>
</td>
</tr>
<%
rankCnt++;
// 茄拌 鑒困甫 逞欄擱 風橇甫 狐柳促.
// if(maxRank < rankCnt)
// break;
}
%>
<!-- 1鍋擄 府膠飄 場 -->
<!-- 郴鑒困
<tr>
<td height="3"></td>
</tr>
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="57" align="left" valign="top" bgcolor="#fff999">
<table width="57" 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=<%=myphonenum%>&gphone=<%=myphonenum%>" 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">
<tr>
<td height="5" colspan="3"></td>
</tr>
<tr>
<td width="5"></td>
<td width="173" height="14"><font color="#ff4759"><%=myrankCnt%>困</font><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=myphonenum%>"><font color="#000000"><%=mynikename%></font></a>
</td>
<td width="5"></td>
</tr>
<tr>
<td height="5" colspan="3"></td>
</tr>
<tr>
<td width="5"></td>
<td width="173" height="15"><font color="#7c8889"><%=mycalumCnt%></font></td>
<td width="5"></td>
</tr>
<tr>
<td height="5" colspan="3"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<!-- 郴鑒困 -->
<tr>
<td height="3"></td>
</tr>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f">
<%
out.println(pagePathRanking(pageurl, dbcount, pageNUM, pagecount));
%>
</font></td>
</tr>
<%
}
else
{
%>
<tr height="19">
<td bgcolor="#FFe0e4" align="center"><font color="#ff586f">
秦寸格廢撈 絕嚼聰促
</font></td>
</tr>
<%
}
}
catch (Exception e)
{
out.println(e);
}
finally
{
if(pstmt2 != null) try{ pstmt2.close(); }catch(Exception se){}
if(rs2 != null) try{ rs2.close(); }catch(Exception se){}
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="17"></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="4"></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="240" border="0" cellpadding="0" cellspacing="0">
<tr height="17">
<td width="106" bgcolor="#FF8EAB" align="center"><font color="#FFFFFF"><a href="<%=url_path+"/kthema/kthema_main.jsp?mphone="+mphone+"&gphone="+gphone%>">瘤僥堡厘權欄肺</a></font></td>
<td width="20"></td>
<td width="106" bgcolor="#FF8EAB" align="center"><font color="#FFFFFF"><a href="<%=link2%>">鷗款琺歐權欄肺</a></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="11"></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="240" 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="19">
<td><a href="<%=step1%>">權</a> > <a href="<%=step2%>">鷗款琺歐</a> > <%=mynikename%>叢狼 琺歐</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 + -