mybatis-plus显示sql执行语句（p6spy）

左手的ㄟ右手 2023-10-03 22:47 17阅读 0赞

### 效果 ###

![在这里插入图片描述][a9a31c1e754d48d7b2d539390c602daf.png]

### 官网参考地址 ###

https://mybatis.plus/guide/p6spy.html

### pom依赖 ###

### yaml配置 ###

#数据源连接信息
    spring:
      datasource:
        username: root
        password: 123456
        url: jdbc:p6spy:mysql://127.0.0.1:3306/scau?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
        driver-class-name: com.p6spy.engine.spy.P6SpyDriver
        type: com.zaxxer.hikari.HikariDataSource

### spy.properties配置 ###

# 自定义日志打印
    logMessageFormat=com.baomidou.mybatisplus.extension.p6spy.P6SpyLogger
    #日志输出到控制台
    appender=com.baomidou.mybatisplus.extension.p6spy.StdoutLogger
    # 使用日志系统记录 sql
    #appender=com.p6spy.engine.spy.appender.Slf4JLogger
    # 设置 p6spy driver 代理
    deregisterdrivers=true
    # 取消JDBC URL前缀
    useprefix=true
    # 配置记录 Log 例外,可去掉的结果集有error,info,batch,debug,statement,commit,rollback,result,resultset.
    excludecategories=info,debug,result,commit,resultset
    # 日期格式
    dateformat=yyyy-MM-dd HH:mm:ss
    # 实际驱动可多个
    #driverlist=org.h2.Driver
    # 是否开启慢SQL记录
    outagedetection=true
    # 慢SQL记录标准 2 秒
    outagedetectioninterval=2

![在这里插入图片描述][a3be6b5c14244dc094441d8492bae9ae.png]

[a9a31c1e754d48d7b2d539390c602daf.png]: https://img-blog.csdnimg.cn/a9a31c1e754d48d7b2d539390c602daf.png
[a3be6b5c14244dc094441d8492bae9ae.png]: https://img-blog.csdnimg.cn/a3be6b5c14244dc094441d8492bae9ae.png