SpringBoot打印系统执行的sql语句以及日志的配置

深碍√TFBOYSˉ_ 2024-04-07 14:57 30阅读 0赞

#### SpringBoot打印系统执行的sql语句以及日志的配置 ####

*  1、Mybatis内置的日志工厂
 *  2、Spring Boot集成Mybatis
 *  3、总结

直接在application.yml/properties文件中进行配置

引入依赖：

<parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            
            <version>2.3.6.RELEASE</version>
            <relativePath/>
        </parent>
        <dependencies>
    		<dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
                
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-logging</artifactId>
                
                
            </dependency>
        </dependencies>

## 1、Mybatis内置的日志工厂 ##

> Mybatis内置的日志工厂提供日志功能，具体的日志实现有以下几种工具：  
> slf4j  
> Apache Commons Logging  
> Log4j 2  
> Log4j  
> JDK logging  
> 具体选择哪个日志实现工具由MyBatis的内置日志工厂确定。它会使用最先找到的（按上文列举的顺序查找）。如果一个都未找到，日志功能就会被禁用。

配置log-impl：可供选择的有以下几种  
![在这里插入图片描述][490efbb5034344e384f78c1305333e83.png]

yml中：

mybatis-plus:
      configuration:
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #这个是可以打印sql、参数、查询结果的,只会打印到控制台不会输出到日志文件中
    			 #org.apache.ibatis.logging.log4j.Log4jImpl:这个不打印查询结果
      mapper-locations: classpath:mapper/*.xml
      type-aliases-package: com.example.plan.entity # 指定的包名

或properties中：

# mybatis plus
    mybatis-plus.mapper-locations=classpath:mapper/*Mapper.xml
    mybatis-plus.type-aliases-package=com.example.plan
    mybatis-plus.configuration.map-underscore-to-camel-case=true
    mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl # 重点

StdOutImpl控制台输出结果：

==>  Preparing: select id, name, sex from t_user where sex = ?
    ==> Parameters: 0(Integer)
    <==      Total: 8
    
    /**
     *第一行是执行的sql语句
     *第二行是传入的参数
     *第三行是返回结果的行数
     */

`补充`：  
log-impl用于设置打印sql的日志实现，指定的值为org.apache.ibatis.logging.Log接口的其中的一个实现类  
在这里以StdOutImpl为例

public class StdOutImpl implements Log {
        
    
      public StdOutImpl(String clazz) {
        
        // Do Nothing
      }
    
      @Override
      public boolean isDebugEnabled() {
        
        return true;
      }
    
      @Override
      public boolean isTraceEnabled() {
        
        return true;
      }
    
      @Override
      public void error(String s) {
        
        System.err.println(s);
      }
    
      @Override
      public void debug(String s) {
        
        System.out.println(s);
      }
    
      @Override
      public void trace(String s) {
        
        System.out.println(s);
      }
    
      @Override
      public void warn(String s) {
        
        System.out.println(s);
      }
    }

方法里面的输出，是用的System.out/error.println方法，所以如果配置为org.apache.ibatis.logging.stdout.StdOutImpl就只会在控制台窗口打印，不会记录到日志文件。  
如果需要保存打印SQL到文件就不能设置为StdOutImpl，可以设置为Slf4jImpl。部分代码如下，使用的是Log的方法，保存到文件中。

@Override
      public void error(String s) {
        
        log.error(s);
      }
    
      @Override
      public void debug(String s) {
        
        log.debug(s);
      }
    
      @Override
      public void trace(String s) {
        
        log.trace(s);
      }
    
      @Override
      public void warn(String s) {
        
        log.warn(s);
      }

也可以不设置。然后对应接口所在包设置logback对应包的日志等级\[debug\\info\\error\\warn等\]，即下面所提到的第二种方式。  
级别从高到低：OFF 、 FATAL 、 ERROR 、 WARN 、 INFO 、 DEBUG 、 TRACE 、 ALL

## 2、Spring Boot集成Mybatis ##

![在这里插入图片描述][7d70cdc958d04d6b8461f61117828659.png]

> **logging.file.name**  
> 设置日志文件：支持绝对路径、相对路径，相对路径的话是相对应用的根目录，比如logging.file.name=logs/demo.log;  
> 默认：spring.log  
> **logging.file.path**  
> 设置日志路径：支持绝对路径、相对路径，比如 logging.file.path=logs，日志文件默认会存为 spring.log；  
> 默认：根路径/LOG\_PATH\_IS\_UNDEFINED/

yml中：

#spring boot集成mybatis的方式打印sql
    logging:
        level:
          com.xxx.mapper: debug # 包路径为mapper文件包路径
          org.springframework: warn
          org.apache.ibatis.logging: debug
        file:
          path/name: #加不加这个配置就看你的resources目录下是否有logbackxxxx之类的xml文件，有的话会自动加载这个，识别里面的logpath。如果外部的这个日志配置和xml文件中具有相同的配置的话，哪个优先级更高一点？

