目录
前言:
本篇,是依据所做练习项目阐述项目中数据分页基本原理,目的是今后复习所用,所以您可能在阅读代码时有些地方难以理解。但基本原理大致方法不变。若有基础,我相信凭您聪明才智,可轻易懂得其中所写。
分页原理:
将查询数据与分页设置相互结合,通过SQL语句中Limit方法进行查询限制。
SQL语句:String sql="select * from news where ntid=? ORDER BY nmodifyDate desc limit ?,?";
Object[] param={i,page.getStartRow(),page.getPageSize()};
//ntid是新闻栏目id,nmodifyDate是根据修改时间排序
完整查询所需具备:
1、分页实体类;2、查询数据实体类;3、数据显示页面(JSP页面);4、servlet逻辑处理层
实体类代码:
package org.news.entity;
public class Paging {
private int totalCount;//总记录数
private int totalPage;//总页数
private int pageSize=30;//每页显示数据
private int currentPage;//当前页
private int startRow;//开始行
public int getTotalCount() {
return totalCount;
}
public void setTotalCount(int totalCount) {
this.totalCount = totalCount;
}
//总页数=总数据/每页显示数据
public int getTotalPage() {
if(this.totalCount%this.pageSize==0) {
this.totalPage=this.totalCount/this.pageSize;
}else {
this.totalPage=(this.totalCount/this.pageSize)+1;
}
return totalPage;
}
public void setTotalPage(int totalPage) {
this.totalPage = totalPage;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getCurrentPage() {
return currentPage;
}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;
}
//查询开始行=(当前页-1)*页面显示条数
public int getStartRow() {
this.startRow=(this.currentPage-1)*this.pageSize;
return startRow;
}
public void setStartRow(int startRow) {
this.startRow = startRow;
}
}
JSP页面实现代码:
<p align="right">
//通过EL表达式获取域内分页实体类 获取当前页和总页数数据
当前页数:[${pags.getCurrentPage()}/${pags.getTotalPage()}]
//当点击上下一页时,把当前页数据-或+1到servlet进行处理
<a href="${pageContext.request.contextPath}/NewServlet?type=listAll¤tPage=${pags.getCurrentPage()+1}&ntid=${ntid}">下一页</a>
//末页可把当前页设置为总页数
<a href="#">末页</a> </p>
Servlet数据处理代码:
response.setContentType("text/html;charset=UTF-8");
NewsService nser = new NewsServiceImpl();
String newsId = request.getParameter("topicId");
int count = nser.getCountByid(Integer.parseInt(newsId));
//承接JSP页面传入数据
String nowPage = request.getParameter("currentPage");
if (nowPage == "" || nowPage == null) {
nowPage = "1";
}
Paging page = new Paging();
//设置当前页
page.setCurrentPage(Integer.parseInt(nowPage));
//设置总记录数
page.setTotalCount(count);
//设置页面数据显示条数
page.setPageSize(10);
//查询根据页面ID和分页数据查新闻
List < News > newsByidList = nser.getNewsByid(Integer.parseInt(newsId), page);
JSONArray jsonArray = new JSONArray();
//把新闻类转存为json对象
for (News ns: newsByidList) {
JSONObject jsona = new JSONObject();
jsona.put("nid", ns.getNid());
jsona.put("ntitle", ns.getNtitle());
jsona.put("date", ns.getNmodifydate());
jsonArray.add(jsona);
}
//数据传输JSon对象
JSONObject jsonr = new JSONObject();
jsonr.put("currentPage", page.getCurrentPage());
jsonr.put("totalPage", page.getTotalPage());
jsonr.put("jsonList", jsonArray);
jsonr.put("pags", page);
//把json数据传入到JSP页面,供调取
response.getWriter().print(jsonr);
//底层补充方法:
public List < News > getNewsByid(int i, Paging page) {
String sql = "select * from news where ntid=? ORDER BY nmodifyDate desc limit ?,?";
Object[] param = {
i,
page.getStartRow(),
page.getPageSize()
};
List < News > newsByid = new ArrayList < News > ();
QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource());
try {
newsByid = qr.query(sql, new BeanListHandler < News > (News.class), param);
} catch(Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return newsByid;
}