📄 game_today_star.jsp
字号:
<!--------------------------------------------------------------------------------------------------------------
*@霸烙皋牢>坷疵狼霸烙驱己
*@Author : 冠惑辣(2007-12-23)
*@Images : 其捞瘤 救俊 甸绢啊绰 捞固瘤
1) temp_01.png : 咯磊酒官鸥 捞固瘤
2) dot_01.png : 俏农祸 档飘
--------------------------------------------------------------------------------------------------------------->
<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.Vector, 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"%>
<%
/***********************************************************************
@ Page Description
霸烙_风虐
@ Parameter
***********************************************************************/
/*------------------------------------------------------------------------------------------------------
+ 扁夯 颇扼固磐
-------------------------------------------------------------------------------------------------------*/
String mphone= request.getParameter("mphone");
String gphone= request.getParameter("gphone");
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
String phonenum = null;
String nickname = null;
int sex = 0;
int up_grade = 0;
String regdate = "";
String oldregdate = "";
String nowregdate = "";
/*------------------------------------------------------------------------------------------------------
+ DB 包访 函荐
-------------------------------------------------------------------------------------------------------*/
PreparedStatement pstmt = null;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;// 其捞瘤 备泅 眠啊 函荐 ---------
String query1 = null;
/*------------------------------------------------------------------------------------------------------
+ 朝楼 包访
-------------------------------------------------------------------------------------------------------*/
Timestamp di_date=null;
Date today = new Date();
SimpleDateFormat timeform;
timeform = new SimpleDateFormat("MM/dd");
/*------------------------------------------------------------------------------------------------------
+ 其捞瘤 备泅 眠啊 函荐
-------------------------------------------------------------------------------------------------------*/
int pagesize = 4; // 茄其捞瘤寸 10俺 免仿拱
int pageNUM=1; // 其捞瘤 锅龋
int pagecount=1 ; // 其捞瘤 肮荐 瘤沥 函荐
int absolutepage=0; // 例措 困摹 其捞瘤 锅龋
int dbcount=0 ; // DB 救俊 臂 肮荐 历厘 函荐
int isNoPage = 0; //茄俺档 绝蠢衬.. 绝栏搁0, 乐栏搁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;
}
}
// 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 ===========================
//其捞隆-----------------------------------------------------
stmt = con.createStatement();
pageset = stmt.executeQuery("select count(rookie_idx) from GT_gamerookie");
if(pageset.next()){
dbcount = pageset.getInt(1); // 臂 醚 肮荐
pageset.close();
}
if(dbcount%pagesize == 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(pageset != null) pageset.close();
//其捞隆场-----------------------------------------------------
%>
<html>
<head>
<title>霸烙_风虐</title>
<link href="mobile.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="17">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="11" bgcolor="#6a76f2"></td>
<td width="165" bgcolor="#6a76f2"><b><font color="#9fb7f8">:::</font> <font color="#ffffff">坷疵狼 霸烙驱己</font></b></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="10"></td>
</tr>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="176" align="center"><font color="#616667">霸烙鉴困啊 酒林 付聪付聪 坷弗<br>公丰霸烙鸥款俊辑 急沥茄 弥绊狼<br><b><font color="#ff672c">风虐巢赤</font></b>模备甸 涝聪促.</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="12"></td>
</tr>
<!-- 府胶飘 矫累 -->
<%
query1 = "SELECT TOP " + pagesize + " phonenum,nickname,sex,up_grade,regdate FROM GT_gamerookie ";
query1 = query1 + " WHERE rookie_idx not in ";
query1 = query1 + "(SELECT TOP " + absolutepage + " rookie_idx FROM GT_gamerookie";
query1 = query1 + " ORDER BY rookie_idx desc, sex asc) order by rookie_idx desc, sex asc";
//out.println(query1);
rs=stmt.executeQuery(query1);
nowregdate = timeform.format(today);
while(rs.next())
{
phonenum = rs.getString(1);
nickname = rs.getString(2);
sex = rs.getInt(3);
up_grade = rs.getInt(4);
regdate = timeform.format(rs.getTimestamp(5));
%>
<%
String bgColor = "#dae6e8";
String bgColor2 = "#6a76f2";
if(regdate.equals(nowregdate))
{
bgColor = "#fff999";
bgColor2 = "#ff4759";
}
if(!regdate.equals(oldregdate))
{
%>
<tr>
<td height="17">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="11" bgcolor="<%=bgColor2%>"></td>
<td width="165" bgcolor="<%=bgColor2%>"><b><font color="#9fb7f8">:::</font> <font color="#ffffff">
<% if(regdate.equals(nowregdate)) out.println("TODAY"); else out.println(regdate); %>
</font></b></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="4"></td>
</tr>
<%
oldregdate = regdate;
}
%>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0">
<tr height="60">
<td width="176" bgcolor="<%=bgColor%>">
<table border="0" cellpadding="0" cellspacing="0">
<tr height="3">
<td width="3"></td>
<td width="48"></td>
<td width="3"></td>
<td width="3" bgcolor="#ffffff" ></td>
<td width="3"></td>
<td width="95"></td>
</tr>
<tr height="54">
<td width="3"></td>
<td width="48"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=phonenum%>&gphone=<%=phonenum%>" width="48" height="54" border="0"></td>
<td width="3"></td>
<td width="3" bgcolor="#ffffff" height="54"></td>
<td width="3"></td>
<td width="95"><font color="#5e6364"><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=phonenum%>"><%=nickname%></a></font><br><b><font color="<%=bgColor2%>"><%=up_grade%>困 惑铰</font></b></td>
</tr>
<tr height="3">
<td width="3"></td>
<td width="48"></td>
<td width="3"></td>
<td width="3" bgcolor="#ffffff" ></td>
<td width="3"></td>
<td width="95"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="6"></td>
</tr>
<%
}
if(rs != null) rs.close();
if(pstmt != null) pstmt.close();
if(stmt != null) stmt.close();
if(con != null) con.close();
}
catch(Exception e)
{
out.println(e);
}
finally
{
if(rs != null) try{ rs.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" bgcolor="#e5ecff" align="center">
<%
String pageurl = url_path+"/ranking/game_today_star.jsp?mphone="+mphone+"&gphone="+gphone;
out.println(pagePath(pageurl, dbcount, pageNUM, pagecount));
%>
</td>
</tr>
<tr>
<td height="7"></td>
</tr>
<tr>
<td align="center">
<table border="0" cellpadding="0" cellspacing="0">
<tr height="17">
<td width=""></td>
<td width="79" bgcolor="#a8bfff" align="center"><a href="<%=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&linkFlag=0"%>"><font color="#ffffff">霸烙皋牢啊扁</font></a></td>
<td width=""></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="13"></td>
</tr>
</table>
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+mphone;//权
String step2=url_path+"/ranking/game.jsp?mphone="+mphone+"&gphone="+gphone+"&linkFlag=0";//霸烙皋牢
%>
<table cellpadding="0" cellspacing="0" width="176" height="19">
<tr>
<td width="10" bgcolor="#BDC7CE"> </td>
<td width="156" bgcolor="#DEE7EF"><a href="<%=step1%>">权</a>><a href="<%=step2%>">霸烙皋牢</a>>坷疵狼霸烙驱己</td>
<td width="10" bgcolor="#BDC7CE"> </td>
</tr>
</table>
<%@ include file="../newbottom.jsp"%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -