实体类Page.java
封装分页相关的信息
package com.nowcoder.community.entity;
/***
*封装分页相关的信息
*/
public class Page {
//当前页码
private int current = 1;
//显示上限
private int limit = 10;
//数据总数(用于计算总页数)
private int rows;
//查询路径(用于复用分页链接)
private String path;
public int getCurrent() {
return current;
}
public void setCurrent(int current) {
if(current >= 1) {
this.current = current;
}
}
public int getLimit() {
return limit;
}
public void setLimit(int limit) {
if (limit >= 1 && limit <= 100) {
this.limit = limit;
}
}
public int getRows() {
return rows;
}
public void setRows(int rows) {
if(rows >=0) {
this.rows = rows;
}
}
public String getPath() {
return path;
}
public void setPath(String path) {
this.path = path;
}
/***
* 获取当前页的起始行
* @return
*/
public int getOffset(){
//current * limit -limit
return (current - 1) * limit;
}
/***
* 获取总页数
* @return
*/
public int getTotal(){
//rows / limit [+1]
if(rows % limit == 0){
return rows / limit;
}else {
return rows / limit + 1;
}
}
/***
* 获取起始页码
* @return
*/
public int getFrom(){
int from = current - 2;
return from < 1 ? 1 : from;
}
/***
* 获取结束页码
* @return
*/
public int getTo(){
int to = current + 2;
int total = getTotal();
return to > total ? total : to;
}
}
DiscussPostMapper.java
//分页查询帖子功能,返回的是多条数据的是一个集合,集合里装的是帖子的对象
//分页功能:MySQL数据库实现只需要设置limit参数:起始行行号offset,这一页最多显示多少条数据limit
List<DiscussPost> selectDiscussPosts(int userId, int offset, int limit);
DsicussPostService.java
public List<DiscussPost> findDiscussPosts(int userId, int offset, int limit){
return discussPostMapper.selectDiscussPosts(userId, offset, limit);
}
HomeController.java
public String getIndexPage(Model model, Page page){
//分页功能
//方法调用之前,SpringMVC自动实例化Model和Page,并将Page注入Model
page.setRows(discussPostService.findDiscussPostRows(0));
page.setPath("/index");
//所以,在thymeleaf中可以直接访问Page中的数据
List<DiscussPost> list = discussPostService.findDiscussPosts(0, page.getOffset(), page.getLimit());
index.html
<!-- 分页 -->
<nav class="mt-5" th:if="${page.rows>0}">
<ul class="pagination justify-content-center">
<li class="page-item">
<a class="page-link" th:href="@{${page.path}(current=1)}">首页</a>
</li>
<li th:class="|page-item ${page.current==1?'disabled':''}|" >
<a class="page-link" th:href="@{${page.path}(current=${page.current -1})}">上一页</a>
</li>
<li th:class="|page-item ${i==page.current?'active':''}|" th:each="i:${#numbers.sequence(page.from,page.to)}">
<a class="page-link" th:href="@{${page.path}(current=${i})}" th:text="${i}">1</a>
</li>
<li th:class="|page-item ${page.current==page.total?'disabled':''}|">
<a class="page-link" th:href="@{${page.path}(current=${page.current+1})}">下一页</a>
</li>
<li class="page-item">
<a class="page-link" th:href="@{${page.path}(current=${page.total})}">末页</a>
</li>
</ul>
</nav>