1、配置文件 application-dev.yml 设置
spring:
datasource:
ds1:
url: jdbc:mysql://10.126.89.86:58885/xxxx?useSSL=false
username: xxxx
password: xxxxx
driver-class-name: com.mysql.jdbc.Driver
ds2:
url: jdbc:mysql://10.126.89.86:58885/xxx?useSSL=false
username: xxxx
password: xxxxxx
driver-class-name: com.mysql.jdbc.Driver
mybatis:
mapper-locations: classpath:mybatis/mapper/*.xml
type-aliases-package: com.data.pcv.dao.model
config-locations: classpath:mybatis/mybatis-config.xml
configuration:
map-underscore-to-camel-case: true
use-generated-keys: true
2、配置Druid 多个数据源和 Druid监控Servlet
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import java.util.HashMap;
import java.util.Map;
@Configuration
public class DruidConfig {
private static final Logger log = LoggerFactory.getLogger(DruidConfig.class);
//数据源一
@Bean(name = "ds1DataSource" )
@ConfigurationProperties(prefix="spring.datasource.ds1")
public DruidDataSource ds1DataSource() {
DruidDataSource druidDataSource = new DruidDataSource();
return druidDataSource;
}
//数据源二
@Bean(name = "ds2DataSource" )
@ConfigurationProperties(prefix="spring.datasource.ds2")
public DruidDataSource ds2DataSource() {
DruidDataSource druidDataSource = new DruidDataSource();
return druidDataSource;
}
@Bean
public ServletRegistrationBean