src/main/java/com/integrated/zyyt/ZyytConstant.java

@@ -1,5 +1,7 @@
package com.integrated.zyyt;

import org.springframework.stereotype.Component;

/**
 * 中邮易通常量
 *
@@ -9,25 +11,33 @@
 * @Description
 * @Version 1.0
 **/
@Component
public class ZyytConstant {
    public static String URL_AUTHON = "http://10.225.71.10:9090/api/clients/auth";
    private static String IP_PORT = "http://10.225.71.10:9090";

//    @Value(value = "${zyyt.ipPort}")
//    public void setIpPort(String ipPort) {
//        ZyytConstant.IP_PORT = ipPort;
//    }

    public static String URL_AUTHON = IP_PORT + "/api/clients/auth";
    // 批次号生成前缀
    public static String batchNoPrefix = "ZYYT";

    //1.社会快递日报表 YYZT_T_SHKDRB
    public static String URL_SHKDRB_QUERY = "http://10.225.71.10:9090/api/sql-services/ZYE_ZYET_YYZT_T_SHKDRB/query";
    public static String URL_SHKDRB_QUERY = IP_PORT + "/api/sql-services/ZYE_ZYET_YYZT_T_SHKDRB/query";
    public static String CLIENT_SHKDRB = "3ad3d605ad6149808e6d7ea9fb26a2e2";
    public static String SECRET_SHKDRB = "7fe76820268a47dc9b1785ded59de33a";
    public static String X_EOS_SOURCESYSKEY_SHKDRB = "ff13e98f32fd4cbeaa66b10278a20f19";

    //2.代寄统计表 YYZT_T_DJTJB
    public static String URL_DJTJB_QUERY = "http://10.225.71.10:9090/api/sql-services/SJZT_DJTJB_01_01/query";
    public static String URL_DJTJB_QUERY = IP_PORT + "/api/sql-services/SJZT_DJTJB_01_01/query";
    public static String CLIENT_DJTJB = "65eed619e0094da299f5e45f924e6e78";
    public static String SECRET_DJTJB = "f2ae2fe68e104814a28ae134ad3530de";
    public static String X_EOS_SOURCESYSKEY_DJTJB = "ff13e98f32fd4cbeaa66b10278a20f19";

    //3.：站点信息表 STATIONINFO
    public static String URL_STATIONINFO_QUERY = "http://10.225.71.10:9090/api/sql-services/ZYE_ZYET_STATIONINFO/query";
    public static String URL_STATIONINFO_QUERY = IP_PORT + "/api/sql-services/ZYE_ZYET_STATIONINFO/query";
    public static String CLIENT_STATIONINFO = "6ffbdfb52cfb481f913608b4e6e99538";
    public static String SECRET_STATIONINFO = "3288ffdb0d5041c0b61885010d1ef2ad";
    public static String X_EOS_SOURCESYSKEY_STATIONINFO = "ff13e98f32fd4cbeaa66b10278a20f19";

 src/main/java/com/integrated/zyyt/ZyytQuartz.java

@@ -27,7 +27,7 @@
    private JdbcTemplate jdbcTemplate;


