springboot 实现多个库查询

如果多个模块的代码需要用到不同的数据库查询那该怎么搞?

创建配置类

配置连接数据库一weave

@Configuration
@MapperScan(basePackages = {"dao接口包的路径"}, sqlSessionTemplateRef = "weaveSqlSessionTemplate")
public class WeaveDatabaseConfiguration {
    @Value("${spring.datasource.weave.url}")
    private String dbUrl;
    @Value("${spring.datasource.weave.username}")
    private String username;
    @Value("${spring.datasource.weave.password}")
    private String password;
    @Value("${spring.datasource.weave.driver-class-name}")
    private String driverClassName;
    @Value("${spring.datasource.weave.initialSize}")
    private int initialSize;
    @Value("${spring.datasource.weave.minIdle}")
    private int minIdle;
    @Value("${spring.datasource.weave.maxActive}")
    private int maxActive;
    @Value("${spring.datasource.weave.maxWait}")
    private int maxWait;
    @Value("${spring.datasource.weave.timeBetweenEvictionRunsMillis}")
    private int timeBetweenEvictionRunsMillis;
    @Value("${spring.datasource.weave.minEvictableIdleTimeMillis}")
    private int minEvictableIdleTimeMillis;
    @Value("${spring.datasource.weave.validationQuery}")
    private String validationQuery;
    @Value("${spring.datasource.weave.testWhileIdle}")
    private boolean testWhileIdle;
    @Value("${spring.datasource.weave.testOnBorrow}")
    private boolean testOnBorrow;
    @Value("${spring.datasource.weave.testOnReturn}")
    private boolean testOnReturn;
    @Value("${spring.datasource.weave.poolPreparedStatements}")
    private boolean poolPreparedStatements;
    @Value("${spring.datasource.weave.maxPoolPreparedStatementPerConnectionSize}")
    private int maxPoolPreparedStatementPerConnectionSize;
    @Value("${mybatis.type-aliases-package}")
    private String aliasesPackagePattern;
    @Value("${pagehelper.weave.helperDialect}")
    private String pagehelperHelperDialect;

    @Bean(name = "weaveDataSource")
    public DataSource dataSource(DataSourceProperties properties) {

        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setUrl(this.dbUrl);
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        dataSource.setDriverClassName(driverClassName);

        //configuration
        dataSource.setInitial
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值