spring boot --- Mybatis多数据源

蔚落 2022-02-16 07:48 235阅读 0赞

配置mybatis多数据源，主要提供SqlsessionFactory实例和sqlSessionTemplate实例，其中SqlsessionFactory用于操作数据源，sqlSessionTemplate管理线程是否安全

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODI5Nzg3OQ_size_16_color_FFFFFF_t_70][]

配置多个数据源

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODI5Nzg3OQ_size_16_color_FFFFFF_t_70 1][]

对应的配置数据进行加载

/**
     * mybatis 的数据源的配置
     */
    @Configuration
    @MapperScan(value = "com.mybatisdatasources.mybatisdatasources.BookMapper.BookMapper", sqlSessionFactoryRef = "sqlSessionFactoryBean1")
    public class MyBatisConfigOne {
        @Resource(name = "dataSourceOne")
        DataSource dataSource;
    
        @Bean
        SqlSessionFactory sqlSessionFactoryBean1() throws Exception {
            SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
            bean.setDataSource(dataSource);
            return bean.getObject();
        }
        @Bean
        SqlSessionTemplate sqlSessionTemplate2() throws Exception {
            return  new SqlSessionTemplate(sqlSessionFactoryBean1());
        }
    }

/**
     * mybatis 的数据源的配置
     */
    @Configuration
    @MapperScan(value = "com.mybatisdatasources.mybatisdatasources.BookMapper.BookMapper2", sqlSessionFactoryRef = "sqlSessionFactoryTwo")
    public class MyBatisConfgTwo {
        @Resource(name = "dataSourceTwo")
        DataSource dataSource;
    
        @Bean
        SqlSessionFactory sqlSessionFactoryTwo() throws Exception {
            SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
            factoryBean.setDataSource(dataSource);
            return factoryBean.getObject();
        }
    
        /**
         * 用于设置守护mybatis中的sqlsession 的线程安全
         *
         * @return
         * @throws Exception
         */
        @Bean
        SqlSessionTemplate sqlSessionTemplate() throws Exception {
            return new SqlSessionTemplate(sqlSessionFactoryTwo());
        }
    }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODI5Nzg3OQ_size_16_color_FFFFFF_t_70 2][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODI5Nzg3OQ_size_16_color_FFFFFF_t_70]: /images/20220216/9b558d2e69e84e9ba53b58a08f149b36.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODI5Nzg3OQ_size_16_color_FFFFFF_t_70 1]: /images/20220216/96ce94bd14274a179e02175e8b7a4ace.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zODI5Nzg3OQ_size_16_color_FFFFFF_t_70 2]: /images/20220216/bd6c3e6f37a741ecadc38f278609e581.png