最近需要做一個分頁,找了挺多的前端分頁效果,發現Bootstrap Paginator分頁插件效果不錯,而我頁面也是用BootStrap做的響應式頁面,就做了實現一個簡單的分頁效果。
PageHelper地址
Bootstrap Paginator地址
在SpringBoot+Mybatis做分頁
1.首先添加maven依賴
<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> <version>4.1.6</version></dependency>
2.添加一個PageHelperConfig配置類
@Configurationpublic class PageHelperConfig { @Bean public PageHelper pageHelper(){ PageHelper pageHelper = new PageHelper(); Properties properties = new Properties(); properties.setProperty("offsetAsPageNum", "true"); properties.setProperty("rowBoundsWithCount", "true"); properties.setProperty("reasonable", "true"); properties.setProperty("reasonable","true"); properties.setProperty("pageSizeZero", "true"); pageHelper.setProperties(properties); return pageHelper; }}3.寫一個用來存儲分頁信息的對象
public class PageBean<T> implements Serializable { private static final long serialVersionUID = 1L; private long total; //總記錄數 private List<T> list; //結果集 private int pageNum; //第幾頁 private int pageSize; //每頁記錄數 private int pages; // 總頁數 private int size; //當前頁的數量<=pageSize public PageBean(List<T> list){ if (list instanceof Page){ Page<T> page = (Page<T>) list; this.pageNum = page.getPageNum(); this.pageSize = page.getPageSize(); this.total = page.getTotal(); this.pages = page.getPages(); this.list = page; this.size = page.size(); } } public long getTotal() { return total; } public void setTotal(long total) { this.total = total; } public List<T> getList() { return list; } public void setList(List<T> list) { this.list = list; } public int getSize() { return size; } public void setSize(int size) { this.size = size; } public int getPageNum() { return pageNum; } public void setPageNum(int pageNum) { this.pageNum = pageNum; } public int getPageSize() { return pageSize; } public void setPageSize(int pageSize) { this.pageSize = pageSize; } public int getPages() { return pages; } public void setPages(int pages) { this.pages = pages; }}4.在Service接口和實現上,我們可以查詢到的把數據傳到PageBean
public interface ArticleService { PageBean<Article> selectArticleList(int pageNum, int pageSize);}@Servicepublic class ArticleServiceImpl implements ArticleService { @Autowired private ArticleMapper articleMapper; public PageBean<Article> selectArticleList(int pageNum, int pageSize) { PageHelper.startPage(pageNum, pageSize); List<Article> list = this.articleMapper.selectArticleList(); return new PageBean<>(list); }}
新聞熱點
疑難解答
圖片精選