使用mybatis-plus控制臺實現(xiàn)打印帶參數(shù)的SQL語句

#by zhengkai.blog.csdn.net
#mybatis-plus配置控制臺打印完整帶參數(shù)SQL語句
mybatis-plus:
 configuration:
 log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

#mybatis-plus配置控制臺打印完整帶參數(shù)SQL語句
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

 static {
  tryImplementation(LogFactory::useSlf4jLogging);
  tryImplementation(LogFactory::useCommonsLogging);
  tryImplementation(LogFactory::useLog4J2Logging);
  tryImplementation(LogFactory::useLog4JLogging);
  tryImplementation(LogFactory::useJdkLogging);
  tryImplementation(LogFactory::useNoLogging);
 }

mybatis-plus:
 configuration:
# log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
# 改為自己寫的
 log-impl: com.softdev.system.config.MybatisPlusOutImpl

package com.softdev.system.config;

import org.apache.ibatis.logging.Log;
/**
 * @Description MybatisPlusOutImpl，直接使用控制臺輸出日志
 * @Author zhengkai.blog.csdn.net
 **/
public class MybatisPlusOutImpl implements Log {
 public MybatisPlusOutImpl(String clazz) {
  System.out.println("MybatisPlusOutImpl::"+clazz);
 }

 public boolean isDebugEnabled() {
  return true;
 }

 public boolean isTraceEnabled() {
  return true;
 }

 public void error(String s, Throwable e) {
  System.err.println(s);
  e.printStackTrace(System.err);
 }

 public void error(String s) {
  System.err.println("MybatisPlusOutImpl::"+s);
 }

 public void debug(String s) {
  System.out.println("MybatisPlusOutImpl::"+s);
 }

 public void trace(String s) {
  System.out.println("MybatisPlusOutImpl::"+s);
 }

 public void warn(String s) {
  System.out.println("MybatisPlusOutImpl::"+s);
 }
}

<!-- https://mvnrepository.com/artifact/p6spy/p6spy -->
<dependency>
 <groupId>p6spy</groupId>
 <artifactId>p6spy</artifactId>
 <version>3.9.1</version>
</dependency>

spring:
 datasource:
 driver-class-name: com.p6spy.engine.spy.P6SpyDriver
 url: jdbc:p6spy:h3:mem:test
 ...

#3.2.1以上使用
modulelist=com.baomidou.mybatisplus.extension.p6spy.MybatisPlusLogFactory,com.p6spy.engine.outage.P6OutageFactory
#3.2.1以下使用或者不配置
#modulelist=com.p6spy.engine.logging.P6LogFactory,com.p6spy.engine.outage.P6OutageFactory
# 自定義日志打印
logMessageFormat=com.baomidou.mybatisplus.extension.p6spy.P6SpyLogger
#日志輸出到控制臺
appender=com.baomidou.mybatisplus.extension.p6spy.StdoutLogger
# 使用日志系統(tǒng)記錄 sql
#appender=com.p6spy.engine.spy.appender.Slf4JLogger
# 設(shè)置 p6spy driver 代理
deregisterdrivers=true
# 取消JDBC URL前綴
useprefix=true
# 配置記錄 Log 例外,可去掉的結(jié)果集有error,info,batch,debug,statement,commit,rollback,result,resultset.
excludecategories=info,debug,result,commit,resultset
# 日期格式
dateformat=yyyy-MM-dd HH:mm:ss
# 實際驅(qū)動可多個
#driverlist=org.h3.Driver
# 是否開啟慢SQL記錄
outagedetection=true
# 慢SQL記錄標準 2 秒
outagedetectioninterval=2