首页 技术 正文
技术 2022年11月14日
0 收藏 317 点赞 3,076 浏览 5106 个字

这几天已在做处理导出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;
}

  

相关推荐
python开发_常用的python模块及安装方法
adodb:我们领导推荐的数据库连接组件bsddb3:BerkeleyDB的连接组件Cheetah-1.0:我比较喜欢这个版本的cheeta…
日期:2022-11-24 点赞:878 阅读:9,105
Educational Codeforces Round 11 C. Hard Process 二分
C. Hard Process题目连接:http://www.codeforces.com/contest/660/problem/CDes…
日期:2022-11-24 点赞:807 阅读:5,582
下载Ubuntn 17.04 内核源代码
zengkefu@server1:/usr/src$ uname -aLinux server1 4.10.0-19-generic #21…
日期:2022-11-24 点赞:569 阅读:6,429
可用Active Desktop Calendar V7.86 注册码序列号
可用Active Desktop Calendar V7.86 注册码序列号Name: www.greendown.cn Code: &nb…
日期:2022-11-24 点赞:733 阅读:6,200
Android调用系统相机、自定义相机、处理大图片
Android调用系统相机和自定义相机实例本博文主要是介绍了android上使用相机进行拍照并显示的两种方式,并且由于涉及到要把拍到的照片显…
日期:2022-11-24 点赞:512 阅读:7,836
Struts的使用
一、Struts2的获取  Struts的官方网站为:http://struts.apache.org/  下载完Struts2的jar包,…
日期:2022-11-24 点赞:671 阅读:4,919