| name |month| value|
| 北京大厦 | 8 | 10000 |
| 南京大厦 | 6 | 4577 |
| 南京大厦 | 7 | 20222 |
| 南京大厦 | 8 | 23575 |
| 港汇大厦 | 7 | 14545 |
| 港汇大厦 | 8 | 54342 |
现在得到的上面的值,写个方法把它保存成以下格式(对应每个月相应的月份):
北京大厦, 0, 0 , 0, 0, 0,0 ,0 , 10000,0 ,0 ,0 ,0 ,;
南京大厦,0 ,0 ,0 ,0 ,0 ,4577,20222,23575 , 0, 0, 0,;
港汇大厦 ,0 , 0, 0, 0, 0, 0,14545 ,54342 , 0, 0,0 ,;
方法:
HashMap<String, Double[]> map = new HashMap<String, Double[]>();
String datas = "";
for (BuildFeeShow fee : list) {
String buildingName = fee.getBuildingName();
Double[] data = map.get(buildingName);
if (data == null) {
data = new Double[13];
map.put(buildingName, data);
}
int n = fee.getMonth();
if (data[n] == null) {
data[n] = fee.getTotlePrice();
} else {
data[n] = data[n] + fee.getTotlePrice();
}
}
for (String name : map.keySet()) {
Double[] data = map.get(name);
String temp = name + ",";
for (int i = 1; i < 13; i++) {
if (data[i] != null) {
temp = temp + data[i] + ",";
} else {
temp = temp + "0" + ",";
}
}
datas += temp + ";";
}
String[] s = datas.split(";");
reoportData = new String[s.length][];
for (int i = 0; i < s.length; i++) {
Object[][] reoportData[i] = s[i].split(",");
}
}