springboot中Mybaits-plus 分页插件使用及sql执行效率插件

红太狼 2022-02-02 05:17 413阅读 0赞

首页是jar包的引入

<dependency>
    	<groupId>com.baomidou</groupId>
    	<artifactId>mybatis-plus-boot-starter</artifactId>
    	<version>3.0.7.1</version>	
    </dependency>

接下来是springboot创建bean，不然分页插件不会生效

package com.ipzoe.ndk.config;
    
    import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
    import com.baomidou.mybatisplus.extension.plugins.PerformanceInterceptor;
    import lombok.extern.slf4j.Slf4j;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    /**
     * @author swy
     */
    @Configuration
    @MapperScan("com.ipzoe.ndk.mapper")
    @Slf4j
    public class MybatisPlusConfig {
        /**
         * mybatis-plus SQL执行效率插件【生产环境可以关闭】
         */
        @Bean
        public PerformanceInterceptor performanceInterceptor() {
            return new PerformanceInterceptor();
        }
    
        /**
         * 分页插件
         */
        @Bean
        public PaginationInterceptor paginationInterceptor() {
            return new PaginationInterceptor();
        }
    }

以上配置结束就i可以使用插件了，插件的使用方法

package com.ipzoe.ndk.service.impl;
    
    import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
    import com.baomidou.mybatisplus.core.toolkit.Wrappers;
    import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    import com.ipzoe.ndk.domain.entity.AdminUser;
    import com.ipzoe.ndk.mapper.AdminUserMapper;
    import com.ipzoe.ndk.service.AdminUserService;
    import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    import org.springframework.stereotype.Service;
    
    
    @Service
    public class AdminUserServiceImpl extends ServiceImpl<AdminUserMapper, AdminUser> implements AdminUserService {
    
        @Override
        public Object getList(Integer pageSize,Integer currentPage) {
            QueryWrapper<AdminUser> query = Wrappers.<AdminUser>query();
            query.orderByDesc("id");
            if(null != pageSize && currentPage != null){
                return page(new Page<>(currentPage,pageSize),query);
            }
            return AdminUser.INSTANCE.selectList(Wrappers.<AdminUser>query().orderByDesc("id"));
        }
    }

sql执行过程中，效率插件会生效，在打印台输出查询的sql语句

![20190510181413202.png][]

[20190510181413202.png]: /images/20220202/87ea8c19178147ab9e9cc9f4ba72639e.png