mybatis-plus配置控制台打印完整带参数SQL语句

<>问题背景

通常我们开发的时候，需要联合控制台和Navicat/PLSQL等工具进行语句的拼接检查，如果只是输出了一堆？？？
，那么将极大降低我们的效率。因此我们需要输出完整的SQL语句以便调试。

<>解决方案

如果是application.yml
#mybatis-plus配置控制台打印完整带参数SQL语句 mybatis-plus: configuration: log-impl:
org.apache.ibatis.logging.stdout.StdOutImpl
如果是application.properties，添加：
#mybatis-plus配置控制台打印完整带参数SQL语句 mybatis-plus.configuration.log-
impl=org.apache.ibatis.logging.stdout.StdOutImpl
输出效果
--- [ XNIO-1 task-12] c.s.cms.controller.IndexController : username-admin-
password-123456-**** Creating a new SqlSession SqlSession [org.apache.ibatis.
session.defaults.DefaultSqlSession@708e9ffd] was not registered for
synchronization because synchronization is not active--- [ XNIO-1 task-12] com.
alibaba.druid.pool.DruidDataSource : {dataSource-1} inited JDBC Connection [com.
alibaba.druid.proxy.jdbc.ConnectionProxyImpl@62b13210] will not be managed by
Spring==> Preparing: select * from user t where t.user_code='admin' and t.
password='123456' ==> Parameters: <== Columns: user_id, user_code, create_date,
modify_date, user_name, password, status, role_id, department_id, major_id,
classes_id, year <== Row: 1, admin, 2020-02-15 22:14:32, 2020-02-18 23:38:51,
Moshow K ZHENG, 123456, 1, 9, 1, 13, 113, 2020 <== Total: 1 Closing non
transactional SqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession
@708e9ffd]

• « 上一篇：左耳听风之《高效学习》-端正学习态度-概要
• » 下一篇：小程序uni-app生成条形码