jsp to pdf

[Aditi agarwal]

hey i am designing some web pages in jsp

now when i input certain information reports are being created from database

now i want those reports to be in pdf format

what should i do

please guide me
thank you

[Swastik Dey]

Probably setting the response type to application/pdf should solve the problem.

[Shashank Ag]

iText is basic api to generate pdf from java.
Now, if you are creating a report from db, I hope you must be using servlet/action etc in between where you can generate this pdf.
Also, which reporting api/tool are you using?

If none, try iReports its free and very easy.

[Deepakkumar Devarajan]

<%
try{
response.setContentType("application/pdf");
response.setHeader("content-disposition","attachment; filename="+"Filename.pdf");
//What ever u write inside this JSP file will be exported as pdf file when you send request and response to this page
%>

Hope this helps, If you need more help ,please let us know.

[Aditi agarwal]

thanks guys for your help

@deepak

where should i include this code & i dnt already have any pdf file i have to show my jsp page report in pdf format

please help me

thank you

[Aditi agarwal]

hey when i give this code then i got an error opening the document

file doesnot begin with %pdf

[Swastik Dey]

Aditi,

As suggested by Shashank, you have to first convert the data into pdf format, then only setting the response type will work.

[Deepakkumar Devarajan]

Aditi agarwal wrote:hey when i give this code then i got an error opening the document

file doesnot begin with %pdf

Can you please post what you have tried?

[Deepakkumar Devarajan]

Swastik Dey wrote:Aditi,

As suggested by Shashank, you have to first convert the data into pdf format, then only setting the response type will work.

I tried exporting data as a PDF file from jsp, it worked perfectly for me(I did not use iText, heard about it. Hope while using iText, conevrsion is must but when you set ContentType as PDF in JSP, it automatically take care of the conversion of data. Will learn iText in the coming days.

[Aditi agarwal]

Sory bear for using java class code in jsp

hey thanks both of you for replying

i am giving same as you have written deepak

<%
 String d=(String)application.getAttribute("div"); 
String y= (String)application.getAttribute("year");
String m =(String) application.getAttribute("month1"); 
%>
<%
Connection con=new database().getConnection();
try
{
response.setContentType("application/pdf");   
response.setHeader("content-disposition","attachment; filename="+"monthwise.pdf");   
String m1=null;
ResultSet rs=null;
Statement st=null;
st=con.createStatement();
rs=st.executeQuery("select * from ams_month where month_no="+m+";");
while(rs.next())
{
m1=rs.getString(3);
}
 %>
<center>
  <b></b><font size="4" face="Georgia, Arial" color="maroon">O&M Activity Monitoring system
   <br/>Status Report on Details of Live Files for the Division - <%=d %>   <br/>
  NIC- Ministry of Petroleum & Natural Gas<br/>  
 Files opened in<%=m1 %><%=y %> </font>  <br/><br/>  <br/><br/>
  </center>

   <%
  ResultSet rs1=null;
  Statement st1=null;
  st1=con.createStatement(); 
  ResultSet rs2=null;
  Statement st2=null;
  st2=con.createStatement();   
   %> 

@swastik i cannt understand how to do that

thank you

[Swastik Dey]

@Deepakkumar

Your case is slightly different, you already have a pdf file and that is being rendered as pdf. But Aditi's case is different, she is first getting data from underlying database table. So as per my understanding that has to be first converted to a pdf format and then only that can be rendered as pdf.

Aditi

Your code as this line

response.setHeader("content-disposition","attachment; filename="+"monthwise.pdf");

So if you render this file to the user with the content type pdf, you should get the correct output. But I don't think that is the case. Probably what you have to do is get the data from table, convert it to pdf using the suggested libraries. Then render that pdf to the user with content type application/pdf.

[Deepakkumar Devarajan]

@Swastik Thanks for the explanation, I understood, why i did not get the error, I tried to export a html table and it did not work, :-). I am looking at iText examples.. As of now i assume that API is converting the data automatically as i do not see any code for conversion. Correct me if i am wrong..

Aditi

The link is for you, hope it will help.

java]http://www.coderanch.com/how-to/java/ItextExample

[Aditi agarwal]

thanks for the reply @swastik & @deepak

but still it cannot include

com.itextpdf.text.*,com.itextpdf.text.pdf.*

files
what could be the problem

[Deepakkumar Devarajan]

You have not add the Itext jar path to your class path.

[Aditi agarwal]

@deepak thanks for your reply

i have already added itext-1.3.1 .jar but still its giving error if you have any link for itext then please post it so that i can download it from new link

if any other problem is there then please let me know

thank you

[Swastik Dey]

Try from here

http://sourceforge.net/projects/itext/files/iText/iText5.0.6/iText-5.0.6.jar/download

[Aditi agarwal]

@swastik thanks for reply but that link is not working

[Swastik Dey]

Its working for me even now. I just tested it. It opens and pop ups a window to save the jar file. If you wish I can send the file.

[Deepakkumar Devarajan]

That link works, May be your browser blocks you downloading the file. If so,just click the message that gets displayed at the top of the page and select download file.

[Aditi agarwal]

@swastik then please send me that file bcause i need that if still it will make any error then i can discuss it here only

thank you

[Aditi agarwal]

Sorry to disappoint you both guys but still same error is coming

that is

there was an error opening this documentfile doesnot begin with %PDF

[Swastik Dey]

So, the import issue is resolved. Could you please show your code?

[Aditi agarwal]

sure this is my code

<%@ page language="java" pageEncoding="ISO-8859-1"%>
<%@page import="java.io.*,java.sql.* ,ams.database.*,javax.servlet.http.*,javax.servlet.*,java.text.SimpleDateFormat,java.text.DateFormat,com.itextpdf.text.*,com.itextpdf.text.pdf.*,java.io.*,java.util.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
      <title>files.jsp</title>
<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
	
	</head>
	<body style="background-color:#FFFFCC;">
  
<%
 String d=(String)application.getAttribute("div"); 
String y= (String)application.getAttribute("year");
String m =(String) application.getAttribute("month1"); 
%>
<%
Connection con=new database().getConnection();
try
{
response.setContentType("application/pdf");   
response.setHeader("content-disposition","attachment; filename="+"monthwise.pdf");   
String m1=null;
ResultSet rs=null;
Statement st=null;
st=con.createStatement();
rs=st.executeQuery("select * from ams_month where month_no="+m+";");
while(rs.next())
{
m1=rs.getString(3);
}
 %>
<center>
  <b></b><font size="4" face="Georgia, Arial" color="maroon">O&M Activity Monitoring system
   <br/>Status Report on Details of Live Files for the Division - <%=d %>   <br/>
  NIC- Ministry of Petroleum & Natural Gas<br/>  
 Files opened in<%=m1 %><%=y %> </font>  <br/><br/>  <br/><br/>
  </center>

   <%
  ResultSet rs1=null;
  Statement st1=null;
  st1=con.createStatement(); 
  ResultSet rs2=null;
  Statement st2=null;
  st2=con.createStatement();   
   %> 
   <center>
  <table border="1" bordercolor="black" cellpadding="3" cellspacing="5">
  <tr>
  <th><font size="3" color="blue">In Section</font></th>
  <th><font size="3" color="blue"> File No.(Computer File No.)</font></th>
   <th><font size="3" color="blue"> Subject</font></th>
  <th><font size="3" color="blue"> Opened Date</font></th>
  </tr>
  <%
 //response.setContentType("application/pdf");
 String FILE = "c:/temp/FirstPdf.pdf";
 Document document = new Document();
 PdfWriter.getInstance(document, new FileOutputStream(FILE));
  document.open();
  String name=null;
int yr =Integer.parseInt(y);  
  rs1=st1.executeQuery("select sec_name from divsec where div_code=(select divcode from ams_division where divname=\'"+d.trim()+"\');");
while(rs1.next())
{
name=rs1.getString("sec_name");
  rs=st.executeQuery("select * from file_reg where ((sec_code= (select sec_code from sec_code where sec_name=\'"+name.trim()+"\')) and (ep_flg='P')AND ((EXTRACT(month FROM open_dt))="+m+")AND ((EXTRACT(year FROM open_dt))="+yr+"))order by sec_code asc;");
  StringBuilder sb=new StringBuilder();
  while(rs.next())
  {
  DateFormat dtFormat = new SimpleDateFormat("dd/MM/yyyy");   
String formattedDate=dtFormat.format(rs.getDate("open_dt"));  
 %>
  <tr>
  <td><%=name %></td>
  <td><%=rs.getString(1) %>(<%=rs.getInt(10) %>)</td>
  <td><%=rs.getString(2) %></td>
  <td><%=formattedDate %></td>
  </tr>
  
  <%}}
  document.close();
  response.setContentType("application/pdf");
    response.setHeader("content-disposition","attachment;filename="+"FirstPdf.pdf");
    byte[] buf = new byte[8192]; 
    FileInputStream in = new FileInputStream(FILE);
    OutputStream out1 = response.getOutputStream();
     int c;  
     while ((c = in.read(buf, 0, buf.length)) > 0) {  
       out1.write(buf, 0, c);  
     }  
     out1.flush();  
   out1.close();
  }
  catch(Exception e)
  {
    }
  finally {
		      // Always close the database connection.
		      try {
		    	    if (con != null) 
		    	    	con.close();
		      }
		      catch (SQLException ignored){
		       
		    	  System.out.println(ignored);
		      }
		    }
   %>

  </table>
  
  <br/><br/>
  <input class=button type="button" value="Print" name="pr" title="Print" onClick="window.print();">
  </center>

  
  </body>
  </html>  

[Swastik Dey]

Comment/Remove the following two lines

response.setContentType("application/pdf");     
response.setHeader("content-disposition","attachment; filename="+"monthwise.pdf");

And make sure in c:\ (c root) you have a folder called temp, because the code

String FILE = "c:/temp/FirstPdf.pdf";

is create the file FirstPdf.pdf under temp folder which is under c:\.

[Aditi agarwal]

problem is solved to some extent but still hard luck

actually i need that link as soon as clicked it should open file in pdf format not jsp as it is doing now

& the firstPdf.pdf which is gettings aved in temp when clicked shows

"there was an error opening this document sharing violation"



thank you

[Swastik Dey]

Do you mean that at first it displays a jsp/html with the tabular data, and when the button is clicked it displays the same data in pdf format? If that is the case, you probably need two codes. First one displays the html/jsp page with the button. When button is clicked send to request to server which again invokes a jsp/servlet the generate the pdf contents.

[Aditi agarwal]

yes you are right partially its now opening tabl ein jsp firstly & when i click my pdf file in temp folder in C then it gives th error

Its in the sense still no oopening pdf aqutomatically

thank you

[Swastik Dey]

As far as I know sharing violation is a os level issue, as you are trying to open the file manually. Just stop tomcat or whatever server you are using and see if it opens.

[Aditi agarwal]

thanks swastik its now not showing violation error but showing file load error

[Swastik Dey]

Aditi

Your code is not writing anything to the pdf file, that might be a probable reason. Just after opening the document, write something to the file

document.open();
document.add(new Paragraph("hello"));

It would be also good, if you declare the document object before starting try block and close it in finally block.