SpringBoot項(xiàng)目多數(shù)據(jù)源及mybatis駝峰失效的問(wèn)題解決方法

第SpringBoot項(xiàng)目多數(shù)據(jù)源及mybatis駝峰失效的問(wèn)題解決方法目錄1配置多數(shù)據(jù)源時(shí)，application.yml的有關(guān)mybatis的配置是失效的，因?yàn)樗恢琅渲媚囊粋€(gè)數(shù)據(jù)源2application.yml配置文件3解決方法一4完整代碼4解決方法二

1配置多數(shù)據(jù)源時(shí)，application.yml的有關(guān)mybatis的配置是失效的，因?yàn)樗恢琅渲媚囊粋€(gè)數(shù)據(jù)源

2application.yml配置文件

server:

#服務(wù)器的HTTP端口

port:8097

spring:

#配置數(shù)據(jù)源

datasource:

master:

jdbc-url:jdbc:mysql://localhost:3306/testuseSSL=falseserverTimezone=UTC

username:root

password:root

driver-class-name:com.mysql.cj.jdbc.Driver

test:

jdbc-url:jdbc:mysql://localhost:3306/test2useSSL=falseserverTimezone=UTC

username:root

password:root

driver-class-name:com.mysql.cj.jdbc.Driver

#MyBatis配置

mybatis:

#搜索指定包別名

#(如果typeAliasesPackage不進(jìn)行配置，resultType就得寫(xiě)全名resultType="com.liyh.entity.User"，

#但是如果配置了別名,就可以不用寫(xiě)全路徑直接寫(xiě)resultType="User"即可)

type-aliases-package:com.liyh.entity

#配置mapper的掃描，找到所有的mapper.xml映射文件

mapper-locations:classpath*:mapper/**/*Mapper.xml

#使用駝峰命名

#數(shù)據(jù)庫(kù)表列：user_name

#實(shí)體類屬性：userName

configuration:

map-underscore-to-camel-case:true

3解決方法一

1application.yml的配置駝峰保留

2定義全局的配置

@Bean

@ConfigurationProperties(prefix="mybatis.configuration")

publicorg.apache.ibatis.session.Configurationconfiguration(){

returnneworg.apache.ibatis.session.Configuration();

}

3在sqlSessionFactory中設(shè)置配置

@Primary

@Bean(name="masterSqlSessionFactory")

publicSqlSessionFactorysqlSessionFactory(@Qualifier("masterDataSource")DataSourcedataSource,org.apache.ibatis.session.Configurationconfiguration)throwsException{

SqlSessionFactoryBeansqlSessionFactoryBean=newSqlSessionFactoryBean();

sqlSessionFactoryBean.setDataSource(dataSource);

sqlSessionFactoryBean.setMapperLocations(newPathMatchingResourcePatternResolver()

.getResources("classpath*:mapper/*.xml"));

sqlSessionFactoryBean.setTypeAliasesPackage("com.liyh.entity");

sqlSessionFactoryBean.setConfiguration(configuration);

returnsqlSessionFactoryBean.getObject();

}

4完整代碼

packagecom.liyh.config;

importorg.apache.ibatis.session.SqlSessionFactory;

importorg.mybatis.spring.SqlSessionFactoryBean;

importorg.mybatis.spring.annotation.MapperScan;

importorg.springframework.beans.factory.annotation.Qualifier;

importperties.ConfigurationProperties;

importorg.springframework.boot.jdbc.DataSourceBuilder;

importorg.springframework.context.annotation.Bean;

importorg.springframework.context.annotation.Configuration;

importorg.springframework.context.annotation.Primary;

importorg.springframework.core.io.support.PathMatchingResourcePatternResolver;

importorg.springframework.jdbc.datasource.DataSourceTransactionManager;

importorg.springframework.transaction.PlatformTransactionManager;

importjavax.sql.DataSource;

@Configuration

