dbconnectionreportfill.java

来自「利用jasperreports和Ireport做报表5」· Java 代码 · 共 57 行

package net.ensode.jasperbook;

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

import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRParameter;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.fill.JRFileVirtualizer;

public class DbConnectionReportFill
{
  Connection connection;

  public void generateReport(String reportName)
  {
    String reportDirectory = "reports";
    JRFileVirtualizer fileVirtualizer = new JRFileVirtualizer(3, "cacheDir");
    HashMap parameterMap = new HashMap();
    parameterMap.put(JRParameter.REPORT_VIRTUALIZER, fileVirtualizer);
    
    try
    {
      Class.forName("com.mysql.jdbc.Driver");

      connection = DriverManager
          .getConnection("jdbc:mysql://localhost:3306/flightstats?user=user&password=secret");

      System.out.println("Filling report...");
      JasperFillManager.fillReportToFile(reportDirectory + "/" + reportName + ".jasper",
          parameterMap,connection);
      System.out.println("Done!");

      connection.close();
    }
    catch (JRException e)
    {
      e.printStackTrace();
    }
    catch (ClassNotFoundException e)
    {
      e.printStackTrace();
    }
    catch (SQLException e)
    {
      e.printStackTrace();
    }
  }

  public static void main(String[] args)
  {
    new DbConnectionReportFill().generateReport(args[0]);
  }
}