81,092
社区成员
发帖
与我相关
我的任务
分享
String sql = "SELECT finishclass,finishtm from" +
" (select state finishclass,createtm finishtm,ROW_NUMBER() OVER(PARTITION BY state ORDER BY createtm desc) rn" +
" from PERSONAL_FINISHINFO_T where 1=1 and applyid =" + subsidyId + ") where rn = 1";
List<Map<String, Object>> list = queryBySql(sql);
Iterator<Map<String, Object>> iterator = list.iterator();
Map<String, Object> map = new HashMap<>();
while (iterator.hasNext()){ // 10条数据
Map<String, Object> next = iterator.next();
map.put(next.get("finishclass")+"",next.get("finishtm")+"");
}
---------------------------------------------------------------分开,不在同个类,有些省略了
List<Map<String, Object>> mapList = subsidyApplyService
.listSubsidyCustom(paramMap,nameSet);
for (Map map : mapList ) { //5000+数据
Map<String, Object> finishInfo = subsidyApplyService.lastFinishInfo(map.get("SUBSIDYID").toString());
if(finishInfo != null){
map.put("PRELEXADATE", finishInfo.get("1") == null ? "" : finishInfo.get("1")+"");
map.put("ONSITEAUDITDATE", finishInfo.get("4") == null ? "" : finishInfo.get("4")+"");
map.put("FIRSTFINISHDATE", finishInfo.get("5") == null ? "" : finishInfo.get("5")+"");
map.put("SECONDFINISHDATE", finishInfo.get("6") == null ? "" : finishInfo.get("6")+"");
map.put("THIRDFINISHDATE", finishInfo.get("7") == null ? "" : finishInfo.get("7")+"");
map.put("FINANCIALAUDIT", finishInfo.get("99") == null ? "" : finishInfo.get("99")+"");
}
}
String sql = "SELECT finishclass,finishtm from" +
" (select state finishclass,createtm finishtm,ROW_NUMBER() OVER(PARTITION BY state ORDER BY createtm desc) rn" +
" from PERSONAL_FINISHINFO_T ) where rn = 1";
List<Map<String, Object>> list = queryBySql(sql);
Iterator<Map<String, Object>> iterator = list.iterator();
Map<String, Object> map = new HashMap<>();
Map<String, Object> map1 = new HashMap<>();
while (iterator.hasNext()){ //20+万条数据
Map<String, Object> next = iterator.next();
map.put(next.get("finishclass")+"",next.get("finishtm")+"");
if(map1.keySet().contains(next.get("ID")+"")){
Map<String, Object> idMap = (Map<String, Object>) map1.get("ID");
map.putAll(idMap);
}
map1.put(next.get("ID")+"",map);
}
---------------------------------------------------------------分开,不在同个类,有些省略了
List<Map<String, Object>> mapList = subsidyApplyService
.listSubsidyCustom(paramMap,nameSet);
for (Map map : mapList ) { //5000+数据
Map<String, Object> finishInfo = (Map<String, Object>) map1.get(map.get("SUBSIDYID")+"");
if(finishInfo != null){
map.put("PRELEXADATE", finishInfo.get("1") == null ? "" : finishInfo.get("1")+"");
map.put("ONSITEAUDITDATE", finishInfo.get("4") == null ? "" : finishInfo.get("4")+"");
map.put("FIRSTFINISHDATE", finishInfo.get("5") == null ? "" : finishInfo.get("5")+"");
map.put("SECONDFINISHDATE", finishInfo.get("6") == null ? "" : finishInfo.get("6")+"");
map.put("THIRDFINISHDATE", finishInfo.get("7") == null ? "" : finishInfo.get("7")+"");
map.put("FINANCIALAUDIT", finishInfo.get("99") == null ? "" : finishInfo.get("99")+"");
}
}