log4jdbc mysql jdbc_spring boot 集成log4jdbc 查看完整sql

application.yml

# 修改前

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=UTF-8

# 修改后

spring.datasource.driver-class-name=net.sf.log4jdbc.DriverSpy

spring.datasource.url=jdbc:log4jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=UTF-8

pom.xml

org.bgee.log4jdbc-log4j2

log4jdbc-log4j2-jdbc4.1

1.16

com.googlecode.log4jdbc

log4jdbc

1.2

log4jdbc.log4j2.properties

log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator

logback.xml

%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n

${LOG_HOME}/mylog.log.%d{yyyy-MM-dd}.log

30

%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n

10MB