springboot DruidData 配置多数据源

最新推荐文章于 2024-06-25 17:10:04 发布

矮小的

最新推荐文章于 2024-06-25 17:10:04 发布

阅读量537

点赞数

分类专栏： Spring 文章标签： spring boot mysql java

本文链接：https://blog.csdn.net/crazyo2jam/article/details/120669389

版权

Spring 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

项目依赖

pom

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

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <!--阿里数据库连接池 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.2.6</version>
        </dependency>
        <!-- Mysql驱动包 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!-- SpringBoot集成mybatis框架 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.3</version>
        </dependency>

        <!-- SpringBoot 拦截器 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-aop</artifactId>
        </dependency>

yml

我们简单的使用本地mysql 创建两个数据库

datasource1>school>名字A
datasource2>school>名字B


spring:
  datasource:
    one:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://127.0.0.1:3306/datasource1?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
      username: root
      password: 123456
    two:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://127.0.0.1:3306/datasource2?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
      username: root
      password: 123456
  # 数据库通用配置
    type: com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.cj.jdbc.Driver
    druid:
      # 初始连接数
      initialSize: 5
      # 最小连接池数量
      minIdle: 10
      # 最大连接池数量
      maxActive: 20
      # 配置获取连接等待超时的时间
      maxWait: 60000
      # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
      timeBetweenEvictionRunsMillis: 60000
      # 配置一个连接在池中最小生存的时间，单位是毫秒
      minEvictableIdleTimeMillis: 300000
      # 配置一个连接在池中最大生存的时间，单位是毫秒
      maxEvictableIdleTimeMillis: 900000
      # 配置检测连接是否有效
      validationQuery: SELECT 1 FROM DUAL
      testWhileIdle: true
      testOnBorrow: false
      testOnReturn: false
      webStatFilter:
        enabled: true
      statViewServlet:
        enabled: true
        # 设置白名单，不填则允许所有访问
        allow:
        url-pattern: /monitor/druid/*
      filter:
        stat:
          enabled: true
          # 慢SQL记录
          log-slow-sql: true
          slow-sql-millis: 1000
          merge-sql: true
        wall:
          config:
            multi-statement-allow: true
            
server:
  port: 8070

Druid配置属性

/**
 * druid 配置属性
 *
 * @author lhcredit
 */
@Configuration
public class DruidProperties {
    @Value("${spring.datasource.druid.initialSize}")
    private int initialSize;

    @Value("${spring.datasource.druid.minIdle}")
    private int minIdle;

    @Value("${spring.datasource.druid.maxActive}")
    private int maxActive;

    @Value("${spring.datasource.druid.maxWait}")
    private int maxWait;

    @Value("${spring.datasource.druid.timeBetweenEvictionRunsMillis}")
    private int timeBetweenEvictionRunsMillis;

    @Value("${spring.datasource.druid.minEvictableIdleTimeMillis}")
    private int minEvictableIdleTimeMillis;

    @Value("${spring.datasource.druid.maxEvictableIdleTimeMillis}")
    private int maxEvictableIdleTimeMillis;

    @Value("${spring.datasource.druid.validationQuery}")
    private String validationQuery;

    @Value("${spring.datasource.druid.testWhileIdle}")
    private boolean testWhileIdle;

    @Value("${spring.datasource.druid.testOnBorrow}")
    private boolean testOnBorrow;

    @Value("${spring.datasource.druid.testOnReturn}")
    private boolean testOnReturn;

    public DruidDataSource dataSource(DruidDataSource datasource) {
        /** 配置初始化大小、最小、最大 */
        datasource.setInitialSize(initialSize);
        datasource.setMaxActive(maxActive);
        datasource.setMinIdle(minIdle);

        /** 配置获取连接等待超时的时间 */
        datasource.setMaxWait(maxWait);

        /** 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 */
        datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);

        /** 配置一个连接在池中最小、最大生存的时间，单位是毫秒 */
        datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
        datasource.setMaxEvictableIdleTimeMillis(maxEvictableIdleTimeMillis);

