路泰科技体检后端
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zjh
2024-07-11 201e9ae76d2c8d6219ceabbf4e1ebb36fc2e7a06 
 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  大