java Sping Boot 应用中的BIRT

xzlaal3s  于 2023-06-04  发布在  Java
关注(0)|答案(3)|浏览(632)

我需要在现有的Sping Boot Web应用程序中创建一个报告功能（函数）。我的建议是使用BIRT，我可以将其与Sping Boot Web应用程序集成。
我找到了下面的文章，并能够在spring Boot starter项目中运行报告（使用http://start.spring.io/）。这篇文章，相当旧，确实帮助我找到了一个工作示例。https://spring.io/blog/2012/01/30/spring-framework-birt .这篇文章基本上正是我想要的，但在一个Spring Boot Web应用程序。
我面临的挑战是使用BIRT查看器运行报告，该查看器具有很好的附加功能。（打印、Expoet数据、PDF、分页等）
我找不到任何像本文描述的那样使用BIRT的Sping Boot 示例。
我的问题是：
1.是否有替代或其他方式在Sping Boot Web应用程序中执行报告？（显然不想从头开始创建类似BIRT的功能，或者尽可能地将报表引擎与Web应用程序分开运行，从而重新发明轮子）
1.今天有没有人在Sping Boot Web应用程序中使用BIRT（与查看器一起），并愿意分享或教育我如何最好地做到这一点？（我试图让JSP页面与Sping Boot 一起工作，但无法如此成功......更多的是缺乏经验）
有人能帮帮我吗。
亲切的问候，亨克

Java

3条答案

按热度按时间
rbpvctlc

rbpvctlc1#

依赖项、IReportEngine的示例和目录是在Sping Boot Web应用程序中设置BIRT最具挑战性的部分。这个例子有一点错误处理，并且依赖于环境变量来指定重要目录的路径。
这个设置的一个优点是，它是一个独立的API，用于构建和生成报告。作为一个附带的好处，它根本不依赖于JSP。
在Docker容器中运行。
最初有一个计划，使用一些接口来尝试其他报告框架，如碧玉报告或其他东西。
这并不是你所要求的，尽管在我看来，在某些情况下这是更好的。在将BIRT报告运行器作为这样的应用程序使用、配置和部署时，您有很大的灵活性。这不使用Actian提供的预打包BIRT查看器。
我将为报告创建一个名为birt-report-runner-data的数据容器，然后将所有用于日志记录和报告的目录放在该容器上，然后您可以将其挂载到BIRT容器上。

主要组件

主文件（BirtReportRunnerApplication.java）

  1. package com.example;
  3. import org.springframework.boot.SpringApplication;
  4. import org.springframework.boot.autoconfigure.SpringBootApplication;
  6. @SpringBootApplication
  7. public class BirtReportRunnerApplication {
  9.     public static void main(String[] args) {
  10.         SpringApplication.run(BirtReportRunnerApplication.class, args);
  11.     }
  12. }

接收报表请求的控制器（ReportController.java）

  1. package com.example.core.web.controller;
  3. import com.example.core.model.BIRTReport;
  4. import com.example.core.service.ReportRunner;
  5. import com.example.core.web.dto.ReportRequest;
  6. import org.slf4j.Logger;
  7. import org.slf4j.LoggerFactory;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.beans.factory.annotation.Qualifier;
  10. import org.springframework.http.HttpHeaders;
  11. import org.springframework.http.HttpStatus;
  12. import org.springframework.http.MediaType;
  13. import org.springframework.http.ResponseEntity;
  14. import org.springframework.web.bind.annotation.RequestBody;
  15. import org.springframework.web.bind.annotation.RequestMapping;
  16. import org.springframework.web.bind.annotation.RequestMethod;
  17. import org.springframework.web.bind.annotation.RestController;
  19. @RestController("ReportController")
  20. @RequestMapping("/reports")
  21. public class ReportController {
  23.     private Logger logger = LoggerFactory.getLogger(ReportController.class);
  25.     @Autowired
  26.     @Qualifier("birt")
  27.     ReportRunner reportRunner;
  29.     @RequestMapping(value = "/birt", method = RequestMethod.POST)
  30.     public ResponseEntity<byte[]> getBIRTReport(@RequestBody ReportRequest reportRequest) {
  31.         byte[] reportBytes;
  32.         ResponseEntity<byte[]> responseEntity;
  33.         try {
  34.             logger.info("REPORT REQUEST NAME:   " + reportRequest.getReportName());
  35.             reportBytes =
  36.                 new BIRTReport(
  37.                     reportRequest.getReportName(),
  38.                     reportRequest.getReportParameters(),
  39.                     reportRunner)
  40.                     .runReport().getReportContent().toByteArray();
  42.             HttpHeaders httpHeaders = new HttpHeaders();
  43.             httpHeaders.setContentType(MediaType.parseMediaType("application/pdf"));
  44.             String fileName = reportRequest.getReportName() + ".pdf";
  45.             httpHeaders.setContentDispositionFormData(fileName, fileName);
  46.             httpHeaders.setCacheControl("must-revalidate, post-check=0, pre-check=0");
  47.             responseEntity = new ResponseEntity<byte[]>(reportBytes, httpHeaders, HttpStatus.OK);
  48.         } catch (Exception e) {
  49.             responseEntity = new ResponseEntity<byte[]>(HttpStatus.NOT_IMPLEMENTED);
  50.             return responseEntity;
  51.         }
  52.         return responseEntity;
  53.     }
  54. }