@MapperScan(basePackages={"com.liyh.mapper"},sqlSessionFactoryRef="masterSqlSessionFactory")

publicclassMybatisMasterConfig{

@Bean(name="masterDataSource")

@ConfigurationProperties(prefix="spring.datasource.master")

publicDataSourcedataSource(){

returnDataSourceBuilder.create().build();

*配置事務(wù)管理器，不然事務(wù)不起作用

*@return

@Bean

publicPlatformTransactionManagertransactionManager(){

returnnewDataSourceTransactionManager(this.dataSource());

@Bean

@ConfigurationProperties(prefix="mybatis.configuration")

publicorg.apache.ibatis.session.Configurationconfiguration(){

returnneworg.apache.ibatis.session.Configuration();

@Primary

@Bean(name="masterSqlSessionFactory")

publicSqlSessionFactorysqlSessionFactory(@Qualifier("masterDataSource")DataSourcedataSource,org.apache.ibatis.session.Configurationconfiguration)throwsException{

SqlSessionFactoryBeansqlSessionFactoryBean=newSqlSessionFactoryBean();

sqlSessionFactoryBean.setDataSource(dataSource);

sqlSessionFactoryBean.setMapperLocations(newPathMatchingResourcePatternResolver()

.getResources("classpath*:mapper/*.xml"));

sqlSessionFactoryBean.setTypeAliasesPackage("com.liyh.entity");

sqlSessionFactoryBean.setConfiguration(configuration);

returnsqlSessionFactoryBean.getObject();

}

4解決方法二

1在sqlSessionFactory返回的bean中設(shè)置駝峰

sqlSessionFactoryBean.getObject().getConfiguration().setMapUnderscoreToCamelCase(true);

@Primary

@Bean(name="masterSqlSessionFactory")

publicSqlSessionFactorysqlSessionFactory(@Qualifier("masterDataSource")DataSourcedataSource)throwsException{

SqlSessionFactoryBeansqlSessionFactoryBean=newSqlSessionFactoryBean();

sqlSessionFactoryBean.setDataSource(dataSource);

sqlSessionFactoryBean.setMapperLocations(newPathMatchingResourcePatternResolver()

.getResources("classpath*:mapper/*.xml"));

sqlSessionFactoryBean.setTypeAliasesPackage("com.liyh.entity");

sqlSessionFactoryBean.getObject().getConfiguration().setMapUnderscoreToCamelCase(true);

returnsqlSessionFactoryBean.getObject();

}

2完整代碼

packagecom.liyh.config;

importorg.apache.ibatis.session.SqlSessionFactory;

importorg.mybatis.spring.SqlSessionFactoryBean;

importorg.mybatis.spring.annotation.MapperScan;

importorg.springframework.beans.factory.annotation.Qualifier;

importperties.ConfigurationProperties;

importorg.springframework.boot.jdbc.DataSourceBuilder;

importorg.springframework.context.annotation.Bean;

importorg.springframework.context.annotation.Configuration;

importorg.springframework.context.annotation.Primary;

importorg.springframework.core.io.support.PathMatchingResourcePatternResolver;

importorg.springframework.jdbc.datasource.DataSourceTransactionManager;

importorg.springframework.transaction.PlatformTransactionManager;

importjavax.sql.DataSource;

@Configuration

@MapperScan(basePackages={"com.liyh.mapper"},sqlSessionFactoryRef="masterSqlSessionFactory")

publicclassMybatisMasterConfig{

@Bean(name="masterDataSource")

@ConfigurationProperties(prefix="spring.datasource.master")

publicDataSourcedataSource(){

returnDataSourceBuilder.create().build();

*配置事務(wù)管理器，不然事務(wù)不起作用

*@return

@Bean

publicPlatformTransactionManagertransactionManager(){

returnnewDataSourceTransactionManager(this.dataSource());

@Bean

@ConfigurationProperties(prefix="mybatis.configuration")

publicorg.apache.ibatis.session.Configurationconfiguration(){

returnneworg.ap