Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JasperReports+JSP+MySQL

843836May 31 2005 — edited Feb 8 2007
i'm new in jasperreports. i hav downloaded several examples. but i dunno how to run the java program for it to compile the jrxml to jasper extension. how do i call it to compile?

import java.sql.Connection;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

import net.sf.jasperreports.engine.*;
//import net.sf.jasperreports.engine.xml.*;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import net.sf.jasperreports.engine.design.*;
import net.sf.jasperreports.view.*;
import database.*;
//import database.database.*;

/*
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.view.JasperViewer;
import database.Database;
//String classpath = (String)request.getSession().getServletContext().getAttribute("org.apache.catal ina.jsp_classpath");
//System.setProperty("jasper.reports.compile.class.path", classpath);
*/


public class CIS {


public static void main(String[] args) {
// load JasperDesign from XML and compile it into JasperReport
try {
JasperDesign jasperDesign = JRXmlLoader.load("CIS.xml");
JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);


// create a map of parameters to pass to the report.

Map parameters = new HashMap();
parameters.put("Title", "Customer Information");


// get a database connection

Connection conn = Database.getConnection();


// create JasperPrint using fillReport() method

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, conn);


// You can use JasperPrint to create PDF

JasperExportManager.exportReportToPdfFile(jasperPrint, "CIS.pdf");

// Or to view report in the JasperViewer

JasperViewer.viewReport(jasperPrint);


} catch (JRException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}

how do i run this file?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2007
Added on May 31 2005
14 comments
632 views