From 8f61316069a6ffffb0998ed3f498bd4e3acc77e4 Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期二, 10 五月 2022 11:36:15 +0800
Subject: [PATCH] 优化 费用
---
java110-db/src/main/java/com/java110/db/DataSourceConfig.java | 96 +++++++++++++++++++++++++++++++----------------
1 files changed, 63 insertions(+), 33 deletions(-)
diff --git a/java110-db/src/main/java/com/java110/db/DataSourceConfig.java b/java110-db/src/main/java/com/java110/db/DataSourceConfig.java
old mode 100644
new mode 100755
index d65e9b8..38cf6bd
--- a/java110-db/src/main/java/com/java110/db/DataSourceConfig.java
+++ b/java110-db/src/main/java/com/java110/db/DataSourceConfig.java
@@ -1,8 +1,16 @@
package com.java110.db;
+import org.apache.shardingsphere.shardingjdbc.api.yaml.YamlShardingDataSourceFactory;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
+import org.springframework.core.env.Environment;
+import org.springframework.core.io.ClassPathResource;
+import org.springframework.core.io.Resource;
-import java.io.IOException;
+import javax.servlet.Filter;
+import javax.sql.DataSource;
+import java.io.*;
import java.sql.SQLException;
/**
@@ -11,10 +19,12 @@
@Configuration
public class DataSourceConfig {
-// @Autowired
-// private Filter statFilter;
-//
-// private static final String SHARDING_YML_PATH = "dataSource.yml";
+ //@Autowired
+ private Filter statFilter;
+
+ @Autowired
+ private Environment env;
+ private static final String SHARDING_YML_PATH = "dataSource.yml";
/**
* 鏋勫缓dataSource
@@ -26,32 +36,52 @@
* @throws IOException IO 寮傚父
* @since 1.8
*/
-// @Bean
-// public DataSource dataSource() throws SQLException, IOException {
-// YamlShardingConfiguration config = parse();
-// YamlShardingRuleConfiguration rule = config.getShardingRule();
-// for (String key : config.getDataSources().keySet()) {
-// DruidDataSource d = (DruidDataSource) config.getDataSources().get(key);
-// d.setProxyFilters(Lists.newArrayList(statFilter));
-// }
-// return ShardingDataSourceFactory.createDataSource(config.getDataSources(),
-// rule.getShardingRuleConfiguration(), config.getConfigMap(), config.getProps());
-// }
-//
-// /**
-// * 瑙ｆ瀽yml
-// *
-// * @return yaml 閰嶇疆鏂囦欢
-// * @throws IOException IO 寮傚父
-// * @throws FileNotFoundException 鏂囦欢鏈彂鐜板紓甯�
-// * @throws UnsupportedEncodingException 涓嶆敮鎸佺紪鐮佸紓甯�
-// */
-// private MasterSlaveDataSourceFactory parse() throws IOException, FileNotFoundException, UnsupportedEncodingException {
-// Resource certResource = new ClassPathResource(SHARDING_YML_PATH);
-// try (
-// InputStreamReader inputStreamReader = new InputStreamReader(certResource.getInputStream(), "UTF-8")
-// ) {
-// return YamlMasterSlaveDataSourceFactory;
-// }
-// }
+ @Bean
+ public DataSource dataSource() throws SQLException, IOException {
+ String path = SHARDING_YML_PATH;
+
+ String[] actives = env.getActiveProfiles();
+ if (actives != null && actives.length > 0 && !"dev".equals(actives[0])) {
+ path = "dataSource-" + actives[0] + ".yml";
+ }
+
+ String configString = new String(getYmlFile(path), "UTF-8");
+ configString = configString.replaceAll("\\$\\{mysqlpwd\\}", env.getProperty("mysqlpwd"));
+
+ return YamlShardingDataSourceFactory.createDataSource(configString.getBytes("UTF-8"));
+ }
+
+ /**
+ * 瑙ｆ瀽yml
+ *
+ * @return yaml 閰嶇疆鏂囦欢
+ * @throws IOException IO 寮傚父
+ * @throws FileNotFoundException 鏂囦欢鏈彂鐜板紓甯�
+ * @throws UnsupportedEncodingException 涓嶆敮鎸佺紪鐮佸紓甯�
+ */
+ private byte[] getYmlFile(String path) throws IOException {
+ Reader reader = null;
+ InputStream inputStream = null;
+ ByteArrayOutputStream swapStream = null;
+ try {
+ Resource resource = new ClassPathResource(path);
+
+ inputStream = resource.getInputStream();
+ swapStream = new ByteArrayOutputStream();
+ byte[] buff = new byte[100];
+ int rc = 0;
+ while ((rc = inputStream.read(buff, 0, 100)) > 0) {
+ swapStream.write(buff, 0, rc);
+ }
+ byte[] in2b = swapStream.toByteArray();
+ return in2b;
+ } finally {
+ if (inputStream != null) {
+ inputStream.close();
+ }
+ if (swapStream != null) {
+ swapStream.close();
+ }
+ }
+ }
}
--
Gitblit v1.8.0