MyBatisPlus分页功能实现

红太狼 2023-10-13 23:39 8阅读 0赞

![在这里插入图片描述][8b557e22fea34bd0b8303c3dd4430c64.png_pic_center]

#### MyBatisPlus分页功能实现 ####

*   *   *  1. MyBatisPlus分页使用
         *   *  1.1 设置分页拦截器作为Spring管理的bean
             *  1.2 执行分页查询
         *  2. 开启MyBatisPlus日志
         *  3. 解决日志打印过多问题
         *   *  3.1 取消初始化spring日志打印
             *  3.2 取消SpringBoot启动banner图标
             *  3.3 取消MybatisPlus启动banner图标

#### 1. MyBatisPlus分页使用 ####

IPage<T> selectPage(IPage<T> page)

##### 1.1 设置分页拦截器作为Spring管理的bean #####

package com.sun.config;
    
    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;
    
    @Configuration
    public class MybatisPlusConfig {
        
    
        @Bean
        public MybatisPlusInterceptor mybatisPlusInterceptor(){
        
            // 1 创建MybatisPlusInterceptor拦截器对象
            MybatisPlusInterceptor mpInterceptor=new MybatisPlusInterceptor();
            // 2 添加分页拦截器
            mpInterceptor.addInnerInterceptor(new PaginationInnerInterceptor());
            return mpInterceptor;
        }
    }

##### 1.2 执行分页查询 #####

//分页查询
    @Test
    void testSelectPage(){
        
        //1 创建IPage分页对象,设置分页参数
        IPage<User> page=new Page<>(1,3);
        //2 执行分页查询
        userDao.selectPage(page,null);
        //3 获取分页结果
        System.out.println("当前页码值："+page.getCurrent());
        System.out.println("每页显示数："+page.getSize());
        System.out.println("总页数："+page.getPages());
        System.out.println("总条数："+page.getTotal());
        System.out.println("当前页数据："+page.getRecords());
    }

#### 2. 开启MyBatisPlus日志 ####

spring:
      datasource:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://localhost:3306/mybatisplus_db?serverTimezone=UTC
        username: root
        password: root
    # 开启mp的日志（输出到控制台）
    mybatis-plus:
      configuration:
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

#### 3. 解决日志打印过多问题 ####

##### 3.1 取消初始化spring日志打印 #####

![在这里插入图片描述][3fb12ddf65a64b65b99b1d49a07ebce2.png]

做法：在resources下新建一个logback.xml文件，名称固定，内容如下：

<?xml version="1.0" encoding="UTF-8"?>
    <configuration>
    
    </configuration>

logback.xml主要包含三个组成部分：**Loggers（日志记录器）**、**Appenders（输出目的在）**、**Layouts（日志输出格式）**

常用模板：

<?xml version="1.0" encoding="UTF-8"?>
    <configuration debug="false" scan="true" scanPeriod="1 seconds">
    
        <contextName>logback</contextName>
    
        <property name="log.path" value="F:\\logback.log" />
    
        <appender name="console" class="ch.qos.logback.core.ConsoleAppender">
            
            <filter class="ch.qos.logback.classic.filter.ThresholdFilter">
                  <level>ERROR</level>
            </filter>
            <encoder>
                <pattern>%d{HH:mm:ss.SSS} %contextName [%thread] %-5level %logger{36} - %msg%n
                </pattern>
            </encoder>
        </appender>
    
        <appender name="file"
            class="ch.qos.logback.core.rolling.RollingFileAppender">
            <file>${log.path}</file>
            <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
                <fileNamePattern>${log.path}.%d{yyyy-MM-dd}.zip</fileNamePattern>
            </rollingPolicy>
    
            <encoder>
                <pattern>%date %level [%thread] %logger{36} [%file : %line] %msg%n
                </pattern>
            </encoder>
        </appender>
    
        <root level="debug">
            <appender-ref ref="console" />
            <appender-ref ref="file" />
        </root>
    
        <logger name="com.example.logback" level="warn" />
    
    </configuration>

##### 3.2 取消SpringBoot启动banner图标 #####

![在这里插入图片描述][35fd42e7758f4862a3190fab9672abed.png]

spring:
      main:
        banner-mode: off # 关闭SpringBoot启动图标(banner)

##### 3.3 取消MybatisPlus启动banner图标 #####

![\[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-PnvYjpL1-1690255536775)(assets/image-20210815154115368.png)\]][img-PnvYjpL1-1690255536775_assets_image-20210815154115368.png]

# mybatis-plus日志控制台输出
    mybatis-plus:
      configuration:
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
      global-config:
        banner: off # 关闭mybatisplus启动图标

[8b557e22fea34bd0b8303c3dd4430c64.png_pic_center]: https://img-blog.csdnimg.cn/8b557e22fea34bd0b8303c3dd4430c64.png#pic_center
[3fb12ddf65a64b65b99b1d49a07ebce2.png]: https://img-blog.csdnimg.cn/3fb12ddf65a64b65b99b1d49a07ebce2.png
[35fd42e7758f4862a3190fab9672abed.png]: https://img-blog.csdnimg.cn/35fd42e7758f4862a3190fab9672abed.png
[img-PnvYjpL1-1690255536775_assets_image-20210815154115368.png]: https://img-blog.csdnimg.cn/20fad14bc0584d77a6997460efaf81f7.png