Jasper Reports(Reports in Java)for Java Developers in netbeans

Embedding SQL Queries into a Report Template save as customerReport1.jrxml

(put into src/reports directories)

(Please send your feedback)

Add libraries files in Net-beans

• jasperreports-3.1.3.jar
• commons-beanutils-1.7.jar
• commons-collections-2.1v
• commons-digester-1.7.jar

Finally run this program

JasperView.java

/*

* To change this template, choose Tools | Templates

* and open the template in the editor.

*/

/**

*

* @author Gowthaman

*/

import java.io.FileNotFoundException;

import java.io.IOException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.HashMap;

import net.sf.jasperreports.engine.JRException;

import net.sf.jasperreports.engine.JasperCompileManager;

import net.sf.jasperreports.engine.JasperExportManager;

import net.sf.jasperreports.engine.JasperFillManager;

import net.sf.jasperreports.engine.JasperPrint;

import net.sf.jasperreports.engine.JasperReport;

import net.sf.jasperreports.view.JasperViewer;

public class JasperView {

Connection connection;

public void generateReport() throws FileNotFoundException, IOException

{

try

{

Class.forName("com.mysql.jdbc.Driver");

connection = DriverManager.getConnection ("Jdbc:mysql://localhost/samples", "root", "password");

System.out.println("Connected to the database");

System.out.println("Filling reports...");

JasperReport jasperReport;

JasperPrint jasperPrint;

jasperReport=JasperCompileManager.compileReport("src/reports/customerReport1.jrxml");

jasperPrint = JasperFillManager.fillReport(jasperReport, new HashMap(),connection);

JasperExportManager.exportReportToPdfFile(jasperPrint, "src/reports/ProvaReport.pdf");

//automatically will created if you want PDF add library itext.jar

String reportDest = "src/reports/report.html";//automatically will created

JasperViewer jv = new JasperViewer(jasperPrint);

jv.setVisible(true);

JasperExportManager.exportReportToHtmlFile(jasperPrint, reportDest);

System.out.println("Done!Html and PDF");

connection.close();

}

catch (JRException e)

{

e.printStackTrace();

System.out.println("Jasper Exception:"+e.getMessage());

System.out.println("Jasper Exception:"+e.getStackTrace());

System.out.println("Jasper Exception:"+e.getLocalizedMessage());

}

catch (ClassNotFoundException e)

{

e.printStackTrace();

}

catch (SQLException e)

{

e.printStackTrace();

}

catch(Exception e)

{

System.out.println("There is exception here"+ e);

}

}

public static void main(String[] args) throws FileNotFoundException, IOException

{

new JasperView().generateReport();

}

}

Database Table

create table employee(

firstname varchar(40),

lastname varchar(40)

)