指定运行报表的报表请求DTO（ReportRequest.java）

  1. package com.example.core.web.dto;
  3. import com.fasterxml.jackson.annotation.JsonProperty;
  5. import java.util.List;
  7. public class ReportRequest {
  8.     private String reportName;
  9.     private String reportParameters;
  11.     public ReportRequest(@JsonProperty("reportName") String reportName,
  12.                          @JsonProperty("reportParameters") String reportParameters) {
  13.         this.reportName = reportName;
  14.         this.reportParameters = reportParameters;
  15.     }
  17.     public String getReportName() {
  18.         return reportName;
  19.     }
  21.     public String getReportParameters() {
  22.         return reportParameters;
  23.     }
  25.     public void setReportParameters(String reportParameters) {
  26.         this.reportParameters = reportParameters;
  27.     }
  28. }

报表运行器接口（ReportRunner.java）

  1. package com.example.core.service;
  3. import com.example.core.model.Report;
  5. import java.io.ByteArrayOutputStream;
  7. public interface ReportRunner {
  9.     ByteArrayOutputStream runReport(Report report);
  10. }

完成大部分工作的最大类（BIRTReportRunner.java）

  1. package com.example.core.service;
  3. import com.example.core.model.Report;
  4. import org.eclipse.birt.core.exception.BirtException;
  5. import org.eclipse.birt.core.framework.Platform;
  6. import org.eclipse.birt.report.engine.api.*;
  7. import org.eclipse.core.internal.registry.RegistryProviderFactory;
  8. import org.slf4j.Logger;
  9. import org.slf4j.LoggerFactory;
  10. import org.springframework.beans.factory.annotation.Autowired;
  11. import org.springframework.beans.factory.annotation.Qualifier;
  12. import org.springframework.core.env.Environment;
  13. import org.springframework.stereotype.Service;
  15. import javax.annotation.PostConstruct;
  16. import javax.annotation.PreDestroy;
  17. import java.io.ByteArrayOutputStream;
  18. import java.io.File;
  19. import java.nio.file.Files;
  20. import java.nio.file.Path;
  21. import java.nio.file.Paths;
  22. import java.util.HashMap;
  23. import java.util.Map;
  24. import java.util.logging.Level;
  26. @Service
  27. @Qualifier("birt")
  28. public class BIRTReportRunner implements ReportRunner {
  29.     private static final String DEFAULT_LOGGING_DIRECTORY = "defaultBirtLoggingDirectory/";
  30.     private Logger logger = LoggerFactory.getLogger(BIRTReportRunner.class);
  32.     private static String reportOutputDirectory;
  34.     private IReportEngine birtReportEngine = null;
  36.     @Autowired
  37.     private Environment env;
  39.     /**
  40.      * Starts up and configures the BIRT Report Engine
  41.      */
  42.     @PostConstruct
  43.     public void startUp() {
  44.         if(env.getProperty("birt_report_input_dir") == null)
  45.             throw new RuntimeException("Cannot start application since birt report input directory was not specified.");
  46.         try {
  47.             String birtLoggingDirectory = env.getProperty("birt_logging_directory") == null ? DEFAULT_LOGGING_DIRECTORY : env.getProperty("birt_logging_directory");
  48.             Level birtLoggingLevel = env.getProperty("birt_logging_level") == null ? Level.SEVERE : Level.parse(env.getProperty("birt_logging_level"));
  49.             EngineConfig engineConfig = new EngineConfig();
  50.             logger.info("BIRT LOG DIRECTORY SET TO : {}", birtLoggingDirectory);
  51.             logger.info("BIRT LOGGING LEVEL SET TO {}", birtLoggingLevel);
  52.             engineConfig.setLogConfig(birtLoggingDirectory, birtLoggingLevel);
  54.             // Required due to a bug in BIRT that occurs in calling Startup after the Platform has already been started up
  55.             RegistryProviderFactory.releaseDefault();
  56.             Platform.startup(engineConfig);
  57.             IReportEngineFactory reportEngineFactory = (IReportEngineFactory) Platform.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);
  58.             birtReportEngine = reportEngineFactory.createReportEngine(engineConfig);
  59.         } catch (BirtException e) {
  60.             // TODO add logging aspect and find out how to log a platform startup problem from this catch block, if possible, using the aspect.
  61.             // Possibly rethrow the exception here and catch it in the aspect.
  62.             logger.error("Birt Startup Error: {}", e.getMessage());
  63.         }
  65.         reportOutputDirectory = env.getProperty("birt_temp_file_output_dir");
  66.     }
  68.     /**
  69.      * Shuts down the BIRT Report Engine
  70.      */
  71.     @PreDestroy
  72.     public void shutdown() {
  73.         birtReportEngine.destroy();
  74.         RegistryProviderFactory.releaseDefault();
  75.         Platform.shutdown();
  76.     }
  78.     public File getReportFromFilesystem(String reportName) throws RuntimeException {
  79.         String reportDirectory = env.getProperty("birt_report_input_dir");
  80.         Path birtReport = Paths.get(reportDirectory + File.separator + reportName + ".rptdesign");
  81.         if(!Files.isReadable(birtReport))
  82.             throw new RuntimeException("Report " + reportName + " either did not exist or was not writable.");
  84.         return birtReport.toFile();
  85.     }
  87.     /**
  88.      * This method creates and executes the report task, the main responsibility
  89.      * of the entire Report Service.
  90.      * This method is key to enabling pagination for the BIRT report. The IRunTask run task
  91.      * is created and then used to generate an ".rptdocument" binary file.
  92.      * This binary file is then read by the separately created IRenderTask render
  93.      * task. The render task renders the binary document as a binary PDF output
  94.      * stream which is then returned from the method.
  95.      * <p>
  96.      *
  97.      * @param birtReport the report object created at the controller to hold the data of the report request.
  98.      * @return Returns a ByteArrayOutputStream of the PDF bytes generated by the
  99.      */
  100.     @Override
  101.     public ByteArrayOutputStream runReport(Report birtReport) {
  103.         ByteArrayOutputStream byteArrayOutputStream;
  104.         File rptDesignFile;
  106.         // get the path to the report design file
  107.         try {
  108.             rptDesignFile = getReportFromFilesystem(birtReport.getName());
  109.         } catch (Exception e) {
  110.             logger.error("Error while loading rptdesign: {}.", e.getMessage());
  111.             throw new RuntimeException("Could not find report");
  112.         }
  114.         // process any additional parameters
  115.         Map<String, String> parsedParameters = parseParametersAsMap(birtReport.getParameters());
  117.         byteArrayOutputStream = new ByteArrayOutputStream();
  118.         try {
  119.             IReportRunnable reportDesign = birtReportEngine.openReportDesign(rptDesignFile.getPath());
  120.             IRunTask runTask = birtReportEngine.createRunTask(reportDesign);
  122.             if (parsedParameters.size() > 0) {
  123.                 for (Map.Entry<String, String> entry : parsedParameters.entrySet()) {
  124.                     runTask.setParameterValue(entry.getKey(), entry.getValue());
  125.                 }
  126.             }
  127.             runTask.validateParameters();
  129.             String rptdocument = reportOutputDirectory + File.separator
  130.                     + "generated" + File.separator
  131.                     + birtReport.getName() + ".rptdocument";
  132.             runTask.run(rptdocument);
  134.             IReportDocument reportDocument = birtReportEngine.openReportDocument(rptdocument);
  135.             IRenderTask renderTask = birtReportEngine.createRenderTask(reportDocument);
  137.             PDFRenderOption pdfRenderOption = new PDFRenderOption();
  138.             pdfRenderOption.setOption(IPDFRenderOption.REPAGINATE_FOR_PDF, new Boolean(true));
  139.             pdfRenderOption.setOutputFormat("pdf");
  140.             pdfRenderOption.setOutputStream(byteArrayOutputStream);
  141.             renderTask.setRenderOption(pdfRenderOption);
  143.             renderTask.render();
  144.             renderTask.close();
  145.         } catch (EngineException e) {
  146.             logger.error("Error while running report task: {}.", e.getMessage());
  147.             // TODO add custom message to thrown exception
  148.             throw new RuntimeException();
  149.         }
  151.         return byteArrayOutputStream;
  152.     }
  154.     /**
  155.      * Takes a String of parameters started by '?', delimited by '&', and with
  156.      * keys and values split by '=' and returnes a Map of the keys and values
  157.      * in the String.
  158.      *
  159.      * @param reportParameters a String from a HTTP request URL
  160.      * @return a map of parameters with Key,Value entries as strings
  161.      */
  162.     public Map<String, String> parseParametersAsMap(String reportParameters) {
  163.         Map<String, String> parsedParameters = new HashMap<String, String>();
  164.         String[] paramArray;
  165.         if (reportParameters.isEmpty()) {
  166.             throw new IllegalArgumentException("Report parameters cannot be empty");
  167.         } else if (!reportParameters.startsWith("?") && !reportParameters.contains("?")) {
  168.             throw new IllegalArgumentException("Report parameters must start with a question mark '?'!");
  169.         } else {
  170.             String noQuestionMark = reportParameters.substring(1, reportParameters.length());
  171.             paramArray = noQuestionMark.split("&");
  172.             for (String param : paramArray) {
  173.                 String[] paramGroup = param.split("=");
  174.                 if (paramGroup.length == 2) {
  175.                     parsedParameters.put(paramGroup[0], paramGroup[1]);
  176.                 } else {
  177.                     parsedParameters.put(paramGroup[0], "");
  178.                 }
  180.             }
  181.         }
  182.         return parsedParameters;
  183.     }
  184. }

