关于hibernate的sql语句记录到Log4j日志中，并将其中的参数值导入到日志中

log4j.rootLogger = INFO, CONSOLE,infoFile,errFile

log4j.appender.Threshold = INFO
log4j.appender.DEBUG = org.apache.log4j.ConsoleAppender
log4j.appender.DEBUG.Target = System.out
log4j.appender.DEBUG.layout = org.apache.log4j.PatternLayout
log4j.appender.DEBUG.layout.ConversionPattern = %p - %C{1}.%M(%L) | %m%n
log4j.appender.CONSOLE = org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.Target = System.out
log4j.appender.CONSOLE.layout = org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern = %p - %C{1}.%M(%L) | %m%n

log4j.appender.infoFile = org.apache.log4j.DailyRollingFileAppender
log4j.appender.infoFile.File = c:/logs/jeecg-oa.log
log4j.appender.infoFile.DatePattern = '.'yyyy-MM-dd
log4j.appender.infoFile.Threshold = ALL
log4j.appender.infoFile.layout = org.apache.log4j.PatternLayout
log4j.appender.infoFile.layout.ConversionPattern = [%-5p] %d{yyyy-MM-dd HH:mm:ss.SSS} method:%l%n%m%n

log4j.appender.errFile = org.apache.log4j.DailyRollingFileAppender
log4j.appender.errFile.File = c:/logs/jeecg-oa-err.log
log4j.appender.errFile.DatePattern = '.'yyyy-MM-dd
log4j.appender.errFile.Threshold = ERROR
log4j.appender.errFile.layout = org.apache.log4j.PatternLayout
log4j.appender.errFile.layout.ConversionPattern =[%-5p] %d{yyyy-MM-dd HH\:mm\:ss.SSS} method\:%l%n%m%n

log4j.logger.org.hibernate.SQL=DEBUG

log4j.logger.org.hibernate.type=ALL

注：①log4j.appender.infoFile.Threshold = ALL，是关键，如果这句话是log4j.appender.infoFile.Threshold=info就不成功。

           会自动忽略log4j.logger.org.hibernate.SQL=DEBUG的DEBUG，导致日志中不会打印SQL

        ②log4j.logger.org.hibernate.type=ALL是是Trace中的参数值打印出来，避免看到的只是带“？”的sql，可以更方便的查看日志，同时log4j.appender.infoFile.Threshold = ALL，不然也无法打印