1.首先加入pagehelper的pom依赖
<!--pagehelper -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
2.准备实体类User.java
public class User {
private int id;
private String username;
private String password;
省略getter setter 方法
}3.controller层代码
[@Controller]
public class UserController {
@Autowired
UserMapper userMapper;
//第一种实现方式
//http://localhost:8080/getUser?pageNum=1&pageSize=2
@RequestMapping(value = {"/getUser","/"})
public String getUser(Integer pageNum, Integer pageSize, Model model){
if (pageNum==null&&pageSize==null){
pageNum=1;
pageSize=5;
}
if (pageNum!=null&&pageSize==null){
pageSize=3;
}
PageHelper.startPage(pageNum,pageSize);
Page<User> userList = userMapper.getUserList();
model.addAttribute("userStat",userList);
return "index";
}
}
4.mapper类
@Mapper
public interface UserMapper {
@Select("select * from user")
Page<User> getUserList();
}
5.页面展示index.html
<body>
<h1>查询所有的用户。。。</h1>
<table class="table table-hover">
<tr>
<td class="active">编号</td>
<td class="success">用户名</td>
<td class="warning">密码</td>
</tr>
<tr th:each="user : ${userStat}">
<td class="active" th:text="${user.id}">编号</td>
<td class="success" th:text="${user.username}">用户名</td>
<td class="warning" th:text="${user.password}" >密码</td>
</tr>
</table>
<nav aria-label="Page navigation">
<ul class="pagination">
<li>
<a href="#" aria-label="Previous">
<span aria-hidden="true">«</span>
</a>
</li>
<li><a href="#" th:href="@{/getUser?pageNum=1}">1</a></li>
<li><a href="#" th:href="@{/getUser?pageNum=2}">2</a></li>
<li><a href="#" th:href="@{/getUser?pageNum=3}">3</a></li>
<li><a href="#" th:href="@{/getUser?pageNum=4}">4</a></li>
<li><a href="#" th:href="@{/getUser?pageNum=5}">5</a></li>
<li>
<a href="#" aria-label="Next">
<span aria-hidden="true">»</span>
</a>
</li>
</ul>
</nav>
</body>
