MyBatis配置日志打印完整SQL和参数

MyBatis配置日志打印完整SQL和参数

工程使用springboot搭建，日志使用logback框架

    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.1.3</version>
    </dependency>

配置文件新增mybatis配置 log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

mybatis:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.tencent.iov.baicorv.tsp.bss
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    map-underscore-to-camel-case: true

效果如下：

Creating a new SqlSession
Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@19e6a2e3]
JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@3bc31e47] will be managed by Spring
==>  Preparing: select id, create_time, update_time, create_by, update_by, title, `status`, question_num, `delete` from tab_paper where id = ? 
==> Parameters: c6b2dba8cfaf4caa8234cc68b745e00d(String)
<==    Columns: id, create_time, update_time, create_by, update_by, title, status, question_num, delete
<==        Row: c6b2dba8cfaf4caa8234cc68b745e00d, 2020-10-22 16:01:45, 2020-12-02 14:09:57, goodnight, goodnight, meihuijia , 2, 4, 0
<==      Total: 1
Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@19e6a2e3]
Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@19e6a2e3]
Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@19e6a2e3]