?? elite.jsp
字號:
<link rel=stylesheet href="style.css" type="text/css">
<body bgcolor="#DEDEDE">
<%@ page language="java" import="java.util.*" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="doit" scope="page" class="dbcon.doit" />
<jsp:useBean id="DB" scope="page" class="dbcon.mydb" />
<%
int intPageSize;
int intRowCount;
int intPageCount;
int intPage;
String strPage,strAreaid,strSql="";
String strUser=(String)session.getValue("user");
String strShow=doit.changecode(strUser);
int i,intAreaid;
//取得待顯示頁碼
strPage=(String)request.getParameter("page");
strAreaid=(String)session.getValue("area_id");
if(!strAreaid.equals("0")&&strAreaid!=null)
{intAreaid=java.lang.Integer.parseInt(strAreaid);
strSql="SELECT INT_ID,STR_TITLE,STR_AUTHOR,INT_RPLYNUMB,INT_CLICKNUMB,STR_DATE,INT_TXTLEN,INT_COOL,INT_ICON";
strSql=strSql+" FROM DATA WHERE INT_ROOTID=0 AND INT_AREAID="+intAreaid+" AND INT_COOL=1 ORDER BY INT_ID DESC";
}
else{strSql="SELECT INT_ID,STR_TITLE,STR_AUTHOR,INT_RPLYNUMB,INT_CLICKNUMB,STR_DATE,INT_TXTLEN,INT_COOL,INT_ICON";
strSql=strSql+" FROM DATA WHERE INT_ROOTID=0 and INT_COOL=1 ORDER BY INT_ID DESC";
}
%>
<table border="0" cellpadding="1" cellspacing="0" width="100%">
<tr bgcolor="#cc3333">
<td align="center" nowrap ><font color="#ffffff" face="times new roman" ><strong>Title</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>Author</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>Reply/Click</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>Date</strong></font></td>
</tr>
<jsp:include page=draw_tb.js />
<%
//設置一頁顯示的記錄數
intPageSize = 20;
if(strPage==null){//表明在QueryString中沒有page這一個參數,此時顯示第一頁數據
intPage = 1;
}
else{//將字符串轉換成整型
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}
ResultSet sqlRst=DB.executeQuery(strSql);
//獲取記錄總數
sqlRst.last();
intRowCount = sqlRst.getRow();
//記算總頁數
intPageCount = (intRowCount+intPageSize-1) / intPageSize;
//調整待顯示的頁碼
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount>0){
//將記錄指針定位到待顯示頁的第一條記錄上
int intCurrent=(intPage-1) * intPageSize +1;
if (intCurrent<=1){
sqlRst.beforeFirst();
}else{
sqlRst.absolute(intCurrent-1);
}
//顯示數據
i = 0;
String s1,s2,s3,s4,s5,s6,s7;
String id,icon,area_nick,area_link,cool_flag;
int all,s8,RowCount;
icon="";
s8=1;
all=0;
area_nick="";
area_link="";
RowCount=0;
while(i<intPageSize && sqlRst.next()){
id=sqlRst.getString("INT_ID");
s1=sqlRst.getString("STR_TITLE");
s2=sqlRst.getString("STR_AUTHOR");
s3=sqlRst.getString("INT_RPLYNUMB");
s4=sqlRst.getString("INT_CLICKNUMB");
s5=sqlRst.getString("STR_DATE");
s6="("+(String)sqlRst.getString("INT_TXTLEN")+" Bytes)";
cool_flag=sqlRst.getString("INT_COOL");
icon=sqlRst.getString("INT_ICON");
s1=s1+s6;
out.print("draw_table("+id+",'"+s1+"','"+s2+"',"+s3+","+s4+",'"+s5+"',"+cool_flag+","+icon+","+all+","+s8+",'"+area_nick+"','"+area_link+"');\n");
i++;
}
}
%>
</script>
</table>
<table border="0" width="100%"><tr><td align="left">[Total <%=intPageCount%> Pages]</td><td align="right">
<%if(intPage>1){%><a href="board.jsp?page=<%=intPage-1%>">Previous</a><%}%> Page<font color="red"><%=intPage%></font> <%if(intPage<intPageCount){%><a href="board.jsp?page=<%=intPage+1%>">Next</a><%}%>
</td></tr></table>
<%
sqlRst.close();
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -