Help on Ireport to pdf

Greenhorn

Posts: 26

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi to all Forumers,

I'm still quite new in programming and now i'm trying to create a report using Ireport and to output it in pdf, but when i try to run it the report never showed up only blank page, maybe anybody here with kind soul that can help me out on this or maybe give me some ideas on this, here is my simple jsp code and servlet

this is my jsp

here is my servlet

package pack;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.util.HashMap;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.jasperreports.engine.*;

/**
 *
 * @author roy-g.ramos
 */
public class bcode extends HttpServlet{
    
    public void doPost (HttpServletRequest req, HttpServletResponse res)
            throws ServletException, IOException {
        {
        } 
        
        PrintWriter out = res.getWriter();
        String dbdriver = "net.sourceforge.jtds.jdbc.Driver";
        String url = "jdbc:jtds:sqlserver://server/db";
        String filename = "report1.jasper";
        String emp_filter = req.getParameter("enos");
        HashMap hm = new HashMap();
        hm.put("emp_filter", emp_filter);
        Connection con = null;
        
        
        try {
            Class.forName(dbdriver);
            con= java.sql.DriverManager.getConnection(url, "uid", "password");
            JasperPrint print = JasperFillManager.fillReport(getServletContext().getRealPath("/")+ filename, hm, con);
            byte[] pdfasbytes = JasperExportManager.exportReportToPdf(print);
            ServletOutputStream sos = res.getOutputStream();
            res.setContentType("application/pdf");
            res.setContentLength(pdfasbytes.length);
            res.setHeader("Content-disposition", "inline; filename=\"Report.pdf\"");
            sos.write(pdfasbytes);
            
            
            
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        finally {
            try {
            con.close();
            }
            catch (Exception sqle){
                sqle.printStackTrace();
            }
        }
        
    
    }
    
    
}

thank you very much

-roy

roy ramos

Greenhorn

Posts: 26

posted 13 years ago