This code is working too
In this application I am first take data from a table studentdetails and then printing its value to pdf.
Description of table
table name: studentdetails
column name:
FatherName, Emailid, firstlanguage, lastschoolname, mothername, nationality, religion, secondlanguage, sex, stream, studentid, date of birth, sname
"Please add the attach .jar file in your lib file manually
My action class
package com.test.pdf;
import java.io.IOException;
import javax.portlet.PortletException;
import javax.portlet.PortletSession;
import javax.portlet.ResourceRequest;
import javax.portlet.ResourceResponse;
import pdf.ashraf.userdata.model.studentDetails;
import pdf.ashraf.userdata.service.studentDetailsLocalServiceUtil;
import com.lowagie.text.Anchor;
import com.lowagie.text.DocumentException;
import com.lowagie.text.Font;
import com.lowagie.text.FontFactory;
import com.lowagie.text.PageSize;
import com.lowagie.text.Paragraph;
import com.lowagie.text.Phrase;
import com.lowagie.text.Rectangle;
import com.lowagie.text.pdf.CMYKColor;
import com.lowagie.text.pdf.PdfPCell;
import com.lowagie.text.pdf.PdfPTable;
import com.lowagie.text.pdf.PdfWriter;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileWriter;
import java.io.IOException;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.io.StringReader;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import com.liferay.portal.kernel.exception.PortalException;
import com.liferay.portal.kernel.exception.SystemException;
import com.liferay.portal.kernel.servlet.HttpHeaders;
import com.liferay.portal.kernel.util.Base64;
import com.liferay.portal.kernel.util.StringPool;
import com.liferay.util.bridges.mvc.MVCPortlet;
public class PdfAsfrafPortlet extends MVCPortlet
{
public void serveResource(ResourceRequest request, ResourceResponse response)
throws PortletException, IOException
{
try
{
createPDF(request,response);
}
catch (SystemException e)
{
e.printStackTrace();
}
}
public void createPDF(ResourceRequest resourceRequest, ResourceResponse resourceResponse)
throws IOException, PortletException, SystemException
{
try
{
resourceRequest.setCharacterEncoding(StringPool.UTF8);
com.lowagie.text.Document document = new com.lowagie.text.Document(); //blank pdf created
ByteArrayOutputStream baos = new ByteArrayOutputStream();
PdfWriter.getInstance(document, baos); //predefine class PdfWriter calls static method getInstance
document.open(); //open pdf in write method
PdfPTable table= new PdfPTable(13); //creating a pdf table having single column hence PdfPTable table= new PdfPTable(1);
table.setWidthPercentage(100); //setting width size //to design cell
table.addCell("FatherName"); //adding value in row. here number of rows is depends on the number of table.addcell();
table.addCell("Emailid");
table.addCell("firstlanguage");
table.addCell("lastschoolname");
table.addCell("mothername"); //adding value in row
table.addCell("nationality");
table.addCell("religion");
table.addCell("secondlanguage");
table.addCell("gender");
table.addCell("stream");
table.addCell("studentid");
table.addCell("date of birth");
table.addCell("sname");
List<studentdetails> tbl=null;
tbl=studentDetailsLocalServiceUtil.findWholeTbl(); //to fetch whole table
if(tbl!=null)
{
System.out.println("tbl size: "+tbl.size());
Iterator<studentdetails> it=tbl.iterator();
while(it.hasNext())
{
studentDetails obj=it.next();
table.addCell(obj.getFatherName());
table.addCell(obj.getEmailId());
table.addCell(obj.getFirstLanguage());
table.addCell(obj.getLastSchoolName());
table.addCell(obj.getMotherName());
table.addCell(obj.getNationality());
table.addCell(obj.getReligion());
table.addCell(obj.getSecondLanguage());
table.addCell(obj.getSex());
table.addCell(obj.getStream());
long l=obj.getStudentId();
String sl=String.valueOf(l);
table.addCell(sl);
String sd=String.valueOf(obj.getDateOfBirth());
table.addCell(sd);
table.addCell(obj.getSName());
}//while
}//if
document.add(table); //adding table to created pdf document
document.close(); //we have to first close the document
String fileName="attachment;filename=ashraf.pdf"; //filename
resourceResponse.setContentType("application/pdf"); //setting the content type either application or pdf(Portable Document Format)
resourceResponse.addProperty(HttpHeaders.CONTENT_DISPOSITION, fileName); //
OutputStream out = resourceResponse.getPortletOutputStream();
byte[] downloadBytes = Base64.decode((String) resourceRequest.getAttribute("fileToDownloadBase64"));
out.write(downloadBytes);
baos.writeTo(out);
out.flush();
out.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}//createPdf
}//end of class
</studentdetails></studentdetails>
and my view.jsp
<%@ taglib uri="http://java.sun.com/portlet_2_0" prefix="portlet" %>
<portlet:defineobjects />
This is the <b>Pdf Asfraf Portlet</b> portlet in View mode.
<portlet:resourceurl var="submitFormDetailsResourceURL" id="appform" escapeXml="false" />
<br><br><br>
<form action="<%=submitFormDetailsResourceURL.toString() %>" method="post">
<h2>This project working fine</h2>
</form>Here I am retreiving data from table asif_studentDetails and then just publish that data in pdf format
<input type="submit" value="Download" name="submitbutton">
