1.在Maven pom.xml中添加依赖包
org.apache.logging.log4j
log4j-core
2.6.1
log4j
log4j
1.2.17
com.googlecode.log4jdbc
log4jdbc
1.2
org.slf4j
slf4j-api
1.7.21
org.slf4j
slf4j-log4j12
1.7.21
2.配置log4j的log4j.properties的配置文件:
log4j.logger.jdbc.sqlonly=DEBUG,console
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss.SSS} %m%n%n
log4j.logger.jdbc.sqltiming=INFO,console
log4j.logger.jdbc.connection=INFO,console
3.修改jdbc.properties(数据库)配置文件的url和driver,注意标红文字:
driver=net.sf.log4jdbc.DriverSpy
url=jdbc:log4jdbc:mysql://127.0.0.1:3306/数据库名?useUnicode=true&characterEncoding=utf8