mybatis-plus在控制台打印SQL语句的方法

方法一、在application.yml添加配置

mybatis-plus:
  configuration:
    #默认不显示SQL日志
#    log-impl: org.apache.ibatis.logging.nologging.NoLoggingImpl
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

方法二、 mapper增加日志等级为debug

logging:
 level:
  com.xxx.mapper: debug

mybaits相关配置

mybatis-plus:
  mapper-locations: classpath*:cn/demo/**/mapping/*.xml, classpath:/META-INF/modeler-mybatis-mappings/*.xml
  configuration:
    map-underscore-to-camel-case: true
    cache-enabled: true
    lazy-loading-enabled: true
    multiple-result-sets-enabled: true
    #默认不显示SQL日志
#    log-impl: org.apache.ibatis.logging.nologging.NoLoggingImpl
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  global-config:
    banner: false
    db-config:
      id-type: assign_id
      table-underline: true
    enable-sql-runner: true
  configuration-properties:
    prefix:
    blobType: BLOB
    boolValue: TRUE