From 201e9ae76d2c8d6219ceabbf4e1ebb36fc2e7a06 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期四, 11 七月 2024 18:18:23 +0800
Subject: [PATCH] zjh 2024/07/11-1
---
ltkj-admin/src/test/java/zjhTest.java | 151 +++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 130 insertions(+), 21 deletions(-)
diff --git a/ltkj-admin/src/test/java/zjhTest.java b/ltkj-admin/src/test/java/zjhTest.java
index 032c563..8d4ac01 100644
--- a/ltkj-admin/src/test/java/zjhTest.java
+++ b/ltkj-admin/src/test/java/zjhTest.java
@@ -3,12 +3,16 @@
import cn.hutool.core.date.DateUnit;
import cn.hutool.core.date.DateUtil;
import cn.hutool.core.io.FileUtil;
+import cn.hutool.extra.pinyin.PinyinUtil;
import cn.hutool.extra.qrcode.QrCodeUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
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;
import com.ltkj.hosp.domain.TjProject;
import com.ltkj.hosp.service.*;
import lombok.extern.slf4j.Slf4j;
@@ -27,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: 瑗垮畨璺嘲绉戞妧鏈夐檺鍏徃/璧典匠璞�
@@ -44,8 +59,12 @@
//
// @Autowired
// private ITjGroupingProService groupingProService;
- @Autowired
- private ITjProjectService projectService;
+// @Autowired
+// private ITjProjectService projectService;
+// @Resource
+// private ITjCustomerService tjCustomerService;
+// @Resource
+// private ITjPackageService tjPackageService;
//
// @Resource
// private ITjOrderService tjOrderService;
@@ -54,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;
@@ -67,27 +86,117 @@
private String secret;
@Test
public void test() {
+/*
// 鐢熸垚鎸囧畾url瀵瑰簲鐨勪簩缁寸爜鍒版枃浠讹紝瀹藉拰楂橀兘鏄�300鍍忕礌
QrCodeUtil.generate("https://ltpeis.xaltjdkj.cn:5516/1000110001240327094056%E7%8E%89%E5%BF%A0_%E4%BD%93%E6%A3%80%E6%8A%A5%E5%91%8A.pdf", 300, 300, FileUtil.file("D:\\Users\\w\\Desktop\\qrcode.jpg"));
+*/
- }
-
-
- public static void main(String[] args) {
-// String dateStr1 = "2024-03-01 22:33:23";
-// Date date1 = DateUtil.parse(dateStr1);
+// List<TjProject> list = projectService.list();
+// for (TjProject tjProject : list) {
+// tjProject.setProEngName(PinyinUtil.getFirstLetter(tjProject.getProName(),""));
+// projectService.updateById(tjProject);
+// }
//
-////鐩稿樊涓�涓湀锛�31澶�
-// long betweenDay = DateUtil.between(new Date(),date1, DateUnit.DAY);
-// System.out.println(betweenDay);
-// System.out.println(DateUtil.between(new Date(),date1, DateUnit.MS));
-// System.out.println(DateUtil.between(new Date(),date1, DateUnit.SECOND));
+// 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);
+// }
- System.out.println(DateUtil.date().toDateStr());
- System.out.println(DateUtil.date().toString());
+
+// PinyinUtil.getFirstLetter();
+
}
+
+
+
+
+
+
+ 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