PDF repot for struts

[Nitin Belaram]

Hi,

Can anyone please suggest how to generate itext PDf report for struts application.
Any source code example will be great.

Thanks

[roshni sivan]

Hello,

Include itext-1.3.jar in lib folder. I have used iText library for creating PDF reports. Code from my application included. Hope this helps.

   
public class RhpmReportGraphicalBirthRateAction extends org.apache.struts.action.Action {
   --------------------------------------------
   ByteArrayOutputStream report = dao.generatePDFReport(reportingInstId,
	    	    		reportForm.getSelectedFinYear(),stateName,instName);
	    	    
   response.setContentType("application/pdf");
   response.setHeader("content-disposition","inline");
   response.setContentLength(report.size());
   ServletOutputStream servletStream = response.getOutputStream();
   report.writeTo(servletStream);
   servletStream.flush();
   servletStream.close();
   return null;     	    
}

And method generatePDFReport in my DAO is as follows:

   
	public ByteArrayOutputStream generatePDFReport(long institutionId, String finYear, 
	String stateName, String instName) throws Exception{
	    
	    Connection connection = null;
	    PreparedStatement preparedStatement =null;
	    ResultSet resultSet = null;	
	    
	    DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy hh:mm:ss");
	    java.util.Date date = new java.util.Date();
	    
	   
	    PdfContentByte contentByte;
	    ByteArrayOutputStream baosPDF;
	    
	    int dateFontSize = 10;
		int titleFontSize = 18;
		int headingFontSize = 14;
		int subHeadingFontSize = 10;
		
	    try {
	    	connection=DbLocator.getInstance().getConnection("APPLDS");	    	
	    	
		Font f = new Font("Helvetica", Font.BOLD, 10);
	    	
	    		
	    	/*
	    	 * PDF generation using iText library
	    	 */
	    	Document doc = new Document(PageSize.A4, 50, 50, 50, 50);
	    	baosPDF = new ByteArrayOutputStream();
	
	    	try {
		    	PdfWriter docWriter = PdfWriter.getInstance(doc, baosPDF);		    	
		    	doc.addAuthor("Health Services");
		    	doc.addSubject("Report on Child Birth");
		    	doc.addCreationDate();		    	
		    	doc.open();		    	
		    	
		    	Paragraph paragraph = new Paragraph(dateFormat.format(date), new RtfFont("Helvetica", dateFontSize));
		    	paragraph.setAlignment(Paragraph.ALIGN_RIGHT);
		    	doc.add(paragraph);
		    		
		    	paragraph = new Paragraph("HEALTH SERVICES, "+stateName, new RtfFont("Helvetica", titleFontSize, RtfFont.BOLD));
		    	paragraph.setAlignment(Paragraph.ALIGN_CENTER);
		    	doc.add(paragraph);
		    	
		    	paragraph = new Paragraph("\nREPORT ON CHILD BIRTH", new RtfFont("Helvetica", headingFontSize, RtfFont.BOLD));
		    	paragraph.setAlignment(Paragraph.ALIGN_CENTER);
		    	doc.add(paragraph);
		    	
		    	paragraph = new Paragraph("\n" + instName, new RtfFont("Helvetica", subHeadingFontSize, RtfFont.BOLD));
		    	paragraph.setAlignment(Paragraph.ALIGN_CENTER);
		    	doc.add(paragraph);
		    	
		    	
		    }
	    	catch(Exception e){
	    		System.out.println("Error-->generatePDFReport"+e);
		    	throw new Exception(e);
	    	}
	    	doc.close();
	    	
	    	
	    }
	    catch (Exception e){
	    	System.out.println("Error-->generatePDFReport"+e);
	    	throw new Exception(e);
	    }
	    finally{
	    	DbLocator.closeConnection(connection);
	    }
	          
		return baosPDF;
	}

roshni sivan

[Nitin Belaram]

Hi,

Please explain


1: How you are getting values for various report in dao from query resultset
2: How you are getting values in various heading
3: And from dao it is send to Action class.
4: Does your values are display in table

[roshni sivan]

