Spring boot+mybatis 打印SQL

mybatis配置添加:

<!--打印SQL语句-->
<setting name="logImpl" value="STDOUT_LOGGING" />

mybatis-config.xml

<?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" />
        <!-- Globally enables or disables any caches configured in any mapper under this configuration -->
        <setting name="cacheEnabled" value="true"/>
        <!-- Sets the number of seconds the driver will wait for a response from the database -->
        <setting name="defaultStatementTimeout" value="3000"/>
        <!-- Enables automatic mapping from classic database column names A_COLUMN to camel case classic Java property names aColumn -->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
        <!-- Allows JDBC support for generated keys. A compatible driver is required.
        This setting forces generated keys to be used if set to true,
         as some drivers deny compatibility but still work -->
        <setting name="useGeneratedKeys" value="true"/>
    </settings>
    <!-- Continue going here -->
</configuration>

application.properties

# mybatis配置 显示SQL
logging.level.包名(是dao或mapper,不是xml)=debug

 

posted @ 2020-02-22 16:39  —八戒—  阅读(226)  评论(0)    收藏  举报