<>问题背景

通常我们开发的时候,需要联合控制台和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]

技术
友情链接
码工具
Toolsou
API参考文档
云服务器优惠
阿里云优惠券
腾讯云优惠券
华为云优惠券
站点信息
问题反馈
邮箱:ixiaoyang8@qq.com
QQ群:766591547
关注微信