3.从nacos配置中心读取mysql数据源DataSource

0.使用前提，已经配置了nacos服务，项目里已经搭建完成了springboot从nacos中读取数据的相关组件。

1.因为druid存在连接池泄露。此处使用springboot默认的连接池hikari

2.在nacos配置中心配置数据源，如下：

spring:
  datasource:
    driverClassName: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/up_db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
    username: root
    password: password
    # Hikari 连接池配置
    hikari:
      # 最小空闲连接数量
      minimum-idle: 5
      # 空闲连接存活最大时间，默认600000（10分钟）
      idle-timeout: 180000
      # 连接池最大连接数，默认是10
      maximum-pool-size: 30
      # 此属性控制从池返回的连接的默认自动提交行为,默认值：true
      auto-commit: true
      # 连接池名称
      pool-name: MyHikariCP
      # 此属性控制池中连接的最长生命周期，值0表示无限生命周期，默认1800000即30分钟
      max-lifetime: 1800000
      # 数据库连接超时时间,默认30秒，即30000
      connection-timeout: 30000
      connection-test-query: SELECT 1

3.使用java配置方式配置Datasource属性

import com.zaxxer.hikari.HikariDataSource;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.cloud.context.config.annotation.RefreshScope;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

@RefreshScope//nacos实时刷新注解
@Configuration
public class DatasourceConfig {

    @Value("${spring.datasource.driverClassName}")
    String driverClass;
    @Value("${spring.datasource.url}")
    String url;
    @Value("${spring.datasource.username}")
    String userName;
    @Value("${spring.datasource.password}")
    String passWord;
    @Value("${spring.datasource.hikari.minimum-idle}")
    Integer minimumIdle;
    @Value("${spring.datasource.hikari.idle-timeout}")
    Long idleTimeout;
    @Value("${spring.datasource.hikari.maximum-pool-size}")
    Integer maximumPoolSize;
    @Value("${spring.datasource.hikari.auto-commit}")
    Boolean autoCommit;
    @Value("${spring.datasource.hikari.pool-name}")
    String poolName;
    @Value("${spring.datasource.hikari.max-lifetime}")
    Long maxLifetime;
    @Value("${spring.datasource.hikari.connection-timeout}")
    Long connectionTimeout;
    @Value("${spring.datasource.hikari.connection-test-query}")
    String connectionTestQuery;

    @Bean
    public DataSource druidDataSource() {
        HikariDataSource hikariDataSource = new HikariDataSource();
        hikariDataSource.setJdbcUrl(url);
        hikariDataSource.setDriverClassName(driverClass);
        hikariDataSource.setUsername(userName);
        hikariDataSource.setPassword(passWord);

        hikariDataSource.setMaximumPoolSize(maximumPoolSize);
        hikariDataSource.setAutoCommit(autoCommit);
        hikariDataSource.setMaxLifetime(maxLifetime);
        hikariDataSource.setConnectionTimeout(connectionTimeout);
        hikariDataSource.setPoolName(poolName);
        hikariDataSource.setConnectionTestQuery(connectionTestQuery);
        hikariDataSource.setIdleTimeout(idleTimeout);
        hikariDataSource.setMinimumIdle(minimumIdle);
        return hikariDataSource;
    }
}