springBoot项目同时使用两个数据库

1.配置文件编写

spring:
  datasource:
    #第一个数据库
    first:
      driver-class-name: org.mariadb.jdbc.Driver
      username: root
      password: 123456
      jdbc-url: jdbc:mariadb://127.0.0.1：3306/first?useUnicode=true&characterEncoding=utf-8
    #第二个数据库
    second:
      driver-class-name: org.mariadb.jdbc.Driver
      username: root
      password: ninemax
      jdbc-url: jdbc:mariadb://127.0.0.2:3306/second?useUnicode=true&characterEncoding=utf-8

2.DataSourceConfigurer类

import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;

import javax.sql.DataSource;

@Configuration
public class DataSourceConfig {
   

    @Bean(name = "firstDataSource")
    @Qualifier("firstDataSource")//指定数据源名称，与Bean中的name属性原理相同，主要是为了确保注入成功
    @Primary//指定的主数据源
    @ConfigurationProperties(prefix = "spring.datasource.first")//将配置文件中的数据源读取进到方法中，进行build
    public DataSource firstDataSource(){
   
        return DataSourceBuilder.create().build();
    }


    @Bean(name = "secondDataSource")
    @Qualifier