- 通过mavem进配置 使用本方法,将讲项目中的settings.xml文件内容放置到USER_HOME/.m2/settings.xml中,或者使用lib包提供的jar文件
<dependency>
<groupId>com.javayh</groupId>
<artifactId>javayh-boot-data-source</artifactId>
<version>1.0.0.RELEASE</version>
</dependency>
如果您在项目启动时出现循环调用，请在启动类加上 @EnableAutoConfiguration(exclude={DataSourceAutoConfiguration.class})
- 配置文件
spring:
datasource:
dynamic:
enable: true #开启多数据源，如果不开启多数据源，改为false，
druid:
# JDBC 配置(驱动类自动从url的mysql识别,数据源类型自动识别,可以配置多个驱动，这里仅以Mysql为例)
core: #关闭多数据时请去掉，走正常的配置即可
url: jdbc:mysql://localhost:3306/db1?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
follower:
url: jdbc:mysql://localhost:3306/db2?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
public void get(){
DataSourceHolder.setDataSourceKey(DataSourceKey.core);
SysMenu sysMenu = menuMapper.findMenu("用户管理界面");
DataSourceHolder.setDataSourceKey(DataSourceKey.follower);
SysUser sysUser = userMapper.selectUserByName("admin");
log.info("sysMenu ={}",sysMenu);
log.info("sysUser ={}",sysUser);
}
@DataSource(name = "core")
public void get(){
SysMenu sysMenu = menuMapper.findMenu("用户管理界面");
log.info("sysMenu ={}",sysMenu);
}