Java操作POI批量导出多个excle，打压缩包

1、前端js

function exportRecord(){  
    var browseUrl=$("#browseUrl").val();  
      if(browseUrl == null || browseUrl == ""){  
          $.messager.show({  
                title : '提示',  
                msg : '浏览资源ID,不能为空！'  
            });  
            return ;  
      }else{  
      var data = $.toJSON(getCustomerSearch());  
      window.location.href="statResourceBrowseAction!exportStatResourceBrowse?queryJson="+data+"&excelTatol="+excelTatol;  
      }  
}  

二、Java请求处理

 public void exportStatResourceBrowse() {  
        ExportToExcelUtil<StatResourceBrowse> excelUtil = new ExportToExcelUtil<StatResourceBrowse>();  
        // 导出总记录数  
        excelTatol = request.getParameter("excelTatol") == null ? 10 : Integer.parseInt(request.getParameter("excelTatol"));  
        OutputStream out = null;  
        try {  
            out = response.getOutputStream();  
            excelUtil.setResponseHeader(response,"Excel表表名");  
            String[] headers = { "列1",  "列2", "列3", "列4","列5","列6","列7"};  
            String[] columns = { "Id", "Title","areas", "province","hospital","Level","Source"};  
  
            List<StatResourceBrowse> dataset = service.getList(getQueryJsonKeywordObject());  
            excelUtil.exportExcel( headers, columns, dataset, out, request, "");  
        } catch (Exception e1) {  
            e1.printStackTrace();  
        } finally {  
            try {  
                out.flush();  
                out.close();  
            } catch (Exception e) {  
                e.printStackTrace();  
            }  
        }  
    }  

三、poi导出Excel工具类

import java.io.File;  
import java.io.FileInputStream;  
import java.io.FileOutputStream;  
import java.io.IOException;  
import java.io.OutputStream;  
import java.lang.reflect.Method;  
import java.text.SimpleDateFormat;  
import java.util.ArrayList;  
import java.util.Collection;  
import java.uti