Boa noite meus caros amigos,
Estou precisando muito de uma ajuda. Configurei o iReport corretamente e testei o banco de dados. Mas quando vou fazer a aplicação no netbeans 6.9.1. ocorre um erro. Abaixo segue o código:
[code]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;
}
}
[/code]
[code]/*
- 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
}
[/code]
E esse próximo código é do Facade que já tenho na máquina. Pergunto. Uso o Facade ou o ConexaoOracle:
[code]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");
}
}
[/code]
MENSAGEM DE ERRO DO NETBEANS
run:
Conexao realizada com exito.
Facade sql = Select * from Login where UPPER(Nome_Usuario) = ‘ELCIO’
O tamanho da tela é: 1280 pixels de largura por 800 pixels de altura.
java.sql.SQLException: No suitable driver found for oracle.jdbc.driver.OracleDriver)
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at laboratorioac.ConexaoOracle.getConnection(ConexaoOracle.java:34)
at laboratorioac.Mapatrab.visualisarActionPerformed(Mapatrab.java:177)
at laboratorioac.Mapatrab.access$000(Mapatrab.java:25)
at laboratorioac.Mapatrab$1.actionPerformed(Mapatrab.java:111)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6267)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6032)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.lang.ClassCastException: laboratorioac.Mapatrab$Hashmap cannot be cast to java.util.Map
at laboratorioac.Mapatrab.visualisarActionPerformed(Mapatrab.java:179)
at laboratorioac.Mapatrab.access$000(Mapatrab.java:25)
at laboratorioac.Mapatrab$1.actionPerformed(Mapatrab.java:111)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6267)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6032)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
CONSTRUÍDO COM SUCESSO (tempo total: 3 minutos 27 segundos)
Desde já agradeço,
Elcio