Pessoal
ainda nao consegui abrir um relatorio .jasper
To usando o seguinte codigo:
import javax.swing.*;
import javax.swing.border.*;
import java.awt.*;
import java.awt.event.*;import java.sql.*;
import java.util.*;
import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.view.JasperViewer;
import net.sf.jasperreports.engine.util.JRLoader;
import org.apache.commons.digester.Digester;
import org.apache.commons.beanutils.BeanUtils;
import net.sf.jasperreports.engine.JasperFillManager;
import java.io.*;
import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.view.JasperViewer;
import org.apache.commons.logging.LogFactory;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.fill.JRFillObjectFactory;
public class RelatProf
{
/* Realiza conexão com o banco de dados, gerando o objeto Connection */
public Connection getConnection( ) throws ClassNotFoundException, SQLException, Exception
{
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost/siafarma";
String user = "root";
String password = "globo12";
Class.forName(driver);
Connection con = DriverManager.getConnection( url, user, password );
return con;
}
/* Gera Relatorio e visualiza-o */
public void geraRelatorio() throws JRException, Exception
{
try {
Connection con = getConnection( );
Statement stmt = con.createStatement( );
String strSQL = "SELECT * FROM paciente";
ResultSet rs = stmt.executeQuery(strSQL);
JRResultSetDataSource jrRS = new JRResultSetDataSource( rs );
Map parameters = new HashMap();
JasperFillManager.fillReportToFile ( "teste.jasper", parameters, jrRS );
JasperExportManager.exportReportToPdfFile("TESTE.jrprint" );
JasperViewer.viewReport("TESTE.jrprint",false,false );
}
catch (Exception e) {
JOptionPane.showMessageDialog(null , e.getMessage());
}
}
public static void main(String[] args) throws JRException, Exception
{
new RelatProf().geraRelatorio();
}
}GERANDO O SEGUINTE ERRO NA LINHA
JasperFillManager.fillReportToFile ( "teste.jasper", parameters, jrRS );java.lang.ExceptionInInitializerError
at net.sf.jasperreports.engine.fill.JRFillObjectFactory.getStaticText(JRFillObjectFactory.java:504)
at net.sf.jasperreports.engine.base.JRBaseStaticText.getCopy(JRBaseStaticText.java:93)
at net.sf.jasperreports.engine.fill.JRFillElementGroup.<init>(JRFillElementGroup.java:88)
at net.sf.jasperreports.engine.fill.JRFillElementContainer.<init>(JRFillElementContainer.java:90)
at net.sf.jasperreports.engine.fill.JRFillBand.<init>(JRFillBand.java:77)
at net.sf.jasperreports.engine.fill.JRFillObjectFactory.getBand(JRFillObjectFactory.java:384)
at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:395)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:92)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:74)
at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:147)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:83)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601)
at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:492)
at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:448)
at RelatProf.geraRelatorio(RelatProf.java:51)
at RelatProf.main(RelatProf.java:83)
Caused by: org.apache.commons.logging.LogConfigurationException: java.lang.VerifyError: (class: org/apache/log4j/LogManager, method: <clinit> signature: ()V) Incompatible argument to function (Caused by java.lang.VerifyError: (class: org/apache/log4j/LogManager, method: <clinit> signature: ()V) Incompatible argument to function)
at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:538)
at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:235)
at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:209)
at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:351)
at net.sf.jasperreports.engine.fill.JRFillTextElement.<clinit>(JRFillTextElement.java:63)
at net.sf.jasperreports.engine.fill.JRFillObjectFactory.getStaticText(JRFillObjectFactory.java:504)
at net.sf.jasperreports.engine.base.JRBaseStaticText.getCopy(JRBaseStaticText.java:93)
at net.sf.jasperreports.engine.fill.JRFillElementGroup.<init>(JRFillElementGroup.java:88)
at net.sf.jasperreports.engine.fill.JRFillElementContainer.<init>(JRFillElementContainer.java:90)
at net.sf.jasperreports.engine.fill.JRFillBand.<init>(JRFillBand.java:77)
at net.sf.jasperreports.engine.fill.JRFillObjectFactory.getBand(JRFillObjectFactory.java:384)
at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:395)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:92)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:74)
at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:147)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:83)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601)
at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:492)
at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:448)
at RelatProf.geraRelatorio(RelatProf.java:51)
at RelatProf.main(RelatProf.java:83)
at __SHELL27.run(__SHELL27.java:6)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at bluej.runtime.ExecServer$3.run(ExecServer.java:858)
Caused by: java.lang.VerifyError: (class: org/apache/log4j/LogManager, method: <clinit> signature: ()V) Incompatible argument to function
at org.apache.log4j.Logger.getLogger(Logger.java:85)
at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:229)
at org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:65)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:529)
... 26 more