报表对象类（Report.java）

  1. package com.example.core.model;
  3. import com.example.core.service.ReportRunner;
  5. import java.io.ByteArrayOutputStream;
  6. import java.util.List;
  8. /**
  9.  * A Report object has a byte representation of the report output that can be
  10.  * used to write to any output stream. This class is designed around the concept
  11.  * of using ByteArrayOutputStreams to write PDFs to an output stream.
  12.  *
  13.  *
  14.  */
  15. public abstract class Report {
  17.     protected String name;
  18.     protected String parameters;
  19.     protected ByteArrayOutputStream reportContent;
  20.     protected ReportRunner reportRunner;
  22.     public Report(String name, String parameters, ReportRunner reportRunner) {
  23.         this.name = name;
  24.         this.parameters = parameters;
  25.         this.reportRunner = reportRunner;
  26.     }
  28.     /**
  29.      * This is the processing method for a Report. Once the report is ran it
  30.      * populates an internal field with a ByteArrayOutputStream of the
  31.      * report content generated during the run process.
  32.      * @return Returns itself with the report content output stream created.
  33.      */
  34.     public abstract Report runReport();
  36.     public ByteArrayOutputStream getReportContent() {
  37.         return this.reportContent;
  38.     }
  40.     public String getName() {
  41.         return name;
  42.     }
  44.     public String getParameters() {
  45.         return parameters;
  46.     }
  47. }

