SpringBoot项目多数据源及mybatis驼峰失效的问题解决方法

第SpringBoot项目多数据源及mybatis驼峰失效的问题解决方法目录1配置多数据源时，application.yml的有关mybatis的配置是失效的，因为他不知道配置哪一个数据源2application.yml配置文件3解决方法一4完整代码4解决方法二

1配置多数据源时，application.yml的有关mybatis的配置是失效的，因为他不知道配置哪一个数据源

2application.yml配置文件

server:

#服务器的HTTP端口

port:8097

spring:

#配置数据源

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不进行配置，resultType就得写全名resultType="com.liyh.entity.User"，

#但是如果配置了别名,就可以不用写全路径直接写resultType="User"即可)

type-aliases-package:com.liyh.entity

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

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

#使用驼峰命名

#数据库表列：user_name

#实体类属性：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中设置配置

@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();

*配置事务管理器，不然事务不起作用

*@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中设置驼峰

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();

*配置事务管理器，不然事务不起作用

*@return

@Bean

publicPlatformTransactionManagertransactionManager(){

returnnewDataSourceTransactionManager(this.dataSource());

@Bean

@ConfigurationProperties(prefix="mybatis.configuration")

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

returnneworg.ap