导出数据 public boolean exportCsv(File file, List<String> dataList ,String checkUser ,BigCustomerOrderVo vo){ boolean isSucess=false; FileOutputStream out=null; OutputStreamWriter osw=null; BufferedWriter bw=null; try { out = new FileOutputStream(file); osw = new OutputStreamWriter(out); bw =new BufferedWriter(osw); if(dataList!=null && !dataList.isEmpty()){ for(String data : dataList){ bw.append(data).append("\r"); } } isSucess=true; } catch (Exception e) { isSucess=false; }finally{ if(bw!=null){ try { bw.close(); bw=null; } catch (IOException e) { e.printStackTrace(); } } if(osw!=null){ try { osw.close(); osw=null; } catch (IOException e) { e.printStackTrace(); } } if(out!=null){ try { out.close(); out=null; } catch (IOException e) { e.printStackTrace(); } } } try { FlowLogPo flowLogPo = new FlowLogPo("project","",checkUser,"大客户订单导出操作", com.jd.payment.paycommon.utils.GsonUtils.toJson(vo)); flowLogDao.insertFlowLog(flowLogPo); } catch (Exception e) { logger.error("大客户订单导出操作,插入日志流水表异常",e); } return isSucess; } 输出并下载public static void outputNewExcel (HttpServletRequest req, HttpServletResponse response, String filename, String path) { response.setHeader ("Content-Transfer-Encoding", "binary"); response.setHeader ("Cache-Control", "must-revalidate, post-check=0, pre-check=0"); response.setHeader ("Pragma", "public"); response.setHeader ("Pragma", "no-cache"); // 禁止数据缓存。 response.setDateHeader ("Expires", 0); response.setContentType ("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");// 设置响应的类型格式为电子表格格式 response.setHeader ("Content-disposition", "attachment;filename=" + filename); try { ServletOutputStream sos = response.getOutputStream (); File f = new File (path + filename); FileInputStream fi = new FileInputStream (f); // byte[] buf = new byte[(int) f.length ()]; // fi.read(buf, 0, (int) f.length()); // sos.write (buf); byte[] buf = new byte[1024*4]; int sizetag =0; while ((sizetag= fi.read (buf, 0, 1024*4))!=-1){ sos.write (buf,0,sizetag); } sos.flush(); fi.close(); sos.close(); } catch (Exception e) { e.printStackTrace (); } finally { File f = new File (path + filename); if (f.exists ()) { f.delete (); } System.gc(); } }
java导出csv
最新推荐文章于 2024-07-17 13:05:59 发布