BIRTReport对象类（BIRTReport.java）

  1. package com.example.core.model;
  3. import com.example.core.service.ReportRunner;
  5. public class BIRTReport extends Report {
  7.     public BIRTReport(String name, String reportParameters, ReportRunner reportRunner) {
  8.         super(name, reportParameters, reportRunner);
  9.     }
  11.     @Override
  12.     public Report runReport() {
  13.         this.reportContent = reportRunner.runReport(this);
  14.         return this;
  15.     }
  16. }

构建文件（build.gradle）

  1. buildscript {
  2.     ext {
  3.         springBootVersion = '1.3.2.RELEASE'
  4.     }
  5.     repositories {
  6.         jcenter()
  8.     }
  9.     dependencies {
  10.         classpath("org.springframework.boot:spring-boot-gradle-plugin:${springBootVersion}")
  11.         classpath("io.spring.gradle:dependency-management-plugin:0.5.2.RELEASE")
  12.     }
  13. }
  15. apply plugin: 'java'
  16. apply plugin: 'eclipse'
  17. apply plugin: 'idea'
  18. apply plugin: 'spring-boot'
  20. jar {
  21.     baseName = 'com.example.simple-birt-runner'
  22.     version = '1.0.0'
  23. }
  25. sourceCompatibility = 1.8
  26. targetCompatibility = 1.8
  28. ext {
  29.     springBootVersion = '1.3.0.M5'
  30. }
  32. repositories {
  33.     jcenter()
  34.     mavenCentral()
  35. }
  37. dependencies {
  38.     compile("org.springframework.boot:spring-boot-starter-actuator:${springBootVersion}")
  39.     compile("org.springframework.boot:spring-boot-starter-web:${springBootVersion}")
  41.     // BIRT Runtime and ReportEngine dependencies
  42.     // These were pulled from the Actuate download site at http://download.eclipse.org/birt/downloads/ for version 4.5.0
  43.     compile fileTree(dir: 'lib', include: '*.jar')
  44.     /*compile("org.eclipse.birt.runtime:org.eclipse.birt.runtime:4.4.2") {
  45.         exclude group: "org.eclipse.birt.runtime", module: "org.apache.poi"
  46.         exclude group: "org.eclipse.birt.runtime", module: "org.eclipse.orbit.mongodb"
  47.     }*/
  49.     compile("org.springframework.boot:spring-boot-starter-tomcat")
  51.     // include any runtime JDBC driver dependencies here
  53.     testCompile("org.springframework.boot:spring-boot-starter-test")
  54. }

