java的orm框架 mybatis 如何查看sql，debug输出

在maven项目中添加slf4j和logback后，执行查询会输出具体的sql语句方便查询，排查错误

logback方便，不用配置，默认输出到控制台

pom.xml

<dependencies>
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.2.8</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.34</version>
    </dependency>
    <!-- slf4j -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>1.7.10</version>
    </dependency>
    <!-- logback -->
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>1.1.2</version>
    </dependency>
</dependencies>

mybatis-configuration.xml 配置

<configuration>  
    <settings>
        <setting name="jdbcTypeForNull" value="NULL"/>
        <setting name="logImpl" value="LOG4J"/>  
    </settings>  
</configuration> 

日志输出：

14:39:19.042 [main] DEBUG org.apache.ibatis.logging.LogFactory - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
14:39:19.069 [main] DEBUG o.a.i.d.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
14:39:19.070 [main] DEBUG o.a.i.d.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
14:39:19.070 [main] DEBUG o.a.i.d.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
14:39:19.070 [main] DEBUG o.a.i.d.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
14:39:19.214 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
14:39:19.691 [main] DEBUG o.a.i.d.pooled.PooledDataSource - Created connection 1260134048.
14:39:19.692 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@4b1c1ea0]
14:39:19.695 [main] DEBUG mapper.CourseMapper.selectCourse - ==>  Preparing: select * from course where id = ? 
14:39:19.768 [main] DEBUG mapper.CourseMapper.selectCourse - ==> Parameters: 1(Integer)
14:39:19.866 [main] DEBUG mapper.CourseMapper.selectCourse - <==      Total: 1
劳动
14:39:19.868 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@4b1c1ea0]
14:39:19.870 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@4b1c1ea0]
14:39:19.870 [main] DEBUG o.a.i.d.pooled.PooledDataSource - Returned connection 1260134048 to pool.
14:39:19.904 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
14:39:19.934 [main] DEBUG o.a.i.d.pooled.PooledDataSource - Created connection 712256162.
14:39:19.934 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@2a742aa2]
14:39:19.935 [main] DEBUG mapper.CourseMapper.selectCourse - ==>  Preparing: select * from course where id = ? 
14:39:19.935 [main] DEBUG mapper.CourseMapper.selectCourse - ==> Parameters: 2(Integer)
14:39:19.945 [main] DEBUG mapper.CourseMapper.selectCourse - <==      Total: 1
自然
14:39:19.946 [main] DEBUG mapper.CourseMapper.selectCourse2 - ==>  Preparing: SELECT * FROM course WHERE takeTime = ? 
14:39:19.947 [main] DEBUG mapper.CourseMapper.selectCourse2 - ==> Parameters: 6(Integer)
14:39:19.949 [main] DEBUG mapper.CourseMapper.selectCourse2 - <==      Total: 1
语文
14:39:19.950 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@2a742aa2]
14:39:19.950 [main] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@2a742aa2]
14:39:19.951 [main] DEBUG o.a.i.d.pooled.PooledDataSource - Returned connection 712256162 to pool.