JasperReports+JSP+MySQL
843836May 31 2005 — edited Feb 8 2007i'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?