Mybatis 开启控制台打印sql语句

矫情吗；* 2024-03-24 15:54 34阅读 0赞

## 概述 ##

## springboot+mybatis整合过程中，开启控制台sql语句打印的多种方式： ##

### 方法1 ###

在springboot+mybatis整合中，可以将springboot的配置文件添加如下一段也可：

logging:
      level:
        com.lucifer.springboot.cache.mapper: debug

ps: com.lucifer.springboot.cache.mapper是包名

### 方法2 ###

1.  （spring+mybatis）在mybatis的配置文件中添加：

示例：mybatis的配置文件----mybatis-config.xml如下：

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        <settings>
            
            <setting name="logImpl" value="STDOUT_LOGGING" />
        </settings>
    </configuration>

1.  (springboot+mybatis)在springboot的配置文件----appcation.yml中添加：

mybatis:
        configuration:
          log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

### 方法三 ###

如果你使用的是springboot+mybatis-plus的话：

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

application.yml:

mybatis-plus:
      configuration:
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

## 参考 ##

[Mybatis 开启控制台打印sql语句][Mybatis _sql]

[Mybatis _sql]: https://blog.csdn.net/qq_37495786/article/details/82799910?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522166908822416782390543222%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=166908822416782390543222&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~top_positive~default-1-82799910-null-null.142%5Ev66%5Econtrol,201%5Ev3%5Econtrol,213%5Ev2%5Et3_esquery_v1&utm_term=mybatis%E6%97%A5%E5%BF%97%E6%89%93%E5%8D%B0sql&spm=1018.2226.3001.4187