Hello,
In the previously presented code, I am not getting any data from database. In our application, I was using iText library for generating graphical reports where I will be getting data from a postgreSQL database. The following method will be called from an action class.

   
	public ByteArrayOutputStream generatePDFReport(long institutionId, String finYear, 
		String stateName, String instName) throws Exception{
	    
	    Connection connection = null;
	    PreparedStatement preparedStatement =null;
		ResultSet resultSet = null;	
	    
	    DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy hh:mm:ss");
	    java.util.Date date = new java.util.Date();
	    
	   
	    ByteArrayOutputStream baosPDF;
	    
	    int dateFontSize = 10;
		int titleFontSize = 18;
		int headingFontSize = 14;
		int subHeadingFontSize = 10;
		
	    try {
	    	connection=DbLocator.getInstance().getConnection("APPLDS");	    	
	    	
              
               
	    	Font f = new Font("Helvetica", Font.BOLD, 10);
	    	
	    	/*
	    	 * PDF generation using iText library
	    	 */
	    	Document doc = new Document(PageSize.A4, 50, 50, 50, 50);
	    	baosPDF = new ByteArrayOutputStream();
	
	    	try {
		    	PdfWriter docWriter = PdfWriter.getInstance(doc, baosPDF);		    	
		    	doc.addAuthor("Department of Health Services");
		    	doc.addSubject("Graphical Report on Child Birth");
		    	doc.addCreationDate();		    	
		    	doc.open();		    	
		    	
		    	Paragraph paragraph = new Paragraph(dateFormat.format(date), new RtfFont("Helvetica", dateFontSize));
		    	paragraph.setAlignment(Paragraph.ALIGN_RIGHT);
		    	doc.add(paragraph);
		    		
		    	paragraph = new Paragraph("HEALTH SERVICES, "+stateName, new RtfFont("Helvetica", titleFontSize, RtfFont.BOLD));
		    	paragraph.setAlignment(Paragraph.ALIGN_CENTER);
		    	doc.add(paragraph);
		    	
		    	paragraph = new Paragraph("\nREPORT ON CHILD BIRTH", new RtfFont("Helvetica", headingFontSize, RtfFont.BOLD));
		    	paragraph.setAlignment(Paragraph.ALIGN_CENTER);
		    	doc.add(paragraph);
		    	
		    	paragraph = new Paragraph("\n" + instName, new RtfFont("Helvetica", subHeadingFontSize, RtfFont.BOLD));
		    	paragraph.setAlignment(Paragraph.ALIGN_CENTER);
		    	doc.add(paragraph);
		    	
		    	 /*
               I am using a database function for getting data from DB. You may also use an SQL query 
              */		   
	    	preparedStatement = connection.prepareStatement
			("select * from myschema.\"GET_DISEASES\"()");	

			resultSet = preparedStatement.executeQuery();   
		   
	    	while(resultSet.next()){
		/* Adding data from DB to PDF document */		
                     paragraph = new Paragraph("\n Disease.." +resultSet .getString("DISEASE_NAME"), new RtfFont("Helvetica", subHeadingFontSize, RtfFont.BOLD));
		     paragraph.setAlignment(Paragraph.ALIGN_LEFT);
		     doc.add(paragraph);		

                     paragraph = new Paragraph("\n Disease Description.." +resultSet .getString("DESCRIPTION_NAME"), new RtfFont("Helvetica", subHeadingFontSize, RtfFont.BOLD));
		     paragraph.setAlignment(Paragraph.ALIGN_LEFT);
		     doc.add(paragraph);		
				
			}

		    }
	    	catch(Exception e){
	    		System.out.println("Error-->generatePDFReport"+e);
		    	throw new Exception(e);
	    	}
	    	doc.close();
	    	
	    	
	    }
	    catch (Exception e){
	    	System.out.println("Error-->generatePDFReport"+e);
	    	throw new Exception(e);
	    }
	    finally{
	    	DbLocator.closeConnection(connection);
	    }
	          
		return baosPDF;
	}

[Nitin Belaram]

Where does PDf report file is view, Does the output display in PDF file.

What to do if resultset reurturn more then one row.,Then how to dispaly them in table