springboot打印sql到控制台

一、mybatis配置
方式 一：

########################################################
###配置打印sql
########################################################
logging:
level:
com.threefivework.mymall.dao.mapper: DEBUG //包路径为mapper文件包路径

方式二：
在application.yml（.properties）中增加配置，在控制台打印sql：

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

二、mybatis-plus配置
mybatis-plus:
type-handlers-package: com.bzl.design.management.mybatis
global-config:
db-config:
id-type: auto
field-strategy: not_empty
#驼峰下划线转换
column-underline: true
#逻辑删除配置
logic-delete-value: 0
logic-not-delete-value: 1
db-type: mysql
refresh: false
configuration:
map-underscore-to-camel-case: true
cache-enabled: false
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
mapper-locations: classpath:mapper/*.xml