报表数据模型研究及系统设计

Research of the Report Data Model and System Design

针对报表系统对数据源的依赖问题,在对报表层次结构及生成技术分析的基础上,提出了基于表单、账户和限制条件的报表数据模型,运用面向对象的报表数据实现方法以及报表格式和报表数据分离的思想,封装数据库操作,完成数据读取和数据加工功能。基于JasperReport论述了报表系统的体系结构以及报表生成过程的关键技术,引入依赖注入的设计模式,应用Spring支撑框架所提供的功能实现报表格式的快速定制并增强系统的可复用性。最后介绍了报表系统的设计以及集成到ERP系统中的应用情况。

To solve the problems of the report system that highly dependent on the data source, based on the analysis of the report hierarchy and the export technology, the report data model which based on the bills, accounts and conditions is presented, it applies the method that isolates the data from the report format to encapsulate the database operation and realize the function of the read and the process. Report system architecture and the implementation technology of the data model are also illustrated based on the Jasper- Report. By using the design pattern of dependency injection and wiring hibernate transactions in Spring, the designed report system, which is both usable and high-reusable, can be easy customized its format. At last, the design method and successful application of the report system is discussed.