Spring Boot 配合log4j.properties输入sql语句

1. 移除自带的logging

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <exclusions>
                <exclusion>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-starter-logging</artifactId>
                </exclusion>
            </exclusions>
</dependency>

2.增加log4j的依赖

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-log4j</artifactId>
            <version>1.3.8.RELEASE</version>
</dependency>

3.增加logj的依赖

#log4j.rootLogger=DEBUG,Console,R
log4j.rootLogger=info,Console,R,D,E

log4j.logger.com.zdhspower.charge.mapper=DEBUG
log4j.logger.com.zdhspower.control.mapper=DEBUG

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} [%c:%L]-[%p] %m%n

#log4j.appender.R=org.apache.log4j.RollingFileAppender
#log4j.appender.R.File=log.txt
#log4j.appender.R.MaxFileSize=500KB
#log4j.appender.R.MaxBackupIndex=10
#log4j.appender.R.layout=org.apache.log4j.PatternLayout
#log4j.appender.R.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} [%t] [%c] [%p] - %m%n

log4j.appender.R.layout=org.apache.log4j.PatternLayout 
log4j.appender.R.layout.ConversionPattern=%-d{yyyy-MM-dd HH\:mm\:ss} [%c]-[%p] %m%n 
log4j.appender.R=org.apache.log4j.DailyRollingFileAppender 
log4j.appender.R.File=backup.log 
log4j.appender.R.MaxFileSize=500KB
log4j.appender.R.DatePattern = '.'yyyy-MM-dd 

log4j.appender.D.layout = org.apache.log4j.PatternLayout
log4j.appender.D.layout.ConversionPattern =%-d{yyyy-MM-dd HH\:mm\:ss} [%c]-[%p] %m%n
log4j.appender.D = org.apache.log4j.DailyRollingFileAppender                        
log4j.appender.D.MaxBackupIndex=100
log4j.appender.D.MaxFileSize=500KB
log4j.appender.D.File = info/info.log
log4j.appender.D.DatePattern = '.'yyyy-MM-dd 
log4j.appender.D.Append = true
log4j.appender.D.Threshold = INFO


log4j.appender.E.layout = org.apache.log4j.PatternLayout
log4j.appender.E.layout.ConversionPattern =%-d{yyyy-MM-dd HH\:mm\:ss} [%c]-[%p] %m%n
log4j.appender.E = org.apache.log4j.DailyRollingFileAppender
log4j.appender.E.MaxBackupIndex=100
log4j.appender.E.MaxFileSize=500KB
log4j.appender.E.File = error/error.log
log4j.appender.E.DatePattern = '.'yyyy-MM-dd 
log4j.appender.E.Append = true
log4j.appender.E.Threshold = ERROR