mybatis plus打印sql日记 - ToB企服应用市场:ToB评测及商务社交产业平台

package com.ybw.config;
import org.apache.ibatis.logging.Log;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
/**
* mybatis日志级别改为info
*
* @author ybw
* @version V1.0
* @className InfoLevelLog
* @date 2024/12/2
**/
public class InfoLevelLogger implements Log {
private final Logger logger;
public InfoLevelLogger(String clazz) {
this.logger = LoggerFactory.getLogger(clazz);
}
@Override
public boolean isDebugEnabled() {
return logger.isInfoEnabled();
}
@Override
public void error(String s, Throwable e) {
logger.error(s, e);
}
@Override
public void error(String s) {
logger.error(s);
}
@Override
public void debug(String s) {
// 修改这里
logger.info(s);
}
@Override
public void warn(String s) {
logger.warn(s);
}
@Override
public boolean isTraceEnabled() {
// 如果需要，也可以将TRACE级别的日志改为INFO
return logger.isInfoEnabled();
}
@Override
public void trace(String s) {
// 修改这里
logger.trace(s);
}
}

复制代码

mybatis:
configuration:
log-impl: com.ybw.config.InfoLevelLogger

复制代码

mybatis-plus:
configuration:
log-impl: com.ybw.config.InfoLevelLogger

复制代码

[INFO ] 2024-12-02 14:37:20.403 [main] org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
[INFO ] 2024-12-02 14:37:20.420 [main] org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7a3643e3] was not registered for synchronization because synchronization is not active
[INFO ] 2024-12-02 14:37:20.517 [main] o.m.s.t.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@3e4afd10] will not be managed by Spring
[INFO ] 2024-12-02 14:37:20.528 [main] c.y.mapper.TestYearMapper.selectList - ==> Preparing: SELECT id,receive_year FROM test_year WHERE (receive_year = ?)
[INFO ] 2024-12-02 14:37:20.660 [main] c.y.mapper.TestYearMapper.selectList - ==> Parameters: 2024(Integer)
[INFO ] 2024-12-02 14:37:20.751 [main] c.y.mapper.TestYearMapper.selectList - <== Columns: id, receive_year
[INFO ] 2024-12-02 14:37:20.753 [main] c.y.mapper.TestYearMapper.selectList - <== Row: 1, 2024-01-01
[INFO ] 2024-12-02 14:37:20.756 [main] c.y.mapper.TestYearMapper.selectList - <== Total: 1
[INFO ] 2024-12-02 14:37:20.762 [main] org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7a3643e3]
[INFO ] 2024-12-02 14:37:20.923 [main] com.ybw.service.TestYearServiceTest - list:[{"id":1,"receiveYear":{"leap":true,"value":2024}}]

复制代码

/**
* sql打印日志
* package命名为mapper方式实现
*
* @methodName: configureLoggers
* @return: void
* @author: ybw
* @date: 2024/7/4
**/
@Bean
public void configureLoggers() {
LoggerContext context = (LoggerContext) LoggerFactory.getILoggerFactory();
Set<String> mapperPackages = findPackagesWithMapper();
if (CollectionUtils.isEmpty(mapperPackages)) {
return;
}
mapperPackages.forEach(packageName -> {
// 设置packageName包的日志级别为DEBUG
context.getLogger(packageName).setLevel(Level.DEBUG);
});
}
/**
* 扫描包下所有mapper
*
* @methodName: findPackagesWithMapper
* @return: java.util.Set<java.lang.String>
* @author: ybw
* @date: 2024/7/4
**/
public Set<String> findPackagesWithMapper() {
// 使用Spring的PathMatchingResourcePatternResolver来查找资源
PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
MetadataReaderFactory metadataReaderFactory = new CachingMetadataReaderFactory(resolver);
// 示例资源路径，根据实际情况调整
String packageSearchPath = "classpath*:**/" + MybatisPlusConstant.Package.BASE_PACKAGE + "/**/*.class";
try {
Resource[] resources = resolver.getResources(packageSearchPath);
Set<String> packagesWithMapper = new HashSet<>();
for (Resource resource : resources) {
if (resource.isReadable()) {
MetadataReader metadataReader = metadataReaderFactory.getMetadataReader(resource);
String packageName = ClassUtils.getPackageName(metadataReader.getClassMetadata().getClassName());
if (packageName.contains(MybatisPlusConstant.Package.PACKAGE_KEYWORD)) {
packagesWithMapper.add(packageName);
}
}
}
return packagesWithMapper;
} catch (IOException e) {
log.error("findPackagesWithMapper error:", e);
}
return new HashSet<>();
}

复制代码