功能要求根据数据库记录的key-value-remark 数据,导出保存properties文件
1. pro.load() pro.list() 处理不能解决备注、排序问题
2. 最后考虑下什么是properties文件,操作系统大概怎么区分这样的数据是正确的properties数据,区分大概回车符与#符,直接拼接字符,输入输出流导出
@RequestMapping(value = "/export/{id}", method = RequestMethod.GET) public void export(@PathVariable("id") Long id) throws IOException { response.reset(); StringBuilder buff = new StringBuilder(); AppProperties tc = appPropertiesService.get(id); String fileName = tc.getLineCode()+tc.getAppCode()+tc.getId(); if(tc != null){ Collection<SearchFilter> filters = new ArrayList<>(); filters.add(new SearchFilter("refId",SearchFilter.Operator.valueOf("EQ"),id)); List<PropertiesInfo> detailList = propertiesInfoService.findAll(new SearchSpecification(filters,PropertiesInfo.class) , new Sort(Sort.Direction.ASC,new String[]{"orderBy"})); for(PropertiesInfo info:detailList){ if(info.getRemark() != null && !"".equals(info.getRemark())){ buff.append("#").append(info.getRemark()).append(" "); } buff.append(info.getKey()).append("=").append(info.getValue()).append(" "); } } response.setHeader("Content-Disposition", "attachment;filename="+fileName+".properties"); response.setContentType("application/msexcel; charset=GBK"); ServletOutputStream out = response.getOutputStream(); BufferedInputStream br = new BufferedInputStream(new ByteArrayInputStream(buff.toString().getBytes())); byte[] buf = new byte[1024]; int len = 0; while ((len = br.read(buf)) > 0){ out.write(buf, 0, len); } out.flush(); br.close(); out.close(); }