Java tutorial
/* * M2M ServiceFOTA ONM version 1.0 * * Copyright 2014 kt corp. All rights reserved. * * This is a proprietary software of kt corp, and you may not use this file except in * compliance with license agreement with kt corp. Any redistribution or use of this * software, with or without modification shall be strictly prohibited without prior written * approval of kt corp, and the copyright notice above does not evidence any actual or * intended publication of such software. */ package com.fota.qualityMgt.controller; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.springframework.web.servlet.view.document.AbstractExcelView; import com.fota.comm.util.DateTimeUtil; import com.fota.qualityMgt.vo.DeviceQualityAnalysisInfoVo; public class DeviceQualityAnalysisExcelDown extends AbstractExcelView { @Override protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request, HttpServletResponse response) throws Exception { String date = DateTimeUtil.getCurrentDate(); String formNm = "??"; String fileName = date + "_" + formNm; String sheetName = "sheet1"; response.setContentType("application/vnd.ms-excel;charset=UTF-8"); response.setHeader("Content-disposition", "attachent; filename=" + new String((fileName).getBytes("KSC5601"), "8859_1") + ".xls"); @SuppressWarnings("unchecked") List<DeviceQualityAnalysisInfoVo> resultData = (List<DeviceQualityAnalysisInfoVo>) model.get("resultData"); HSSFSheet sheet = workbook.createSheet(sheetName); // ? HSSFRow header = sheet.createRow(0); header.createCell(0).setCellValue("??"); header.createCell(1).setCellValue(""); header.createCell(2).setCellValue(""); header.createCell(3).setCellValue("??"); header.createCell(4).setCellValue(""); header.createCell(5).setCellValue("?"); header.createCell(6).setCellValue("??"); header.createCell(7).setCellValue(""); header.createCell(8).setCellValue("?"); header.createCell(9).setCellValue("?"); // header.createCell(10).setCellValue("QMV"); // ? header.createCell(11).setCellValue("CPU"); header.createCell(12).setCellValue("MEM"); header.createCell(13).setCellValue("CHW"); header.createCell(14).setCellValue("CHWE"); header.createCell(15).setCellValue("ErrorDesc"); // header.createCell(16).setCellValue("RSSI"); header.createCell(17).setCellValue("RAT"); header.createCell(18).setCellValue("RSCP (WCDMA)"); header.createCell(19).setCellValue("E/I (WCDMA)"); header.createCell(20).setCellValue("RSRP (LTE)"); header.createCell(21).setCellValue("RSRQ (LTE)"); header.createCell(22).setCellValue("RMNET/QMI (LTE)"); header.createCell(23).setCellValue("BR"); header.createCell(24).setCellValue("SRVS"); header.createCell(25).setCellValue("Tx"); header.createCell(26).setCellValue("SS"); header.createCell(27).setCellValue("CS"); header.createCell(28).setCellValue("FREQ"); header.createCell(29).setCellValue("APN"); header.createCell(30).setCellValue("QoS"); header.createCell(31).setCellValue("PSC (WCDMA)"); header.createCell(32).setCellValue("D/N"); header.createCell(33).setCellValue("VER"); header.createCell(34).setCellValue("IMEI"); header.createCell(35).setCellValue("ICCID"); int index = 0; for (int i = 0; i < resultData.size(); i++) { DeviceQualityAnalysisInfoVo fvo = resultData.get(i); HSSFRow row = sheet.createRow(++index); // ?? row.createCell(0).setCellValue(fvo.getLastAccDt()); row.createCell(1).setCellValue(fvo.getBizNm()); row.createCell(2).setCellValue(fvo.getSvcNm()); row.createCell(3).setCellValue(fvo.getDevId()); row.createCell(4).setCellValue(fvo.getCtn()); row.createCell(5).setCellValue(fvo.getDevMakerNm()); row.createCell(6).setCellValue(fvo.getDevModelNm()); row.createCell(7).setCellValue(fvo.getModemMakerNm()); row.createCell(8).setCellValue(fvo.getModemModelNm()); row.createCell(9).setCellValue(fvo.getDevQulInfo()); // row.createCell(10).setCellValue(fvo.getQmv()); // ? row.createCell(11).setCellValue(fvo.getCpu()); row.createCell(12).setCellValue(fvo.getMem()); row.createCell(13).setCellValue(fvo.getChw()); row.createCell(14).setCellValue(fvo.getChwe()); row.createCell(15).setCellValue(fvo.getErrorDesc()); // row.createCell(16).setCellValue(fvo.getRssi()); row.createCell(17).setCellValue(fvo.getRat()); row.createCell(18).setCellValue(fvo.getRscp()); row.createCell(19).setCellValue(fvo.getEi()); row.createCell(20).setCellValue(fvo.getRsrp()); row.createCell(21).setCellValue(fvo.getRsrq()); row.createCell(22).setCellValue(fvo.getRmnet()); row.createCell(23).setCellValue(fvo.getBr()); row.createCell(24).setCellValue(fvo.getSrvc()); row.createCell(25).setCellValue(fvo.getTx()); row.createCell(26).setCellValue(fvo.getSs()); row.createCell(27).setCellValue(fvo.getCs()); row.createCell(28).setCellValue(fvo.getFreq()); row.createCell(29).setCellValue(fvo.getApn()); row.createCell(30).setCellValue(fvo.getQos()); row.createCell(31).setCellValue(fvo.getPsc()); row.createCell(32).setCellValue(fvo.getDn()); row.createCell(33).setCellValue(fvo.getVer()); row.createCell(34).setCellValue(fvo.getImei()); row.createCell(35).setCellValue(fvo.getIccid()); } workbook.write(response.getOutputStream()); response.getOutputStream().close(); } }