import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.util.JRLoader;


public class GenerateJasperReport {

        /**
         * @param args
         */
        public static void main(String[] args) {
                String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=CRS.mdb;";
                Connection conn = null;
                try {
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

                        // First, load compiled JasperReport template
                        JasperReport jasperReport = (JasperReport) JRLoader.loadObject("rasReport.jasper");
                        // Second, create a map of parameters to pass to the report.
                        Map parameters = new HashMap();
                        // Third, get a database connection
                        conn = DriverManager.getConnection(database, "", "");

                        // Fourth, create JasperPrint using fillReport() method
                        JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,
                           parameters, conn);
                        // You can use JasperPrint to create PDF
                        JasperExportManager.exportReportToPdfFile(jasperPrint, "rasReport.pdf");
                } catch (SQLException e) {
                        // TODO Auto-generated catch block
                        e.printStackTrace();
                } catch (JRException e) {
                        // TODO Auto-generated catch block
                        e.printStackTrace();
                } catch (ClassNotFoundException e) {
                        // TODO Auto-generated catch block
                        e.printStackTrace();
                } finally {
                        if(conn != null) {
                                try {
                                        conn.close();
                                } catch (SQLException e) {
                                        // TODO Auto-generated catch block
                                        e.printStackTrace();
                                }
                                conn = null;
                        }
                }
        }

}