JSP分页代码

最新推荐文章于 2024-08-01 23:36:06 发布

原创最新推荐文章于 2024-08-01 23:36:06 发布 · 2.4k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#jsp #border #table #stylesheet #jbuilder #import

本文介绍了一个使用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>

</head>

<tr>

<td>

</tr>

<tr>

<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>

cu++;

}

</tr>

</table>

</td>

</tr>

</table>

</td>

</tr>

</table>

</body>

</html>