        /**
         * 用来检测连接是否有效的sql，要求是一个查询语句，常用select 'x'。如果validationQuery为null，testOnBorrow、testOnReturn、testWhileIdle都不会起作用。
         */
        datasource.setValidationQuery(validationQuery);
        /** 建议配置为true，不影响性能，并且保证安全性。申请连接的时候检测，如果空闲时间大于timeBetweenEvictionRunsMillis，执行validationQuery检测连接是否有效。 */
        datasource.setTestWhileIdle(testWhileIdle);
        /** 申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。 */
        datasource.setTestOnBorrow(testOnBorrow);
        /** 归还连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。 */
        datasource.setTestOnReturn(testOnReturn);
        return datasource;
    }
}

配置数据源

package com.movedatasource.config;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.annotation.Resource;
import javax.sql.DataSource;

@Configuration
public class DataSourceConfig {
    @Bean(name = "dbSource1")
    @ConfigurationProperties(prefix = "spring.datasource.one")
    @Primary  //自动装配时当出现多个Bean候选者时，被注解为@Primary的Bean将作为首选者，否则将抛出异常。（只对接口的多个实现生效）
    DataSource dbSource1(DruidProperties properties){
        DruidDataSource druidDataSource= DruidDataSourceBuilder.create().build();
        return properties.dataSource(druidDataSource);
    }

    @Bean(name="dbSource2")
    @ConfigurationProperties(prefix = "spring.datasource.two")
    DataSource dbSource2(DruidProperties druidProperties){
        DruidDataSource dataSource = DruidDataSourceBuilder.create().build();
        return druidProperties.dataSource(dataSource);
    }
    // 数据源1 对应映射mapper1
    @Configuration
    @MapperScan(basePackages = "com.movedatasource.demo.mapper1",sqlSessionFactoryRef = "sqlSessionFactory1",sqlSessionTemplateRef="sqlSessionTemplate1")
    class MyBatisConfigOne{
        @Resource(name = "dbSource1")
        DataSource  dbOne;

        @Bean
        @Primary
        SqlSessionFactory sqlSessionFactory1()throws Exception {
            SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
            PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
            // xml路径
            bean.setMapperLocations(resolver.getResources("classpath:mybatis/*Mapper.xml"));
            bean.setDataSource(dbOne);
            return bean.getObject();
        }
        @Bean
        @Primary
        SqlSessionTemplate sqlSessionTemplate1() throws Exception{
            return new SqlSessionTemplate(sqlSessionFactory1());
        }
    }
    // 数据源2 对应映射mapper2
    @Configuration
    @MapperScan(basePackages = "com.movedatasource.demo.mapper2",sqlSessionFactoryRef = "sqlSessionFactory2",sqlSessionTemplateRef="sqlSessionTemplate2")
    class MyBatisConfigTwo{
        @Resource(name = "dbSource2")
        DataSource  dbTwo;

        @Bean
        SqlSessionFactory sqlSessionFactory2()throws Exception {
            SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
            PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
            // xml路径
            bean.setMapperLocations(resolver.getResources("classpath:mybatis/*Mapper.xml"));
            bean.setDataSource(dbTwo);
            return bean.getObject();
        }
        @Bean
        SqlSessionTemplate sqlSessionTemplate2() throws Exception{
            return new SqlSessionTemplate(sqlSessionFactory2());
        }
    }
}

在这里插入图片描述

调用测试

@SpringBootTest
class DemoApplicationTests {
    @Autowired
    TestServicelmpl servicelmpl;
    @Test
    void contextLoads() {
        servicelmpl.getSchoolInfo();
    }
}

@Service
public class TestServicelmpl {
    @Autowired
    TestMapper mapper1;
    @Autowired
    Test2Mapper mapper2;

    public void getSchoolInfo(){
       School sc1= mapper1.getInfo();
       School sc2= mapper2.getInfo();
       System.out.println(sc1.toString());
       System.out.println(sc2.toString());
    }
}

@Mapper
public interface TestMapper {
    @Select("select * from school")
    School getInfo();
}

在这里插入图片描述

矮小的

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
springboot DruidData 配置多数据源

项目依赖pom <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId
复制链接

扫一扫

专栏目录