SpringBoot2.x | 分页插件PageHelper

pom.xml

<!-- 分页插件 --> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.9</version> </dependency>

appliction.properties

# Pagehelper pagehelper.helperDialect=mysql pagehelper.reasonable=true pagehelper.supportMethodsArguments=true pagehelper.params=count=countSql

服务层接口实现，如VipServiceImpl.java

/** * 获取所有的会员信息 * @param page 页码 * @param rows 当前页会员数 * @return vips */ @Overrid public List<Vip> getAll(Integer page, Integer rows) { // PageHelper分页信息 PageHelper.startPage(page, rows); // 获取所有会员信息 VipExample vipExample = new VipExample(); // 通过Criteria构造查询条件 VipExample.Criteria criteria = vipExample.createCriteria(); criteria.andVipIdIsNotNull(); List<Vip> vips = vipMapper.selectByExample(vipExample); return vips; }

MemberController.java

import com.bookstore.entity.Vip; import com.bookstore.service.VipService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import java.util.List; /** * <P>会员相关页面控制层</p> * =================== * @author noTalent * @version 1.0 */ @Controller public class MemberController { @Autowired private VipService vipService; /** * 会员列表路由 * @return member-list.html */ @RequestMapping(value = "/member-list") public String memberList(Model model, @RequestParam(value = "page", defaultValue = "1") Integer page, @RequestParam(value = "size", defaultValue = "10") Integer size) { List<Vip> vips = vipService.getAll(page, size); if (vips != null && vips.size() > 0) { model.addAttribute("vips", vips); } return "member-list"; } }

Thymeleaf

<tr th:each="vip : ${vips}"> <td> <div class="layui-unselect layui-form-checkbox" lay-skin="primary" data-id='2'><i class="layui-icon">&#xe605;</i></div> </td> <td th:text="${vip.getVipId()}"></td> <td th:text="${vip.getVipUsername()}"></td> <td th:text="${vip.getVipPassword()}"></td> <td th:text="${vip.getVipNickname()}"></td> <td th:text="${vip.getVipGender()}"></td> <td></td> <td th:text="${vip.getVipPhone()}"></td> <td th:text="${vip.getVipEmail()}"></td> <td th:text="${vip.getVipBirthday()}"></td> <td th:text="${vip.getVipLocation()}"></td> <td th:text="${vip.getVipCreateTime()}"></td> <td class="td-status"> <span class="layui-btn layui-btn-normal layui-btn-mini">已启用</span></td> <td> <a title="编辑" onclick="x_admin_show('编辑','member-edit.html',600,400)" href="javascript:;"> <i class="layui-icon">&#xe642;</i> </a> <a onclick="x_admin_show('修改密码','member-password.html',600,400)" title="修改密码" href="javascript:;"> <i class="layui-icon">&#xe631;</i> </a> </td> </tr>