依赖

获取Birt Viewer lib目录中的所有依赖项，并将它们放在类路径中。以下是外部依赖项的完整列表：

  1. com.ibm.icu_54.1.1.v201501272100.jar
  2. com.lowagie.text_2.1.7.v201004222200.jar
  3. derby.jar
  4. flute.jar
  5. javax.wsdl_1.5.1.v201012040544.jar
  6. javax.xml.stream_1.0.1.v201004272200.jar
  7. javax.xml_1.3.4.v201005080400.jar
  8. net.sourceforge.lpg.lpgjavaruntime_1.1.0.v201004271650.jar
  9. org.apache.batik.bridge_1.6.0.v201011041432.jar
  10. org.apache.batik.css_1.6.0.v201011041432.jar
  11. org.apache.batik.dom.svg_1.6.0.v201011041432.jar
  12. org.apache.batik.dom_1.6.1.v201505192100.jar
  13. org.apache.batik.ext.awt_1.6.0.v201011041432.jar
  14. org.apache.batik.parser_1.6.0.v201011041432.jar
  15. org.apache.batik.pdf_1.6.0.v201105071520.jar
  16. org.apache.batik.svggen_1.6.0.v201011041432.jar
  17. org.apache.batik.transcoder_1.6.0.v201011041432.jar
  18. org.apache.batik.util.gui_1.6.0.v201011041432.jar
  19. org.apache.batik.util_1.6.0.v201011041432.jar
  20. org.apache.batik.xml_1.6.0.v201011041432.jar
  21. org.apache.commons.codec_1.6.0.v201305230611.jar
  22. org.apache.commons.logging_1.1.1.v201101211721.jar
  23. org.apache.lucene.core_3.5.0.v20120725-1805.jar
  24. org.apache.poi_3.9.0.v201405241750.jar
  25. org.apache.xerces_2.9.0.v201101211617.jar
  26. org.apache.xml.resolver_1.2.0.v201005080400.jar
  27. org.apache.xml.serializer_2.7.1.v201005080400.jar
  28. org.eclipse.birt.runtime_4.5.0.jar
  29. org.eclipse.core.contenttype_3.5.0.v20150421-2214.jar
  30. org.eclipse.core.expressions_3.5.0.v20150421-2214.jar
  31. org.eclipse.core.filesystem_1.5.0.v20150421-0713.jar
  32. org.eclipse.core.jobs_3.7.0.v20150330-2103.jar
  33. org.eclipse.core.resources_3.10.0.v20150423-0755.jar
  34. org.eclipse.core.runtime.compatibility_3.2.300.v20150423-0821.jar
  35. org.eclipse.core.runtime_3.11.0.v20150405-1723.jar
  36. org.eclipse.datatools.connectivity.apache.derby.dbdefinition_1.0.2.v201107221459.jar
  37. org.eclipse.datatools.connectivity.apache.derby_1.0.103.v201212070447.jar
  38. org.eclipse.datatools.connectivity.console.profile_1.0.10.v201109250955.jar
  39. org.eclipse.datatools.connectivity.db.generic_1.0.1.v201107221459.jar
  40. org.eclipse.datatools.connectivity.dbdefinition.genericJDBC_1.0.2.v201310181001.jar
  41. org.eclipse.datatools.connectivity.oda.consumer_3.2.6.v201403131814.jar
  42. org.eclipse.datatools.connectivity.oda.design_3.3.6.v201403131814.jar
  43. org.eclipse.datatools.connectivity.oda.flatfile_3.1.8.v201403010906.jar
  44. org.eclipse.datatools.connectivity.oda.profile_3.2.9.v201403131814.jar
  45. org.eclipse.datatools.connectivity.oda_3.4.3.v201405301249.jar
  46. org.eclipse.datatools.connectivity.sqm.core_1.2.8.v201401230755.jar
  47. org.eclipse.datatools.connectivity_1.2.11.v201401230755.jar
  48. org.eclipse.datatools.enablement.hsqldb.dbdefinition_1.0.0.v201107221502.jar
  49. org.eclipse.datatools.enablement.hsqldb_1.0.0.v201107221502.jar
  50. org.eclipse.datatools.enablement.ibm.db2.iseries.dbdefinition_1.0.3.v201107221502.jar
  51. org.eclipse.datatools.enablement.ibm.db2.iseries_1.0.2.v201107221502.jar
  52. org.eclipse.datatools.enablement.ibm.db2.luw.dbdefinition_1.0.7.v201405302027.jar
  53. org.eclipse.datatools.enablement.ibm.db2.luw_1.0.3.v201401170830.jar
  54. org.eclipse.datatools.enablement.ibm.db2.zseries.dbdefinition_1.0.4.v201107221502.jar
  55. org.eclipse.datatools.enablement.ibm.db2.zseries_1.0.2.v201107221502.jar
  56. org.eclipse.datatools.enablement.ibm.db2_1.0.0.v201401170830.jar
  57. org.eclipse.datatools.enablement.ibm.informix.dbdefinition_1.0.4.v201107221502.jar
  58. org.eclipse.datatools.enablement.ibm.informix_1.0.1.v201107221502.jar
  59. org.eclipse.datatools.enablement.ibm_1.0.0.v201401170830.jar
  60. org.eclipse.datatools.enablement.msft.sqlserver.dbdefinition_1.0.1.v201201240505.jar
  61. org.eclipse.datatools.enablement.msft.sqlserver_1.0.3.v201308161009.jar
  62. org.eclipse.datatools.enablement.mysql.dbdefinition_1.0.4.v201109022331.jar
  63. org.eclipse.datatools.enablement.mysql_1.0.4.v201212120617.jar
  64. org.eclipse.datatools.enablement.oda.ws_1.2.6.v201403131825.jar
  65. org.eclipse.datatools.enablement.oda.xml_1.2.5.v201403131825.jar
  66. org.eclipse.datatools.enablement.oracle.dbdefinition_1.0.103.v201206010214.jar
  67. org.eclipse.datatools.enablement.oracle_1.0.0.v201107221506.jar
  68. org.eclipse.datatools.enablement.postgresql.dbdefinition_1.0.2.v201110070445.jar
  69. org.eclipse.datatools.enablement.postgresql_1.1.1.v201205252207.jar
  70. org.eclipse.datatools.enablement.sap.maxdb.dbdefinition_1.0.0.v201107221507.jar
  71. org.eclipse.datatools.enablement.sap.maxdb_1.0.0.v201107221507.jar
  72. org.eclipse.datatools.modelbase.dbdefinition_1.0.2.v201107221519.jar
  73. org.eclipse.datatools.modelbase.derby_1.0.0.v201107221519.jar
  74. org.eclipse.datatools.modelbase.sql.query_1.1.4.v201212120619.jar
  75. org.eclipse.datatools.modelbase.sql_1.0.6.v201208230744.jar
  76. org.eclipse.datatools.sqltools.data.core_1.2.3.v201212120623.jar
  77. org.eclipse.datatools.sqltools.parsers.sql.lexer_1.0.1.v201107221520.jar
  78. org.eclipse.datatools.sqltools.parsers.sql.query_1.2.1.v201201250511.jar
  79. org.eclipse.datatools.sqltools.parsers.sql_1.0.2.v201107221520.jar
  80. org.eclipse.datatools.sqltools.result_1.1.6.v201402080246.jar
  81. org.eclipse.emf.common_2.11.0.v20150512-0501.jar
  82. org.eclipse.emf.ecore.change_2.11.0.v20150512-0501.jar
  83. org.eclipse.emf.ecore.xmi_2.11.0.v20150512-0501.jar
  84. org.eclipse.emf.ecore_2.11.0.v20150512-0501.jar
  85. org.eclipse.equinox.app_1.3.300.v20150423-1356.jar
  86. org.eclipse.equinox.common_3.7.0.v20150402-1709.jar
  87. org.eclipse.equinox.preferences_3.5.300.v20150408-1437.jar
  88. org.eclipse.equinox.registry_3.6.0.v20150318-1503.jar
  89. org.eclipse.help_3.6.0.v20130326-1254.jar
  90. org.eclipse.osgi.services_3.5.0.v20150519-2006.jar
  91. org.eclipse.osgi_3.10.100.v20150529-1857.jar
  92. org.eclipse.update.configurator_3.3.300.v20140518-1928.jar
  93. org.mozilla.javascript_1.7.5.v201504281450.jar
  94. org.w3c.css.sac_1.3.1.v200903091627.jar
  95. org.w3c.dom.events_3.0.0.draft20060413_v201105210656.jar
  96. org.w3c.dom.smil_1.0.1.v200903091627.jar
  97. org.w3c.dom.svg_1.1.0.v201011041433.jar

