java 实现分页_[Java] 一种好的JAVA分页实现

喃都不说了，贴代码，意思都在代码里面了

Page.java //分页类。定义分页字段信息，供前台页面使用

package com.core.common;

import java.util.List;

public class Page {

private int pageIndex;//当前页

private int pageSize;//每页条数

private int totalCount;//符合查询条件总条数

private List pageData;//符合查询条件的列表_注意这里是泛型

private int startRow;//数据库起始记录指针

private int totalPage;//总页数

public Page(int pageIndex, int pageSize){

this.pageIndex = pageIndex <= 0 ? 1 : pageIndex;

this.pageSize = pageSize <= 0 ? 10 : pageSize;

}

public int getPageIndex() {

return pageIndex;

}

public void setPageIndex(int pageIndex) {

this.pageIndex = pageIndex;

}

public int getPageSize() {

return pageSize;

}

public void setPageSize(int pageSize) {

this.pageSize = pageSize;

}

public int getTotalCount() {

return totalCount;

}

public void setTotalCount(int totalCount) {

this.totalCount = totalCount;

}

public List getPageData() {

return pageData;

}

public void setPageData(List pageData) {

this.pageData = pageData;

}

public int getStartRow() {

startRow = (pageIndex-1) * pageSize;

return startRow;

}

public int getTotalPage() {

totalPage = (int) Math.ceil(totalCount/Double.parseDouble(String.valueOf(pageSize)));

return totalPage;

}

}

//分页过程————controller

@RequestMapping(value = {"/order/list"})

//page当前页

//model 查询参数实体

public ModelAndView get_orders(Integer page,B2cOrderModel model){

ModelAndView mv = new ModelAndView();

mv.setViewName("/order_list");

//传递参数分别是:当前页，每页条数，查询参数

Page pageData = orderService.getOrders(getPageIndex(page), ConstantUtil.Page.PAGE_NUM, model);

mv.addObject("pageData", pageData.getPageData());//列表

mv.addObject("totalCount", pageData.getTotalCount());//总条数

mv.addObject("totalPage", pageData.getTotalPage());//总页数

mv.addObject("currentPage", page);//当前页

mv.addObject("pageNav", PageNavUtil.getBluePageNavHtml(getPageIndex(page),

ConstantUtil.Page.PAGE_NUM, pageData.getTotalCount(), ConstantUtil.Page.NAV_NUM));//分页导航

return mv;

}

//分页过程————service

@Override

public Page getOrders(Integer pageIndex, int pageNum, B2cOrderModel model)

{

Page page = new Page(pageIndex, pageNum);

//创建查询条件对象

CriteriaCondition condition = new CriteriaCondition();//封装查询条件的类

condition.setDistinct(false);

condition.setStart(page.getStartRow());

condition.setPageSize(pageNum);

condition.setOrderByClause(" CREATED_DT DESC");

condition.put("postName", model.getPostName());

condition.put("postContactPhone", model.getPostContactPhone());

//查询符合条件的总条数和列表

int totalCount = b2cOrderSourceDao.countByCondition(condition.getCondition());

List pageData = b2cOrderSourceDao.selectByCondition(condition);

//设置分页信息

page.setTotalCount(totalCount);

page.setPageData(pageData);

//返回分页信息对象

return page;

}

//分页过程————mybatis语句

查询条数

select count(*) from 表

查询列表

select

distinct

from b2c_order

order by #{orderByClause}

limit #{start}, #{pageSize}

//结果映射列

//字段列

需要查询出的数据库字段

//查询条件

and 数据库字段名= #{condition.参数字段名}

//分页过程---查询条件封装对象

CriteriaCondition

import java.util.HashMap;

/**

* 公用条件查询类

*/

public class CriteriaCondition

