------------- 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 +数据库本身驱动包