在控制台日志打印输出,带时间SQL参数、带SQL参数返回结果
1. 带时间SQL参数
效果一:
2021-12-10 14:05:27.740 ==> Preparing: SELECT id,type_name,create_time,update_time FROM email_type WHERE id=?
2021-12-10 14:05:27.760 ==> Parameters: 1001(Integer)
2021-12-10 14:05:27.780 <== Total: 1
配置application.properties代码:
备注:注意第三行改成自己的mapper路径
logging.level.com.baomidou.mybatisplus=DEBUG
#项目mapper目录
logging.level.com.xu.time_email.mapper=DEBUG
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.slf4j.Slf4jImpl
2. 带SQL参数返回结果
效果二:
==> Preparing: SELECT id,type_name,create_time,update_time FROM email_type WHERE id=?
==> Parameters: 1001(Integer)
<== Columns: id, type_name, create_time, update_time
<== Row: 1001, 喜乐, 2021-09-27 09:35:53, 2021-12-10 09:43:54
<== Total: 1
application.properties代码:
备注:需要配合mybatis-plus使用
#mybatis-plus配置控制台打印完整带参数SQL语句
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
application.yml文件的配置:
实现效果一
logging:
level:
com.xingyiclinic.clinic.mapper: DEBUG
mybatis-plus:
configuration:
log-impl: org.apache.ibatis.logging.slf4j.Slf4jImpl
实现效果二
logging:
level:
com.xingyiclinic.clinic.mapper: trace
mybatis-plus:
configuration:
log-impl: org.apache.ibatis.logging.slf4j.Slf4jImpl