spring boot 整合pagehelper

素颜马尾好姑娘i 2023-10-04 16:01 9阅读 0赞

#### spring boot 整合pagehelper ####

1.pom依赖

<dependency>
    			<groupId>com.github.pagehelper</groupId>
    			<artifactId>pagehelper-spring-boot-starter</artifactId>
    			<version>1.2.5</version>
    		</dependency>

> 务必使用此依赖，springboot与spring整合依赖不同，spring可以使用的依赖springboot不可以

2.配置文件

pagehelper.helper-dialect=mysql
    pagehelper.reasonable=true
    pagehelper.support-methods-arguments=true
    pagehelper.params=count=countSql
    pagehelper.helperDialect: mysql
    pagehelper.supportMethodsArguments: true #是否支持接口参数来传递分页参数，默认false
    pagehelper.pageSizeZero: false #pageSize=0 返回所有

3.控制层

//用户列表
        @RequestMapping(value = "/getUserList.action")
        public String getUserList(UserCondition userCondition, HttpServletRequest request,Integer pageNum, Integer pageSize, Model model){
        
    
            pageNum=pageNum==null?1:pageNum;
            pageSize=pageSize==null?3:pageSize;
            userCondition.setPage(pageNum);
            userCondition.setPagesize(pageSize);
            PageInfo<User> pageInfo = userService.findAll(userCondition);
            model.addAttribute("pageInfo", pageInfo);
            model.addAttribute("userCondition", userCondition);
            return "user/user_list";
        }

4.serviceimpl（此处省略service中的方法）

public PageInfo<User> findAll(UserCondition userCondition) {
        
    
            PageHelper.startPage(userCondition.getPage(), userCondition.getPagesize());
            List<User> userList = userDao.findAll(userCondition);
            PageInfo<User> pageInfo = new PageInfo<User>(userList);
            return pageInfo;
        }

5.模糊查询（省略数据操作层方法）

<select id="findAll" parameterType="UserCondition" resultType="User">
    		select * from sys_user where 1 = 1
    		<if test="userid!=null and userid!=''">
    			and userid like concat ('%',#{
        userid},'%')
    		</if>
    	</select>

6.UserCondition模糊查询条件

package com.example.springboot.po;
    
    public class UserCondition {
        
    
    
        private String userid;
        private Integer page=1;
        private Integer pagesize=5;
    
    
        public String getUserid() {
        
            return userid;
        }
    
        public void setUserid(String userid) {
        
            this.userid = userid;
        }
    
        public Integer getPage() {
        
            return page;
        }
    
        public void setPage(Integer page) {
        
            this.page = page;
        }
    
        public Integer getPagesize() {
        
            return pagesize;
        }
    
        public void setPagesize(Integer pagesize) {
        
            this.pagesize = pagesize;
        }
    }

7.实体类（省略，根据实际情况）  
8.前端（必须提前引入c标签）

<div class="pagelist">
                <th:if test="${!pageInfo.isFirstPage}">
                    <a th:href="@{/getUserList.action(pageNum=1)}">首页</a>
                </th:if>
    
                <th:if test="${pageInfo.hasPreviousPage}">
                    <a th:href="@{/getUserList.action(pageNum=${pageInfo.pageNum-1})}">上一页</a>
                </th:if>
    
                <span class="current"style="background:red;">[[${
        pageInfo.pageNum}]]</span>
                <th>/</th>
                <span class="current">[[${
        pageInfo.pages}]]</span>
    
                <th:if test="${pageInfo.hasNextPage}">
                    <a th:href="@{/getUserList.action(pageNum=${pageInfo.pageNum+1})}">下一页</a>
                </th:if>
    
                <th:if test="${!pageInfo.isLastPage}">
                    <a th:href="@{/getUserList.action(pageNum=${pageInfo.getLastPage()})}">尾页</a>
                </th:if>
    
            </div>