MyBatis輸出SQL日志

方式一： 指定mybatis日志級别

# application.yml
mybatis:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

# 等價于application.properties
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl      

方式二：配置mybatis-config.xml

<configuration>
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
</configuration>      

方式三：指定整個mapper包下的日志級别

# application.yml
logging:
  level:
    com.example.demo.mapper: debug

# 等價于application.properties
logging.level.com.example.demo.mapper=debug      

# application.yml
logging:
  level:
    com.example.demo.mapper: debug

# 等價于application.properties
logging.level.com.example.demo.mapper=debug      

參考

1. SpringBoot+MyBatis如何配置log4j日志輸出（sql）
2. spring boot如何列印mybatis的執行sql