mybatis 是 ibatis 的进阶版
https://www.jianshu.com/p/b8cbf023df0d
打印 mybatis sql 日志
- 打印 mybatis sql 日志到控制台
/src/main/resources/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>
<!-- 打印查询语句 -->
<setting name="logImpl" value="STDOUT_LOGGING" />
</settings>
</configuration>
- 打印 mybatis sql 到 log4j 文件
<!-- mybatis sql打印到log4j文件-->
<setting name="logImpl" value="LOG4J"/>
打印 ibatis sql 日志
- logback.xml 中添加如下配置
<logger name="com.apache.ibatis" level="DEBUG"/>
<logger name="java.sql.Connection" level="DEBUG"/>
<logger name="java.sql.Statement" level="DEBUG"/>
<logger name="java.sql.PreparedStatement" level="DEBUG"/>
<logger name="com.jxre.bigdata.dao" level="DEBUG"/>