java分页数据导出excel
2023-09-14 09:07:57 时间
/** * 订单导出(用于统计利润) * @return */ public String orderExport() throws IOException{ if (queryOrderList_currentPage == null || queryOrderList_currentPage <= 0) { queryOrderList_currentPage = 1; } OrderInfo order = new OrderInfo(); if (!StringUtil.isNull(queryOrderList_orderStatus)) { order.setOrderStatus(queryOrderList_orderStatus); } if (!StringUtil.isNull(queryOrderList_orderCard)) { order.setOrderCard(queryOrderList_orderCard); } if (!StringUtil.isNull(queryOrderList_memberPhone)) { order.setMemberPhone(queryOrderList_memberPhone); } if (!StringUtil.isNull(queryOrderList_memberContactsPhone)) { order.setMemberContactsPhone(queryOrderList_memberContactsPhone); } if (queryOrderList_businessId != null && queryOrderList_businessId > 0) { order.setBusinessId(queryOrderList_businessId); } if (!StringUtil.isNull(queryOrderList_addressDesc)) { order.setAddressDesc(queryOrderList_addressDesc); } if (!StringUtil.isNull(queryOrderList_beginTime) && !StringUtil.isNull(queryOrderList_endTime)) { order.setBeginTime(queryOrderList_beginTime); order.setEndTime(queryOrderList_endTime); } try { HttpServletResponse response = ServletActionContext.getResponse(); queryOrderList_pageBean = statisticsService.queryOrderListByCompanyConditions(order,queryOrderList_currentPage, queryOrderList_pageSize); int totalPage = queryOrderList_pageBean.getTotalPage(); response.reset(); SimpleDateFormat sdFormat = new SimpleDateFormat("yyyy-MM-dd"); String fname= "订单导出"+sdFormat.format(new Date()); fname=new String(fname.getBytes("GBK"),"ISO_8859_1");//文件名{避免出现乱码} response.setHeader("Content-disposition", "attachment; filename="+fname+".csv");// 设定输出文件头 response.setContentType("text/csv"); response.setCharacterEncoding("UTF-8"); OutputStream out = response.getOutputStream(); String sep = ","; //列名 for(int column=0;column<CompanyConfig.ORDER_EXPORT_COLUMN.split(",").length;column++){ out.write(CompanyConfig.ORDER_EXPORT_COLUMN.split(",")[column].getBytes()); out.write(sep.getBytes()); } //换行符 out.write(System.getProperty("line.separator").getBytes()); //数据 OrderInfo newOrderInfo =new OrderInfo(); if(queryOrderList_pageBean.getList()!=null && queryOrderList_pageBean.getList().size()>0){ for (int i = 0; i < queryOrderList_pageBean.getList().size(); i++) { newOrderInfo=(OrderInfo)queryOrderList_pageBean.getList().get(i); getOut(out,newOrderInfo,sep); } } if(totalPage>1){ for (int m = 2; m <= totalPage; m++) { queryOrderList_pageBean = statisticsService.queryOrderListByCompanyConditions(order, queryOrderList_currentPage, queryOrderList_pageSize); List list =queryOrderList_pageBean.getList(); if(list!=null && list.size()>0){ for (int j = 0; j < list.size(); j++){ OrderInfo nOrderInfo=(OrderInfo)list.get(j); getOut(out, nOrderInfo, sep); } } } } out.flush(); out.close(); } catch (Exception e) { e.printStackTrace(); } return null; } public void getOut(OutputStream out,OrderInfo newOrderInfo,String sep) throws IOException{ if(!StringUtil.isNull(newOrderInfo.getOrderCard())){ out.write(String.valueOf(newOrderInfo.getOrderCard()).getBytes()); }else{ out.write(String.valueOf("订单编号为空").getBytes()); } out.write((sep).getBytes()); if(!StringUtil.isNull(newOrderInfo.getMemberContactsPhone())){ out.write(newOrderInfo.getMemberContactsPhone().getBytes()); }else{ out.write(String.valueOf("用户联系电话为空").getBytes()); } out.write((sep).getBytes()); if(newOrderInfo.getAddressDesc()!=null){ out.write(newOrderInfo.getAddressDesc().getBytes()); }else{ out.write(String.valueOf("联系地址为空").getBytes()); } out.write((sep).getBytes()); if(newOrderInfo.getGenerateTime()!=null){ out.write(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(newOrderInfo.getGenerateTime()).getBytes()); }else{ out.write(String.valueOf("下单时间为空").getBytes()); } out.write(System.getProperty("line.separator").getBytes()); }
相关文章
- java解析xml方法_详解Java解析XML的四种方法
- java导出文件前端获取到数据流后下载excel文档
- Java如何卸载?怎么删掉Windows计算机上的Java?Java卸载流程详解!
- java编译命令是什么_Java编译命令整理
- 我的世界java版需要多少钱_我的世界Java版20w49a快照版[通俗易懂]
- 什么是java虚拟机(Java Virtual Machine)?
- java运行机制是什么_JAVA运行机制
- java获取服务器路径_Java获取此次请求URL以及服务器根路径的方法「建议收藏」
- Java实现Excel导入和导出,看这一篇就够了(珍藏版)
- java导出excel(二):多个sheet
- Java截取字符串方法_java通过split截取字符串
- Java中注解学习系列教程-4 使用自定义注解实现excel导出
- JAVA以UTF-8导出CSV文件,用excel打开产生乱码的解决方法
- Java实现pdf和Excel的生成及数据动态插入、导出
- Java 读取 .properties 配置文件的几种方式详解编程语言
- java处理Excel文件—excel文件的创建,删除,写入,读取详解编程语言
- java POI读取Excel文件详解编程语言
- Java数据导出(写)Excel文件 解析详解编程语言
- java:POI导出excel详解编程语言
- Java连接Mysql:探索数据库之路。(java链接mysql)
- java实现Excel数据导出详解编程语言
- 解锁Java 与 Oracle 的连接之门(java连接oracle)
- Java高效操作MySQL数据库(java写入mysql)
- MySQL数据导出Excel快速教程(mysql转excel)
- 使用Java类连接MSSQL数据库(mssql连接java类)
- Oracle数据快速导出至Excel表格(oracle导出excel)
- Redis无法与Java建立连接(redis连不上java)
- Java实现Redis计数器功能(redis计数 java)