springboot整合mybatis的多数据源配置文件

@Configuration
@MapperScan(basePackages = “com.asiainfo.mapper”,
sqlSessionTemplateRef = “db1SqlSessionTemplate”)
//是否使用数据库
@ConditionalOnExpression("’${cmsspring.datasource.enable}’ == ‘true’")
public class DataSource1Config {
//获取配置文件的内容
@Autowired
private JdbcSettings JdbcSettings;

@Bean(name = "db1DataSource")
@Primary
public DataSource testDataSource() {
    DruidDataSource dataSource = new DruidDataSource();
    dataSource.setDriverClassName(JdbcSettings.getDriverClassName());
    dataSource.setUrl(JdbcSettings.getUrl());
    dataSource.setUsername(JdbcSettings.userName);
    dataSource.setPassword(JdbcSettings.getPassword());
    return dataSource;
}

@Bean(name = "db1SqlSessionFactory")
@Primary
public SqlSessionFactory testSqlSessionFactory(@Qualifier("db1DataSource") DataSource dataSource) throws Exception {
    SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
    bean.setDataSource(dataSource);
    bean.setMapperLocations(new PathMatchingResourcePatternResolver()
            .getResources("classpath:mapper/*.xml"));
    return bean.getObject();
}

@Bean(name = "db1TransactionManager")
@Primary
public DataSourceTransactionManager testTransactionManager(@Qualifier("db1DataSource") DataSource dataSource) {
    return new DataSourceTransactionManager(dataSource);
}

@Bean(name = "db1SqlSessionTemplate")
@Primary
public SqlSessionTemplate testSqlSessionTemplate(
        @Qualifier("db1SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
    return new SqlSessionTemplate(sqlSessionFactory);
}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
好的,以下是一个简单的 Spring Boot 整合 MyBatis 多数据源的示例代码: 首先,在 pom.xml 文件中添加以下依赖: ```xml <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.1.4</version> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.2.6</version> </dependency> ``` 然后,在 application.properties 文件中配置数据源: ```properties # 主数据源 spring.datasource.url=jdbc:mysql://localhost:3306/db1 spring.datasource.username=root spring.datasource.password=123456 spring.datasource.driver-class-name=com.mysql.jdbc.Driver # 从数据源 spring.datasource.second.url=jdbc:mysql://localhost:3306/db2 spring.datasource.second.username=root spring.datasource.second.password=123456 spring.datasource.second.driver-class-name=com.mysql.jdbc.Driver ``` 接下来,创建两个数据源的配置类: ```java @Configuration @MapperScan(basePackages = "com.example.mapper.primary", sqlSessionTemplateRef = "primarySqlSessionTemplate") public class PrimaryDataSourceConfig { @Bean @Primary @ConfigurationProperties(prefix = "spring.datasource") public DataSource primaryDataSource() { return DruidDataSourceBuilder.create().build(); } @Bean @Primary public SqlSessionFactory primarySqlSessionFactory(@Qualifier("primaryDataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean bean = new SqlSessionFactoryBean(); bean.setDataSource(dataSource); return bean.getObject(); } @Bean @Primary public SqlSessionTemplate primarySqlSessionTemplate(@Qualifier("primarySqlSessionFactory") SqlSessionFactory sqlSessionFactory) { return new SqlSessionTemplate(sqlSessionFactory); } } @Configuration @MapperScan(basePackages = "com.example.mapper.second", sqlSessionTemplateRef = "secondSqlSessionTemplate") public class SecondDataSourceConfig { @Bean @ConfigurationProperties(prefix = "spring.datasource.second") public DataSource secondDataSource() { return DruidDataSourceBuilder.create().build(); } @Bean public SqlSessionFactory secondSqlSessionFactory(@Qualifier("secondDataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean bean = new SqlSessionFactoryBean(); bean.setDataSource(dataSource); return bean.getObject(); } @Bean public SqlSessionTemplate secondSqlSessionTemplate(@Qualifier("secondSqlSessionFactory") SqlSessionFactory sqlSessionFactory) { return new SqlSessionTemplate(sqlSessionFactory); } } ``` 最后,在需要使用数据源的地方,使用 @Qualifier 注解指定数据源: ```java @Service public class UserService { @Autowired @Qualifier("primarySqlSessionTemplate") private SqlSessionTemplate primarySqlSessionTemplate; @Autowired @Qualifier("secondSqlSessionTemplate") private SqlSessionTemplate secondSqlSessionTemplate; public User getUserByIdFromPrimaryDataSource(int id) { return primarySqlSessionTemplate.selectOne("com.example.mapper.primary.UserMapper.getUserById", id); } public User getUserByIdFromSecondDataSource(int id) { return secondSqlSessionTemplate.selectOne("com.example.mapper.second.UserMapper.getUserById", id); } } ``` 希望这个示例能够帮助你!
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值