07_MybatisPlus—分页插件PaginationInnerInterceptor

从Mybatis Plus 3.4.0版本开始，不再使用旧版本的PaginationInterceptor ，而是使用MybatisPlusInterceptor。

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>3.4.0</version>
        </dependency>

config.java中添加以下代码：

package com.zs.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@EnableTransactionManagement
@Configuration
public class MybatisPlusConfig {
    /**
     * 新的分页插件,一缓和二缓遵循mybatis的规则,需要设置 MybatisConfiguration#useDeprecatedExecutor = false 避免缓存出现问题
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }
}

测试：

package com.zs;

import com.baomidou.mybatisplus.core.metadata.OrderItem;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.zs.dao.UserMapper;
import com.zs.entity.User;
import lombok.extern.slf4j.Slf4j;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest
@Slf4j
public class MainApplicationTest {
    @Autowired
    private UserMapper mapper;
    @Test
    void lambdaPagination() {
        /*
         * current – 当前页
         * size – 每页显示条数
         */
        Page<User> page = new Page<>(2, 2);
        Page<User> result = mapper.selectPage(page,
                Wrappers.<User>lambdaQuery()
                        .ge(User::getAge, 1)
                        .orderByAsc(User::getAge));
        System.out.println(result.getTotal());
        System.out.println(result.getRecords().size());
    }

    @Test
    void tests1() {
        log.error("----------------------------------baseMapper 自带分页-------------------------------------------------------");
        Page<User> page = new Page<>(1, 5);
        page.addOrder(OrderItem.asc("age"));
        Page<User> userIPage = mapper.selectPage(page,
                Wrappers.<User>lambdaQuery()
                        .eq(User::getAge, 20)
                        .like(User::getName, "Jack"));
        System.out.println(userIPage);
        log.error("总条数 -------------> {}", userIPage.getTotal());
        log.error("当前页数 -------------> {}", userIPage.getCurrent());
        log.error("当前每页显示数 -------------> {}", userIPage.getSize());
        List<User> records = userIPage.getRecords();
        System.out.println(records);

    }

}