java代码实现导出CSV格式

参考代码

/** * 导出CSV格式的 * @return */@POST@Path("/subjectExportCSV")@Produces("*/*")public String subjectExportCSV(){List<Subject> listSubjectAll = subjectService.listSubjectAll();List<SubjectSearchModel> searchModels = searchModelList(listSubjectAll);String path = this.getClass().getResource("/").getPath();// 得到d:/tomcat/webapps/工程名WEB-INF/classes/路径path = path.substring(1, path.indexOf("WEB-INF/classes"));// 从路径字符串中取出工程路劲FileOutputStream out;try {//查询所有年级的列表/*List<Subject> listSubjectAll = subjectService.listSubjectAll();CsvWriter wr =new CsvWriter("D://subject.csv",',',Charset.forName("GBK"));for(Subject s : listSubjectAll){String[] contents = {s.getId()+"",s.getName()+"",s.getCode()+"",s.getDeleteFlag()+"",s.getRemark()+"",s.getCreateUserId()+"",s.getCreateDate()+"",s.getUpdateUserId()+"",s.getUpdateDate()+""};    wr.writeRecord(contents);}wr.close();*/File csvFile = null;csvFile = new File(path+"make/csvprint/subject.csv");System.out.println(path+"make/csvprint/subject.csv");File parent = csvFile.getParentFile();if (parent != null && !parent.exists()) {//假如目录../make/csvprint不存在则创建目录parent.mkdirs();}csvFile.createNewFile();//创建一个空文件out = new FileOutputStream(csvFile);//用已经打开的文件创建一个新的文件流OutputStreamWriter osw = new OutputStreamWriter(out, "GB2312");//是Writer的子类，将输出的字符流变为字节流，即将一个字符流的输出对象变为字节流输出对象。BufferedWriter bw = new BufferedWriter(osw);bw.write("科目名称" + "," +"科目代号" + ","+"备注" +"\r\n");for (int i = 0; i < searchModels.size(); i++) {String name = searchModels.get(i).getName().replaceAll(",", "").replaceAll("，", "");String code=searchModels.get(i).getCode().replaceAll(",", "").replaceAll("，", "");String remark=searchModels.get(i).getRemark().replaceAll(",", "").replaceAll("，", "");bw.write(name + ","+code+","+remark+ "\r\n");}bw.close();osw.close();out.close();} catch (Exception e) {e.printStackTrace();return StringParam.returnPageFalse();}return StringParam.returnPageTrue("path","subject.csv");}