20250804

zhaowenxuan

2025-08-04 093362ca4f902996aeb3586b45ebd2791a2b596f

20250804

 src/main/java/com/example/config/DruidConfig.java

@@ -30,7 +30,7 @@
 * @Date: 2024/7/1 10:27
 */
@Slf4j
@Configuration
//@Configuration
public class DruidConfig {
    @Autowired
    private ConfigValue configValue;

 src/main/java/com/example/mapper/SqlMapper.java

New file
@@ -0,0 +1,14 @@
package com.example.mapper;

import org.apache.ibatis.annotations.Select;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: zhaowenxuan
 * @Date: 2025/7/30 10:10
 */
public interface SqlMapper {

    @Select("call pro_tb_his_project()")
    void pro_tb_his_project();
}

 src/main/java/com/example/scheudleds/DictSyncCommon.java

@@ -1,8 +1,11 @@
package com.example.scheudleds;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.example.config.db.DataSourceConfig;
import com.example.config.db.DataSourceContextHolder;
import com.example.domain.DictHosp;
import com.example.factory.ServiceFactory;
import com.example.mapper.SqlMapper;
import com.example.service.DictHospService;
import com.example.service.HisService;
import lombok.extern.slf4j.Slf4j;
@@ -31,23 +34,40 @@

    @Autowired
    private DictHospService dictHospService;
    @Autowired
    private SqlMapper sqlMapper;
    @Autowired
    private DataSourceConfig dataSourceConfig;

    @Scheduled(cron = "0 0 22 * * ?")
    public void executeTasks() {
//        List<String> list = Arrays.asList("shanxiqinxamjyy","shanxiqinpbkwyy","shanxiqinjdczgzyy","shanxiqinsqyy");
        List<String> list = dictHospService.list(new LambdaQueryWrapper<DictHosp>().isNotNull(DictHosp::getBeanName))
                .stream().map(DictHosp::getBeanName).collect(Collectors.toList());
//        List<String> list = dictHospService.list(new LambdaQueryWrapper<DictHosp>().isNotNull(DictHosp::getBeanName))
//                .stream().map(DictHosp::getBeanName).collect(Collectors.toList());
        List<DictHosp> list = dictHospService.list(new LambdaQueryWrapper<DictHosp>().isNotNull(DictHosp::getBeanName));
        log.info("开始执行定时任务：{}", System.currentTimeMillis());
        try {
            for (String hosp : list) {
            for (DictHosp hosp : list) {
                executorService.submit(() -> {
                    try {
                        log.info("开始同步医院数据：{}", hosp);
                        HisService hisService = serviceFactory.getService(hosp);
                        hisService.syncDict(hosp);
                        log.info("完成同步医院数据：{}", hosp);
                        String beanName = hosp.getBeanName();
                        log.info("开始同步医院数据：{}", beanName);
                        HisService hisService = serviceFactory.getService(beanName);
                        hisService.syncDict(beanName);
                        log.info("完成同步医院数据：{}", beanName);
                    } catch (Exception e) {
                        log.error("同步医院数据失败，医院：{}，异常：{}", hosp, e.getMessage());
                        log.error("同步医院数据失败，医院：{}", hosp.getBeanName(), e);
                    }
                    if (hosp.getIsTbHisProject() != null && hosp.getIsTbHisProject() == 1) {
                        try {
                            dataSourceConfig.addDataSource(hosp.getDbname());
                            DataSourceContextHolder.setDataSourceKey(hosp.getDbname());
                            sqlMapper.pro_tb_his_project();
                        } catch (Exception e) {
                            log.error("调用同步存储过程失败，医院：{}", hosp.getBeanName(), e);
                        }finally {
                            DataSourceContextHolder.clear();
                        }
                    }
                });
            }

 src/main/resources/application-win.yaml

@@ -1,6 +1,6 @@
config:
  path: C:\ltkjprojectconf\config.properties
  dir: C:\ltkjprojectconf
#config:
#  path: D:\ltkjprojectconf\config.properties
#  dir: D:\ltkjprojectconf
#  path: C:\ltkjprojectconf\configregion.properties
#  dir: C:\ltkjprojectconf
config:
  path: D:\ltkjprojectconf\configregion.properties
  dir: D:\ltkjprojectconf

 src/main/resources/mapper/SqlMapper.xml

New file
@@ -0,0 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.mapper.SqlMapper">

</mapper>