SpringBoot多数据源配置

小赵同学爱榴莲

于 2024-09-18 09:55:51 发布

阅读量300

点赞数 1

文章标签： spring boot 后端 java 架构 sql

本文链接：https://blog.csdn.net/bigchen_1/article/details/142324998

版权

项目中需要用到多个数据源，百度了很多文章，发现很多都很麻烦，需要写很多配置类，下面是我配置多数据源的过程，使用dynamic为基础，三步完成多数据源的配置，做个记录后面回顾！以下为具体过程以及完整代码：

第一步：首先确定你需要确定你需要使用的数据源，在yml文件中进行配置，我配置了两个mysql数据源以及一个sqlserver数据源，yml配置如下：

server:
  port: 8085
spring:
  datasource:
    dynamic:
      primary: db1 # 配置默认数据库
      datasource:
        db1: # 数据源1配置
          url: jdbc:mysql://localhost:3306/db1?characterEncoding=utf8&useUnicode=true&useSSL=false&serverTimezone=GMT%2B8
          username: root
          password: 123456
          driver-class-name: com.mysql.cj.jdbc.Driver
        db2: # 数据源2配置
          url: jdbc:mysql://localhost:3306/db2?characterEncoding=utf8&useUnicode=true&useSSL=false&serverTimezone=GMT%2B8
          username: root
          password: 123456
          driver-class-name: com.mysql.cj.jdbc.Driver
        db3: # 数据源3配置
          url: jdbc:sqlserver://127.0.0.1;SelectMethod=cursor;DatabaseName=db3
          username: sa
          password: 123456
          driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
      druid:
        initial-size: 1
        max-active: 20
        min-idle: 1
        max-wait: 60000
  autoconfigure:
    exclude:  com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 去除druid配置

需要注意的就是最后一行，springboot默认会使用自动配置，需要在yml文件加这个配置或者在启动类中增加注解@SpringBootApplication(exclude = DruidDataSourceAutoConfigure.class)，否则会启动报错！

第二步：添加相关依赖，因为我使用了myqls以及sqlserver两个数据源，依赖中就需要同时引入这两个数据库的相关依赖，还有个配置多数据源的dynamic依赖，完成依赖代码如下：

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
		 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.1.9.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.example</groupId>
	<artifactId>java-product</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>java-product</name>
	<description>Demo project for Spring Boot</description>

	<properties>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<!--mybatis-plus依赖-->
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>mybatis-plus-boot-starter</artifactId>
			<version>3.2.0</version>
		</dependency>

		<!--多数据源dynamic依赖-->
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
			<version>2.5.6</version>
		</dependency>

		<!--mysql依赖-->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>

		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid-spring-boot-starter</artifactId>
			<version>1.1.20</version>
		</dependency>

		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
			<version>1.18.32</version>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>

		<!--sqlserver依赖-->
		<dependency>
			<groupId>com.microsoft.sqlserver</groupId>
			<artifactId>mssql-jdbc</artifactId>
			<version>6.4.0.jre8</version> <!-- 请检查最新的版本 -->
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>

	</build>

	<profiles>
		<profile>
			<id>local1</id>
			<properties>
				<profileActive>local1</profileActive>
			</properties>
			<activation>
				<activeByDefault>true</activeByDefault>
			</activation>
		</profile>
		<profile>
			<id>local2</id>
			<properties>
				<profileActive>local2</profileActive>
			</properties>
		</profile>
	</profiles>


	<!-- 配置阿里云仓库 -->
	<repositories>
		<repository>
			<id>aliyun-repos</id>
			<url>https://maven.aliyun.com/repository/public</url>
			<releases>
				<enabled>true</enabled>
			</releases>
			<snapshots>
				<enabled>false</enabled>
			</snapshots>
		</repository>
	</repositories>
	<pluginRepositories>
		<pluginRepository>
			<id>aliyun-repos</id>
			<url>https://maven.aliyun.com/repository/public</url>
			<releases>
				<enabled>true</enabled>
			</releases>
			<snapshots>
				<enabled>false</enabled>
			</snapshots>
		</pluginRepository>
	</pluginRepositories>


</project>

第三步：此时已经配置结束了，是不感觉很简单，我们写个测试类进行测试

package com.example.firstboot.controller;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.example.firstboot.domain.PlatDayProduct;
import com.example.firstboot.domain.PlatDayTemp;
import com.example.firstboot.domain.SysUser;
import com.example.firstboot.domain.ZtUser;
import com.example.firstboot.service.PlatDayProductService;
import com.example.firstboot.service.PlatDayTempService;
import com.example.firstboot.service.SysUserService;
import com.example.firstboot.service.ZtUserService;
import lombok.RequiredArgsConstructor;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.ArrayList;
import java.util.List;

@RestController
@RequiredArgsConstructor
@RequestMapping("/task")
public class TaskController {

    @Autowired
    private final PlatDayProductService platDayProductService;
    @Autowired
    private final SysUserService sysUserService;
    @Autowired
    private final ZtUserService ztUserService;

    @PostMapping("/sysUser")
    public Object getUser(){
        List<SysUser> list =sysUserService.list();
        return list;
    }

    @PostMapping("/ztUser")
    @DS("db2")
    public Object getZentaoUser(){
        List<ZtUser> list = ztUserService.list();
        return list;
    }

    @PostMapping("/taskList")
    @DS("db3")
    public Object getTaskList(){
        List<PlatDayProduct> list = platDayProductService.getList();
        return list;
    }
}

上面三个方法分别查询了配置的三个数据源，使用@DS注解即可进行数据源的切换，对比db1为主数据源，默认查询的就是这个数据源，所以无需增加注解，使用其他数据源的时候则需要使用此注解进行区分，好了结束！