java 엑셀다운로드

Question

@RequestMapping(value="mngr/module/mngrSfwfRentaPayList{schExcelType}.do") public ModelAndView mngrSfwfRentaPayList(@PathVariable String schExcelType, @ModelAttribute("searchVO") DefaultVO searchVO, @RequestParam Map params, HttpServletRequest request) throws IOException, SQLException, ParseException{ ModelAndView mav = new ModelAndView(ExcelDownloadView.EXCEL_DOWN); List dataList = new ArrayList<>(); //조회해서 보낼 리스트 String fileName=""; String schUseSdt=""; String schUseEdt=""; HashMap paramMap = new HashMap(); if( params.get("schDateTerm") == null && params.get("schDateStart") == null && params.get("schDateEnd") == null ){ //LocalDateTime curr_today = LocalDateTime.now(); Date today = new Date(); SimpleDateFormat format1 = new SimpleDateFormat("yyyy-MM-01"); SimpleDateFormat format2 = new SimpleDateFormat("yyyy-MM-dd"); String setDateStart = format1.format(today); String setDateEnd = format2.format(today); //String setDateStart = curr_today.format(DateTimeFormatter.ofPattern("yyyy-MM-01")); //String setDateEnd = curr_today.format(DateTimeFormatter.ofPattern("yyyy-MM-dd")); params.put("schDateTerm", "REQ_DAY"); params.put("schDateStart", setDateStart); params.put("schDateEnd", setDateEnd); } //## VO to Map Convert & MapCon Add request map(Param) Map paramMapCon = new HashMap(); paramMapCon = VoToParamsUtil.convertObjectToMap(searchVO); paramMapCon.putAll( params ); //System.out.println("LOG params : " + params ); //System.out.println("LOG paramMapCon : " + paramMapCon ); String orgCodeList=""; if (schExcelType.contains("space")) { orgCodeList="spacesallim"; paramMapCon.put("schRrmOrgCd", "spacesallim"); }else{ orgCodeList="sfwf"; paramMapCon.put("schRrmOrgCd", "sfwf"); } //ListorgCodeList = rentalMngrService.selectRentalOrgCodeList(params); ListrsListRrm = rentalMngrService.selectRentalPayList(paramMapCon); Map rMap = new HashMap<>(); int ii=1; int noCount=1; for(ItgMap map : rsListRrm) { if(!rMap.containsKey(map.get("rrmIdx")+"")){ rMap.put(map.get("rrmIdx")+"", map); map.put("again", "N"); map.put("ii", ii); }else{ map.put("again", "Y"); map.put("ii", ii); rMap.put(map.get("rrmIdx")+"", map); } if ("Y".equals(map.get("again"))) { map.put("rrmReqEventName", map.get("rrmReqEventName")); map.put("rrmBsName", map.get("rrmBsName")); map.put("rrgrlrsfname", map.get("rrgrlrsfname")); map.put("rrfCurDateMin", map.get("rrfCurDateMin")+"~"+map.get("rrfCurDateMax")); map.put("rrfCurDateMax", map.get("rrfCurDateMax")); map.put("totamount", map.get("totamount")); String tot=map.get("totamount")+""; String paytot=map.get("payamount")+""; String cancelFee=CommUtil.isNull(map.get("cancelFee"),"0"); DecimalFormat df = new DecimalFormat("#"); int tottot1=Integer.parseInt(df.format(Double.parseDouble(CommUtil.isNull(Integer.parseInt(tot)/1.1,"0")))); map.put("totamount1", tottot1); map.put("totamount2", Integer.parseInt(df.format(Integer.parseInt(CommUtil.isNull(tot,"0"))-Integer.parseInt(CommUtil.isNull(tottot1,"0"))))); if ("rentalPayState92".equals(map.get("rrmPayState"))) { } map.put("totamount3", Integer.parseInt(df.format(Integer.parseInt(CommUtil.isNull(tot,"0"))-Integer.parseInt(CommUtil.isNull(paytot,"0"))-Integer.parseInt(CommUtil.isNull(cancelFee,"0"))))); map.put("rrtType", map.get("rrtType")); map.put("cancelFee", cancelFee); map.put("rrtContent", map.get("rrtContent")); map.put("payamount", map.get("payamount")); map.put("noCount",noCount-1); rMap.put(ii+"",map); ii=ii+1; map.put("rrmReqEventName", ""); map.put("rrmReqEventName", ""); map.put("rrmBsName", ""); map.put("rrgrlrsfname", ""); map.put("rrfCurDateMin", ""); map.put("rrfCurDateMax", ""); map.put("totamount", 0); map.put("totamount1", 0); map.put("totamount2", 0); map.put("totamount3", 0); map.put("cancelFee", 0); /*map.put("rrtType", ""); map.put("rrtContent", "");*/ map.put("payamount", 0); map.put("noCount",""); }else{ rMap.put(ii+"",map); map.put("rrfCurDateMin", map.get("rrfCurDateMin")+"~"+map.get("rrfCurDateMax")); map.put("rrfCurDateMax", map.get("rrfCurDateMax")); map.put("totamount", map.get("totamount")); String tot=map.get("totamount")+""; String paytot=map.get("payamount")+""; String cancelFee=CommUtil.isNull(map.get("cancelFee"),"0"); DecimalFormat df = new DecimalFormat("#"); int tottot1=Integer.parseInt(df.format(Double.parseDouble(CommUtil.isNull(Integer.parseInt(tot)/1.1,"0")))); map.put("totamount1", tottot1); map.put("totamount2", Integer.parseInt(df.format(Integer.parseInt(CommUtil.isNull(tot,"0"))-Integer.parseInt(CommUtil.isNull(tottot1,"0"))))); map.put("totamount3", Integer.parseInt(df.format(Integer.parseInt(CommUtil.isNull(tot,"0"))-Integer.parseInt(CommUtil.isNull(paytot,"0"))-Integer.parseInt(CommUtil.isNull(cancelFee,"0"))))); map.put("noCount",noCount); map.put("cancelFee",cancelFee); noCount=noCount+1; ii=ii+1; } if ("RTN".equals(map.get("rrpInOutType"))) { map.put("rrpPrice2", Integer.parseInt(CommUtil.isNull(map.get("rrpPrice"),"0"))); }else{ map.put("rrpPrice2", 0); } } SimpleDateFormat format1 = new SimpleDateFormat ( "yyyy-MM-dd HH:mm:ss"); Date time = new Date(); String time1 = format1.format(time); paramMap.put("time1", time1); paramMap.put("dataList", rsListRrm); paramMap.put("schUseSdt", params.get("schDateStart")); paramMap.put("schUseEdt", params.get("schDateEnd")); fileName="수입금현황"; // 엑셀 템플릿에 넘겨줄 데이타 설정 mav.addObject("data", paramMap); // 다운로드에 사용되어질 엑셀파일 템플릿 mav.addObject(ExcelDownloadView.DOWN_EXCEL_TEMPLATE, "mngr.mngrSfwfRentaPayList"); // 다운로드시 표시될 파일명 (확장자는 자동으로 xls로 지정된다.) mav.addObject(ExcelDownloadView.DOWN_FILE_NM, fileName); return mav; }엑셀다운로드를 누르면 이 메소드가 타지는데 ㅜㅜ 엑셀다운로드 누르면 엑셀이 다운받아집니다 .하나를 추가해야하는데 전혀 안들어가는데 따로 타이틀 정의한 곳이 없는데 어디서 해야할까요 ㅠ

독고die · Answer

혹시.. 이거 회사 코드에요?

java 엑셀다운로드

1개의 답변

Q&A 목록