springboot整合pagehelper实现分页

你的名字 2023-06-11 03:26 117阅读 0赞

# 运行环境 #

jdk版本：jdk1.8.0_202
    springboot版本：2.2.0
    mysql版本：5.6.31

# 代码实现 #

1、在pom.xml中添加依赖包

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

2、创建mapper（SysUserMapper.java）

package com.jeff.mapper;
    
    import com.github.pagehelper.Page;
    import com.jeff.entity.SysUser;
    import org.apache.ibatis.annotations.Select;
    
    import java.util.List;
    
    /** * @author Jeff * @description 用户管理 * @date 2019/10/28 */
    public interface SysUserMapper{ 
    
        /** * @description 分页查询方法一 * @author Jeff * @date 2019/10/28 * @return java.util.List<com.jeff.entity.SysUser> */
        @Select("SELECT id,login_name loginName,sex,status,name,role_id roleId,create_time createTime,create_name createName FROM sys_user")
        List<SysUser> getUserList1();
    
        /** * @description 分页查询方法二 * @author Jeff * @date 2019/10/28 * @return com.github.pagehelper.Page<com.jeff.entity.SysUser> */
        @Select("SELECT id,login_name loginName,sex,status,name,role_id roleId,create_time createTime,create_name createName FROM sys_user")
        Page<SysUser> getUserList2();
    
    }

3、创建service（SysUserService.java）

package com.jeff.service;
    
    import com.github.pagehelper.Page;
    import com.jeff.entity.SysUser;
    import com.jeff.mapper.SysUserMapper;
    import org.springframework.stereotype.Service;
    
    import javax.annotation.Resource;
    import java.util.List;
    
    /** * @author Jeff * @description 用户管理 * @date 2019/10/28 */
    @Service
    public class SysUserService { 
    
        @Resource
        private SysUserMapper sysUserMapper;
    
        /** * @description 分页查询方法一 * @author Jeff * @date 2019/10/28 * @return java.util.List<com.jeff.entity.SysUser> */
        public List<SysUser> getUserList1() { 
    
            return  sysUserMapper.getUserList1();
        }
    
        /** * @description 分页查询方法二 * @author Jeff * @date 2019/10/28 * @return com.github.pagehelper.Page<com.jeff.entity.SysUser> */
        public Page<SysUser> getUserList2() { 
    
            return  sysUserMapper.getUserList2();
        }
    
    }

4、创建controller实现分页（SysUserController.java）

package com.jeff.controller;
    
    import com.github.pagehelper.Page;
    import com.github.pagehelper.PageHelper;
    import com.github.pagehelper.PageInfo;
    import com.jeff.entity.SysUser;
    import com.jeff.entity.request.PageEntity;
    import com.jeff.service.SysUserService;
    import com.jeff.utils.ResultsUtils;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    import java.util.List;
    
    /** * @author Jeff * @description 用户管理 * @date 2019/10/28 */
    @RestController
    public class SysUserController { 
    
        @Autowired
        private SysUserService sysUserService;
    
        /** * @description 分页查询方法一 * @author Jeff * @date 2019/10/28 * @param page * @return java.lang.Object */
        @RequestMapping("getUserList1")
        public Object getUserList1(PageEntity page) { 
            PageHelper.startPage(page.getPage(), page.getRows());
            List<SysUser> list=sysUserService.getUserList1();
            PageInfo<SysUser> pageInfo = new PageInfo<>(list);
            return ResultsUtils.success(pageInfo.getList(), pageInfo.getTotal());
        }
    
        /** * @description 分页查询方法二 * @author Jeff * @date 2019/10/28 * @param page * @return java.lang.Object */
        @RequestMapping("getUserList2")
        public Object getUserList2(PageEntity page) { 
            PageHelper.startPage(page.getPage(), page.getRows());
            Page<SysUser> list =sysUserService.getUserList2();
            return ResultsUtils.success(list, list.getTotal());
        }
    }

5、在springboot启动类上加上 **@MapperScan(basePackages = \{ “com.jeff.mapper” \})**

package com.jeff;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    @MapperScan(basePackages = {  "com.jeff.mapper" })
    public class JfSpringbootApplication { 
    
        public static void main(String[] args) { 
            SpringApplication.run(JfSpringbootApplication.class, args);
        }
    
    }

`注：通过使用@MapperScan可以指定要扫描的Mapper类的包的路径`  
6、启动springboot项目，打开浏览器访问 **http://localhost:8080/getUserList1?page=1&&rows=5**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70 1]

# 源码地址： #

[https://gitee.com/jiefu813/jf-springboot/tree/jf\_pagehelper/][https_gitee.com_jiefu813_jf-springboot_tree_jf_pagehelper]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70]: /images/20230531/2017f7bf04b749c7bcfcce3b77584434.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70 1]: /images/20230531/9843e10e9f08427cbc0ce4c7ece99dc5.png
[https_gitee.com_jiefu813_jf-springboot_tree_jf_pagehelper]: https://gitee.com/jiefu813/jf-springboot/tree/jf_pagehelper/