CAJ | 학술논문

设计并实现了一种基于XML和Excel技术的自定义动态报表系统，系统由数据层、业务层、定义层及展现层组成。其中数据层为任何能提供报表原始数据的数据源，如数据库、文本文件等；业务层的功能主要是解析配置文件，获取报表原始数据、组织提供报表数据给展现层，决定报表最终的处理方式（如打开、下载或者直接打印等）；定义层主要用于定义数据源的获取方式、连接类型、报表格式、打印信息等；展现层由Excel模板构成，可以包含文本、图形、控件等。该设计能使报表的实施和维护成本大幅降低，通过简单的配置即可满足多变的报表需求，具有极高的灵活性、易用性和实用性。
설계병실현료일충기우XML화Excel기술적자정의동태보표계통，계통유수거층、업무층、정의층급전현층조성。기중수거층위임하능제공보표원시수거적수거원，여수거고、문본문건등；업무층적공능주요시해석배치문건，획취보표원시수거、조직제공보표수거급전현층，결정보표최종적처리방식（여타개、하재혹자직접타인등）；정의층주요용우정의수거원적획취방식、련접류형、보표격식、타인신식등；전현층유Excel모판구성，가이포함문본、도형、공건등。해설계능사보표적실시화유호성본대폭강저，통과간단적배치즉가만족다변적보표수구，구유겁고적령활성、역용성화실용성。
Based on XML and EXcelltechnology , this paper designs and implements a custom dynamic report system.The system is composed of data layer , business layer , definition layer and presentation layer .The data layer can provide statements of original data source , such as database , text file.The main function of business layer is parsing configuration files , obtaining statements , providing original data report data to the presentation layer , and deciding the final processing way such as open , download or print .Definition layer is mainly used for the definition of source data acquisition mode , link type, report format, print information.Presentation layer consists of EXcelltemplates , which can contain text , graphics, controls.The design significantly reduces imple-mentation and maintenance costs of statements , and variable reporting requirements can be met by a simple con-figuration.The design has high flexibility , ease of use and practicality .