SpringBoot整合mybatis配置多数据源

素颜马尾好姑娘i 2021-11-08 18:40 417阅读 0赞

### 一、添加数据库配置 ###

spring.datasource.url=jdbc:mysql://localhost:3306/study
    spring.datasource.username=root
    spring.datasource.password=root
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    
    #自定义数据源test1
    spring.datasource.test1.driverClassName=com.mysql.jdbc.Driver
    spring.datasource.test1.url=jdbc:mysql://localhost:3306/test01?useUnicode=true&characterEncoding=utf-8
    spring.datasource.test1.username=root
    spring.datasource.test1.password=root
    
    #自定义数据源test2
    spring.datasource.test2.driverClassName =com.mysql.jdbc.Driver
    spring.datasource.test2.url=jdbc:mysql://localhost:3306/test02?useUnicode=true&characterEncoding=utf-8
    spring.datasource.test2.username=root
    spring.datasource.test2.password=root

### 二、配置自定义数据源  ###

@Configuration // 注册到springboot容器中
    @MapperScan(basePackages = "com.zhq.test1", sqlSessionFactoryRef = "test1SqlSessionFactory")//com.zhq.test1表示哪个mapper包应用该数据源
    public class DataSource1Config {
    
    	/**
    	 * 
    	 * @methodDesc: 功能描述:(配置test1数据库)
    	 */
    	@Bean(name = "test1DataSource")
    	@Primary
    	@ConfigurationProperties(prefix = "spring.datasource.test1")
    	public DataSource testDataSource() {
    		return DataSourceBuilder.create().build();
    	}
    
    	/**
    	 * 
    	 * @methodDesc: 功能描述:(test1 sql会话工厂)
    	 */
    	@Bean(name = "test1SqlSessionFactory")
    	@Primary
    	public SqlSessionFactory testSqlSessionFactory(@Qualifier("test1DataSource") DataSource dataSource)
    			throws Exception {
    		SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
    		bean.setDataSource(dataSource);
    //		bean.setMapperLocations(
    //				new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/mapper/test1/*.xml"));
    		return bean.getObject();
    	}
    
    	/**
    	 * 
    	 * @methodDesc: 功能描述:(test1 事物管理)
    	 */
    	@Bean(name = "test1TransactionManager")
    	@Primary
    	public DataSourceTransactionManager testTransactionManager(@Qualifier("test1DataSource") DataSource dataSource) {
    		return new DataSourceTransactionManager(dataSource);
    	}
    
    	@Bean(name = "test1SqlSessionTemplate")
    	public SqlSessionTemplate testSqlSessionTemplate(
    			@Qualifier("test1SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
    		return new SqlSessionTemplate(sqlSessionFactory);
    	}
    
    }

test02同理