鞍钢鲅鱼圈能源管控系统后端代码
潘志宝
9 天以前 460eb8108ddba02f4dfde9e22ba33c7d4888b602
Merge branch 'master' of http://dlindusit.com:53929/r/ansteel
已修改1个文件
23 ■■■■■ 文件已修改
ansteel-biz/src/main/java/com/iailab/module/ansteel/job/task/SyncEmsTask.java 23 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ansteel-biz/src/main/java/com/iailab/module/ansteel/job/task/SyncEmsTask.java
@@ -57,11 +57,9 @@
            // 执行查询并处理结果
            ResultSet rs = pstmt.executeQuery();
            ResultSetMetaData meta = rs.getMetaData();
            boolean colCount = rs.next();
            if(!colCount){
                pstmt.setString(1, lastMonth);
                meta = rs.getMetaData();
                rs = pstmt.executeQuery();
                colCount =  rs.next();
                if(!colCount){
@@ -73,8 +71,7 @@
                }
            }
            byqlzAdsService.delete(yearMonth);
            while (rs.next()) {
            while (colCount) {
                ByqlzAdsEntity entity = new ByqlzAdsEntity();
                // 映射基础字段
@@ -100,11 +97,11 @@
                        case 7: entity.setVal7(val); break;
                        case 8: entity.setVal8(val); break;
                        case 9: entity.setVal9(val); break;
                        case 10: entity.setVal11(val); break;
                        case 11: entity.setVal12(val); break;
                        case 12: entity.setVal13(val); break;
                        case 13: entity.setVal14(val); break;
                        case 14: entity.setVal2(val); break;
                        case 10: entity.setVal10(val); break;
                        case 11: entity.setVal11(val); break;
                        case 12: entity.setVal12(val); break;
                        case 13: entity.setVal13(val); break;
                        case 14: entity.setVal14(val); break;
                        case 15: entity.setVal15(val); break;
                        case 16: entity.setVal16(val); break;
                        case 17: entity.setVal17(val); break;
@@ -125,7 +122,7 @@
                    }
                }
                entity.setLoadTime(currentDate);
                entity.setLoadTime(rs.getString("LOAD_TIME"));
                resultList.add(entity);
            }
@@ -140,11 +137,5 @@
            e.printStackTrace();
        }
        logger.info("SyncEmsTask运行完成");
    }
    public static void main(String[] args) {
        SyncEmsTask task = new SyncEmsTask();
        String params = "";
        task.run(params);
    }
}