樟树网站建设,完整的app网站开发,湘潭seo磐石网络,手机做网站多少钱SpringBoot集成Mybati 配置多数据源参考上一篇文章
在Spring框架中使用MyBatis时#xff0c;如果配置了多数据源#xff0c;可能会导致之前配置的打印SQL语句的设置失效。这通常是因为在多数据源配置中#xff0c;MyBatis的SQL打印功能只对默认数据源生效#xff0c;而对于…SpringBoot集成Mybati 配置多数据源参考上一篇文章
在Spring框架中使用MyBatis时如果配置了多数据源可能会导致之前配置的打印SQL语句的设置失效。这通常是因为在多数据源配置中MyBatis的SQL打印功能只对默认数据源生效而对于其他数据源需要手动开启SQL打印。
1. 确保你已经在application.properties或application.yml中启用了MyBatis的SQL日志打印功能
# mybatis 配置
mybatis:type-aliases-package: com.roborock.framework.entitymapper-locations: classpath*:mappers/**/*.xmlconfiguration:log-impl: org.apache.ibatis.logging.stdout.StdOutImplmap-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语句configurationBeanConfigurationProperties(prefix mybatis.configuration)public org.apache.ibatis.session.Configuration globalConfiguration() {return new org.apache.ibatis.session.Configuration();}PrimaryBean(name rbkDataSourceProperties)ConfigurationProperties(prefix spring.datasource.druid.rbk)public DataSourceProperties rbkDataSourceProperties() {return new DataSourceProperties();}PrimaryBean(name rbkDataSource)public DataSource storyDataSource(Qualifier(rbkDataSourceProperties) DataSourceProperties rbkDataSourceProperties) {return rbkDataSourceProperties.initializeDataSourceBuilder().build();}PrimaryBean(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();}PrimaryBean(name rbkTransactionManager)public DataSourceTransactionManager rbkTransactionManager(Qualifier(rbkDataSource) DataSource dataSource) {return new DataSourceTransactionManager(dataSource);}PrimaryBean(name rbkSqlSessionTemplate)public SqlSessionTemplate rbkSqlSessionTemplate(Qualifier(rbkSqlSessionFactory) SqlSessionFactory sqlSessionFactory) {return new SqlSessionTemplate(sqlSessionFactory);}}
