这几天已在做处理导出pdf文件的功能,摸索了几天总算可以了。记录下这几天遇到的问题。
1.网上基本都是基于Itext5和Itext7来处理的。我最终是在Itext5上成功了,itext7应该是模板出问题了,在写的test方法里面测试时候,总是 找不到 pdf文档里面的form表单内容。因为需要使用adobe acrobat reader dc 来制作模板,而我没有这个。一直导致失败。
2.最终成功是参考这个文档:
https://blog.csdn.net/yi2419808933/article/details/52469241
https://blog.csdn.net/yi2419808933/article/details/52469241
3.贴上最终代码
/** * 导出对账单 * @return */ @RequestMapping("/exportSupplierFeeData") @ResponseBody @MasterSlaveConfigs(configs={ @MasterSlaveConfig(databaseTag="mdbcarmanage-DataSource",mode= DynamicRoutingDataSource.DataSourceMode.SLAVE) } ) public AjaxResponse exportSupplierFeeData(HttpServletRequest request, HttpServletResponse response, ServletOutputStream outputStream, Integer cityId, Integer supplierId, Integer status, Integer amountStatus, String settleStartDate, String settleEndDate, String paymentStartTime, String paymentEndTime, String feeOrderNo){ logger.info(MessageFormat.format("查询司机线上化入参:cityId:%s,supplierId:%s,status:%s," + "amountStatus:%s,settleStartDate:%s,settleEndDate:%s,paymentStartTime:%s,paymentEndTime:%s",cityId,supplierId,status,amountStatus,settleStartDate,settleEndDate,paymentStartTime,paymentEndTime)); response.setContentType("application/pdf;charset=ISO8859-1"); response.setHeader("Content-disposition", "attachment; filename="+"supplierFeePDF-1.pdf"); SupplierFeeManageDto feeManageDto = new SupplierFeeManageDto(); feeManageDto.setCityId(cityId); feeManageDto.setSettleStartDate(settleStartDate); feeManageDto.setSettleEndDate(settleEndDate); feeManageDto.setAmountStatus(amountStatus); feeManageDto.setStatus(status); SupplierFeeManage manage = supplierFeeService.queryByOrderNo(feeOrderNo); String[] titles = { "供应商名称1", "列名t2", "列名3", "列名4", "t5", "t6","t7"}; try { ByteArrayOutputStream ba = new ByteArrayOutputStream(); Document document = new Document(PageSize.A3); // Step 1—Create a Document. PdfWriter writer; writer = PdfWriter.getInstance(document, ba); document.open(); document.setMargins(5, 5, 5, 5); //H 代表文字版式是横版,相应的 V 代表竖版 BaseFont bfChinese = BaseFont.createFont("STSongStd-Light","UniGB-UCS2-H",BaseFont.NOT_EMBEDDED);//STSongStd-Light 是字体,在jar 中以property为后缀 //参数一:新建好的字体;参数二:字体大小,参数三:字体样式,多个样式用“|”分隔 Font topfont = new Font(bfChinese,14,Font.BOLD); //BaseFont bf = BaseFont.createFont("" + "fonts/simsun.ttc,0", BaseFont.IDENTITY_H, // BaseFont.EMBEDDED); Paragraph blankRow1 = new Paragraph(18f, " "); blankRow1.setAlignment(Element.ALIGN_CENTER); PdfPTable table1 = new PdfPTable(titles.length); //创建一个表格,参数为一行有几栏 int width1[] = {100,150,150,100,50,50,55};//每栏的宽度 table1.setWidths(width1); //设置宽度 //首行 for(int i=0;i<titles.length;i++){ PdfPCell cell1 = new PdfPCell(new Paragraph(titles[i],topfont)); table1.addCell(cell1); } //每栏的值 //PdfPCell cell1 = new PdfPCell(new Paragraph(manage.getSupplierId())); /* PdfPTable celltable = new PdfPTable(2); cell1 = new PdfPCell(celltable); cell1.setRowspan(2); cell1.setPadding(10); table1.addCell(cell1);*/ PdfPCell cell1 = new PdfPCell(new Paragraph("5555",topfont)); table1.addCell(cell1); PdfPCell cell2= new PdfPCell(new Paragraph(manage.getFlowAmount(),topfont)); table1.addCell(cell2); PdfPCell cell3= new PdfPCell(new Paragraph(manage.getSettleStartDate().toString(),topfont)); table1.addCell(cell3); PdfPCell cell4= new PdfPCell(new Paragraph(manage.getPaymentTime().toString(),topfont)); table1.addCell(cell4); PdfPCell cell5= new PdfPCell(new Paragraph(manage.getFeeOrderNo(),topfont)); table1.addCell(cell5); PdfPCell cell6= new PdfPCell(new Paragraph(manage.getSupplierId().toString(),topfont)); table1.addCell(cell6); PdfPCell cell7= new PdfPCell(new Paragraph(manage.getSupplierName().toString(),topfont)); table1.addCell(cell7); document.add(table1);//将表格加入到document中 // document.add(table2); document.add(blankRow1); document.close(); ba.writeTo(outputStream); outputStream.flush(); outputStream.close(); ba.close(); // 导出pdf注解 } catch (Exception e) { e.printStackTrace(); } // 模板路径 String templatePath = "/Users/fan/workspace/mp-manage/src/main/webapp/upload/supplierFeePDF-1.pdf"; // 生成的新文件路径 String newPDFPath = "/Users/fan/workspace/mp-manage/src/main/webapp/upload/supplierFeePDF-2.pdf"; /* PdfReader reader; FileOutputStream out; ByteArrayOutputStream bos; PdfStamper stamper; try { out = new FileOutputStream(newPDFPath);// 输出流 reader = new PdfReader(templatePath);// 读取pdf模板 bos = new ByteArrayOutputStream(); stamper = new PdfStamper(reader, bos); AcroFields form = stamper.getAcroFields(); *//*String[] str = {manage.getSupplierName(), DateUtils.formatDate(manage.getSettleStartDate()),DateUtils.formatDate(manage.getSettleEndDate()), manage.getFlowAmount()};*//* String[] str = { "123456789", "TOP__ONE", "男", "1991-01-01", "130222111133338888", "河北省保定市" }; java.util.Iterator<String> it = form.getFields().keySet().iterator(); *//*for(int i = 0;i<feeManageList.size();i++){ SupplierFeeManage feeManage = feeManageList.get(i); form.setField(null,feeManage.getSupplierName()); }*//* int i = 0; while (it.hasNext()) { String name = it.next().toString(); System.out.println(name); form.setField(name, str[i++]); } stamper.setFormFlattening(true);// 如果为false那么生成的PDF文件还能编辑,一定要设为true stamper.close(); Document doc = new Document(); PdfCopy copy = new PdfCopy(doc, out); doc.open(); PdfImportedPage importPage = copy.getImportedPage(new PdfReader(bos.toByteArray()), 1); copy.addPage(importPage); doc.close(); } catch (IOException e) { System.out.println(1); } catch (DocumentException e) { System.out.println(2); } */ return null; }