我想在控制台输出刚刚执行的sql语句

使用mybatisPlus插件,在application.properties添加下面这句

#mybatis??
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

控制台就能正常展示啦,下面是我显示的结果

JDBC Connection [HikariProxyConnection@1547944799 wrapping com.mysql.jdbc.JDBC4Connection@849eae6] will not be managed by Spring
JsqlParserCountOptimize sql=SELECT  id,hosname,hoscode,api_url,sign_key,contacts_name,contacts_phone,status,create_time,update_time,is_deleted  FROM hospital_set 
 WHERE  is_deleted=0

AND (hosname LIKE ?)
==>  Preparing: SELECT COUNT(1) FROM hospital_set WHERE is_deleted = 0 AND (hosname LIKE ?) 
==> Parameters: %协和医院%(String)
<==    Columns: COUNT(1)
<==        Row: 5
==>  Preparing: SELECT id,hosname,hoscode,api_url,sign_key,contacts_name,contacts_phone,status,create_time,update_time,is_deleted FROM hospital_set WHERE is_deleted=0 AND (hosname LIKE ?) LIMIT ?,? 
==> Parameters: %协和医院%(String), 4(Long), 2(Long)
<==    Columns: id, hosname, hoscode, api_url, sign_key, contacts_name, contacts_phone, status, create_time, update_time, is_deleted
<==        Row: 11, 北京协和医院, 1000_10, http://localhost:9998, acc13df8dc5fb4845c2a4c8d9da7fe11, 221, 13911231231, 1, 2021-08-10 20:57:47.0, 2021-09-13 19:47:13.0, 0
<==      Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3249a2ad]
  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值