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"; |
|
'프로그램 관련 > Java 및 JAVA라이브러리' 카테고리의 다른 글
spring 맵핑 문제날시 (0) | 2020.09.15 |
---|---|
JAVA int 길이 (length ) 구하기 자리수 구하기 (몇자리인지) (2) | 2019.01.03 |
Java split 쓰기 문자열 자르기 . 기준 자르기 (0) | 2018.09.28 |
Table 구조 배열 가로 형식 출력(피벗) 알고리즘 (0) | 2018.09.20 |
JAVA 배열 내에 중복값 제거하기/출력하기 (0) | 2018.09.18 |