数据生成PDF文件

1、 1. 数据生成PDF：在父页面中加入如下示例方法function createPDF()var flag = ;jQuery.ajax(url : /interface/pdfAjax.jsp,type : post,processData : false,data : sql_pdf=&sql_pdf2=,dataType : xml,async : false,success: function do4Success(msg)tryflag = msg.getElementsByTagName(flag)0.childNodes0.nodeValue;path= msg.getEleme

2、ntsByTagName(path)0.childNodes0.nodeValue;catch(e) );if(flag=1)window.open(path);elsealert(导出PDF失败);打开的页面就是生成的PDF 可以右击另存为或在文件中选择另存为2. 相关jar包iText.jar3. 实例代码package erfaces.tjjc;import java.io.FileOutputStream;import java.io.IOException;import weaver.conn.RecordSet;import weaver.general.Bas

3、eBean;import weaver.general.Util;import pany.DepartmentComInfo;import weaver.hrm.resource.ResourceComInfo;import erfaces.tjjc.KqDateTimeUtil;import com.lowagie.text.Document;import com.lowagie.text.DocumentException;import com.lowagie.text.Element;import com.lowagie.text.Font;import com.lo

4、wagie.text.PageSize;import com.lowagie.text.Paragraph;import com.lowagie.text.pdf.BaseFont;import com.lowagie.text.pdf.PdfPCell;import com.lowagie.text.pdf.PdfPTable;import com.lowagie.text.pdf.PdfWriter;public class PdfTools /* * * 生成PDF的方法 * * return boolean * */public static boolean createPDF(Str

5、ing pdfPath, String sql, String sql2) Document document = new Document();/ 建立一个Document对象document.setPageSize(PageSize.A4);/ 设置页面大小try PdfWriter.getInstance(document, new FileOutputStream(pdfPath);/ 建立一个PdfWriter对象document.open();BaseFont bfChinese = BaseFont.createFont(c:windowsfontssimsun.ttc,1, B

6、aseFont.IDENTITY_H,BaseFont.EMBEDDED);/ 设置中文字体Font titleFont = new Font(bfChinese, 15, Font.BOLD);/ 设置字体大小Font headFont = new Font(bfChinese, 10, Font.BOLD);/ 设置字体大小Font headFont1 = new Font(bfChinese, 10, Font.BOLD);/ 设置字体大小Font headFont2 = new Font(bfChinese, 10, Font.NORMAL);/ 设置字体大小document.add(

7、new Paragraph(缺勤信息, titleFont);float widths = 80f, 80f, 80f, 80f, 80f, 80f, 80f ;/ 设置表格的列宽PdfPTable table = new PdfPTable(widths);/ 建立一个pdf表格table.setSpacingBefore(20f);/ 设置表格上面空白宽度table.setTotalWidth(widths);/ 设置表格的宽度table.setLockedWidth(true);/ 设置表格的宽度固定table.getDefaultCell().setBorder(1);/ 设置表格默认

8、为边框1PdfPCell cell = null;cell = new PdfPCell(new Paragraph(姓名, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);cell = new PdfPCell(new Paragraph(部门, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);cell = new PdfP

9、Cell(new Paragraph(日期, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);cell = new PdfPCell(new Paragraph(签到时间, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);cell = new PdfPCell(new Paragraph(签退时间, headFont);cel

10、l.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);cell = new PdfPCell(new Paragraph(缺勤时段, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);cell = new PdfPCell(new Paragraph(缺勤原因, headFont);cell.setHorizontalAlignment(Element.ALI

11、GN_CENTER);/ 设置内容水平居中显示table.addCell(cell);cell.setColspan(7);/ cell.setBorder(0);/设置单元格无边框/ cell.setColspan(7);/ 设置合并单元格的列数/ table.addCell(cell);/ 增加单元格RecordSet rs = new RecordSet();RecordSet RecordSet2 = new RecordSet();ResourceComInfo ResourceComInfo = new ResourceComInfo();DepartmentComInfo Dep

12、artmentComInfo = new DepartmentComInfo();KqDateTimeUtil KqDateTimeUtil = new KqDateTimeUtil();rs.execute(sql);while (rs.next() String resourceid = Util.null2String(rs.getString(resourceid);String lastname = ResourceComInfo.getLastname(resourceid);String deptname = DepartmentComInfo.getDepartmentname

13、(ResourceComInfo.getDepartmentID(resourceid);String carddate = Util.null2String(rs.getString(carddate);String maxtime = Util.null2String(rs.getString(maxtime);String mintime = Util.null2String(rs.getString(mintime);String temptypename = ;String typename = ;if (.equals(maxtime) maxtime = 00:00;if (.e

14、quals(mintime) mintime = 00:00;long timelen = KqDateTimeUtil.timeInterval(carddate + + mintime + :00, carddate + + maxtime + :00);System.out.println(s-+ mintime + :00+-x-+ carddate + + maxtime + :00);System.out.println(timelen-+timelen);if (timelen 530) RecordSet2.execute(select type,xtypename,mark,

15、typename from oa_kq_tnjc where userid=+ resourceid+ and kqdate=+ carddate+ and xtype=1);if (RecordSet2.next() String type = Util.null2String(RecordSet2.getString(type); typename = Util.null2String(RecordSet2.getString(typename);String mark = Util.null2String(rs.getString(mark);if (0.equals(type) tem

16、ptypename = 上午; else if (1.equals(type) temptypename = 下午; else if (2.equals(type) temptypename = 全天; else if (00:00.equals(maxtime) & 00:00.equals(mintime) temptypename = 全天; else if (00:00.equals(maxtime)& !00:00.equals(mintime) temptypename = 下午; else if (!00:00.equals(maxtime)& 00:00.equals(mint

17、ime) temptypename = 上午;if(00:00.equals(maxtime)maxtime = ;if(00:00.equals(mintime)mintime = ;cell = new PdfPCell(new Paragraph(lastname, headFont);/ cell.setBorder(0);cell.setFixedHeight(20);/ cell.setColspan(7);/ 设置合并单元格的列数cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示/ cell.setVert

18、icalAlignment(Element.ALIGN_MIDDLE);table.addCell(cell);cell = new PdfPCell(new Paragraph(deptname, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);cell = new PdfPCell(new Paragraph(carddate, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置

19、内容水平居中显示table.addCell(cell);cell = new PdfPCell(new Paragraph(maxtime, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);cell = new PdfPCell(new Paragraph(mintime, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);ce

20、ll = new PdfPCell(new Paragraph(temptypename, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);cell = new PdfPCell(new Paragraph(typename, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);/B类人员rs.execute(sql2);whil

21、e (rs.next() String resourceid = Util.null2String(rs.getString(resourceid);String lastname = ResourceComInfo.getLastname(resourceid);String deptname = DepartmentComInfo.getDepartmentname(ResourceComInfo.getDepartmentID(resourceid);String carddate = Util.null2String(rs.getString(carddate);String maxt

22、ime = Util.null2String(rs.getString(maxtime);String mintime = Util.null2String(rs.getString(mintime);String mark = Util.null2String(rs.getString(mark);String temptypename = ;String typename=;if (.equals(maxtime) maxtime = 00:00;if (.equals(mintime) mintime = 00:00;long timelen = KqDateTimeUtil.timeI

23、nterval(carddate + + mintime + :00, carddate + + maxtime + :00);if (timelen 530) RecordSet2.execute(select type,xtypename,mark,typename from oa_kq_tnjc where userid=+ resourceid+ and kqdate=+ carddate+ and xtype=1);if (RecordSet2.next() String type = Util.null2String(RecordSet2.getString(type);typen

24、ame = Util.null2String(RecordSet2.getString(typename);if (0.equals(type) temptypename = 上午; else if (1.equals(type) temptypename = 下午; else if (2.equals(type) temptypename = 全天; else if (00:00.equals(maxtime) & 00:00.equals(mintime) temptypename = 全天; else if (00:00.equals(maxtime)& !00:00.equals(mi

25、ntime) temptypename = 下午; else if (!00:00.equals(maxtime)& 00:00.equals(mintime) temptypename = 上午;if(00:00.equals(maxtime)maxtime = ;if(00:00.equals(mintime)mintime = ;cell = new PdfPCell(new Paragraph(lastname, headFont);/ cell.setBorder(0);cell.setFixedHeight(20);/ cell.setColspan(7);/ 设置合并单元格的列数

26、cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示/ cell.setVerticalAlignment(Element.ALIGN_MIDDLE);table.addCell(cell);cell = new PdfPCell(new Paragraph(deptname, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);cell = new PdfPCell(new Paragraph(carddate, headFont);cell.setHorizontalAlignment(Element.ALIGN_CENTER);/ 设置内容水平居中显示table.addCell(cell);cell = new PdfPCell(new Paragr