springboot 整合jpa多数据源（sqlsever和mysql）

原创

已于 2022-06-19 20:36:11 修改 · 1.2k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #spring boot #sqlserver

于 2022-06-19 20:35:35 首次发布

springboot jpa实现增删改查

1.配置依赖
2.配置数据库链接
3.创建多数据源配置类
4.创建Entity
5.创建Repository
6.创建Service和ServiceImpl
7.创建单元测试运行查看效果

1.配置依赖

pom.xml

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>sqljdbc4</artifactId>
            <version>4.0</version>
            <scope>runtime</scope>
        </dependency>

2.配置数据库链接

application.yml

spring:
  jpa:
    open-in-view: false
    database-platform: org.hibernate.dialect.SQLServerDialect
    show-sql: true
    database: sql_server
    hibernate:
      default_schema: dbo
      ddl-auto: validate
  datasource:
    qmishop:
      jdbc-url: jdbc:mysql://***:3306/***?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8
      username: ***
      password: ***
      driver-class-name: com.mysql.cj.jdbc.Driver
    jeeboot3:
      jdbc-url: jdbc:sqlserver://***:1433;SelectMethod=cursor;DatabaseName=***
      username: ***
      password: ***
      driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver

3.创建多数据源配置类

DataSourceConfig.java

package cn.qmi.study3.config.jpa;


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 = "qmishopDataSource")
    @Qualifier("qmishopDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.qmishop")
    @Primary
    public DataSource qmishopDataSource() {
   
   
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "jeeboot3DataSource")
    @Qualifier("jeeboot3DataSource")
    @ConfigurationProperties(prefix = "spring.datasource.jeeboot3")
    public DataSource jeeboot3DataSource() {
   
   
        return DataSourceBuilder.create().build