1. pom.xml中springboot版本依赖

  1. <!--Spring-boot中去掉logback的依赖-->
  2. <dependency>
  3.     <groupId>org.springframework.boot</groupId>
  4.     <artifactId>spring-boot-starter-web</artifactId>
  5.     <exclusions>
  6.         <exclusion>
  7.             <groupId>org.springframework.boot</groupId>
  8.             <artifactId>spring-boot-starter-logging</artifactId>
  9.         </exclusion>
  10.     </exclusions>
  11. </dependency>
  13. <!--日志-->
  14. <dependency>
  15.     <groupId>org.springframework.boot</groupId>
  16.     <artifactId>spring-boot-starter-log4j2</artifactId>
  17. </dependency>
  19. <!--数据库连接池-->
  20. <dependency>
  21.     <groupId>com.alibaba</groupId>
  22.     <artifactId>druid-spring-boot-starter</artifactId>
  23.     <version>1.1.6</version>
  24. </dependency>
  26. <!--其他依赖-->

2. log4j2.xml文件中的日志配置(完整，可直接拷贝使用)

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <configuration status="OFF">
  3.     <appenders>
  5.         <Console name="Console" target="SYSTEM_OUT">
  6.             <!--只接受程序中DEBUG级别的日志进行处理-->
  7.             <ThresholdFilter level="DEBUG" onMatch="ACCEPT" onMismatch="DENY"/>
  8.             <PatternLayout pattern="[%d{HH:mm:ss.SSS}] %-5level %class{36} %L %M - %msg%xEx%n"/>
  9.         </Console>
  11.         <!--处理DEBUG级别的日志，并把该日志放到logs/debug.log文件中-->
  12.         <!--打印出DEBUG级别日志，每次大小超过size，则这size大小的日志会自动存入按年份-月份建立的文件夹下面并进行压缩，作为存档-->
  13.         <RollingFile name="RollingFileDebug" fileName="./logs/debug.log"
  14.                      filePattern="logs/$${date:yyyy-MM}/debug-%d{yyyy-MM-dd}-%i.log.gz">
  15.             <Filters>
  16.                 <ThresholdFilter level="DEBUG"/>
  17.                 <ThresholdFilter level="INFO" onMatch="DENY" onMismatch="NEUTRAL"/>
  18.             </Filters>
  19.             <PatternLayout
  20.                     pattern="[%d{yyyy-MM-dd HH:mm:ss}] %-5level %class{36} %L %M - %msg%xEx%n"/>
  21.             <Policies>
  22.                 <SizeBasedTriggeringPolicy size="500 MB"/>
  23.                 <TimeBasedTriggeringPolicy/>
  24.             </Policies>
  25.         </RollingFile>
  27.         <!--处理INFO级别的日志，并把该日志放到logs/info.log文件中-->
  28.         <RollingFile name="RollingFileInfo" fileName="./logs/info.log"
  29.                      filePattern="logs/$${date:yyyy-MM}/info-%d{yyyy-MM-dd}-%i.log.gz">
  30.             <Filters>
  31.                 <!--只接受INFO级别的日志，其余的全部拒绝处理-->
  32.                 <ThresholdFilter level="INFO"/>
  33.                 <ThresholdFilter level="WARN" onMatch="DENY" onMismatch="NEUTRAL"/>
  34.             </Filters>
  35.             <PatternLayout
  36.                     pattern="[%d{yyyy-MM-dd HH:mm:ss}] %-5level %class{36} %L %M - %msg%xEx%n"/>
  37.             <Policies>
  38.                 <SizeBasedTriggeringPolicy size="500 MB"/>
  39.                 <TimeBasedTriggeringPolicy/>
  40.             </Policies>
  41.         </RollingFile>
  43.         <!--处理WARN级别的日志，并把该日志放到logs/warn.log文件中-->
  44.         <RollingFile name="RollingFileWarn" fileName="./logs/warn.log"
  45.                      filePattern="logs/$${date:yyyy-MM}/warn-%d{yyyy-MM-dd}-%i.log.gz">
  46.             <Filters>
  47.                 <ThresholdFilter level="WARN"/>
  48.                 <ThresholdFilter level="ERROR" onMatch="DENY" onMismatch="NEUTRAL"/>
  49.             </Filters>
  50.             <PatternLayout
  51.                     pattern="[%d{yyyy-MM-dd HH:mm:ss}] %-5level %class{36} %L %M - %msg%xEx%n"/>
  52.             <Policies>
  53.                 <SizeBasedTriggeringPolicy size="500 MB"/>
  54.                 <TimeBasedTriggeringPolicy/>
  55.             </Policies>
  56.         </RollingFile>
  58.         <!--处理error级别的日志，并把该日志放到logs/error.log文件中-->
  59.         <RollingFile name="RollingFileError" fileName="./logs/error.log"
  60.                      filePattern="logs/$${date:yyyy-MM}/error-%d{yyyy-MM-dd}-%i.log.gz">
  61.             <ThresholdFilter level="ERROR"/>
  62.             <PatternLayout
  63.                     pattern="[%d{yyyy-MM-dd HH:mm:ss}] %-5level %class{36} %L %M - %msg%xEx%n"/>
  64.             <Policies>
  65.                 <SizeBasedTriggeringPolicy size="500 MB"/>
  66.                 <TimeBasedTriggeringPolicy/>
  67.             </Policies>
  68.         </RollingFile>
  70.         <!--druid的日志记录追加器-->
  71.         <RollingFile name="druidSqlRollingFile" fileName="./logs/druid-sql.log"
  72.                      filePattern="logs/$${date:yyyy-MM}/api-%d{yyyy-MM-dd}-%i.log.gz">
  73.             <PatternLayout pattern="[%d{yyyy-MM-dd HH:mm:ss}] %-5level %L %M - %msg%xEx%n"/>
  74.             <Policies>
  75.                 <SizeBasedTriggeringPolicy size="500 MB"/>
  76.                 <TimeBasedTriggeringPolicy/>
  77.             </Policies>
  78.         </RollingFile>
  79.     </appenders>
  81.     <loggers>
  82.         <root level="DEBUG">
  83.             <appender-ref ref="Console"/>
  84.             <appender-ref ref="RollingFileInfo"/>
  85.             <appender-ref ref="RollingFileWarn"/>
  86.             <appender-ref ref="RollingFileError"/>
  87.             <appender-ref ref="RollingFileDebug"/>
  88.         </root>
  90.         <!--记录druid-sql的记录-->
  91.         <logger name="druid.sql.Statement" level="debug" additivity="false">
  92.             <appender-ref ref="druidSqlRollingFile"/>
  93.         </logger>
  94.         <logger name="druid.sql.Statement" level="debug" additivity="false">
  95.             <appender-ref ref="druidSqlRollingFile"/>
  96.         </logger>
  98.         <!--log4j2 自带过滤日志-->
  99.         <Logger name="org.apache.catalina.startup.DigesterFactory" level="error" />
  100.         <Logger name="org.apache.catalina.util.LifecycleBase" level="error" />
  101.         <Logger name="org.apache.coyote.http11.Http11NioProtocol" level="warn" />
  102.         <logger name="org.apache.sshd.common.util.SecurityUtils" level="warn"/>
  103.         <Logger name="org.apache.tomcat.util.net.NioSelectorPool" level="warn" />
  104.         <Logger name="org.crsh.plugin" level="warn" />
  105.         <logger name="org.crsh.ssh" level="warn"/>
  106.         <Logger name="org.eclipse.jetty.util.component.AbstractLifeCycle" level="error" />
  107.         <Logger name="org.hibernate.validator.internal.util.Version" level="warn" />
  108.         <logger name="org.springframework.boot.actuate.autoconfigure.CrshAutoConfiguration" level="warn"/>
  109.         <logger name="org.springframework.boot.actuate.endpoint.jmx" level="warn"/>
  110.         <logger name="org.thymeleaf" level="warn"/>
  111.     </loggers>
  112. </configuration>

