IDEA打印项目执行最终执行sql

系统管理员 2024-03-25 20:55 72阅读 0赞

### 一、下载插件 ###

> **1、MyBatis Log Plugin随着IDEA 升级到 2020.2 版本之后开始收费了...**  
> **2、也可以使用"MyBatis Log Free"，"MyBatis Log Free"打印的SQL是小写且格式化过的。**

![446ee2c872164dd799ba116e16e1da94.png][]

### 二、启用方式 ###

#### **1、"Tools"内启用** ####

![a1bc308c7c76402a8c7abf4b85bc1ec9.png][]

#### 2、**Version Control** ####

![315cbbf60a13459bb3223a234d8b01f2.png][]

#### 3、控制台Mybatis Log ####

启用后会多出一个只打印SQL的控制台

![64919fa9c729444ab3eef5ad78a16d97.png][]

### 三、**配置文件配置** ###

#### 1、**logback.xml** ####

<loggername="com.xx.mapper"level="DEBUG" />

1.  #### Mybatis配置-yml ####

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

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

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

#### 3、Mybatis配置-**properties** ####

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

### 四、效果 ###

![45f50e89b204461b82ff78f7344537a3.png][]

**有用请点赞，养成良好习惯！**

**疑问、交流、鼓励请留言！**

![8ebbb4217b5112e5fcbb0453f8766a42.gif][]

[446ee2c872164dd799ba116e16e1da94.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/7cc7de78a7ff4c3c9a98efce2336da25.png
[a1bc308c7c76402a8c7abf4b85bc1ec9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/c84c0682d403491591d3f3fb4b40cd85.png
[315cbbf60a13459bb3223a234d8b01f2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/a25bcea3477e4d95b7d09bf69d1cdf30.png
[64919fa9c729444ab3eef5ad78a16d97.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/c5c3c9560ed3418fb063f14a0966310b.png
[45f50e89b204461b82ff78f7344537a3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/e25f0aff7d9046ba9df2870fff92f3de.png
[8ebbb4217b5112e5fcbb0453f8766a42.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/0bc7061b5b674503954df6eeac87ed96.png