应用属性（application.yml）

  1. birt:
  2.   report:
  3.     output:
  4.       dir: ${birt_temp_file_output_dir}
  5.     input:
  6.       dir: ${birt_report_input_dir}
  7.   logging:
  8.     level: ${birt_logging_level}
  10. server:
  11.   port: 8080
  12.   context-path: /simple-birt-runner
  14. birt:
  15.   logging:
  16.     level: SEVERE
  18. logging:
  19.   level:
  20.     org:
  21.       springframework:
  22.         web: ERROR

运行Dockerfile（Dockerfile）

  1. FROM java:openjdk-8u66-jre
  2. MAINTAINER Kent O. Johnson <kentoj@gmail.com>
  4. COPY com.example.simple-birt-runner-*.jar /opt/soft/simple-birt-runner.jar
  6. RUN mkdir -p /reports/input \
  7.     && mkdir /reports/output \
  8.     && mkdir -p /reports/log/engine
  10. WORKDIR /opt/soft
  12. CMD java -jar -Xms128M -Xmx4G simple-birt-runner.jar
  14. EXPOSE 8080

运行镜像的Docker compose文件（docker-compose.yml）

  1. simple-birt-runner:
  2.   image: soft/simple-birt-runner-release
  3.   ports:
  4.   - "8090:8080"
  5.   environment:
  6.   - birt_temp_file_output_dir=/reports/output
  7.   - birt_report_input_dir=/reports/input
  8.   - birt_logging_directory=/reports/log/engine
  9.   - birt_logging_level=SEVERE
  10.   volumes_from:
  11.   - birt-report-runner-data
