Relatorio ireport

import java.sql.*;

import java.util.HashMap;

import java.util.Map;

import net.sf.jasperreports.engine.JRException;

import net.sf.jasperreports.engine.JRResultSetDataSource;

import net.sf.jasperreports.engine.JasperExportManager;

import net.sf.jasperreports.engine.JasperFillManager;

import net.sf.jasperreports.view.JasperViewer;

public class Main {

private static final String url = “jdbc:mysql://localhost/boph”;

private static final String driver = “com.mysql.jdbc.Driver”;

private static final String login = “root”;

private static final String pwd = " ";

public Main() {


}

public void gerar( String jasperFile ) throws JRException , SQLException, ClassNotFoundException {


    Class.forName( driver );
	Connection con = DriverManager.getConnection( url , login , pwd );
	Statement stm = con.createStatement();
	String query = "select * from pessoa";
	ResultSet rs = stm.executeQuery( query );


    try {
        stm = con.createStatement();
        rs = stm.executeQuery("Select * from pessoa");
    } catch (SQLException ex) {
        ex.printStackTrace();
    }
    while(rs.next()){
        System.out.println(rs.getString("nome"));
    }

   JRResultSetDataSource jrRS = new JRResultSetDataSource( rs );

    //executa o relatório
    Map parametros = new HashMap();
    parametros.put("nome", new String("ewwerwer"));

           JasperFillManager.fillReportToFile( "C:\\Users\\Othon\\Documents\\NetBeansProjects\\relatorio01\\relatorio1.jasper" , parametros, jrRS );
    
    JasperExportManager.exportReportToPdfFile( "iReport.jrprint");
           
    JasperViewer.viewReport( "iReport.pdf", false );

}

public static void main(String[] args) {
    try {
        new Main().gerar( "C:\\Users\\Othon\\Documents\\NetBeansProjects\\relatorio01\\relatorio1.jasper" );
    } catch (Exception e) {
        e.printStackTrace();
    }
}

net.sf.jasperreports.engine.JRRuntimeException: Unknown hyperlink target 0

at net.sf.jasperreports.engine.JRHyperlinkHelper.getLinkTarget(JRHyperlinkHelper.java:273)

at net.sf.jasperreports.engine.base.JRBaseTextField.normalizeLinkTarget(JRBaseTextField.java:317)

at net.sf.jasperreports.engine.base.JRBaseTextField.readObject(JRBaseTextField.java:381)

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:597)

at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:974)

at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1849)

at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)

at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)

at java.io.ObjectInputStream.readObject(ObjectInputStream.java:351)

at java.util.ArrayList.readObject(ArrayList.java:593)

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:597)

at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:974)

at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1849)

at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)

at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)

at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)

at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)

at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)

at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)

at java.io.ObjectInputStream.readArray(ObjectInputStream.java:1667)

at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1323)

at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)

at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)

at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)

at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)

at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)

at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)

at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)

at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)

at java.io.ObjectInputStream.readObject(ObjectInputStream.java:351)

at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:92)

at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:443)

at relatorio01.Main.gerar(Main.java:55)

at relatorio01.Main.main(Main.java:65)

CONSTRUÍDO COM SUCESSO (tempo total: 1 segundo)