ExportExcel<BandwidthData> domainExcel = new ExportExcel<BandwidthData>();
//数据集合List<Long> outputDataList
Map<String,Map<String, String>> maps = new HashMap<String,Map<String, String>>();for (int i = 0; i < outputDataList.size(); i++) {
//时间转换
String time = DateUtil.formatDate(startTime, "yyyy/MM/dd HH:mm");
String day1 = DateUtil.formatDate(startTime, "yyyy/MM/dd");
if(maps.get(day1) == null){
Map<String, String> map1 = new HashMap<String, String>();
//如果没数据了,重新去取
map1.put(time, CodeUtils.getSizeEqualByMB2(outputDataList.get(i)));
maps.put(day1, map1);
}else{
//把每一天的数据放在一起
maps.get(day1).put(time, CodeUtils.getSizeEqualByMB2(outputDataList.get(i)));
}
startTime = DateUtils.addMinutes(startTime, 5);
}
//创建一个Map(里面方人员KV多种形式)
Map<String,List<Map.Entry<String, String>>> maps2 = new HashMap<String,List<Map.Entry<String, String>>>();
//获取key集合 ,生成一个无序不可重复的Set集合
Set<String> keySet = maps.keySet();
for (String day2 : keySet) {
Map<String, String> map2 = maps.get(day2);
List<Map.Entry<String, String>> orderList = new LinkedList<Map.Entry<String, String>>(map2.entrySet());
//根据大小倒序排列
Collections.sort(orderList, new Comparator<Map.Entry<String, String>>() {
public int compare(Map.Entry<String, String> o1, Map.Entry<String, String> o2) {
return (Double.valueOf((String)o2.getValue())).compareTo(Double.valueOf((String) o1.getValue()));
}
});
maps2.put(day2, orderList);
}
//根据这个KeySet创建一个List,List内的数据就是KeySet的值
List<String> dayList = new ArrayList<String>(keySet);
//正序排列
Collections.sort(dayList);
String[] headers = new String[dayList.size() * 2] ;
for(int i = 0; i < dayList.size()*2; i++){
headers[i] = "时间";
headers[i+1] = "吐出(Mbps)";
i+=1;
}
//List思想:根据角标去取值
List<ArrayList<String>> orderList2 = new ArrayList<ArrayList<String>> (); //所有数据
//外层循环行数
for (int j = 0; j < 288; j++) {
//创建一个List保存没一行的数据
ArrayList<String> orderList = new ArrayList<String>();
//内层循环天数
for (int g = 0; g < dayList.size(); g++) {
//通过天数取出当天的数据
List<Entry<String, String>> list2 = maps2.get(dayList.get(g));
//判断是否为空,比isNull效率高
if (list2.size() > j) {
Entry<String, String> entry = list2.get(j);
orderList.add(entry.getKey());
orderList.add(entry.getValue());
} else {
//若没有数据添加空字符串防止串行
orderList.add("");
orderList.add("");
}
}
//把每一行的数据添加到一个List中
orderList2.add(orderList);
}