iRepor

package br.com.fit.teste;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
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 RelatorioBibliotecaPessoal {

	private static Connection getConnection() throws ClassNotFoundException,
			SQLException {
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/cadastro";
		String user = "root";
		String password = "root";
		
		Class.forName(driver);
		Connection con = DriverManager.getConnection(url, user, password);
		return con;
	}

	public void geraRelatorio() throws JRException, Exception {
		
		Connection con = getConnection();
		Statement stm = con.createStatement();
		String query = "select * from associado";
		ResultSet rs = stm.executeQuery(query);
		JRResultSetDataSource jrRS = new JRResultSetDataSource(rs);
		Map parameters = new HashMap();
		// parameters.put("abc" , "def");

		JasperFillManager.fillReportToFile("RelatorioBibliotecaPessoal.jasper",
				parameters, jrRS);
		JasperExportManager.exportReportToPdfFile("RelatorioBibliotecaPessoal.jrPrint");

		JasperViewer.viewReport("BibliotecaPessoal.pdf", false);
	}

	public static void main(String[] args) throws JRException, Exception {
		new RelatorioBibliotecaPessoal().geraRelatorio();
	}

}