SpringBoot集成Mybati 配置多数据源参考上一篇文章
在Spring框架中使用MyBatis时,如果配置了多数据源,可能会导致之前配置的打印SQL语句的设置失效。这通常是因为在多数据源配置中,MyBatis的SQL打印功能只对默认数据源生效,而对于其他数据源,需要手动开启SQL打印。
1. 确保你已经在application.properties或application.yml中启用了MyBatis的SQL日志打印功能
# mybatis 配置
mybatis:
type-aliases-package: com.roborock.framework.entity
mapper-locations: classpath*:mappers/**/*.xml
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
map-underscore-to-camel-case: true
单数据源直接增加上面的配置mybatis.configuration.log-impl: org.apache.ibatis.logging.stdout.StdOutImpl 即可打印SQL语句
2. 多数据源时,只需要在其中的一个配置类中增加如下配置即可打印SQL语句,不需要在所有数据源配置中都增加
@Bean
@ConfigurationProperties(prefix = "mybatis.configuration")
public org.apache.ibatis.session.Configuration globalConfiguration() {
return new org.apache.ibatis.session.Configuration();
}
然后在其中一个配置类的SqlSessionFactory方法中增加入参Configuration configuration,使用bean.setConfiguration(configuration)即可!
完整代码如下:
package com.study.framework.config;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import javax.sql.DataSource;
/**
* @description rbk数据源配置类
* //basePackages 自己mapper包路径
*/
@Configuration
@MapperScan(basePackages = {"com.study.framework.mapper.rbkmapper"}, sqlSessionFactoryRef = "rbkSqlSessionFactory")
public class rbkDataSourceConfiguration {
//配置打印SQL语句configuration
@Bean
@ConfigurationProperties(prefix = "mybatis.configuration")
public org.apache.ibatis.session.Configuration globalConfiguration() {
return new org.apache.ibatis.session.Configuration();
}
@Primary
@Bean(name = "rbkDataSourceProperties")
@ConfigurationProperties(prefix = "spring.datasource.druid.rbk")
public DataSourceProperties rbkDataSourceProperties() {
return new DataSourceProperties();
}
@Primary
@Bean(name = "rbkDataSource")
public DataSource storyDataSource(@Qualifier("rbkDataSourceProperties") DataSourceProperties rbkDataSourceProperties) {
return rbkDataSourceProperties.initializeDataSourceBuilder().build();
}
@Primary
@Bean("rbkSqlSessionFactory")
public SqlSessionFactory rbkSqlSessionFactory(@Qualifier("rbkDataSource") DataSource rbkDataSource,
org.apache.ibatis.session.Configuration configuration) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(rbkDataSource);
//其中一个数据源中增加如下代码即可打印SQL语句
bean.setConfiguration(configuration);
bean.setMapperLocations(
// 设置mybatis的xml所在位置
new PathMatchingResourcePatternResolver().getResources("classpath*:mappers/rbkmapper/*.xml"));
bean.setTypeAliasesPackage("com.study.framework.entity"); //自己entity包路径
return bean.getObject();
}
@Primary
@Bean(name = "rbkTransactionManager")
public DataSourceTransactionManager rbkTransactionManager(@Qualifier("rbkDataSource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
@Primary
@Bean(name = "rbkSqlSessionTemplate")
public SqlSessionTemplate rbkSqlSessionTemplate(@Qualifier("rbkSqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
return new SqlSessionTemplate(sqlSessionFactory);
}
}