java怎么导出csv文件

 

 /*** 查询任务列表导出* type: 待领取, 未完成, 已完成* */@RequestMapping(value = "/taskList/export")@ResponseBody@TjkRole(tjkRole = TjkRoleEnum.ManageUser)public void takeListExport(HttpServletResponse response, Hotel h, Integer tjkId, Integer pageSize){String title = "ID,任务名\n";ByteArrayOutputStream baos = null;BufferedWriter bw = null;try {baos = new ByteArrayOutputStream();bw = new BufferedWriter(new OutputStreamWriter(baos, "UTF-8"));baos.write(239); // 0xEFbaos.write(187); // 0xBBbaos.write(191);bw.write(title);String fileName = new String(("测试数据").getBytes("GBK"), "ISO8859-1");response.setHeader("Content-disposition", "attachment; filename=" + fileName + ".csv");// 设定输出文件头response.setContentType("application/csv");// 定义输出类型int pageNum = 1;while(true){Integer pageSize = 200;PageInfo<Hotel> page = this.queryPageList(pageNum, pageSize);List<Hotel> list = page.getList();if (CollectionUtils.isEmpty(list)) {break;}for (Hotel data : list) {StringBuilder sb = new StringBuilder();sb.append(convertCell2(data.getUniqueId()));sb.append(convertCell2(data.getHotelName())) + "\n";bw.write(sb.toString());}pageNum++;bw.flush();byte[] data = baos.toByteArray();response.getOutputStream().write(data);response.getOutputStream().flush();baos.reset();}} catch (Exception e) {log.error("#T100 ", e);} finally {try {baos.close();bw.close();} catch (IOException e) {log.error("===exportCsv关闭异常", e);}}}