第一种:
配置类型
- # 配置 slq 打印日志
- logging.level.com.lawt.repository.mapper=debug
打印出来:
如果只需要打印
第二种:
java 代码类型
- /**
- * 打印 sql
- */
- @Bean
- public PerformanceInterceptor performanceInterceptor() {
- PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor();
- // 格式化 sql 语句
- Properties properties = new Properties();
- properties.setProperty("format", "false");
- performanceInterceptor.setProperties(properties);
- return performanceInterceptor;
- }
打印:
- Time:21 ms - ID:com.lawt.repository.mapper.UserInfoMapper.selectById
- Execute SQL:SELECT id,user_name FROM user_info WHERE id=111
来源: https://www.qcloud.com/developer/article/1464111