Spring Boot 配置MyBatis 显示SQL日志

布满荆棘的人生 2023-10-10 14:04 36阅读 0赞

刚刚在IDEA 编辑器上集成SQL Params Setter SQL格式化插件，需要控制台输出MyBatis sql 语句。

打印SQL语句的配置非常简单

在application.[properties][]或application.yml文件中配置对应mapper所在包的日志级别即可。

**示列：com.zzg.mapper 指向mapper 接口包路径地址**

# 日志记录输出配置
    logging.level.com.zzg.mapper=debug

**控制台效果展示：**

2022-04-21 17:07:45.577  INFO 12036 --- [nio-8080-exec-2] o.s.web.servlet.DispatcherServlet        : Completed initialization in 4 ms
    2022-04-21 17:07:45.606 DEBUG 12036 --- [nio-8080-exec-2] com.zzg.mapper.UserMapper.selectAll      : ==>  Preparing: select id, account, `name`, passwd, create_dt, create_by, update_dt, update_by, `state` from house_user 
    2022-04-21 17:07:45.687 DEBUG 12036 --- [nio-8080-exec-2] com.zzg.mapper.UserMapper.selectAll      : ==> Parameters: 
    2022-04-21 17:07:45.706 DEBUG 12036 --- [nio-8080-exec-2] com.zzg.mapper.UserMapper.selectAll      : <==      Total: 0
    2022-04-21 17:07:49.316 DEBUG 12036 --- [nio-8080-exec-1] com.zzg.mapper.UserMapper.selectAll      : ==>  Preparing: select id, account, `name`, passwd, create_dt, create_by, update_dt, update_by, `state` from house_user 
    2022-04-21 17:07:49.317 DEBUG 12036 --- [nio-8080-exec-1] com.zzg.mapper.UserMapper.selectAll      : ==> Parameters: 
    2022-04-21 17:07:49.318 DEBUG 12036 --- [nio-8080-exec-1] com.zzg.mapper.UserMapper.selectAll      : <==      Total: 0
    2022-04-21 17:07:51.311 DEBUG 12036 --- [nio-8080-exec-3] com.zzg.mapper.UserMapper.selectAll      : ==>  Preparing: select id, account, `name`, passwd, create_dt, create_by, update_dt, update_by, `state` from house_user 
    2022-04-21 17:07:51.311 DEBUG 12036 --- [nio-8080-exec-3] com.zzg.mapper.UserMapper.selectAll      : ==> Parameters: 
    2022-04-21 17:07:51.312 DEBUG 12036 --- [nio-8080-exec-3] com.zzg.mapper.UserMapper.selectAll      : <==      Total: 0

使用SQL Params Setter 格式化SQL语句，提取相关联的SQL 语句。

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Zyo5aWL5paX55qE5aSn6YGT_size_20_color_FFFFFF_t_70_g_se_x_16][]

打开一个文本编辑器，粘贴格式后的SQL语句。

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Zyo5aWL5paX55qE5aSn6YGT_size_20_color_FFFFFF_t_70_g_se_x_16 1][]

**IDEA 集成SQL Params Setter SQL 语句格式化插件**

1、打开setting,找到Plugins选项（安装**SQL Params Setter** 插件（如果有就跳过这一步））

检索：**SQL Params Setter**

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Zyo5aWL5paX55qE5aSn6YGT_size_20_color_FFFFFF_t_70_g_se_x_16 2][]

[properties]: https://so.csdn.net/so/search?q=properties&spm=1001.2101.3001.7020
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Zyo5aWL5paX55qE5aSn6YGT_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/f57bd1f0c9244946b890b169bb33c26b.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5Zyo5aWL5paX55qE5aSn6YGT,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Zyo5aWL5paX55qE5aSn6YGT_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/c679fcdd9a6341fb9e60689f56ed75fb.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5Zyo5aWL5paX55qE5aSn6YGT,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Zyo5aWL5paX55qE5aSn6YGT_size_20_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/b0ca4bc9a3e248858defbc07607bb542.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5Zyo5aWL5paX55qE5aSn6YGT,size_20,color_FFFFFF,t_70,g_se,x_16