- 技术人生
- JSP分页代码
<
%@ page
import
="java.sql.*"
%
>
<
%@ page
import
="java.io.*"
%
>
<
%@ page
import
="java.util.*"
%
>
<
jsp:useBean
id
="sqlconn"
scope
="page"
class
="kk.database.sqlconn"
/>
<
%! String
aTitle,aAuthor,AType,ArticleType,InsertTime,Color; %
>
<!
DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
>
<
HTML
>
<
HEAD
>
<
TITLE
>
ArticleList
</
TITLE
>
<
META
NAME
="Generator"
CONTENT
="jBuilder3.5 && jEdit1.0"
>
<
META
NAME
="Author"
CONTENT
="bigangell"
>
<
META
NAME
="Keywords"
CONTENT
="Java,Servlet,Jsp,Beans,PHP"
>
<
META
NAME
="Description"
CONTENT
="A Pure World For Programming Include C/C++,Java"
>
<
META
HTTP-EQUIV
="Content-Type"
CONTENT
="text/html; CHARSET=gb2312"
>
<
link
rel
="stylesheet"
href
="style.css"
>
</
head
>
<
body
bgcolor
="#FFFFFF"
>
<
table
width
="760"
border
="0"
cellspacing
="0"
cellpadding
="0"
align
="center"
>
<
tr
>
<
td
>
<
table
width
="750"
border
="0"
cellspacing
="2"
cellpadding
="2"
align
="center"
>
<
tr
align
="center"
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
>
<
table
width
="740"
border
="0"
cellspacing
="1"
cellpadding
="1"
align
="center"
>
<
tr
align
="center"
bgcolor
="#CCCCCC"
>
<
td
><
b
>
标题
</
b
></
td
>
<
td
><
b
>
作者
</
b
></
td
>
<
td
><
b
>
类型
</
b
></
td
>
<
td
><
b
>
点击
</
b
></
td
>
<
td
><
b
>
加入时间
</
b
></
td
>
</
tr
>
<
% int
i; int ipage
=10;
//分页单位 int allpage; //总页数 int pages; //接受的页码变量 int cpage
=1;
//当前页 int spage; //开始页 //数据库连接声明 java.lang.String sql,pagesql; java.sql.ResultSet rs,pagers; pagesql
= "select count(a_id) as A from article"
; //取总文章数 pagers
= sqlconn.executeQuery(pagesql);
int allCol
= pagers.getInt("A");
//获得总页面数 allpage
= (int)Math.ceil((allCol
+ ipage-1) / ipage); //判断参数pages是否为空 if (request.getParameter("pages")
==null)
{ pages
=1;
} else { pages
= new
Integer(request.getParameter("pages")).intValue(); } //判断当前页 if(pages
>
allpage // pages == 0){ cpage = 1; } else { cpage = pages; } //判断起始页 spage=(cpage-1)*ipage; sql = "select a_id,a_title,a_author,aID,a_time,a_readtime,sID from article order by a_id desc limit "+ spage +","+ ipage; rs = sqlconn.executeQuery(sql); int cu=1; //循环取数据库值 while (rs.next()) { int aID = rs.getInt("a_id"); aTitle = rs.getString("a_title"); aAuthor = rs.getString("a_author"); int ArticleTypeID = rs.getInt("aID"); int ReadTime = rs.getInt("a_readtime"); InsertTime = rs.getString("a_time"); if (cu % 2 == 0) { Color="#DBECFD"; } else { Color="#C6E1FD"; } switch (ArticleTypeID) { case(1): ArticleType="小说"; break; case(2): ArticleType="散文"; break; case(3): ArticleType="诗歌"; break; case(4): ArticleType="随笔"; break; } %>
<
tr
bgcolor
="<%= Color %>"
>
<
td
width
="300"
><
a
href
="viewarticle.jsp?aID=<%= aID %>"
><
%= aTitle
%
></
a
></
td
>
<
td
align
="center"
width
="100"
><
%= aAuthor
%
></
td
>
<
td
align
="center"
width
="50"
><
%= ArticleType
%
></
td
>
<
td
align
="center"
width
="50"
><
%= ReadTime
%
></
td
>
<
td
align
="center"
width
="240"
><
%= InsertTime
%
></
td
>
</
tr
>
<
% cu
++; } %
>
<
tr
bgcolor
="#CCCCCC"
>
<
td
colspan
="5"
align
="right"
valign
="middle"
>
共
<
%= allCol
%
>
条记录 共
<
%= allpage
%
>
页
<
% if
(cpage
>
1) { %>
<
a
href
="article.jsp?pages=<%= cpage-1 %>"
><
img
src
="images/prev.gif"
border
="0"
></
a
><
% } if
(cpage<allpage) { %
><
a
href
="article.jsp?pages=<%= cpage+1 %>"
><
img
src
="images/next.gif"
border
="0"
></
a
><
% } %
>
/
<
% for
(i
=1;i<=allpage;i++)
{ if (i !
= pages)
{%
><
a
href
="article.jsp?pages=<%= i %>"
><
%= i
%
></
a
>
<
% } }%
></
td
>
</
tr
>
</
table
>
</
td
>
</
tr
>
</
table
>
</
td
>
</
tr
>
</
table
>
</
body
>
</
html
>
