dbchartreportfill.java

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

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.JasperFillManager;

public class DbChartReportFill
{
  Connection connection;

  public void generateReport(String reportName)
  {
    String reportDirectory = "reports";
    
    try
    {
      Class.forName("com.mysql.jdbc.Driver");

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

      System.out.println("Filling report...");
      JasperFillManager.fillReportToFile(reportDirectory + "/" + reportName + ".jasper",
          new HashMap(), 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 DbChartReportFill().generateReport(args[0]);
  }
}