此时，如果有相应的log配置文件，比如叫logback-spring.xml。  
配置文件中部分内容如下：

<springProfile name="dev,prod,test">
            <logger name="com.example.plan" level="info"/>
        </springProfile>
    
        <root level="info">
            <appender-ref ref="CONSOLE"/>
            <appender-ref ref="INFO_FILE"/>
            <appender-ref ref="WARNING_FILE"/>
            <appender-ref ref="ERROR_FILE"/>
        </root>

相应的yml中的logging配置：

logging:
      config: ${
        spring.config.location}logback-spring.xml # 不加也行，Springboot默认的日志配置文件名称为logback.xml和logback-spring.xml、logbackxxxx.xml
    spring:
      profiles:
        active: dev

## 3、总结 ##

<table> 
 <thead> 
  <tr> 
   <th>sql</th> 
   <th>其它日志信息</th> 
   <th>简述</th> 
   <th>配置</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>只打印到控制台</td> 
   <td>不输出</td> 
   <td>只打印sql到控制台</td> 
   <td>仅需log-impl配置为StdOutImpl</td> 
  </tr> 
  <tr> 
   <td>只打印到控制台</td> 
   <td>输出</td> 
   <td>其它日志信息保存到文件，sql只打印到控制台，不保存到文件中</td> 
   <td>log-impl配置为StdOutImpl，再加上logging的配置（logging.config指定配置文件/ resources目录下有符合spring boot自动化配置文件名的logbackxxx.xml/ yml中logging.level/file配置完整一些）</td> 
  </tr> 
  <tr> 
   <td>打印到控制台且输出到日志文件中</td> 
   <td>输出</td> 
   <td>sql和其它日志信息保存到文件中，sql也打印到控制台</td> 
   <td>log-impl为Slf4jImpl/或者不设置，总之不能设置为StdOutImpl，再加上logging的配置即可</td> 
  </tr> 
 </tbody> 
</table>

配置为logback-test.xml后，控制台的输出：

