方法一
-
在mybatis的配置文件中添加
<settings> <!-- 打印sql日志 --> <setting name="logImpl" value="STDOUT_LOGGING" /> </settings>
例:在mybatis的配置文件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" /> </settings> </configuration>
-
在springboot的配置文件appcation.yml中添加:
mybatis: configuration: log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
properties中:mybatis.configuration.log-impl= org.apache.ibatis.logging.stdout.StdOutImpl
方法二
在springboot的配置文件添加
logging:
level:
com.lucifer.springboot.cache.mapper: debug
com.lucifer.springboot.cache.mapper是包名
方法三
如果使用的是springboot+mybatis-plus
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.3.1</version>
</dependency>
application.yml
mybatis-plus:
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl