From 2863a68e336bd9b2d187e98557bdc7cc6b9aac2e Mon Sep 17 00:00:00 2001 From: zjh <zjh@888> Date: 星期四, 27 六月 2024 10:21:49 +0800 Subject: [PATCH] zjh 本地 2024/06/27 --1 --- ltkj-admin/src/test/java/zjhTest.java | 43 +++++++++++++++++++++++++++++++++++-------- 1 files changed, 35 insertions(+), 8 deletions(-) diff --git a/ltkj-admin/src/test/java/zjhTest.java b/ltkj-admin/src/test/java/zjhTest.java index 845975f..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; @@ -34,6 +35,9 @@ 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; @@ -41,6 +45,7 @@ import java.io.InputStreamReader; import java.net.HttpURLConnection; import java.net.URL; +import java.util.Properties; /** * @Author: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃/璧典匠璞� @@ -112,17 +117,39 @@ } - public static void main(String[] args) { - try { - forwardUrl("192.168.0.5","www.baidu.com"); - } catch (Exception e) { - e.printStackTrace(); + + + 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(); + } } - - } - -- Gitblit v1.8.0