> 15:50:13,315 |-INFO in ch.qos.logback.classic.LoggerContext\[logback\] - Found resource \[logback-test.xml\] at \[file:/Users/congee/Desktop/code/GService/service/target/classes/**logback-test**.xml\]  
> 15:50:13,342 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute not set  
> 15:50:13,345 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - Will scan for changes in \[file:/Users/congee/Desktop/code/GService/service/target/classes/logback-test.xml\]  
> 15:50:13,345 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - Setting ReconfigureOnChangeTask scanning period to 10 seconds  
> 15:50:13,357 |-INFO in ch.qos.logback.classic.joran.action.ContextNameAction - Setting logger context name as \[logback\]  
> 15:50:13,357 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type \[ch.qos.logback.core.ConsoleAppender\]  
> 15:50:13,358 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as \[CONSOLE\]  
> 15:50:13,362 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type \[ch.qos.logback.classic.encoder.PatternLayoutEncoder\] for \[encoder\] property  
> 15:50:13,381 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type \[ch.qos.logback.core.rolling.RollingFileAppender\]  
> 15:50:13,382 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as \[INFO\_FILE\]  
> 15:50:13,382 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type \[ch.qos.logback.classic.encoder.PatternLayoutEncoder\] for \[encoder\] property  
> 15:50:13,386 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@1858609436 - No compression will be used  
> 15:50:13,387 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@1858609436 - Will use the pattern /Users/congee/log/monitor//log-info-%d\{yyyy-MM-dd\}.%i.log for the active file  
> 15:50:13,388 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@7276c8cd - The date pattern is ‘yyyy-MM-dd’ from file name pattern ‘/Users/congee/log/monitor//log-info-%d\{yyyy-MM-dd\}.%i.log’.  
> 15:50:13,388 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@7276c8cd - Roll-over at midnight.  
> 15:50:13,389 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@7276c8cd - Setting initial period to Thu Apr 13 15:50:13 CST 2023  
> 15:50:13,389 |-WARN in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@7276c8cd - SizeAndTimeBasedFNATP is deprecated. Use SizeAndTimeBasedRollingPolicy instead  
> 15:50:13,389 |-WARN in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@7276c8cd - For more information see http://logback.qos.ch/manual/appenders.html\#SizeAndTimeBasedRollingPolicy  
> 15:50:13,392 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender\[INFO\_FILE\] - Active log file name: /Users/congee/log/monitor//log-info-2023-04-13.0.log  
> 15:50:13,392 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender\[INFO\_FILE\] - File property is set to \[null\]  
> 15:50:13,392 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type \[ch.qos.logback.core.rolling.RollingFileAppender\]  
> 15:50:13,392 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as \[WARNING\_FILE\]  
> 15:50:13,392 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type \[ch.qos.logback.classic.encoder.PatternLayoutEncoder\] for \[encoder\] property  
> 15:50:13,393 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@1414147750 - No compression will be used  
> 15:50:13,393 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@1414147750 - Will use the pattern /Users/congee/log/monitor//log-warning-%d\{yyyy-MM-dd\}.%i.log for the active file  
> 15:50:13,393 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2e3fc542 - The date pattern is ‘yyyy-MM-dd’ from file name pattern ‘/Users/congee/log/monitor//log-warning-%d\{yyyy-MM-dd\}.%i.log’.  
> 15:50:13,393 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2e3fc542 - Roll-over at midnight.  
> 15:50:13,393 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2e3fc542 - Setting initial period to Thu Apr 13 15:50:13 CST 2023  
> 15:50:13,394 |-WARN in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2e3fc542 - SizeAndTimeBasedFNATP is deprecated. Use SizeAndTimeBasedRollingPolicy instead  
> 15:50:13,394 |-WARN in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2e3fc542 - For more information see http://logback.qos.ch/manual/appenders.html\#SizeAndTimeBasedRollingPolicy  
> 15:50:13,394 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender\[WARNING\_FILE\] - Active log file name: /Users/congee/log/monitor//log-warning-2023-04-13.0.log  
> 15:50:13,394 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender\[WARNING\_FILE\] - File property is set to \[null\]  
> 15:50:13,394 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type \[ch.qos.logback.core.rolling.RollingFileAppender\]  
> 15:50:13,394 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as \[ERROR\_FILE\]  
> 15:50:13,394 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type \[ch.qos.logback.classic.encoder.PatternLayoutEncoder\] for \[encoder\] property  
> 15:50:13,395 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@22069592 - No compression will be used  
> 15:50:13,395 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@22069592 - Will use the pattern /Users/congee/log/monitor//log-error-%d\{yyyy-MM-dd\}.%i.log for the active file  
> 15:50:13,395 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@4524411f - The date pattern is ‘yyyy-MM-dd’ from file name pattern ‘/Users/congee/log/monitor//log-error-%d\{yyyy-MM-dd\}.%i.log’.  
> 15:50:13,395 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@4524411f - Roll-over at midnight.  
> 15:50:13,395 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@4524411f - Setting initial period to Thu Apr 13 15:50:13 CST 2023  
> 15:50:13,395 |-WARN in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@4524411f - SizeAndTimeBasedFNATP is deprecated. Use SizeAndTimeBasedRollingPolicy instead  
> 15:50:13,395 |-WARN in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@4524411f - For more information see http://logback.qos.ch/manual/appenders.html\#SizeAndTimeBasedRollingPolicy  
> 15:50:13,395 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender\[ERROR\_FILE\] - Active log file name: /Users/congee/log/monitor//log-error-2023-04-13.0.log  
> 15:50:13,395 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender\[ERROR\_FILE\] - File property is set to \[null\]  
> 15:50:13,396 |-ERROR in ch.qos.logback.core.joran.spi.Interpreter@91:31 - no applicable action for \[springProfile\], current ElementPath is \[\[configuration\]\[springProfile\]\]  
> 15:50:13,396 |-ERROR in ch.qos.logback.core.joran.spi.Interpreter@92:54 - no applicable action for \[logger\], current ElementPath is \[\[configuration\]\[springProfile\]\[logger\]\]  
> 15:50:13,396 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - Setting level of ROOT logger to INFO  
> 15:50:13,396 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named \[CONSOLE\] to Logger\[ROOT\]  
> 15:50:13,396 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named \[INFO\_FILE\] to Logger\[ROOT\]  
> 15:50:13,396 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named \[WARNING\_FILE\] to Logger\[ROOT\]  
> 15:50:13,396 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named \[ERROR\_FILE\] to Logger\[ROOT\]  
> 15:50:13,396 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.  
> 15:50:13,396 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@401e7803 - Registering current configuration as safe fallback point

配置完号后的紧接着的日志输出：

> 2023-04-13 15:50:18.450 \[background-preinit\] INFO org.hibernate.validator.internal.util.Version - HV000001: Hibernate Validator 6.1.6.Final  
> 2023-04-13 15:50:18.689 \[main\] INFO c.u.j.c.EnableEncryptablePropertiesBeanFactoryPostProcessor - Post-processing PropertySource instances  
> 2023-04-13 15:50:18.715 \[main\] INFO c.u.j.EncryptablePropertySourceConverter - Converting PropertySource configurationProperties \[org.springframework.boot.context.properties.source.ConfigurationPropertySourcesPropertySource\] to AOP Proxy

可以直观的感受到前面日志的时间格式的变化。

[490efbb5034344e384f78c1305333e83.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/5d580320631a45a6a167376c6e480566.png
[7d70cdc958d04d6b8461f61117828659.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/5a4a87ff79ce4692a131f0b50af968ce.png