From e37740bcaa6a0dfdef6e082e4d8136b81d453000 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 09 七月 2024 18:16:48 +0800
Subject: [PATCH] zjh 2024/07/9-1
---
ltkj-admin/src/test/java/zjhTest.java | 158 ++++++++++++++++++++++++++++++++++++++++------------
1 files changed, 121 insertions(+), 37 deletions(-)
diff --git a/ltkj-admin/src/test/java/zjhTest.java b/ltkj-admin/src/test/java/zjhTest.java
index db68e95..8d4ac01 100644
--- a/ltkj-admin/src/test/java/zjhTest.java
+++ b/ltkj-admin/src/test/java/zjhTest.java
@@ -9,6 +9,7 @@
import com.ltkj.LtkjApplication;
import com.ltkj.common.core.redis.RedisCache;
import com.ltkj.common.utils.SecurityUtils;
+import com.ltkj.framework.config.MatchUtils;
import com.ltkj.hosp.domain.DictHosp;
import com.ltkj.hosp.domain.TjCustomer;
import com.ltkj.hosp.domain.TjPackage;
@@ -30,10 +31,21 @@
import org.springframework.web.bind.annotation.PostMapping;
import javax.annotation.Resource;
+import java.io.BufferedReader;
+import java.io.InputStreamReader;
+import java.net.HttpURLConnection;
+import java.net.URL;
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
-
+import java.io.BufferedReader;
+import java.io.InputStreamReader;
+import java.net.HttpURLConnection;
+import java.net.URL;
+import java.util.Properties;
/**
* @Author: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃/璧典匠璞�
@@ -47,12 +59,12 @@
//
// @Autowired
// private ITjGroupingProService groupingProService;
- @Autowired
- private ITjProjectService projectService;
- @Resource
- private ITjCustomerService tjCustomerService;
- @Resource
- private ITjPackageService tjPackageService;
+// @Autowired
+// private ITjProjectService projectService;
+// @Resource
+// private ITjCustomerService tjCustomerService;
+// @Resource
+// private ITjPackageService tjPackageService;
//
// @Resource
// private ITjOrderService tjOrderService;
@@ -61,12 +73,12 @@
// @Resource
// private ITjOrderRemarkService remarkService;
//
- @Resource
- private RedisCache redisCache;
-//
- @Autowired
- public RedisTemplate<Object,Object> redisTemplate;
// @Resource
+// private RedisCache redisCache;
+////
+// @Autowired
+// public RedisTemplate<Object,Object> redisTemplate;
+//// @Resource
// private StringRedisTemplate stringRedisTemplate;
@Resource
private IDictHospService dictHospService;
@@ -81,23 +93,23 @@
*/
- List<TjProject> list = projectService.list();
- for (TjProject tjProject : list) {
- tjProject.setProEngName(PinyinUtil.getFirstLetter(tjProject.getProName(),""));
- projectService.updateById(tjProject);
- }
-
- List<TjCustomer> list1 = tjCustomerService.list();
- for (TjCustomer customer : list1) {
- customer.setPym(PinyinUtil.getFirstLetter(customer.getCusName(),""));
- tjCustomerService.updateById(customer);
- }
-
- List<TjPackage> list2 = tjPackageService.list();
- for (TjPackage tjPackage : list2) {
- tjPackage.setPym(PinyinUtil.getFirstLetter(tjPackage.getPacName(),""));
- tjPackageService.updateById(tjPackage);
- }
+// List<TjProject> list = projectService.list();
+// for (TjProject tjProject : list) {
+// tjProject.setProEngName(PinyinUtil.getFirstLetter(tjProject.getProName(),""));
+// projectService.updateById(tjProject);
+// }
+//
+// List<TjCustomer> list1 = tjCustomerService.list();
+// for (TjCustomer customer : list1) {
+// customer.setPym(PinyinUtil.getFirstLetter(customer.getCusName(),""));
+// tjCustomerService.updateById(customer);
+// }
+//
+// List<TjPackage> list2 = tjPackageService.list();
+// for (TjPackage tjPackage : list2) {
+// tjPackage.setPym(PinyinUtil.getFirstLetter(tjPackage.getPacName(),""));
+// tjPackageService.updateById(tjPackage);
+// }
// PinyinUtil.getFirstLetter();
@@ -105,14 +117,86 @@
}
-// public static void main(String[] args) {
-//
-//
-// String a ="璧靛璞�";
-// String firstLetter = PinyinUtil.getFirstLetter(a, "");
-// System.out.println(firstLetter);
-//
-// }
+
+
+
+
+ public static void main(String[] args) {
+ // 鍒濆鏁版嵁搴撻厤缃�
+ String initialUrl = "jdbc:mysql://initial_host:3306/initial_db";
+ String username = "user";
+ String password = "pass";
+
+ // 鏂版暟鎹簱閰嶇疆
+ String newUrl = "jdbc:mysql://new_host:3306/new_db";
+
+ // 鏇存敼杩炴帴URL
+ String urlToUse = initialUrl; // 鍙互鏍规嵁闇�瑕佸垏鎹㈠埌newUrl
+
+ // 鍒涘缓鏁版嵁搴撹繛鎺ュ睘鎬�
+ Properties props = new Properties();
+ props.setProperty("user", username);
+ props.setProperty("password", password);
+
+ try {
+ // 杩炴帴鍒版暟鎹簱
+ Connection conn = DriverManager.getConnection(urlToUse, props);
+
+ // 浣跨敤conn杩涜鏁版嵁搴撴搷浣�...
+
+ // 鍏抽棴杩炴帴
+ conn.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
+
+
+
+ public static void forwardUrl(String targetUrl, String forwardUrl) throws Exception {
+ // 鍒涘缓URL瀵硅薄
+ URL url = new URL(forwardUrl);
+
+ // 鎵撳紑杩炴帴
+ HttpURLConnection connection = (HttpURLConnection) url.openConnection();
+
+ // 璁剧疆璇锋眰鏂规硶
+ connection.setRequestMethod("GET");
+
+ // 璁剧疆璇锋眰澶达紝渚嬪Referer鎴栧叾浠栦綘闇�瑕佽浆鍙戠殑澶翠俊鎭�
+ connection.setRequestProperty("Referer", targetUrl);
+
+ // 杩炴帴
+ connection.connect();
+
+ // 妫�鏌ュ搷搴斾唬鐮�
+ int responseCode = connection.getResponseCode();
+ if (responseCode == HttpURLConnection.HTTP_OK) {
+ // 璇诲彇鏈嶅姟鍣ㄥ搷搴�
+ BufferedReader in = new BufferedReader(new InputStreamReader(connection.getInputStream()));
+ String inputLine;
+ StringBuilder response = new StringBuilder();
+
+ while ((inputLine = in.readLine()) != null) {
+ response.append(inputLine);
+ }
+
+ in.close();
+
+ // 鎵撳嵃鏈嶅姟鍣ㄥ搷搴�
+ System.out.println(response.toString());
+ } else {
+ System.out.println("GET request not worked");
+ }
+
+ // 鍏抽棴杩炴帴
+ connection.disconnect();
+ }
+
+
+
+
+
//
// public static String getAdd(String log, String lat ){
// //lat 灏� log 澶�
--
Gitblit v1.8.0