jasper with jsp

Anand Karia

Ranch Hand

Posts: 158

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Dear All

First of all i would like to inform that I am new to jsp.

I have code jsp with database and jasper report. It shows very well with my server.
But when i am connecting through my client computer it shows the html file only and report is generated at server.

I do not know where i made mistake. Can any body help me out.

<%-- 
    Document   : k2m
    Created on : Mar 3, 2010, 10:40:24 AM
    Author     : root

--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page session="false"%>
<%@page import= "java.io.*,java.text.*,java.util.*,java.sql.*,java.io.*;"%>
<%!    private static final DecimalFormat PMT = new DecimalFormat("#0.00");
    public Connection Conn;
    public String _Path = "";
    public Statement stmt;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Fuel Efficiency Conversion Chart</title>
    </head>
    <body>
        <h1>Database Connection</h1>
        The Current Time is <%= new java.util.Date()%>
        <table border="1"  >
            <%
            Class.forName("org.postgresql.Driver");
            String url = "jdbc:postgresql://localhost:5432/barcode";
            System.out.println(url);
            Conn = DriverManager.getConnection(url,"postgres","20051130");
            %>
            <tr>
                <td><%= Conn%> </td>
                <td><%= System.getProperty("user.dir") %> </td>
            </tr>
            
            
        </table>
        <table border="0" >
            <tr>
                <th> Degrees <BR>Fahrenheit </th>
                <th> Degrees <BR>Celsius </th>
            </tr>
            <%
            Statement st_fs = Conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
            java.util.Map parameters = new java.util.HashMap();
            String sql = "";
            sql = "select * from tmp_barcode ";
            ResultSet rs_fs = st_fs.executeQuery(sql);
            String sPrintSource = "Preview";
            net.sf.jasperreports.engine.JRResultSetDataSource jrs = new net.sf.jasperreports.engine.JRResultSetDataSource(rs_fs);
            net.sf.jasperreports.engine.JasperReport aReport = null ;
            aReport = net.sf.jasperreports.engine.JasperManager.compileReport("/u/web_agi/web/b_barcode.jrxml");
            
            if(sPrintSource.equals("Preview")) {
                net.sf.jasperreports.engine.JasperPrint jasperPrint = net.sf.jasperreports.engine.JasperFillManager.fillReport(aReport, parameters, jrs);
                net.sf.jasperreports.view.JasperViewer vv = new net.sf.jasperreports.view.JasperViewer(jasperPrint);
                vv.viewReport(jasperPrint,false);
            
            }
            else if(sPrintSource.equals("Direct_Print")){
                net.sf.jasperreports.engine.JasperPrint jasperPrint = net.sf.jasperreports.engine.JasperManager.fillReport(aReport , parameters, jrs );
                net.sf.jasperreports.engine.JasperManager.printReport(jasperPrint, true);

}
            else if(sPrintSource.equals("PDF")){
                net.sf.jasperreports.engine.JasperPrint aPrint = net.sf.jasperreports.engine.JasperManager.fillReport(aReport , parameters, jrs );
                javax.swing.JFileChooser fc = new javax.swing.JFileChooser(new File("/root/a.pdf"));
                //fc.showOpenDialog(this);
                fc.showSaveDialog(fc.getParent());
                File selFile = fc.getSelectedFile();
                String str = String.valueOf(selFile.getAbsoluteFile());
                net.sf.jasperreports.engine.JasperManager.printReportToPdfFile(aPrint,str);
            }
            
            %>

</table>
    </body>
</html>

Love is GOD and GOD is Love.
Anand Karia
IT Concretor.......
M/s. Anand Karia Concreting IT

David Newton

Author

Posts: 12617

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Well, you're creating a file on the server--it won't be magically downloaded. You need to stream it to the client.

Before going much further, please consider writing the Java code in a Java file--*not* in a JSP. This is an outdated practice and not even very suitable for quick testing; it's just not worth it.

Anand Karia

Ranch Hand

Posts: 158

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

David Newton

I would appreciate if you could guide me a bit in code means how and where to write it.
I wrote following lines but it shows error to me.
java.io.OutputStream outputStream = response.getOutputStream() ;
JasperExportManager.exportReportToPdfStream(jasperPrint, outputStream);

Love is GOD and GOD is Love.
Anand Karia
IT Concretor.......
M/s. Anand Karia Concreting IT

David Newton

Author

Posts: 12617

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Please see ItDoesntWorkIsUseless and TellTheDetails. Saying "it shows error to me" gives me zero information that can be used to diagnose the problem.

Although I'd bet it's a illegal state when you try to get the output stream.

Lasagna is spaghetti flvored cake. Just like this tiny ad:

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders