<>问题背景

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

技术
©2020 ioDraw All rights reserved
2020诺贝尔生理或医学奖公布央行:微信支付宝和数字人民币不存在竞争关系layui.table动态获取表头和列表数据示例python中的gc回收机制安卓开发—根据顾客预算显示食物信息分享一场黑客帝国代码雨脚本,简单好玩!re模块常用方法三分钟看懂神经网络机器翻译OpenCV之IplImage详解逆向工程核心原理笔记(一)——Hello World-1