|
JAVA -
List<Map<String, Object>> excelList = new ArrayList<Map<String,Object>>();
excelList = testService.selectList(testVo);
List<Object> titleList = new ArrayList<Object>();
titleList.add("순위" );
titleList.add("순위2" );
titleList.add("순위3" );
titleList.add("순위4" );
titleList.add("순위5" );
titleList.add("순위6" );
titleList.add("순위7" );
List<Object> dataList = new ArrayList<Object>();
for(int i = 0; excelList .size(); i++;)
{
List<Object> subList = new ArrayList<Object>();'
subList .add(excelList.get(i).get("rank1") == null ? "" : subList .add(excelList.get(i).get("rank1"));
subList .add(excelList.get(i).get("rank2") == null ? "" : subList .add(excelList.get(i).get("rank2"));
subList .add(excelList.get(i).get("rank3") == null ? "" : subList .add(excelList.get(i).get("rank3"));
subList .add(excelList.get(i).get("rank4") == null ? "" : subList .add(excelList.get(i).get("rank4"));
subList .add(excelList.get(i).get("rank5") == null ? "" : subList .add(excelList.get(i).get("rank5"));
subList .add(excelList.get(i).get("rank6") == null ? "" : subList .add(excelList.get(i).get("rank6"));
subList .add(excelList.get(i).get("rank7") == null ? "" : subList .add(excelList.get(i).get("rank7"));
dataList .add(subList);
}
model.put("titleList ",titleList )
model.put("list",dataList)
model.put("name","rank")
model.put("sheetName","순위")
return "excelView";
|