展开查看全部
赞(0）分享  回复(0）举报  2023-06-04
nkkqxpd9

nkkqxpd92#

关于@肯特Json的回答。我没有设法用gradle配置项目，但我设法用maven构建了它。下面是pom.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2.         <project xmlns="http://maven.apache.org/POM/4.0.0"
  3.      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.      xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  5. <modelVersion>4.0.0</modelVersion>
  7. <groupId>birt-runner</groupId>
  8. <artifactId>com.example.simple-birt-runner</artifactId>
  9. <version>1.0-SNAPSHOT</version>
  10. <packaging>jar</packaging>
  12. <parent>
  13.     <groupId>org.springframework.boot</groupId>
  14.     <artifactId>spring-boot-starter-parent</artifactId>
  15.     <version>1.4.4.RELEASE</version>
  16.     <relativePath/> <!-- lookup parent from repository -->
  17. </parent>
  19. <properties>
  20.     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  21.     <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
  22.     <java.version>1.8</java.version>
  23. </properties>
  25. <dependencies>
  26.     <dependency>
  27.         <groupId>org.springframework.boot</groupId>
  28.         <artifactId>spring-boot-starter-web</artifactId>
  29.     </dependency>
  31.     <dependency>
  32.         <groupId>org.springframework.boot</groupId>
  33.         <artifactId>spring-boot-starter-tomcat</artifactId>
  34.         <!--<scope>provided</scope>-->
  35.     </dependency>
  37.     <dependency>
  38.         <groupId>org.springframework.boot</groupId>
  39.         <artifactId>spring-boot-starter-test</artifactId>
  40.         <scope>test</scope>
  41.     </dependency>
  43.     <!-- https://mvnrepository.com/artifact/org.springframework/spring-web -->
  44.     <dependency>
  45.         <groupId>org.springframework</groupId>
  46.         <artifactId>spring-web</artifactId>
  47.     </dependency>
  49.     <!-- https://mvnrepository.com/artifact/org.eclipse.birt.runtime/org.eclipse.birt.runtime -->
  50.     <dependency>
  51.         <groupId>org.eclipse.birt.runtime</groupId>
  52.         <artifactId>org.eclipse.birt.runtime</artifactId>
  53.         <version>4.2.0</version>
  54.     </dependency>
  56.     <!-- https://mvnrepository.com/artifact/org.springframework/spring-core -->
  57.     <dependency>
  58.         <groupId>org.springframework</groupId>
  59.         <artifactId>spring-core</artifactId>
  60.     </dependency>
  62.     <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
  63.     <dependency>
  64.         <groupId>com.fasterxml.jackson.core</groupId>
  65.         <artifactId>jackson-databind</artifactId>
  66.     </dependency>
  69. </dependencies>
  71. <build>
  72.     <plugins>
  73.         <plugin>
  74.             <groupId>org.springframework.boot</groupId>
  75.             <artifactId>spring-boot-maven-plugin</artifactId>
  76.         </plugin>
  77.     </plugins>
  78. </build>
展开查看全部
赞(0）分享  回复(0）举报  2023-06-04
qqrboqgw

qqrboqgw3#

我创建了一个API来使用Sping Boot 的Birt Report。要使用它，只需创建一个新的报告，并通过发送正确的参数来调用它。友情链接：https://github.com/devStraub/BirtAPI
代码：

  1. @RestController
  2. @SpringBootApplication
  3. public class BirtReportApplication {
  5. @Value("${reports.relative.path}")
  6. private String reportsPath;
  7. @Value("${images.relative.path}")
  8. private String imagesPath;  
  9. @Value("${temp.files.path}")
  10. private String tempPath;      
  12. private ApplicationContext context;
  14. public static void main(String[] args) {
  15.     SpringApplication.run(BirtReportApplication.class, args);
  16. }
  18. @SuppressWarnings("unchecked")
  19. @PostMapping("/report")
  20. public ResponseEntity<byte[]> generateReport(@RequestBody String json) {
  21.     try {
  22.         ObjectMapper objectMapper = new ObjectMapper();
  23.         Map<String, String> parametersMap = objectMapper.readValue(json, Map.class);            
  24.         
  25.         EngineConfig config = new EngineConfig();
  26.         config.getAppContext().put("spring", this.context);
  27.         Platform.startup(config);
  28.         IReportEngineFactory factory = (IReportEngineFactory) Platform.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);
  29.         IReportEngine engine = factory.createReportEngine(config);
  31.         IReportRunnable report = engine.openReportDesign(reportsPath + parametersMap.get("report") + ".rptdesign");
  33.         IRunAndRenderTask task = engine.createRunAndRenderTask(report);
  34.         for (Entry<String, String> parametro : parametersMap.entrySet()) {
  35.             task.setParameterValue(parametro.getKey(), parametro.getValue());
  36.         }
  38.         String reportFileName = tempPath + Calendar.getInstance().getTimeInMillis() + ".pdf";
  39.         
  40.         PDFRenderOption options = new PDFRenderOption();
  41.         options.setOutputFormat("pdf");
  42.         options.setOutputFileName(reportFileName);
  43.         task.setRenderOption(options);
  44.         task.run();
  45.         task.close();           
  47.         byte[] relatorioBytes = Files.readAllBytes(Paths.get(reportFileName));
  49.         Files.deleteIfExists(Paths.get(reportFileName));
  51.         return ResponseEntity.ok()
  52.                 .header("Content-Type", "application/pdf")
  53.                 .body(relatorioBytes);
  54.     } catch (Exception e) {
  55.         e.printStackTrace();
  56.         return ResponseEntity.status(HttpStatus.INTERNAL_SERVER_ERROR).build();
  57.     }
  58. }

}
pom.xml:

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0"
  3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 
  5. https://maven.apache.org/xsd/maven-4.0.0.xsd">
  6. <modelVersion>4.0.0</modelVersion>
  7. <parent>
  8.     <groupId>org.springframework.boot</groupId>
  9.     <artifactId>spring-boot-starter-parent</artifactId>
  10.     <version>3.1.0</version>
  11.     <relativePath /> <!-- lookup parent from repository -->
  12. </parent>
  13. <groupId>com.birt2</groupId>
  14. <artifactId>birt2</artifactId>
  15. <version>0.0.1-SNAPSHOT</version>
  16. <name>demo</name>
  17. <description>Demo project for Spring Boot</description>
  18. <properties>
  19.     <java.version>17</java.version>
  20. </properties>
  21. <dependencies>
  22.     <dependency>
  23.         <groupId>org.springframework.boot</groupId>
  24.         <artifactId>spring-boot-starter-web</artifactId>
  25.     </dependency>
  27.     <dependency>
  28.         <groupId>org.springframework.boot</groupId>
  29.         <artifactId>spring-boot-starter-test</artifactId>
  30.         <scope>test</scope>
  31.     </dependency>
  33.     <dependency>
  34.         <groupId>com.innoventsolutions.birt.runtime</groupId>
  35.         <artifactId>org.eclipse.birt.runtime_4.8.0-20180626</artifactId>
  36.         <version>4.8.0</version>
  37.     </dependency>
  39.     <dependency>
  40.         <groupId>com.fasterxml.jackson.core</groupId>
  41.         <artifactId>jackson-databind</artifactId>
  42.         <version>2.12.4</version>
  43.     </dependency>
  45.     <dependency>
  46.         <groupId>org.postgresql</groupId>
  47.         <artifactId>postgresql</artifactId>
  48.         <scope>runtime</scope>
  49.     </dependency>
  50. </dependencies>
  52. <build>
  53.     <plugins>
  54.         <plugin>
  55.             <groupId>org.springframework.boot</groupId>
  56.             <artifactId>spring-boot-maven-plugin</artifactId>
  57.         </plugin>
  58.     </plugins>
  59. </build>

您应该打开报表的XML Source并将“version”属性（第2行）修改为“3.2.23”。如果不执行此操作，报告将显示错误。我还在努力解决这个问题如果有人对如何设置报告版本有任何想法，那就太好了。
希望我帮上忙了。

展开查看全部
赞(0）分享  回复(0）举报  2023-06-04
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com