数据库配置之sql日志打印

1,springboot与jdbc整合:

logging.level.org.springframework.jdbc.core.JdbcTemplate=DEBUG

2,springboot与jpa整合

jpa:
    hibernate:
      ddl-auto: update  # 第一次简表create  后面用update
    show-sql: true

3,springboot与mybatis整合

方法一:

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

 

使用springboot+mybatis-plus整合配置:

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

 方法二:

logging:
  level:
    com.lucifer.springboot.cache.mapper: debug

4,spring+mybatis整合

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <!-- 打印sql日志 -->
        <setting name="logImpl" value="STDOUT_LOGGING" />
    </settings>
</configuration>