java下载excel

下载文件相关:使用阿里的excelExcel,下面是相关下载代码

java端代码: 

/**
 * 下载excel
 *
 * @param response
 * @param fileName
 * @param data 数据可谓null
 * @param t 实体类根据注解生成表头
 */
public static <T extends BaseRowModel> void downLoadExcel(HttpServletResponse response, String fileName, List<T> data, Class<T> t) {
    ServletOutputStream out = null;
    try {
        response.setContentType("application/vnd.ms-excel;charset=UTF-8");
        response.setCharacterEncoding("utf-8");
        fileName = new String((fileName + new SimpleDateFormat("yyyy-MM-dd").format(new Date())).getBytes("UTF-8"), "iso-8859-1");
        response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
        out = response.getOutputStream();
        ExcelWriter writer = new ExcelWriter(out, ExcelTypeEnum.XLSX);
        Sheet sheet1 = new Sheet(1, 0, t);
        sheet1.setSheetName("sheet1");
        writer.write(data, sheet1);
        writer.finish();
        out.flush();
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if (out != null) {
            try {
                out.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
}

 

前段代码,利用jquery无刷新页面进行下载文件

// Ajax 文件下载
//当不用传参时，可以将data去掉
function download (url, data, method){ // 获得url和data
   if( url){
      // data 是 string 或者 array/object
      if(data != null && data  != ''){
         data = typeof data == 'string' ? data : jQuery.param(data); // 把参数组装成 form的 input
         var inputs = '';
         jQuery.each(data.split('&'), function(){
            var pair = this.split('=');
            inputs+='<input type="hidden" name="'+ pair[0] +'" value="'+ pair[1] +'" />';
         }); // request发送请求
      }

      jQuery('<form action="'+ url +'" method="'+ (method||'post') +'">'+inputs+'</form>').appendTo('body').submit().remove();
   };
};