springBoot 使用 mybatis-plus 插件实现分页

电玩女神 2022-05-15 15:48 173阅读 0赞

## 个人对mybatis-plus总结地址：[mybatis-plus 介绍][mybatis-plus] ##

一、项目结构

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70][]

二、pom.xml 依赖添加   （这里我是加在krystal\_dao的pom.xml里面，单个项目，直接加在pom.xml，多模块根据自己项目情况添加）

<dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus</artifactId>
        <version>3.0-beta</version>
    </dependency>

三、新建MyBatisPlusConfig.java (这里我用专门一个模块添加一些功能代码，里面依赖自己根据报错添加进去即可)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 1][]

package com.dm.krystal.core.config;
    import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    /**
     * @author krystal
     */
    @Configuration
    /*@MapperScan("com.dm.krystal")*/ /*  KrystalApiApplication在启动文件上写了，这里不加*/
    public class MyBatisPlusConfig {
        /**
         * mybatis-plus分页插件
         */
        @Bean
        public PaginationInterceptor paginationInterceptor() {
            PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
            return paginationInterceptor;
        }
    }

四、具体代码实现

1.controller

@GetMapping("/findAllUser")
        @ResponseBody
        public List<User>  findAllUser(){
            User user = new User();
            int page=2;//当前页
            int pageSize=4;//页面接收数据大小
            IPage<User> iPage = userService.selectPageExt(user, page, pageSize);
            iPage.getRecords();
            return   iPage.getRecords();
        }
    }

2.service

![20181030162818881.png][]

3.serviceImp

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 2][]

public IPage<User> selectPageExt(User user, int page, int pageSize) throws RuntimeException {
        try {
            Page<User> p = new Page<>(page, pageSize);
            p.setRecords(userDao.selectPageExt(p, user));
            return p;
        } catch (Exception e) {
            throw new RuntimeException(e.getMessage());
        }
    }

4.dao

List<User> selectPageExt(Page<User> page, @Param("user") User user);

5. .xml

<select id="selectPageExt" resultType="com.dm.krystal.entity.User">
       select
        <include refid="userColumns"/>
        from  sys_user
    </select>

五、sql 打印

select \* from sys\_user LIMIT 4,4

结果

![2018103016374316.png][]

[mybatis-plus]: https://blog.csdn.net/sinat_34338162/article/details/108683596
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70]: /images/20220503/2b640c5ce1e24479a5860878e99a7027.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 1]: /images/20220503/729f2cbf19c24a9db96138c00b7c6dcd.png
[20181030162818881.png]: /images/20220503/5946eee066d140faa66606e236c8dff3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MzM4MTYy_size_16_color_FFFFFF_t_70 2]: /images/20220503/833b462400a44dc7bf1fe157e2282f84.png
[2018103016374316.png]: /images/20220503/1041d3fea74549029035674b518eb3bb.png