{

/**

* 存放条件查询值

*/

Map condition;

/**

* 是否相异

*/

boolean distinct;

/**

* 排序字段

*/

String orderByClause;

/**

* 分页起始页

*/

Integer start;

/**

* 分页数值

*/

Integer pageSize;

public CriteriaCondition()

{

super();

condition = new HashMap();

}

public CriteriaCondition(String orderByClause, Integer start, Integer pageSize)

{

this.distinct = true;

this.orderByClause = orderByClause;

this.start = start;

this.pageSize = pageSize;

condition = new HashMap();

}

public CriteriaCondition(boolean distinct, String orderByClause, Integer start, Integer pageSize)

{

this.distinct = distinct;

this.orderByClause = orderByClause;

this.start = start;

this.pageSize = pageSize;

condition = new HashMap();

}

public CriteriaCondition put(String condition, Object value)

{

this.condition.put(condition, value);

return (CriteriaCondition)this;

}

public Map getCondition()

{

return condition;

}

public void setDistinct(boolean distinct)

{

this.distinct = distinct;

}

public void setOrderByClause(String orderByClause)

{

this.orderByClause = orderByClause;

}

public void setStart(Integer start)

{

this.start = start;

}

public void setPageSize(Integer pageSize)

{

this.pageSize = pageSize;

}

}

//构造前台分页显示

public class PageNavUtil

{

public static String getBluePageNavHtml(int currentPage, int pageSize, int totalRows, int showNums)

{

StringBuilder pageNavHtml = new StringBuilder();

if (showNums < 1)

{

showNums = 5;

}

// 计算总页数

int totalPage = (int)Math.ceil(totalRows / Double.parseDouble(String.valueOf(pageSize)));

// 计算中间页码数字

int midNum = (int)Math.ceil(Double.parseDouble(String.valueOf(showNums)) / 2);

int beginNum = currentPage <= midNum ? 1 : currentPage - midNum + 1;

int endNum = beginNum + showNums - 1;

if (endNum > totalPage)

{

endNum = totalPage;

}

// 至少有1页以上 才显示分页导航

if (totalPage > 1)

{

// 需要显示 首页

if (currentPage > 1)

{

pageNavHtml.append(" 首页");

}

// 如果有上一页

if (currentPage > beginNum)

{

pageNavHtml.append(" < ");

}

else

{

pageNavHtml.append(" < ");

}

for (int i = beginNum; i <= endNum; i++)

{

if (i == currentPage)

{

pageNavHtml.append("" + currentPage + "");

}

else

{

pageNavHtml.append("" + i + "");

}

}

// 如果有下一页

if (currentPage < endNum)

{

pageNavHtml.append(" > ");

}

else

{

pageNavHtml.append(" > ");

}

// 需要显示 尾页

if (currentPage < totalPage)

{

pageNavHtml.append("尾页");

}

}

return pageNavHtml.toString();

}

public static String getPageNavHtml(int currentPage, int pageSize, int totalRows, int showNums)

{

StringBuilder pageNavHtml = new StringBuilder();

if (showNums < 1)

{

showNums = 5;

}

// 计算总页数

int totalPage = (int)Math.ceil(totalRows / Double.parseDouble(String.valueOf(pageSize)));

// 计算中间页码数字

int midNum = (int)Math.ceil(Double.parseDouble(String.valueOf(showNums)) / 2);

int beginNum = currentPage <= midNum ? 1 : currentPage - midNum + 1;

int endNum = beginNum + showNums - 1;

if (endNum > totalPage)

{

endNum = totalPage;

}

// 至少有1页以上 才显示分页导航

if (totalPage > 1)

{

// 需要显示 首页

if (currentPage > 1)

{

pageNavHtml.append(" 首页");

}

// 如果有上一页

if (currentPage > beginNum)

{

pageNavHtml.append(" < ");

}

else

{

pageNavHtml.append(" < ");

}

for (int i = beginNum; i <= endNum; i++)

{

if (i == currentPage)

{

pageNavHtml.append("" + currentPage + "");

}

else

{

pageNavHtml.append("" + i + "");

}

}

// 如果有下一页

if (currentPage < endNum)

{

pageNavHtml.append(" > ");

}

else

{

pageNavHtml.append(" > ");

}

// 需要显示 尾页

if (currentPage < totalPage)

{

pageNavHtml.append("尾页");

}

}

return pageNavHtml.toString();

}

}