egovframework.rte.tex.com.web.EgovExcel.java Source code

Introduction

Here is the source code for egovframework.rte.tex.com.web.EgovExcel.java

Source

/*
 * Copyright 2011 MOPAS(Ministry of Public Administration and Security).
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package egovframework.rte.tex.com.web;

import java.util.List;
import java.util.Map;

import egovframework.rte.tex.gds.service.GoodsVO;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.web.servlet.view.document.AbstractExcelView;

/**
 * ?? ? ? ?.
 * @author   
 * @since 2011.06.07
 * @version 1.0
 * @see <pre>
 *  == ?(Modification Information) ==
 *
 *   ?      ?           
 *  -------    --------    ---------------------------
 *   2011.06.07             ?
 *
 * </pre>
 */
public class EgovExcel extends AbstractExcelView {

    /**
     * ??  ?.
     * @param model
     * @param wb
     * @param request
     * @param response
     * @throws Exception
     */
    @SuppressWarnings({ "deprecation", "unchecked" })
    @Override
    protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook wb, HttpServletRequest request,
            HttpServletResponse response) throws Exception {

        HSSFCell cell = null;

        HSSFSheet sheet = wb.createSheet("Goods List");
        sheet.setDefaultColumnWidth((short) 12);

        // put text in first cell
        cell = getCell(sheet, 0, 0);
        setText(cell, "Goods List");

        // set header information
        setText(getCell(sheet, 2, 0), "No.");
        setText(getCell(sheet, 2, 1), "NAME");
        setText(getCell(sheet, 2, 2), "PRICE");
        setText(getCell(sheet, 2, 3), "CATEGORY NAME");
        setText(getCell(sheet, 2, 4), "MAKER");

        List<GoodsVO> goods = (List<GoodsVO>) model.get("goodsList");

        for (int i = 0; i < goods.size(); i++) {
            GoodsVO goodsVO = goods.get(i);

            cell = getCell(sheet, 3 + i, 0);
            setText(cell, Integer.toString(i + 1));

            cell = getCell(sheet, 3 + i, 1);
            setText(cell, goodsVO.getGoodsNm());

            cell = getCell(sheet, 3 + i, 2);
            setText(cell, Integer.toString(goodsVO.getPrice()));

            cell = getCell(sheet, 3 + i, 3);
            setText(cell, goodsVO.getCategoryVO().getCtgryNm());

            cell = getCell(sheet, 3 + i, 4);
            setText(cell, goodsVO.getMakr());
        }
    }
}