|
import cn.hutool.core.date.DateTime;
|
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;
|
import org.junit.Test;
|
import org.junit.runner.RunWith;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
|
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
|
import org.springframework.boot.test.context.SpringBootTest;
|
import org.springframework.data.redis.core.Cursor;
|
import org.springframework.data.redis.core.RedisTemplate;
|
import org.springframework.data.redis.core.ScanOptions;
|
import org.springframework.data.redis.core.StringRedisTemplate;
|
import org.springframework.test.context.junit4.SpringRunner;
|
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: 西安路泰科技有限公司/赵佳豪
|
* @Date: 2022/12/12 9:05
|
*/
|
@RunWith(SpringRunner.class)
|
@SpringBootTest(classes = LtkjApplication.class, webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT)
|
@Slf4j
|
@EnableAutoConfiguration(exclude = {DataSourceAutoConfiguration.class})
|
public class zjhTest {
|
//
|
// @Autowired
|
// private ITjGroupingProService groupingProService;
|
// @Autowired
|
// private ITjProjectService projectService;
|
// @Resource
|
// private ITjCustomerService tjCustomerService;
|
// @Resource
|
// private ITjPackageService tjPackageService;
|
//
|
// @Resource
|
// private ITjOrderService tjOrderService;
|
// @Resource
|
// private ITjOrderDetailService tjOrderDetailService;
|
// @Resource
|
// private ITjOrderRemarkService remarkService;
|
//
|
// @Resource
|
// private RedisCache redisCache;
|
////
|
// @Autowired
|
// public RedisTemplate<Object,Object> redisTemplate;
|
//// @Resource
|
// private StringRedisTemplate stringRedisTemplate;
|
@Resource
|
private IDictHospService dictHospService;
|
@Value("${token.secret_key}")
|
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"));
|
|
*/
|
|
// 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();
|
|
}
|
|
|
|
|
|
|
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 大
|
// //参数解释: 纬度,经度 type 001 (100代表道路，010代表POI，001代表门址，111可以同时显示前三项)
|
// String urlString = "http://gc.ditu.aliyun.com/regeocoding?l="+lat+","+log+"&type=010";
|
// JSONObject salerJson=JSONObject.parseObject(getUrl(urlString));
|
// JSONObject jsonData=JSONObject.parseObject(String.valueOf(salerJson));
|
// /* JSONArray fileItemsjson = JSONArray.fromObject(jsonData.get("addrList").toString());
|
// System.out.println("地区"+fileItemsjson);
|
// JSONObject job = fileItemsjson.getJSONObject(0);*/
|
// return jsonData.toString();
|
// }
|
//
|
// public static String getUrl(String url)
|
// {
|
// String resData = null;
|
// StringBuffer s = new StringBuffer();
|
// BufferedReader bReader = null;
|
// try {
|
// //114.55.248.182
|
// URL urlWeb = new URL(url);
|
// URLConnection connection = urlWeb.openConnection();
|
// bReader = new BufferedReader(new InputStreamReader(connection.getInputStream(), "utf-8"));
|
// while (null != (resData = bReader.readLine())) {
|
// s.append(resData);
|
// }
|
// bReader.close();
|
// } catch (MalformedURLException e) {
|
// e.printStackTrace();
|
// } catch (IOException e) {
|
// e.printStackTrace();
|
// }
|
// System.out.println(s);
|
// return s.toString();
|
// }
|
}
|
