Aplicação de relatório iReport no Netbeans

package laboratorioac;

import java.sql.Connection;
import java.sql.DriverManager;

/**
 *
 * @author Elcio
 */
public class ConexaoOracle {

    private static class e {

        private static void printStackTrace() {
            throw new UnsupportedOperationException("Not yet implemented");
        }

        public e() {
        }
    }
    //private String driver;

    public Connection getConnection(){

        try{
           //Class.forName(driver);
           String driver = "oracle.jdbc.driver.OracleDriver)";
           String url = "jdbc:oracle:thin:@127.0.0.1:1521:xe";
           Connection con = DriverManager.getConnection(driver, "igm", "igm");
           return con;
        } catch (Exception e) {
            e.printStackTrace();
        } return null;
        
    }
}

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * Mapatrab.java
 *
 * Created on 30/09/2011, 20:39:44
 */

package laboratorioac;

import java.sql.Connection;
import java.util.Map;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.view.JasperViewer;

/**
 *
 * @author Elcio
 */
public class Mapatrab extends javax.swing.JFrame {

    private JasperViewer JasperViewer(JasperPrint jp) {
        throw new UnsupportedOperationException("Not yet implemented");
    }

    private static class Hashmap {

        public Hashmap() {
        }
    }

    /** Creates new form Mapatrab */
    public Mapatrab() {
        initComponents();
    }

private void visualisarActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:
        try{
            Connection con = new ConexaoOracle().getConnection();
            Hashmap parametros = new Hashmap();
            JasperPrint jp = JasperFillManager.fillReport("./jasper/Mapatrab.jasper", (Map) parametros, con);
            JasperViewer jrv = JasperViewer (jp);
            jrv.setVisible(true);
        }
        catch (Exception e) {
            e.printStackTrace();
        }
}                                          

    private void pdfActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        try{
            Connection con = new ConexaoOracle().getConnection();
            Hashmap parametros = new Hashmap();
            JasperPrint jp = JasperFillManager.fillReport("./jasper/Mapatrab.jasper", (Map) parametros, con);
            JasperExportManager.exportReportToPdfFile(jp, "./Mapatrab.pdf");

        }
        catch (Exception e) {
            e.printStackTrace();
        }
    }

    private void htmlActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        try{
            Connection con = new ConexaoOracle().getConnection();
            Hashmap parametros = new Hashmap();
            JasperPrint jp = JasperFillManager.fillReport("./jasper/Mapatrab.jasper", (Map) parametros, con);
            JasperExportManager.exportReportToHtmlFile(jp, "./Mapatrab.pdf");

        }
        catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new Mapatrab().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify
    private javax.swing.JButton html;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JButton pdf;
    private javax.swing.JButton visualisar;
    // End of variables declaration

}
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * Mapatrab.java
 *
 * Created on 30/09/2011, 20:39:44
 */

package laboratorioac;

import java.sql.Connection;
import java.util.Map;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.view.JasperViewer;

/**
 *
 * @author Elcio
 */
public class Mapatrab extends javax.swing.JFrame {

    private JasperViewer JasperViewer(JasperPrint jp) {
        throw new UnsupportedOperationException("Not yet implemented");
    }

    private static class Hashmap {

        public Hashmap() {
        }
    }

    /** Creates new form Mapatrab */
    public Mapatrab() {
        initComponents();
    }

private void visualisarActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:
        try{
            Connection con = new ConexaoOracle().getConnection();
            Hashmap parametros = new Hashmap();
            JasperPrint jp = JasperFillManager.fillReport("./jasper/Mapatrab.jasper", (Map) parametros, con);
            JasperViewer jrv = JasperViewer (jp);
            jrv.setVisible(true);
        }
        catch (Exception e) {
            e.printStackTrace();
        }
}                                          

    private void pdfActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        try{
            Connection con = new ConexaoOracle().getConnection();
            Hashmap parametros = new Hashmap();
            JasperPrint jp = JasperFillManager.fillReport("./jasper/Mapatrab.jasper", (Map) parametros, con);
            JasperExportManager.exportReportToPdfFile(jp, "./Mapatrab.pdf");

        }
        catch (Exception e) {
            e.printStackTrace();
        }
    }

    private void htmlActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        try{
            Connection con = new ConexaoOracle().getConnection();
            Hashmap parametros = new Hashmap();
            JasperPrint jp = JasperFillManager.fillReport("./jasper/Mapatrab.jasper", (Map) parametros, con);
            JasperExportManager.exportReportToHtmlFile(jp, "./Mapatrab.pdf");

        }
        catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new Mapatrab().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify
    private javax.swing.JButton html;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JButton pdf;
    private javax.swing.JButton visualisar;
    // End of variables declaration

}

import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import javax.swing.*;

public class Facade
{
 
    String driver = "oracle.jdbc.driver.OracleDriver";
    String url = "jdbc:oracle:thin:@127.0.0.1:1521:xe";
    private static String usuario = "igm";
    private static String senha = "igm";
    private static Statement statement;
    public static ResultSet resultset;
    private Connection con;
    private static Facade instance;

    public static Facade getInstance() {
        if (instance == null) {
            instance = new Facade();
        }
        return instance;
    }

    public Connection conexao()
    {
        con = null;
        try
        {
            Class.forName(driver);
            con = DriverManager.getConnection(url, usuario, senha);
        }
        catch(ClassNotFoundException Driver)
        {
           JOptionPane.showMessageDialog(null, "Facade - Driver não localizado: "+Driver);
           System.exit(0);
        }
        catch(SQLException Fonte)
        {
            JOptionPane.showMessageDialog(null,"Facade - Erro na conexão com a fonte de dados: "+Fonte);
            System.exit(0);
        }
        System.out.println("Conexao realizada com exito.");
        return con;

    }

    public int desconecta()
    {
        try
        {
            con.close();
            return(0);
        }
        catch(SQLException fecha)
        {
            JOptionPane.showMessageDialog(null, "Facade - Não foi possível "+"fechar o banco de dados: "+fecha);
            return(1);
        }
    }

    public int executeSQL (String sql)
    {
        System.out.println("Facade sql = "+sql);
        try
        {
            statement = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
            resultset = statement.executeQuery(sql);
            return(0);
        }
        catch(SQLException sqlex)
        {
            JOptionPane.showMessageDialog(null,"Facade - Não foi possível executar o comando sql, "+sqlex+", o sql passado foi "+sql);
            System.out.println("Facade - Não foi possível executar o comando sql, "+sqlex+", o sql passado foi "+sql);
            return(1);
        }
    }

    public int executeInsert (String sql)
    {
        try
        {
            statement = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            statement.executeUpdate(sql);
            return(0);
        }
        catch(SQLException sqlex)
        {
            JOptionPane.showMessageDialog(null,"Facade - Não foi possível executar o comando sql, "+sqlex+", o sql passado foi "+sql);
            return(1);
        }
    }

    public int executeUpdate (String sql)
    {
        try
        {
            statement = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            statement.executeUpdate(sql);
            return(0);
        }
        catch(SQLException sqlex)
        {
            JOptionPane.showMessageDialog(null,"Facade - Não foi possível executar o comando sql, "+sqlex+", o sql passado foi "+sql);
            return(1);
        }

    }

    Connection getConnection() {
        throw new UnsupportedOperationException("Not yet implemented");
    }

}