Map rest =new HashMap<>();
String d ="2018/04/25";
String sql=" select to_char(ACTIVE_DATE,'yyyy/mm/dd') 时间,a.* from table a ";
System.out.println("sql" + sql);
String list = utilService.getJSONAlls(sql, new Object[] {}, 2);
JSONObject clonetmp =new JSONObject() ;
list = utilService.getJSONAlls(sql, new Object[] {}, 2);
HashMap<String,String> val = CommonUtil.getMap(list);
String str =val.get("rows");//这里是封装后方法里面
JSONArray jsonArray = JSONArray.fromObject(str);
JSONArray jsonArray2 = new JSONArray();
String tmpStr ="";
Iterator iterator =null;
for(int i=0;i<jsonArray.size();i++){
System.out.println("jsonArray:"+jsonArray.get(i).toString());
System.out.println("jsonArray2:"+jsonArray2.toString());
tmpStr =jsonArray.getJSONObject(i).getString("时间");
System.out.println("tmpStr:"+tmpStr);
DateFormat df = new SimpleDateFormat("yyyy/MM/dd");/*** 加一天*/
long dif = df.parse(d).getTime()-86400*1000 * i;
Date date=new Date();
date.setTime(dif);
System.out.println("减少一天之后:" + df.format(date));
String tt =df.format(date);
if(tt.equals(tmpStr) ){
lastObj = jsonArray.getJSONObject(i);
iterator =lastObj.keySet().iterator();
while(iterator.hasNext()){
String key = iterator.next().toString();
clonetmp.put(key, lastObj.get(key));
}
jsonArray2.add(clonetmp);
clonetmp.clear();
}else{
clonetmp.put("时间", tt);
clonetmp.put("数量", "0");
jsonArray2.add(clonetmp);
// System.out.println("jsonArray2:"+jsonArray2.toString());
clonetmp.clear();
}
}
System.out.println("jsonArraydayin"+jsonArray.toString());
String d ="2018/04/25";
String sql=" select to_char(ACTIVE_DATE,'yyyy/mm/dd') 时间,a.* from table a ";
System.out.println("sql" + sql);
String list = utilService.getJSONAlls(sql, new Object[] {}, 2);
System.out.println("list:"+list);
JSONObject clonetmp =new JSONObject() ;
list = utilService.getJSONAlls(sql, new Object[] {}, 2);
HashMap<String,String> val = CommonUtil.getMap(list);
String str =val.get("rows");//这里是封装后方法里面
JSONArray jsonArray = JSONArray.fromObject(str);
JSONArray jsonArray2 = new JSONArray();
String tmpStr ="";
Iterator iterator =null;
for(int i=0;i<jsonArray.size();i++){
System.out.println("jsonArray:"+jsonArray.get(i).toString());
System.out.println("jsonArray2:"+jsonArray2.toString());
tmpStr =jsonArray.getJSONObject(i).getString("时间");
System.out.println("tmpStr:"+tmpStr);
DateFormat df = new SimpleDateFormat("yyyy/MM/dd");/*** 加一天*/
long dif = df.parse(d).getTime()-86400*1000 * i;
Date date=new Date();
date.setTime(dif);
System.out.println("减少一天之后:" + df.format(date));
String tt =df.format(date);
if(tt.equals(tmpStr) ){
lastObj = jsonArray.getJSONObject(i);
iterator =lastObj.keySet().iterator();
while(iterator.hasNext()){
String key = iterator.next().toString();
clonetmp.put(key, lastObj.get(key));
}
jsonArray2.add(clonetmp);
clonetmp.clear();
}else{
clonetmp.put("时间", tt);
clonetmp.put("数量", "0");
jsonArray2.add(clonetmp);
// System.out.println("jsonArray2:"+jsonArray2.toString());
clonetmp.clear();
}
}
System.out.println("jsonArraydayin"+jsonArray.toString());