网络编程 发布日期:2024/11/12 浏览次数:1
最近需要做一个分页,找了挺多的前端分页效果,发现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配置类
@Configuration public 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); } @Service public 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); } }
5.Controller
@RestController public class ArticleJsonController { @Autowired private ArticleService articleService; @GetMapping("/articleManage/articlePageBean") public PageBean articlePageBean(int pageNum, int pageSize) { PageBean<Article> pageBean = this.articleService.selectArticleList(pageNum, pageSize); return pageBean; } }
6.页面用Ajax无刷新分页,添加Bootstrap Paginator插件,bootstrap-paginator.js和bootstrap-responsive.min.css样式
<div id="content" class="container"></div> <div class="container"> <div class="panel col-sm-10 panel-default"> <div class="panel-body reply-top media"> <div id="page"></div> </div> </div> </div> function pagehtml(pageNum) { var articleid = $("#articleNum").val(); if (pageNum == 0){ pageNum=1; } else { pageNum=pageNum; } $.ajax({ url:"/TsengBlog/article/replyPage", type:"get", dataType:"json", data: {pageNum : pageNum, pageSize : 5, articleid : articleid }, success:function (data) { var options = { alignment:"center",//居中显示 currentPage: data.pageNum,//当前页数 totalPages: data.pages,//总页数 注意不是总条数 pageUrl: function(type, page, current){ if (page==current) { return "javascript:void(0)"; } else { return "javascript:pagehtml("+page+")"; } } }; var html=""; $.each(data.list, function (i, obj) { html += '<div class="panel col-sm-10 panel-default">'+ '<div class="panel-body reply-top media">'+ '<div class="col-sm-3 col-md-2 media-left">'+ '<img src="/UploadFiles/2021-04-02/Tseng.png">如果是Maven+SSM的,SSM整合就不多说了,网上有很多博客和例子整合。
1.mybatis.xml配置
<configuration> <plugins> <plugin interceptor="com.github.pagehelper.PageHelper"> <property name="dialect" value="mysql" /> <property name="pageSizeZero" value="true" /> <property name="offsetAsPageNum" value="true" /> <property name="reasonable" value="true" /> <property name="rowBoundsWithCount" value="true" /> </plugin> </plugins> </configuration>2.service
public PageInfo page(pageNum, pageSize){ PageHelper.startPage(pageNum, pageSize); List<ShopNav> lists = navService.getAllNav(); PageInfo<ShopNav> pageInfo = new PageInfo<ShopNav>(lists); return PageInfo; }页面效果展示
如果大家还想深入学习,可以点击这里进行学习,再为大家附3个精彩的专题:
Bootstrap学习教程
Bootstrap实战教程
Bootstrap插件使用教程
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持。