    @Scheduled(cron = "0 0/30 * * * ?")
    @Scheduled(cron = "0 3 0/6 * * ?")
    private void stationInfoTask() {
        LocalDate yestDay = LocalDate.now().minus(1, ChronoUnit.DAYS);
        if (ZyytUtil.canGetAgain("STATIONINFO", yestDay)) {
@@ -39,7 +39,7 @@
    }


    @Scheduled(cron = "0 3/30  * * * ?")
    @Scheduled(cron = "0 23 0/3 * * ?")
    private void shkdrbTasks() {
        LocalDate yestDay = LocalDate.now().minus(1, ChronoUnit.DAYS);
        if (ZyytUtil.canGetAgain("YYZT_T_SHKDRB", yestDay)) {
@@ -50,7 +50,7 @@
        }
    }

    @Scheduled(cron = "0 7/30 * * * ?")
    @Scheduled(cron = "0 7 0/3 * * ?")
    private void djtjbTasks() {
        LocalDate yestDay = LocalDate.now().minus(1, ChronoUnit.DAYS);
        if (!ZyytUtil.canGetAgain("YYZT_T_DJTJB", yestDay)) {

 src/main/java/com/integrated/zyyt/controller/ZyytController.java

@@ -2,21 +2,18 @@

import com.integrated.zyyt.service.ZyytService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.ControllerAdvice;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.lang.reflect.Method;
import java.time.Instant;
import java.time.LocalDate;
import java.time.LocalTime;
import java.time.ZoneId;
import java.time.temporal.ChronoUnit;
import java.util.Date;
import java.util.concurrent.Callable;
import java.util.concurrent.ExecutorService;
import java.util.concurrent.Executors;

/**
 * @ClassName ZyytController
@@ -25,11 +22,11 @@
 * @Description
 * @Version 1.0
 **/
@ControllerAdvice
@RestController
@Slf4j
@RequestMapping("/api/zyyt")
public class ZyytController {
    private ExecutorService threadPool = Executors.newFixedThreadPool(6);
//    private ExecutorService threadPool = Executors.newFixedThreadPool(6);

    @Resource
    private ZyytService zyytService;
@@ -58,16 +55,32 @@


    @GetMapping("/shkdrbTasksYear")
    public String shkdrbTasksYear(int year) {
    public String shkdrbTasksYear(int year) throws Exception {
        LocalDate startOfYear = LocalDate.of(year, 1, 1);
        LocalDate endOfYear = LocalDate.of(year, 12, 31);
        LocalDate now = LocalDate.now();
        for (LocalDate tmp = startOfYear; endOfYear.compareTo(tmp) > 0 && now.compareTo(tmp) > 0; tmp = tmp.plus(1, ChronoUnit.DAYS)) {
            Instant instant = tmp.atTime(LocalTime.MIDNIGHT).atZone(ZoneId.systemDefault()).toInstant();
            threadPool.submit(new ZyytTask(Date.from(instant), zyytService, "shkdrbTasks"));
//            Instant instant = tmp.atTime(LocalTime.MIDNIGHT).atZone(ZoneId.systemDefault()).toInstant();
//            threadPool.submit(new ZyytTask(Date.from(instant), zyytService, "shkdrbTasks"));
            zyytService.shkdrbTasks(tmp);
        }
        return "后台执行中 ，请不要重复请求";

    }

    @GetMapping("/shkdrbTasksAuto")
    /**
     * start 2022-12-01
     * end 2022-12-31
     */
    public String shkdrbTasksMonth(String start,String end) throws Exception {
        LocalDate startOfYear = LocalDate.parse(start);
        LocalDate endOfYear = LocalDate.parse(end);
        LocalDate now = LocalDate.now();
        for (LocalDate tmp = startOfYear; endOfYear.compareTo(tmp) > 0 && now.compareTo(tmp) > 0; tmp = tmp.plus(1, ChronoUnit.DAYS)) {
            zyytService.shkdrbTasks(tmp);
        }
        return "后台执行中 ，请不要重复请求";
    }


@@ -88,15 +101,32 @@
     * @params isForece 1强制更新 2不强制
     *
     */
    public String djtjbTasksYear(int year) {
    public String djtjbTasksYear(int year) throws Exception {
        LocalDate startOfYear = LocalDate.of(year, 1, 1);
        LocalDate endOfYear = LocalDate.of(year, 12, 31);
        LocalDate now = LocalDate.now();
        for (LocalDate tmp = startOfYear; endOfYear.compareTo(tmp) > 0 && now.compareTo(tmp) > 0; tmp = tmp.plus(1, ChronoUnit.DAYS)) {
            Instant instant = tmp.atTime(LocalTime.MIDNIGHT).atZone(ZoneId.systemDefault()).toInstant();
            threadPool.submit(new ZyytTask(Date.from(instant), zyytService, "djtjbTasks"));
//            Instant instant = tmp.atTime(LocalTime.MIDNIGHT).atZone(ZoneId.systemDefault()).toInstant();
//            threadPool.submit(new ZyytTask(Date.from(instant), zyytService, "djtjbTasks"));
            zyytService.djtjbTasks(tmp);
        }
        return "123";
    }

    @GetMapping("/djtjbTasksAuto")
    /**
     * start 2022-12-01
     * end 2022-12-31
     */
    public String djtjbTasksAuto(String start,String end) throws Exception {
        LocalDate startOfYear = LocalDate.parse(start);
        LocalDate endOfYear = LocalDate.parse(end);
        LocalDate now = LocalDate.now();
        for (LocalDate tmp = startOfYear; endOfYear.compareTo(tmp) > 0 && now.compareTo(tmp) > 0; tmp = tmp.plus(1, ChronoUnit.DAYS)) {
            zyytService.djtjbTasks(tmp);
        }
        return "后台执行中 ，请不要重复请求";

    }

}

 src/main/java/com/integrated/zyyt/service/ZyytService.java

@@ -1,6 +1,5 @@
package com.integrated.zyyt.service;

import com.alibaba.fastjson.JSON;
import com.integrated.zyyt.enetity.StationInfo;
import com.integrated.zyyt.enetity.YyztTDjtjb;
import com.integrated.zyyt.enetity.YyztTShkdrb;
@@ -35,26 +34,20 @@
        log.info("开始进行 机构同步");
        LocalDate yestDay = LocalDate.now().minus(1, ChronoUnit.DAYS);
        String batchNo = ZyytUtil.getBatchNo(yestDay);
        log.info("批次号为 {}", batchNo);
        if (ZyytUtil.isRunning("STATIONINFO", yestDay)) {
            log.info("批次{}正在运行", batchNo);
            return;
        }

        Zyyt<StationInfo> stationInfoService = ZyytUtil.getBusinessEntity("STATIONINFO", yestDay);
        String exeSql = "merge into STATIONINFO A USING" +
                " (select ? V_JGBH  from dual ) C " +
                "ON(A.V_JGBH=C.V_JGBH) " +
                "when matched then " +
                "update SET A.V_SFMC=?,A.V_SFDM=?,A.V_DSDM=?,A.V_DSMC=?,A.V_QXDM=?,A.V_XSMC=?,A.V_TDJGBH=?,A.V_TDJGMC=?,A.V_JGMC=?,A.V_LXRXM=?,A.V_LXDH=?,A.V_SJHM=?,A.V_LXDZ=?,A.ISCOUNTRY=?,A.C_WDLX =?,A.C_YZBM=?,A.V_YYWDBH=?,A.V_YYWDMC=?,A.V_GPSJD=?,A.V_GPSWD=?,A.YLGZDID  =?,A.YLGZDMC=?,A.V_STATUS=?,A.D_SQRQ=?,A.D_SPRQ=?" +
                "when not matched then " +
                "insert(A.V_SFMC,A.V_SFDM,A.V_DSDM,A.V_DSMC,A.V_QXDM,A.V_XSMC,A.V_TDJGBH,A.V_TDJGMC,A.V_JGBH,A.V_JGMC,A.V_LXRXM,A.V_LXDH,A.V_SJHM,A.V_LXDZ,A.ISCOUNTRY,A.C_WDLX ,A.C_YZBM,A.V_YYWDBH,A.V_YYWDMC,A.V_GPSJD,A.V_GPSWD,A.YLGZDID  ,A.YLGZDMC,A.V_STATUS,A.D_SQRQ,A.D_SPRQ) values " +
                "(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        String exeSql = "merge into STATIONINFO A USING" + " (select ? V_JGBH  from dual ) C " + "ON(A.V_JGBH=C.V_JGBH) " + "when matched then " + "update SET A.V_SFMC=?,A.V_SFDM=?,A.V_DSDM=?,A.V_DSMC=?,A.V_QXDM=?,A.V_XSMC=?,A.V_TDJGBH=?,A.V_TDJGMC=?,A.V_JGMC=?,A.V_LXRXM=?,A.V_LXDH=?,A.V_SJHM=?,A.V_LXDZ=?,A.ISCOUNTRY=?,A.C_WDLX =?,A.C_YZBM=?,A.V_YYWDBH=?,A.V_YYWDMC=?,A.V_GPSJD=?,A.V_GPSWD=?,A.YLGZDID  =?,A.YLGZDMC=?,A.V_STATUS=?,A.D_SQRQ=?,A.D_SPRQ=?" + "when not matched then " + "insert(A.V_SFMC,A.V_SFDM,A.V_DSDM,A.V_DSMC,A.V_QXDM,A.V_XSMC,A.V_TDJGBH,A.V_TDJGMC,A.V_JGBH,A.V_JGMC,A.V_LXRXM,A.V_LXDH,A.V_SJHM,A.V_LXDZ,A.ISCOUNTRY,A.C_WDLX ,A.C_YZBM,A.V_YYWDBH,A.V_YYWDMC,A.V_GPSJD,A.V_GPSWD,A.YLGZDID  ,A.YLGZDMC,A.V_STATUS,A.D_SQRQ,A.D_SPRQ) values " + "(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

        Long recordId = stationInfoService.insertRecord("STATIONINFO", batchNo);
        Long totalSize = 0L;

        int pageNum = 0;
        int pageSize = 500;
        int pageSize = 1000;

        //设置回滚点
        Object savePoint = TransactionAspectSupport.currentTransactionStatus().createSavepoint();
@@ -81,7 +74,7 @@
                    int fromIndex = i * batchSize;
                    // 结束位置
                    int toIndex = (i + 1) * batchSize < length ? (i + 1) * batchSize : length;
                    if (fromIndex == batchSize) {
                    if (fromIndex == length) {
                        continue;
                    }
                    System.out.println(fromIndex + " === " + toIndex);
@@ -91,67 +84,70 @@
                            @Override
                            public void setValues(PreparedStatement ps, int i) throws SQLException {
                                StationInfo stationInfo = stationInfoListCopy.get(i);
                                log.info("stationInfo==> {}", JSON.toJSONString(stationInfo));
//                                log.info("stationInfo==> {}", JSON.toJSONString(stationInfo));

                                ps.setObject(1, stationInfo.getVJgbh());
                                ps.setString(1, stationInfo.getVJgbh());

                                ps.setObject(2, stationInfo.getVSfmc());
                                ps.setObject(3, stationInfo.getVSfdm());
                                ps.setObject(4, stationInfo.getVDsdm());
                                ps.setObject(5, stationInfo.getVDsmc());
                                ps.setObject(6, stationInfo.getVQxdm());
                                ps.setObject(7, stationInfo.getVXsmc());
                                ps.setObject(8, stationInfo.getVTdjgbh());
                                ps.setObject(9, stationInfo.getVTdjgmc());
                                ps.setObject(10, stationInfo.getVJgmc());
                                ps.setObject(11, stationInfo.getVLxrxm());
                                ps.setObject(12, stationInfo.getVLxdh());
                                ps.setObject(13, stationInfo.getVSjhm());
                                ps.setObject(14, stationInfo.getVLxdz());
                                ps.setObject(15, stationInfo.getIscountry());
                                ps.setObject(16, stationInfo.getCWdlx());
                                ps.setObject(17, stationInfo.getCYzbm());
                                ps.setObject(18, stationInfo.getVYywdbh());
                                ps.setObject(19, stationInfo.getVYywdmc());
                                ps.setObject(20, stationInfo.getVGpsjd());
                                ps.setObject(21, stationInfo.getVGpswd());
                                ps.setObject(22, stationInfo.getYlgzdid());
                                ps.setObject(23, stationInfo.getYlgzdmc());
                                ps.setObject(24, stationInfo.getVStatus());
                                ps.setDate(25, new Date(stationInfo.getDSqrq().getTime()));
//                                ps.setObject(25, stationInfo.getDSqrq());
//                                ps.setObject(26, stationInfo.getDSprq());
                                ps.setDate(26, new Date(stationInfo.getDSprq().getTime()));
                                ps.setString(2, stationInfo.getVSfmc());
                                ps.setString(3, stationInfo.getVSfdm());
                                ps.setString(4, stationInfo.getVDsdm());
                                ps.setString(5, stationInfo.getVDsmc());
                                ps.setString(6, stationInfo.getVQxdm());
                                ps.setString(7, stationInfo.getVXsmc());
                                ps.setString(8, stationInfo.getVTdjgbh());
                                ps.setString(9, stationInfo.getVTdjgmc());
                                ps.setString(10, stationInfo.getVJgmc());
                                ps.setString(11, stationInfo.getVLxrxm());
                                ps.setString(12, stationInfo.getVLxdh());
                                ps.setString(13, stationInfo.getVSjhm());
                                ps.setString(14, stationInfo.getVLxdz());
                                ps.setString(15, stationInfo.getIscountry());
                                ps.setShort(16, stationInfo.getCWdlx());
                                ps.setString(17, stationInfo.getCYzbm());
                                ps.setString(18, stationInfo.getVYywdbh());
                                ps.setString(19, stationInfo.getVYywdmc());
                                ps.setString(20, stationInfo.getVGpsjd());
                                ps.setString(21, stationInfo.getVGpswd());
                                ps.setString(22, stationInfo.getYlgzdid());
                                ps.setString(23, stationInfo.getYlgzdmc());
                                ps.setString(24, stationInfo.getVStatus());
//                                ps.setDate(25, new Date(stationInfo.getDSqrq().getTime()));
                                ps.setDate(25,
                                        stationInfo.getDSqrq() == null ? null :
                                                new Date(stationInfo.getDSqrq().getTime()));
//                                ps.setString(25, stationInfo.getDSqrq());
//                                ps.setString(26, stationInfo.getDSprq());
                                ps.setDate(26, stationInfo.getDSprq() == null ? null :
                                        new Date(stationInfo.getDSprq().getTime()));

                                ps.setObject(27, stationInfo.getVSfmc());
                                ps.setObject(28, stationInfo.getVSfdm());
                                ps.setObject(29, stationInfo.getVDsdm());
                                ps.setObject(30, stationInfo.getVDsmc());
                                ps.setObject(31, stationInfo.getVQxdm());
                                ps.setObject(32, stationInfo.getVXsmc());
                                ps.setObject(33, stationInfo.getVTdjgbh());
                                ps.setObject(34, stationInfo.getVTdjgmc());
                                ps.setObject(35, stationInfo.getVJgbh());
                                ps.setObject(36, stationInfo.getVJgmc());
                                ps.setObject(37, stationInfo.getVLxrxm());
                                ps.setObject(38, stationInfo.getVLxdh());
                                ps.setObject(39, stationInfo.getVSjhm());
                                ps.setObject(40, stationInfo.getVLxdz());
                                ps.setObject(41, stationInfo.getIscountry());
                                ps.setObject(42, stationInfo.getCWdlx());
                                ps.setObject(43, stationInfo.getCYzbm());
                                ps.setObject(44, stationInfo.getVYywdbh());
                                ps.setObject(45, stationInfo.getVYywdmc());
                                ps.setObject(46, stationInfo.getVGpsjd());
                                ps.setObject(47, stationInfo.getVGpswd());
                                ps.setObject(48, stationInfo.getYlgzdid());
                                ps.setObject(49, stationInfo.getYlgzdmc());
                                ps.setObject(50, stationInfo.getVStatus());
//                                ps.setObject(51, stationInfo.getDSqrq());
                                ps.setDate(51, new Date(stationInfo.getDSqrq().getTime()));
                                ps.setString(27, stationInfo.getVSfmc());
                                ps.setString(28, stationInfo.getVSfdm());
                                ps.setString(29, stationInfo.getVDsdm());
                                ps.setString(30, stationInfo.getVDsmc());
                                ps.setString(31, stationInfo.getVQxdm());
                                ps.setString(32, stationInfo.getVXsmc());
                                ps.setString(33, stationInfo.getVTdjgbh());
                                ps.setString(34, stationInfo.getVTdjgmc());
                                ps.setString(35, stationInfo.getVJgbh());
                                ps.setString(36, stationInfo.getVJgmc());
                                ps.setString(37, stationInfo.getVLxrxm());
                                ps.setString(38, stationInfo.getVLxdh());
                                ps.setString(39, stationInfo.getVSjhm());
                                ps.setString(40, stationInfo.getVLxdz());
                                ps.setString(41, stationInfo.getIscountry());
                                ps.setShort(42, stationInfo.getCWdlx());
                                ps.setString(43, stationInfo.getCYzbm());
                                ps.setString(44, stationInfo.getVYywdbh());
                                ps.setString(45, stationInfo.getVYywdmc());
                                ps.setString(46, stationInfo.getVGpsjd());
                                ps.setString(47, stationInfo.getVGpswd());
                                ps.setString(48, stationInfo.getYlgzdid());
                                ps.setString(49, stationInfo.getYlgzdmc());
                                ps.setString(50, stationInfo.getVStatus());
//                                ps.setString(51, stationInfo.getDSqrq());
                                ps.setDate(51, stationInfo.getDSqrq() == null ? null : new Date(stationInfo.getDSqrq().getTime()));

                                ps.setObject(52, stationInfo.getDSprq());
                                ps.setDate(52, new Date(stationInfo.getDSprq().getTime()));
                                ps.setDate(52, stationInfo.getDSprq() == null ? null : new Date(stationInfo.getDSprq().getTime()));
                            }

                            @Override
@@ -160,6 +156,8 @@
                            }
                        });
                    } catch (Exception e) {
                        log.error("设置参数值报错了");
                        e.printStackTrace();
                        log.error(e.getMessage());
                        //手工回滚异常
                        TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint);
@@ -203,7 +201,7 @@
        Object savePoint = TransactionAspectSupport.currentTransactionStatus().createSavepoint();
        try {
            int pageNum = 0;
            int pageSize = 500;
            int pageSize = 1000;

            String batchInsertSql = "INSERT INTO YYZT_T_SHKDRB (\"V_SFDM\",\"V_SFMC\",\"V_DSDM\",\"V_DSMC\",\"V_QXDM\",\"V_XSMC\",\"V_TDJGBH\",\"V_TDJGMC\",\"V_JGBH\",\"V_JGMC\",\"D_RBRQ\",\"N_ZGYZLJS\",\"N_ZGYZQJS\",\"N_SHKDLJS\",\"N_SHKDQJS\",\"N_ZTLJS\",\"N_ZTQJS\",\"N_YTLJS\",\"N_YTQJS\",\"N_STLJS\",\"N_STQJS\",\"N_BSLJS\",\"N_BSQJS\",\"N_YDLJS\",\"N_YDQJS\",\"N_YFLJS\",\"N_YFQJS\",\"N_JDLJS\",\"N_JDQJS\",\"N_JTLJS\",\"N_JTQJS\",\"N_TTLJS\",\"N_TTQJS\",\"N_DBLJS\",\"N_DBQJS\",\"N_DNLJS\",\"N_DNQJS\",\"N_FWLJS\",\"N_FWQJS\",\"N_YSLJS\",\"N_YSQJS\",\"N_QTLJS\",\"N_QTQJS\",\"RESERVED1\",\"RESERVED2\",\"RESERVED3\",\"RESERVED4\",\"BATCH_NO\") VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

@@ -229,7 +227,7 @@
                    int fromIndex = i * batchSize;
                    // 结束位置
                    int toIndex = (i + 1) * batchSize < length ? (i + 1) * batchSize : length;
                    if (fromIndex == batchSize) {
                    if (fromIndex == length) {
                        continue;
                    }
                    List<YyztTShkdrb> yyztTShkdrbs = stationInfoList.subList(fromIndex, toIndex);
@@ -284,8 +282,7 @@
                                    item.getReserved2(),
                                    item.getReserved3(),
                                    item.getReserved4(),
                                    item.getBatchNo()
                            });
                                    batchNo});
                        });
                        jdbcTemplate.batchUpdate(batchInsertSql, insertShkdrbList);
                    } catch (Exception e) {
@@ -330,7 +327,7 @@

        try {
            int pageNum = 0;
            int pageSize = 500;
            int pageSize = 1000;

            String batchInsertSql = "INSERT INTO YYZT_T_DJTJB (\"V_SFDM\", \"V_SFMC\", \"V_DSDM\", \"V_DSMC\", \"V_QXDM\", \"V_XSMC\", \"V_TDJGBH\", \"V_JGBH\", \"V_JGMC\", \"D_RBRQ\", \"V_YLGZDID\", \"V_YLGZDMC\", \"N_SJYWL\", \"N_TKYWL\", \"N_BKYEL\", \"N_SJZJE\", \"N_TKSR\", \"N_BKSR\", \"BATCH_NO\") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
            // 查询总数
@@ -354,7 +351,7 @@
                    int fromIndex = i * batchSize;
                    // 结束位置
                    int toIndex = (i + 1) * batchSize < length ? (i + 1) * batchSize : length;
                    if (fromIndex == batchSize) {
                    if (fromIndex == length) {
                        continue;
                    }
                    System.out.println(fromIndex + " === " + toIndex);
@@ -381,7 +378,7 @@
                                    item.getNSjzje(),
                                    item.getNTksr(),
                                    item.getNBksr(),
                                    item.getBatchNo()
                                    batchNo
                            });
                        });
                        jdbcTemplate.batchUpdate(batchInsertSql, insertShkdrbList);

 src/main/java/com/integrated/zyyt/util/ZyytUtil.java

@@ -216,7 +216,7 @@

    public static Zyyt getBusinessEntity(String tableName, LocalDate date) {
        if ("STATIONINFO".equalsIgnoreCase(tableName)) {
            new ZyytStationInfo(
            return new ZyytStationInfo(
                    ZyytConstant.URL_AUTHON,
                    ZyytConstant.URL_STATIONINFO_QUERY,
                    false,

 src/main/resources/application-dev.yml

@@ -1,7 +1,7 @@
server:
  port: 9529
  servlet:
    context-path: /
    context-path: /schedule
spring:
  # 出现错误时, 直接抛出异常(便于异常统一处理，否则捕获不到404)
  mvc:

 src/main/resources/application.yml

@@ -2,7 +2,7 @@
  mvc:
    static-path-pattern: /static         # 设置静态文件路径，js,css等
  profiles:
    active: prod
    active: dev
  http:
    encoding:
      charset: UTF-8
@@ -62,3 +62,6 @@
  encryptor:
    password: EbfYkitulv73I2p0mXI50JMXoaxZTKJ0

zyyt:
  ipPort: http://10.225.71.10:9090