netBeans 6.1 e iReport

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

package appcadastro;

/**
 *
 * @author Wibson
 */

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.io.*;
import java.sql.*;
import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.view.*;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;
import net.sf.jasperreports.engine.export.JRPdfExporter;


public class AppCadastro extends Frame implements ActionListener
{
    TextField nome = new TextField(71);
    TextField descricao = new TextField(68);
    Button salvar = new Button("Salvar");
    Button limpar = new Button("Limpar");
    Button report = new Button("Relatório");
    Button sair = new Button("Sair");
    Panel geral;
    Curso c = new Curso();
    Label result = new Label();
    
    public AppCadastro()
    {
        super("Aplicação de cadastro");
        setSize(800, 285);
        setLocation(200, 100);
        EvtJanela evt = new EvtJanela();
        addWindowListener(evt);
        MenuBar barraMenu = new MenuBar();
        Menu menuArquivo = new Menu("Arquivo");
        MenuItem itemCadastro = new MenuItem("Novo Curso");
        MenuItem itemSair = new MenuItem("Sair", new MenuShortcut(KeyEvent.VK_R));
        menuArquivo.add(itemCadastro);
        menuArquivo.add(itemSair);
        barraMenu.add(menuArquivo);
        setMenuBar(barraMenu);
        itemCadastro.addActionListener(this);
        itemSair.addActionListener(this);
        Panel painelApp = new Panel();
        Panel painelCadastro = new Panel();
        painelApp.setBackground(SystemColor.control);
        painelCadastro.setBackground(SystemColor.control);
        geral = new Panel();
        geral.add(painelApp,"J1");
        geral.add(painelCadastro,"J2");
        geral.setLayout(new CardLayout());
        add("Center", geral);
        painelCadastro.setLayout(new FlowLayout());
        painelCadastro.add(new Label("Nome:"));
        painelCadastro.add(nome);
        painelCadastro.add(new Label("Descrição:"));
        painelCadastro.add(descricao);
        String[] colunas = {"NOME", "DESCRIÇÃO"};
        Object[][] conteudo = {{"", ""}};
        JTable tabela =  new JTable(conteudo, colunas);
        tabela.setPreferredScrollableViewportSize(new Dimension(560, 120));
        painelCadastro.add(new JScrollPane(tabela));
        Panel painelButton = new Panel();
        painelButton.add(salvar);
        painelButton.add(limpar);
        painelButton.add(report);
        painelButton.add(sair);
        painelButton.add(result);
        painelCadastro.add("South", painelButton);
        salvar.addActionListener(this);
        limpar.addActionListener(this);
        report.addActionListener(this);
        sair.addActionListener(this);
    }
    
    public static void main(String[] args)
    {
        AppCadastro exec = new AppCadastro();
        exec.setVisible(true);
    }
    
    public void actionPerformed(ActionEvent e)
    {
        if (e.getSource() instanceof MenuItem)
        {
            MenuItem item = (MenuItem) e.getSource();
            if (item.getLabel().equals("Sair"))
            {
                System.exit(0);
            }
            if (item.getLabel().equals("Novo Curso"))
            {
                CardLayout pilha = (CardLayout) geral.getLayout();
                pilha.next(geral);
            }  
        }
        if (e.getSource()==salvar)
        {
            c.setNome(nome.getText());
            c.setDescricao(descricao.getText());
            incluir();
            limpar();
        }
        if (e.getSource()==limpar)
        {
            limpar();
        }
        if (e.getSource()==report)
        {
            gerarReport();
        }
        if (e.getSource()==sair)
        {
            System.exit(0);
        }
    }

    public void gerarReport()
    {
        try
        {
            Connection con = connection();
            Statement stm = (Statement) con.createStatement();
            String query = "Select * from Curso";
            ResultSet rs = (ResultSet) stm.executeQuery(query);
            JRResultSetDataSource jrRS = new JRResultSetDataSource(rs);
            JRExporter jrpdf = new JRPdfExporter();
            JasperPrint print;
            OutputStream fos = null;
            print = JasperFillManager.fillReport("iReport.jasper", null, jrRS);
            fos = new FileOutputStream("iReport.pdf");
            jrpdf.setParameter(JRExporterParameter.OUTPUT_STREAM, fos);
            jrpdf.setParameter(JRExporterParameter.JASPER_PRINT, print);
            jrpdf.exportReport();
            fos.close();
            JasperViewer.viewReport(print);
        
        } catch (IOException e) {
            e.printStackTrace();
        } catch (JRException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public void incluir()
    {
        try 
        {
            Statement statement = (Statement) connection().createStatement();
            String sql = "Insert into Curso VALUES (

"+  c.getNome()+    
                                             "

, 

"+   c.getDescricao()+"

)";
                statement.executeUpdate(sql);
            result.setText("CURSO INSERIDO COM SUCESSO!");
        } catch (SQLException e)
        {
            e.printStackTrace();
            result.setText("OCORRERAM ERROS NA INSERÇÃO!");
        } 
    }
    
    public void consultar()
    {
        ResultSet resultadoBanco = null;
        String consulta = "Select * from Curso";
        try
        {
            PreparedStatement comandoBanco = connection().prepareStatement(consulta);
            resultadoBanco = (ResultSet)comandoBanco.executeQuery();
            connection().close();
        } catch (Exception Erro)
        {
            result.setText("OCORRERAM ERROS NA CONSULTA!");
        }
    }
    public void limpar()
    {
        nome.setText("");
        descricao.setText("");
    }

    public Connection connection()
    {
        Connection connection = null;
        try
        {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
        } catch (InstantiationException e)
        {
            e.printStackTrace();
        } catch (IllegalAccessException e)
        {
            e.printStackTrace();
        } catch (ClassNotFoundException e)
        {
            e.printStackTrace();
        }
    
        try
        {
            connection = (Connection) DriverManager.getConnection(
                                           "jdbc:mysql://localhost:3306/root?" +
                                                 "user=root&password=mysteri0");
        } catch (SQLException e)
        {
            e.printStackTrace();
        }
        return connection;
    }
}
class EvtJanela extends WindowAdapter
{
    public void windowClosing(WindowEvent e)
    {
        System.exit(0);
    }
}

class Curso
{
    Integer id = new Integer(0);
    String nome = new String();
    String descricao = new String();
    
    public String getDescricao()
    {
        return descricao;
    }
    public void setDescricao(String descricao)
    {
        this.descricao = descricao;
    }
   
    public Integer getId()
    {
        return id;
    }
    
    public void setId(Integer id)
    {
        this.id = id;
    }
    
    public String getNome()
    {
        return nome;
    }
    
    public void setNome(String nome)
    {
        this.nome = nome;
    }
}

import java.sql.Connection;  
import java.sql.ResultSet;  
import java.sqlStatement; 

//...

Statement stm = con.createStatement();  //SEM CAST!

//...