3. 配置application.properties

  1. # 配置日志输出
  2. spring.datasource.druid.filter.slf4j.enabled=true
  3. spring.datasource.druid.filter.slf4j.statement-create-after-log-enabled=false
  4. spring.datasource.druid.filter.slf4j.statement-close-after-log-enabled=false
  5. spring.datasource.druid.filter.slf4j.result-set-open-after-log-enabled=false
  6. spring.datasource.druid.filter.slf4j.result-set-close-after-log-enabled=false

4. 输出日志于druid-sql.log

  1. [2018-02-07 14:15:50] DEBUG 134 statementLog - {conn-10001, pstmt-20000} created. INSERT INTO city  ( id,name,state ) VALUES( ?,?,? )
  2. [2018-02-07 14:15:50] DEBUG 134 statementLog - {conn-10001, pstmt-20000} Parameters : [null, b2ffa7bd-6b53-4392-aa39-fdf8e172ddf9, a9eb5f01-f6e6-414a-bde3-865f72097550]
  3. [2018-02-07 14:15:50] DEBUG 134 statementLog - {conn-10001, pstmt-20000} Types : [OTHER, VARCHAR, VARCHAR]
  4. [2018-02-07 14:15:50] DEBUG 134 statementLog - {conn-10001, pstmt-20000} executed. 5.113815 millis. INSERT INTO city  ( id,name,state ) VALUES( ?,?,? )
  5. [2018-02-07 14:15:50] DEBUG 134 statementLog - {conn-10001, stmt-20001} executed. 0.874903 millis. SELECT LAST_INSERT_ID()
  6. [2018-02-07 14:15:52] DEBUG 134 statementLog - {conn-10001, stmt-20002, rs-50001} query executed. 0.622665 millis. SELECT 1