开发环境中配置p6spy数据库操作语句日志

1.在项目依赖中导入p6spy的相关依赖文件

        <dependency>
            <groupId>p6spy</groupId>
            <artifactId>p6spy</artifactId>
            <version>3.8.2</version>
        </dependency>

2.编写spy.properties配置文件

appender=com.p6spy.engine.spy.appender.Slf4JLogger
logMessageFormat=com.p6spy.engine.spy.appender.CustomLineFormat
customLogMessageFormat=executionTime:%(executionTime) | sql:%(sqlSingleLine)

3.在数据库的配置文件上更改驱动。

spring:
  datasource:
    driver-class-name: com.p6spy.engine.spy.P6SpyDriver
    url: jdbc:p6spy:mysql://127.0.0.1:3306/?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false
    username: 
    password: 

4.查看运行效果