mybatisplus多数据源使用Bean Searcher

柔光的暖阳◎ 2024-03-29 16:06 59阅读 0赞

![6aea9891c5cd4c189c30c723419c10fb.png][] **新建一个类DynamicDataSourceInjection将多数据源主动注入到Spring容器中**

package com.ciih.authcenter.client.config.mybatisplus;
    
    import com.ejlchina.searcher.boot.NamedDataSource;
    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 javax.sql.DataSource;
    
    /**
     * 因其他框架也要用到多数据源，所以这里主动将多数据暴露到Spring容器的外层。
     *
     * @author Lenovo
     */
    @Configuration
    public class DynamicDataSourceInjection {
    
        @Bean(name = "mastermysql")
        @Primary
        @ConfigurationProperties(prefix = "spring.datasource.dynamic.datasource.mastermysql")
        public DataSourceProperties masterMysql() {
            return new DataSourceProperties();
        }
    
        @Bean(name = "slave1")
        @ConfigurationProperties(prefix = "spring.datasource.dynamic.datasource.slave1")
        public DataSourceProperties datasource1() {
            return new DataSourceProperties();
        }
    
        @Bean(name = "slave2")
        @ConfigurationProperties(prefix = "spring.datasource.dynamic.datasource.slave2")
        public DataSourceProperties datasource2() {
            return new DataSourceProperties();
        }
    
    
        @Bean
        public NamedDataSource userNamedDataSource(@Qualifier("slave1") DataSourceProperties dataSourceProperties) {
            DataSource dataSource = dataSourceProperties.initializeDataSourceBuilder().build();
            // 具名数据源：com.ejlchina.searcher.boot.NamedDataSource
            return new NamedDataSource("slave1", dataSource);
        }
    
        @Bean
        public NamedDataSource orderNamedDataSource(@Qualifier("slave2") DataSourceProperties dataSourceProperties) {
            DataSource dataSource = dataSourceProperties.initializeDataSourceBuilder().build();
            // 具名数据源：com.ejlchina.searcher.boot.NamedDataSource
            return new NamedDataSource("slave2", dataSource);
        }
    }

Bean Searcher中使用：

![34240033e64d48d0a2ea022854250ccf.png][]

[6aea9891c5cd4c189c30c723419c10fb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/28/49f5515524d5408995fec1bb06519eb5.png
[34240033e64d48d0a2ea022854250ccf.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/28/1b57220d514f4044b12148174cf4ed00.png