SSM切换数据库

最新推荐文章于 2024-04-03 11:31:45 发布

渴了的鱼

最新推荐文章于 2024-04-03 11:31:45 发布

阅读量817

点赞数

CC 4.0 BY-SA版权

分类专栏：数据类型转换文章标签：数据库切换

本文链接：https://blog.youkuaiyun.com/weixin_42164207/article/details/86570190

数据类型转换专栏收录该内容

2 篇文章

订阅专栏

该博客介绍了如何在SSM（Spring、SpringMVC、MyBatis）框架下进行数据库切换的配置。通过创建两个不同的配置类`MyConfiguration`和`OraConfiguration`，分别加载一号和二号数据库的相关配置，包括数据源、SqlSessionFactory和SqlSessionTemplate。在实际应用中，可以根据业务需求选择合适的数据源进行操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

工具类：

1.一号数据库:
/**
* 加载数据库相关配置
*
*/
@Configuration
@MapperScan(basePackages = { "...mySqlDao" }, sqlSessionFactoryRef = "sqlSessionFactory1")
public class MyConfiguration {
   /**
    * 数据源
    * @return
    */
   @Autowired
   @Qualifier("myDataSource")
   private DataSource ds2;

   @Bean
    public SqlSessionFactory sqlSessionFactory1() throws Exception {
        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
        factoryBean.setDataSource(ds2);
        PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        // 加载mapper的路径
      factoryBean.setMapperLocations(resolver.getResources("classpath:.../sqlmapperMySql/*Mapper.xml"));

return factoryBean.getObject();

}

    @Bean
    public SqlSessionTemplate sqlSessionTemplate1() throws Exception {
        SqlSessionTemplate template = new SqlSessionTemplate(sqlSessionFactory1());
        return template;
    }
}

2.二号数据库:

/**
* 加载数据库相关配置
*
*/
@Configuration
@MapperScan(basePackages = { "...dao" }, sqlSessionFactoryRef = "sqlSessionFactory2")
public class OraConfiguration {
   /**
    * 数据源
    * @return
    */
   @Autowired
   @Qualifier("orDataSource")
   private DataSource ds1;

   @Bean
    public SqlSessionFactory sqlSessionFactory2() throws Exception {
        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
        factoryBean.setDataSource(ds1);
        PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        // 加载mapper的路径
      factoryBean.setMapperLocations(resolver.getResources("classpath:.../sqlmapper/*Mapper.xml"));
        return factoryBean.getObject();

}

    @Bean
    public SqlSessionTemplate sqlSessionTemplate2() throws Exception {
        SqlSessionTemplate template = new SqlSessionTemplate(sqlSessionFactory2());
        return template;
    }

}

3.调用控制:


/**
 * 多数据声明
 */
@Configuration
public class DataSourceConfig {

    /**
    * @return mysql 
    */
   @Primary    //配置该数据源为主数据源
    @Bean(name = "myDataSource")
    @Qualifier(value = "myDataSource")  
    @ConfigurationProperties(prefix = "spring.datasource.mysql")
    public DataSource myagenDataSource(){
        return DataSourceBuilder.create().build();
    }

    /**
    * @return oracle 
    */
    @Bean(name = "orDataSource")
    @Qualifier(value = "orDataSource")
   @ConfigurationProperties(prefix = "spring.datasource.or")
    public DataSource orderDiscountDataSource(){
        return DataSourceBuilder.create().build();
    }
}

附图：