fj-dc/.svn/pristine/74/740b3929f850e1ddfeccea8affbeed791bd7760f.svn-base

package cn.com.goldenwater.dcproj.utils.expExcel;

import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * Created by lhc on 2019-3-18.
 */
public class ExpSimaple {

    public static void expSimaple(HttpServletResponse response) throws Exception {
        List<Map<String, Object>> ls = new ArrayList<>();
        Map<String, Object> temp1 = new HashMap<>(5);
        temp1.put("STCD", "123456");
        temp1.put("STNM", "123456");
        temp1.put("RVNM", "123456");
        temp1.put("ADDVNM", "123456");
        temp1.put("DRP", "123456");
        ls.add(temp1);
        Map<String, Object> temp2 = new HashMap<>(5);
        temp2.put("STCD", "123456");
        temp2.put("STNM", "123456");
        temp2.put("RVNM", "123456");
        temp2.put("ADDVNM", "123456");
        temp2.put("DRP", "123456");
        ls.add(temp2);
        ExportAbstract export = new ExcelExport();
        // view.getView_name()
        export.setFileName("时段累计雨量");
        export.setExport_ps_export(true);
        export.setExport_ps_type(ExportAbstract.XLS);
        export.setExport_bzip(false);
        export.setTitle("时段累计雨量");
        ArrayList<Object> cols = new ArrayList<>();
        cols.add("STCD[站码]");
        cols.add("STNM[站名]");
        cols.add("RVNM[河流]");
        cols.add("ADDVNM[县]");
        cols.add("DRP[累计雨量]");
        export.setCols(cols);

        export.setGroupable(false);
        // 设置视图指标
        export.setLevel(1);
        export.setLocksize(0);
        export.Export(response);
        // 导出表头
        export.ExportHeadForCustom(response);
        export.ContinueExport(ls);
        export.EndExport();
    }

}