这几天已在做处理导出pdf文件的功能,摸索了几天总算可以了。记录下这几天遇到的问题。
1.网上基本都是基于Itext5和Itext7来处理的。我最终是在Itext5上成功了,itext7应该是模板出问题了,在写的test方法里面测试时候,总是 找不到 pdf文档里面的form表单内容。因为需要使用adobe acrobat reader dc 来制作模板,而我没有这个。一直导致失败。
2.最终成功是参考这个文档:
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
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 it = form.getFields().keySet().iterator();
*//*for(int i = 0;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;
}