List<Map<String, Object>> list = jdbcTemplate.queryForList(sql);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
for (int i = 0;i<list.size();i++) {
Object timeofend = list.get(i).get("ENDTIME");
if(null==timeofend||"".equals(timeofend)){
System.out.println("null---"+timeofend);
list.get(i).put("timecha", "");
}else{
System.out.println("not null---"+timeofend);
Date dateTimeend = sdf.parse(String.valueOf(timeofend));
String starttime = String.valueOf(list.get(i).get("STARTTIME"));
Date dateTimeStart =sdf.parse(starttime);
long timecha = dateTimeend.getTime()-dateTimeStart.getTime();
double daytime = Math.floor(timecha/(24 * 60 * 60 * 1000));
int day=(int)Math.floor(daytime);
double housess = timecha % (1000 * 60 * 60 * 24) / (1000 * 60 * 60);
int house = (int) Math.floor(housess);
double mi = timecha % (1000 * 60 * 60) / (1000 * 60);
int minutes = (int) Math.floor(mi);
System.out.println(day + "天" + house + "小时" + minutes + "分");
if(day>0){
list.get(i).put("timecha", day + "天" + house + "小时" + minutes + "分");
}else{
if(house>0){
list.get(i).put("timecha", house + "小时" + minutes + "分");
}else{
list.get(i).put("timecha", minutes + "分");
}
}