Generate Report Using Jasper Reports
For Windows users only
Pre-Requisites:
- jdk1.6.0_11
- MySQL Server 5.1
- iReport-2.0.1
- jasperreports-2.0.1.jar
- commons-beanutils-1.7.jar
- commons-collections-2.1.jar
- commons-digester-1.7.jar
- commons-logging-1.0.2.jar
- mysql-connector-java-3.0.11-stable-bin.jar
Jar files required for creating report can be found in iReport installed location
(C:\Program Files\JasperSoft\iReport-2.0.1\lib\).
iReport can be
downloaded
Environment Variables:
Enter Variable name and Variable value which is mentioned below.
Variable name:
JAVA_HOME
Variable value:
C:\Program Files\Java\jdk1.6.0_11
Variable name:
PATH
Variable value:
C:\Program Files\Java\jdk1.6.0_11\bin
Variable name:
CLASSPATH:
Variable value:
.;C:\Program Files\JasperSoft\iReport-2.0.1\lib\jasperreports-2.0.1.jar;
C:\Program Files\JasperSoft\iReport-2.0.1\lib\commons-beanutils-1.7.jar;
C:\Program Files\JasperSoft\iReport-2.0.1\lib\commons-collections-2.1.jar;
C:\Program Files\JasperSoft\iReport-2.0.1\lib\commons-digester-1.7.jar;
C:\Program Files\JasperSoft\iReport-2.0.1\lib\commons-logging-1.0.2.jar;
C:\Program Files\JasperSoft\iReport-2.0.1\lib\mysql-connector-java-3.0.11-stable-bin.jar
Code for jasper report
/**
* FirstJasperReportProgram.java
*/
package com.javaworkspace.jasperreports;
import java.sql.Connection;
import java.sql.DriverManager;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import net.sf.jasperreports.view.JasperViewer;
/**
* @author www.javaworkspace.com
*
*/
public class FirstJasperReportProgram {
public static Connection getConnection() {
Connection jdbcConnection = null;
try {
Class.forName("com.mysql.jdbc.Driver");
jdbcConnection = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/jasperreporttutorial", "root",
"root");
} catch (Exception e) {
e.printStackTrace();
}
return jdbcConnection;
}
/**
* @param reportFile
*/
public static void runReport(String reportFile) {
try {
JasperDesign jasperDesign = JRXmlLoader.load(reportFile);
JasperReport jasperReport = JasperCompileManager
.compileReport(jasperDesign);
Connection jdbcConnection = getConnection();
JasperPrint jasperPrint = JasperFillManager.fillReport(
jasperReport, null, jdbcConnection);
JasperViewer.viewReport(jasperPrint);
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
String reportFile = "src\\reports\\Report1.jrxml";
runReport(reportFile);
}
}