java 生成pdf报表

public void saveMapAddressInfo(String orderCode){
try{
List<Leads> leadses = leadsService.findLeadsByCode(orderCode);
if (leadses != null && leadses.size() > 0){
       //创建Document实例
Document document = new Document(PageSize.A4, 20, 20, 20, 20);
       //建立一个书写器(Writer)与document对象关联,通过书写器(Writer)可以将文档写入到磁盘中。
PdfWriter.getInstance(document, new FileOutputStream(this.filePath + "/" + orderCode+"-MapUserInfo.pdf"));
       //打开文档。
document.open();
Font cellFont = FontFactory.getFont("HELVETICA", 9, BaseColor.BLACK);
Font titleFont = FontFactory.getFont("HELVETICA-BOLD", 9, BaseColor.BLACK);
PdfPTable table = new PdfPTable(8);
PdfPCell cell;
table.setWidthPercentage(100);
table.setWidths(new int[]{3, 4, 4, 5, 3, 3, 2, 3});
table.getDefaultCell().setUseAscender(true);
table.getDefaultCell().setUseDescender(true);

// first row
cell = new PdfPCell(new Phrase(orderCode + " - Map User Info"));
cell.setColspan(8);
cell.setHorizontalAlignment(Element.ALIGN_CENTER);
cell.setPadding(5.0f);
cell.setBackgroundColor(new BaseColor(53,168,3));
cell.setMinimumHeight(30);
table.addCell(cell);

cell = new PdfPCell(new Paragraph("Name",titleFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph("Phone",titleFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph("Email",titleFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph("Address",titleFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph("Address2",titleFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph("City",titleFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph("State",titleFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph("ZipCode",titleFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
for(Leads leads:leadses){
cell = new PdfPCell(new Paragraph(leads.getFirstName()+" "+leads.getLastName(),cellFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph(leads.getPhone(),cellFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph(leads.getEmail(),cellFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph(leads.getAddress(),cellFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph(leads.getAddress2(),cellFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph(leads.getCity(),cellFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph(leads.getState(),cellFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
cell = new PdfPCell(new Paragraph(leads.getZipCode(),cellFont));
cell.setPadding(5.0f);
cell.setMinimumHeight(25);
table.addCell(cell);
}
       //向文档中添加内容。
document.add(table);
// 5.关闭文档
document.close();
}
}catch (FileNotFoundException e){
e.printStackTrace();
}catch (DocumentException e){
e.printStackTrace();
}
}

转载于:https://www.cnblogs.com/qyhol/p/5690711.html

Java使用com.lowagie.text.pdf插件编写的PDF报表工具类,支持动态报表创建,使用简单,附件中包含了测试类和生成报表文件。附件中的代码需要修改相关的保存路径后可以直接使用。创建一张报表例子: private JsFileExportResult createRowReport() { String condition = "开始时间:2018-02-02 14:00:30 结束时间:2018-02-06 16:00:30"; PDFGridReport pdfReport = new PDFGridReport("报表创建测试", GridReportTestModel.getModels()); pdfReport.addCondition(condition); pdfReport.header("字段名称1", "item1", 0, 0).width(160); pdfReport.header("字段名称3", "item3", 0, 2).getCell().backgroundColor(Color.ORANGE); pdfReport.header("字段名称4", "item4", 0, 3); pdfReport.header("字段名称5", "item5", 0, 4); pdfReport.header("字段名称2", "item2", 0, 1); pdfReport.header("值", "value", 0, 5).alignH(HAlign.ALIGN_CENTER).getCell().alignH(HAlign.ALIGN_RIGHT); pdfReport.header("时间", "time", 0, 6); pdfReport.header("图片", "image", 0, 7).width(60).alignH(HAlign.ALIGN_CENTER).getCell() .alignH(HAlign.ALIGN_CENTER).alignV(VAlign.ALIGN_MIDDLE); // 横向打印 pdfReport.getPageSetting().setPrintHorizontal(); pdfReport.group("item1").childGroup("item2"); pdfReport.setCellFormat(new PDFCellValueFormat() { @Override public String format(String fieldName, String oriValue) { if ("value".equals(fieldName)) { return String.format("%.2f", Double.parseDouble(oriValue)).toString(); } else { return oriValue; } } }); JsFileExportResult fileResult = pdfReport.createReport(); return fileResult; }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值