\u56e0\u4e3a\u9879\u76ee\u9700\u8981\uff0c\u9700\u8981\u5728\u9879\u76ee\u8fd0\u884c\u8fc7\u7a0b\u4e2d\u80fd\u591f\u52a8\u6001\u4fee\u6539\u6570\u636e\u6e90\uff08\u5373\uff1a\u6570\u636e\u6e90\u7684\u70ed\u66f4\u65b0\uff09\u3002\u8fd9\u91cc\u4ee5 \u8fd9\u91cc\u4e3a\u4ec0\u4e48\u8981\u91cd\u5199\u8fd9\u4e2a\u7c7b\uff1a\u56e0\u4e3aDruidDataSource\u6570\u636e\u6e90\u5728\u521d\u59cb\u5316\u540e\uff0c\u5c31\u4e0d\u5141\u8bb8\u518d\u91cd\u65b0\u8bbe\u7f6e\u6570\u636e\u5e93\u7684url\u548cuserName<\/p>\n <\/p>\n \u91cd\u5199\u7684\u65f6\u5019\u5305\u8def\u5f84\u4e0d\u80fd\u53d8\uff0c\u53ea\u6709\u8fd9\u6837\u7c7b\u52a0\u8f7d\u7684\u65f6\u5019\u624d\u4f1a\u4f18\u5148\u52a0\u8f7d\u91cd\u5199\u540e\u7684\u7c7b<\/p>\n DruidConfiguration.java<\/p>\n \u8fd9\u91cc\u8981\u6ce8\u610f\u589e\u52a0 SpringUtils.java<\/p>\n \u524d\u8a00 \u56e0\u4e3a\u9879\u76ee\u9700\u8981\uff0c\u9700\u8981\u5728\u9879\u76ee\u8fd0\u884c\u8fc7\u7a0b\u4e2d\u80fd\u591f\u52a8\u6001\u4fee\u6539\u6570\u636e\u6e90\uff08\u5373\uff1a\u6570\u636e\u6e90\u7684\u70ed\u66f4\u65b0\uff09\u3002\u8fd9\u91cc\u4ee5com.alibaba […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,41],"tags":[],"class_list":["post-1922","post","type-post","status-publish","format-standard","hentry","category-nacos","category-spring-boot"],"_links":{"self":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/comments?post=1922"}],"version-history":[{"count":0,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/1922\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}com.alibaba.druid.pool.DruidDataSource<\/code>\u6570\u636e\u6e90\u4e3a\u4f8b<\/p>\n\u7b2c\u4e00\u6b65\uff1a\u91cd\u5199DruidAbstractDataSource\u7c7b<\/h3>\n
package com.alibaba.druid.pool;\n...\n\npublic abstract class DruidAbstractDataSource extends WrapperAdapter implements DruidAbstractDataSourceMBean, DataSource, DataSourceProxy, Serializable {\n\n ...\n\n public void setUrl(String jdbcUrl) {\n if (StringUtils.equals(this.jdbcUrl, jdbcUrl)) {\n return;\n }\n \/\/ \u91cd\u5199\u7684\u65f6\u5019\uff0c\u9700\u8981\u5c06\u8fd9\u4e2a\u5224\u65ad\u6ce8\u91ca\u6389\uff0c\u5426\u5219\u4f1a\u62a5\u9519\n \/\/ if (inited) {\n \/\/ throw new UnsupportedOperationException();\n \/\/ }\n\n if (jdbcUrl != null) {\n jdbcUrl = jdbcUrl.trim();\n }\n\n this.jdbcUrl = jdbcUrl;\n\n \/\/ if (jdbcUrl.startsWith(ConfigFilter.URL_PREFIX)) {\n \/\/ this.filters.add(new ConfigFilter());\n \/\/ }\n }\n\n public void setUsername(String username) {\n if (StringUtils.equals(this.username, username)) {\n return;\n }\n \/\/ \u91cd\u5199\u7684\u65f6\u5019\uff0c\u9700\u8981\u5c06\u8fd9\u4e2a\u5224\u65ad\u6ce8\u91ca\u6389\uff0c\u5426\u5219\u4f1a\u62a5\u9519\n \/\/ if (inited) {\n \/\/ throw new UnsupportedOperationException();\n \/\/ }\n\n this.username = username;\n }\n}<\/code><\/pre>\n\u7b2c\u4e8c\u6b65\uff1a\u914d\u7f6e\u52a8\u6001\u83b7\u53d6Nacos\u914d\u7f6e\u4fe1\u606f<\/h3>\n
import com.alibaba.druid.pool.DruidDataSource;\nimport lombok.Data;\nimport lombok.extern.slf4j.Slf4j;\nimport org.springframework.beans.factory.annotation.Value;\nimport org.springframework.cloud.context.config.annotation.RefreshScope;\nimport org.springframework.context.annotation.Bean;\nimport org.springframework.context.annotation.Configuration;\n\n\/**\n * \u63cf\u8ff0\uff1a\u5982\u679c\u4e0d\u4f7f\u7528\u4ee3\u7801\u624b\u52a8\u521d\u59cb\u5316DataSource\u7684\u8bdd\uff0c\u76d1\u63a7\u754c\u9762\u7684SQL\u76d1\u63a7\u4f1a\u6ca1\u6709\u6570\u636e\n *\/\n@Slf4j\n@Configuration\n@RefreshScope\n@Data\npublic class DruidConfiguration {\n @Value("${spring.datasource.url}")\n private String dbUrl;\n\n @Value("${spring.datasource.username}")\n private String username;\n\n @Value("${spring.datasource.password}")\n private String password;\n\n @Value("${spring.datasource.driver-class-name}")\n private String driverClassName;\n\n \/\/ @Value("${spring.datasource.initialSize}")\n \/\/ private int initialSize;\n \/\/\n \/\/ @Value("${spring.datasource.minIdle}")\n \/\/ private int minIdle;\n \/\/\n \/\/ @Value("${spring.datasource.maxActive}")\n \/\/ private int maxActive;\n \/\/\n \/\/ @Value("${spring.datasource.maxWait}")\n \/\/ private int maxWait;\n \/\/\n \/\/ @Value("${spring.datasource.timeBetweenEvictionRunsMillis}")\n \/\/ private int timeBetweenEvictionRunsMillis;\n \/\/\n \/\/ @Value("${spring.datasource.minEvictableIdleTimeMillis}")\n \/\/ private int minEvictableIdleTimeMillis;\n \/\/\n \/\/ @Value("${spring.datasource.validationQuery}")\n \/\/ private String validationQuery;\n \/\/\n \/\/ @Value("${spring.datasource.testWhileIdle}")\n \/\/ private boolean testWhileIdle;\n \/\/\n \/\/ @Value("${spring.datasource.testOnBorrow}")\n \/\/ private boolean testOnBorrow;\n \/\/\n \/\/ @Value("${spring.datasource.testOnReturn}")\n \/\/ private boolean testOnReturn;\n \/\/\n \/\/ @Value("${spring.datasource.poolPreparedStatements}")\n \/\/ private boolean poolPreparedStatements;\n \/\/\n \/\/ @Value("${spring.datasource.maxPoolPreparedStatementPerConnectionSize}")\n \/\/ private int maxPoolPreparedStatementPerConnectionSize;\n \/\/\n \/\/ @Value("${spring.datasource.filters}")\n \/\/ private String filters;\n \/\/\n \/\/ @Value("${spring.datasource.connectionProperties}")\n \/\/ private String connectionProperties;\n \/\/\n \/\/ @Value("${spring.datasource.useGlobalDataSourceStat}")\n \/\/ private boolean useGlobalDataSourceStat;\n\n @Bean\n @RefreshScope\n public DruidDataSource dataSource() {\n DruidDataSource datasource = new DruidDataSource();\n datasource.setUrl(this.dbUrl);\n datasource.setUsername(username);\n datasource.setPassword(password);\n datasource.setDriverClassName(driverClassName);\n\n \/\/configuration\n \/\/ datasource.setInitialSize(initialSize);\n \/\/ datasource.setMinIdle(minIdle);\n \/\/ datasource.setMaxActive(maxActive);\n \/\/ datasource.setMaxWait(maxWait);\n \/\/ datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);\n \/\/ datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);\n \/\/ datasource.setValidationQuery(validationQuery);\n \/\/ datasource.setTestWhileIdle(testWhileIdle);\n \/\/ datasource.setTestOnBorrow(testOnBorrow);\n \/\/ datasource.setTestOnReturn(testOnReturn);\n \/\/ datasource.setPoolPreparedStatements(poolPreparedStatements);\n \/\/ datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);\n \/\/ datasource.setUseGlobalDataSourceStat(useGlobalDataSourceStat);\n \/\/ try {\n \/\/ datasource.setFilters(filters);\n \/\/ } catch (SQLException e) {\n \/\/ log.error("druid configuration initialization filter: " + e);\n \/\/ }\n \/\/ datasource.setConnectionProperties(connectionProperties);\n return datasource;\n }\n}<\/code><\/pre>\n@RefreshScope<\/code>\u6ce8\u89e3<\/p>\n\u7b2c\u4e09\u6b65\uff1a\u624b\u52a8\u5237\u65b0\u6570\u636e\u6e90<\/h3>\n
@GetMapping("\/refresh")\npublic String refresh() throws SQLException\n{\n DruidDataSource master = SpringUtils.getBean("dataSource");\n master.setUrl(druidConfiguration.getDbUrl());\n master.setUsername(druidConfiguration.getUsername());\n master.setPassword(druidConfiguration.getPassword());\n master.setDriverClassName(druidConfiguration.getDriverClassName());\n master.restart();\n return userName + "<>" + jdbcUrl + "----------" + druidConfiguration.getDbUrl();\n}<\/code><\/pre>\nimport org.springframework.beans.BeansException;\nimport org.springframework.context.ApplicationContext;\nimport org.springframework.context.ApplicationContextAware;\nimport org.springframework.stereotype.Component;\n\nimport java.util.Map;\n\n@Component\npublic class SpringUtils implements ApplicationContextAware {\n\n private static ApplicationContext applicationContext;\n\n @Override\n public void setApplicationContext(ApplicationContext applicationContext) throws BeansException {\n SpringUtils.applicationContext = applicationContext;\n }\n\n public static <T> T getBean(String beanName) {\n if (applicationContext.containsBean(beanName)) {\n return (T) applicationContext.getBean(beanName);\n } else {\n return null;\n }\n }\n\n public static <T> Map<String, T> getBeansOfType(Class<T> baseType) {\n return applicationContext.getBeansOfType(baseType);\n }\n\n public static ApplicationContext getApplicationContext() {\n return applicationContext;\n }\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"