jdbc日志配置

------------- db.properties:

connectDB=jdbc\:log4jdbc:sqlserver\://192.168.100.37\:1433;DatabaseName\=USER00012018

 

------------- log4j.properties:

log4j.rootLogger = DEBUG,stdout,file

log4j.logger.jdbc.sqlonly=DEBUG
log4j.logger.jdbc.sqltiming=OFF
log4j.logger.jdbc.audit=OFF
log4j.logger.jdbc.resultset=OFF
log4j.logger.jdbc.connection=OFF

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.Threshold=DEBUG
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=[%d{yyyyMMdd HH:mm:ss}-%p]-- %m

log4j.appender.file = org.apache.log4j.DailyRollingFileAppender
log4j.appender.file.File = d:/log.log
log4j.appender.file.Encoding=UTF-8
log4j.appender.file.DatePattern = yyyy-MM-dd'.log'
log4j.appender.file.Threshold=DEBUG
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss}[ %p ]%m%n
log4j.appender.file.append = true

 

-----------驱动：

String JDriver = "net.sf.log4jdbc.DriverSpy";

------------包：

log4j-1.2.17.jar ，log4jdbc-1.2.jar ，slf4j-api-1.6.0.jar，slf4j-log4j12-1.7.7.jar +数据库本身驱动包