mybatis中druid多数据源怎么配置

   2024-10-12 2810
核心提示:在MyBatis中配置Druid多数据源主要需要进行以下步骤:首先,在pom.xml文件中添加Druid和MyBatis的依赖:dependencygroupIdcom.al

在MyBatis中配置Druid多数据源主要需要进行以下步骤:

首先,在pom.xml文件中添加Druid和MyBatis的依赖:
<dependency>    <groupId>com.alibaba</groupId>    <artifactId>druid</artifactId>    <version>1.1.23</version></dependency><dependency>    <groupId>org.mybatis</groupId>    <artifactId>mybatis</artifactId>    <version>3.5.6</version></dependency>
然后在application.properties或者application.yml文件中配置Druid的数据源信息,例如:
spring.datasource.druid.datasource1.url=jdbc:mysql://localhost:3306/test1spring.datasource.druid.datasource1.username=rootspring.datasource.druid.datasource1.password=rootspring.datasource.druid.datasource2.url=jdbc:mysql://localhost:3306/test2spring.datasource.druid.datasource2.username=rootspring.datasource.druid.datasource2.password=root
创建DruidDataSource配置类,用于配置Druid数据源:
@Configurationpublic class DruidDataSourceConfig {    @Bean(name = "dataSource1")    @ConfigurationProperties(prefix = "spring.datasource.druid.datasource1")    public DataSource dataSource1() {        return DruidDataSourceBuilder.create().build();    }    @Bean(name = "dataSource2")    @ConfigurationProperties(prefix = "spring.datasource.druid.datasource2")    public DataSource dataSource2() {        return DruidDataSourceBuilder.create().build();    }    @Bean    @Primary    public DynamicDataSource dataSource(@Qualifier("dataSource1") DataSource dataSource1, @Qualifier("dataSource2") DataSource dataSource2) {        Map<Object, Object> targetDataSources = new HashMap<>();        targetDataSources.put("dataSource1", dataSource1);        targetDataSources.put("dataSource2", dataSource2);        DynamicDataSource dynamicDataSource = new DynamicDataSource();        dynamicDataSource.setTargetDataSources(targetDataSources);        dynamicDataSource.setDefaultTargetDataSource(dataSource1);        return dynamicDataSource;    }    @Bean    public SqlSessionFactory sqlSessionFactory(@Qualifier("dataSource") DataSource dataSource) throws Exception {        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();        sqlSessionFactoryBean.setDataSource(dataSource);        return sqlSessionFactoryBean.getObject();    }    @Bean    public SqlSessionTemplate sqlSessionTemplate(SqlSessionFactory sqlSessionFactory) {        return new SqlSessionTemplate(sqlSessionFactory);    }}
创建DynamicDataSource类,用于动态切换数据源:
public class DynamicDataSource extends AbstractRoutingDataSource {    @Override    protected Object determineCurrentLookupKey() {        return DataSourceContextHolder.getDataSource();    }}
创建DataSourceContextHolder类,用于设置数据源的key:
public class DataSourceContextHolder {    private static final ThreadLocal<String> contextHolder = new ThreadLocal<>();    public static void setDataSource(String key) {        contextHolder.set(key);    }    public static String getDataSource() {        return contextHolder.get();    }    public static void clearDataSource() {        contextHolder.remove();    }}

通过以上步骤,就可以实现在MyBatis中配置Druid多数据源。在需要切换数据源的地方,可以通过调用DataSourceContextHolder.setDataSource("dataSource2")来切换到相应的数据源。

 
举报打赏
 
更多>同类维修大全
推荐图文
推荐维修大全
点击排行

网站首页  |  关于我们  |  联系方式网站留言    |  赣ICP备2021007278号