Session Attribute from JSP to Servlet PDF Generating

[Lester Carmelotes]

Hi Guys,

I'm trying to create PDF Downloadable file through Servlet. I am trying to pass a user session attribute from JSP to Servlet but it gives me null value.

Here's my code:

package my.report.pck;

import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.servlet.*;
import javax.servlet.http.*;

import com.itextpdf.text.pdf.PdfWriter;
import com.itextpdf.text.Document;
import com.itextpdf.text.DocumentException;
import com.itextpdf.text.Paragraph;


public class BillingAccount extends HttpServlet {

	
	private static final long serialVersionUID = 1L;

	public void init(ServletConfig config) throws ServletException{
		super.init(config);
	}
	
	public void doGet(HttpServletRequest request, 
			HttpServletResponse response) 
			throws ServletException, IOException{
		doPost(request, response);
	}
	
	public void doPost(HttpServletRequest request, 
			HttpServletResponse response) 
			throws ServletException, IOException{
		
		HttpSession session = request.getSession(true);
		String name = (String) session.getAttribute("user");		
		
		
		
		response.setContentType("application/pdf"); // Code 1
		
		
		OutputStream out=response.getOutputStream();
	    try {
	        Document document = new Document();
	        /* Basic PDF Creation inside servlet */
	        PdfWriter.getInstance(document, out);
	        document.open();
	        document.add(new Paragraph("Tutorial to Generate PDF using Servlet"));
	        document.add(new Paragraph("PDF Created Using Servlet, iText Example Works"));
	        
	        try {
								
				Class.forName("com.mysql.jdbc.Driver");
				Connection con = DriverManager.getConnection(
						"jdbc:mysql://localhost:3306/db_wbsb", "root", "");
				
				Statement statement = con.createStatement();
				ResultSet resultset = statement
							.executeQuery("select * from  payment where id = '" + name +"'");
				

				while(resultset.next()){
					
					document.add(new Paragraph("Tuition Fee :" + resultset.getString("balance")));
					
				}
				
	        } catch (Exception e) {						
				((ServletOutputStream) out).println("<b>Error:</b>" + e);
			}
	        
	        document.close();	        
	    }
	            catch (DocumentException exc){
	            throw new IOException(exc.getMessage());
	            }
	    finally {            
	        out.close();
	    }
	}
	
	@Override
	public String getServletInfo() {
	    return "This Servlet Generates PDF Using iText Library";
	}
	
} 

I'm trying to get data from database of specific person through the user.

Any ideas guys?

need help please!

Thanks...

[Paul Clapham]

Lester Carmelotes wrote:I am trying to pass a user session attribute from JSP to Servlet but it gives me null value.

I don't quite understand this... how does your JSP put that attribute into the session? Without knowing that it's impossible to say much (except that apparently it isn't doing that).

Anyway your problem isn't likely to have anything to do with the fact that you plan to generate PDF output. It looks like an ordinary servlet problem to me, so let's move this thread to the Servlets forum.

[Lalit Mehra]

Post the JSP too ...

[James Boswell]

Rather than saying you are getting a null value, does the exception you get tell you where? Might be useful to post the stack trace of any exception received.

[Lester Carmelotes]

Thanks for the reply guys...

Its working now....