基于XML配置的动态数据查询技术  

Dynamic Data Query Technology Based on XML

作　　者：江日念 许锟 林霞[1] JIANG Ri-Nian;XU Kun;LIN Xia(Department of Computer Application Technology, Research Institute of Petroleum Exploration & Development, Beijing 100083, China)

机构地区：[1]中国石油勘探开发研究院计算机应用技术研究所

出　　处：《计算机系统应用》2019年第8期148-154,共7页Computer Systems & Applications

摘　　要：针对信息系统中静态数据列表开发效率低下和不能满足用户定制化需求的问题,提出基于XML配置的动态数据查询技术.首先通过Apache Digester解析表单的XML结构化配置,将实例化的配置信息交由动态查询引擎处理,动态查询引擎结合配置信息通过SQL、HQL、接口查询获取数据.最后将配置和数据以JSON格式传给客户端处理,以二次封装改进的dhtmlxGrid表格控件展示,形成动态数据列表.该动态查询技术已在多个系统中应用,应用效果证明,其显著提高了软件研发效率,能够满足组合查询定制、数据列自定义、数据列渲染、数据范围控制等各种定制需求.As the static data table in the information system has a low efficiency in development and cannot be changed according to customized requirements, this study proposes a dynamic query technology based on XML configurations. First of all, digester reads the instantiated configuration information from XML which will be handled by the dynamic query engine. Secondly, the dynamic query engine combined with XML configuration obtains the dataset by SQL, HQL, or interface. Finally, the configuration and dataset are transmitted to clients in the form of JSON and shown by improved dhtmlxGrid. After the above steps, the dynamic data table is formed. The technology is applied to the scientific research management system and human resource information system. The application results prove that this technology significantly improves the development efficiency and meets all kinds of customized requirements such as combination-conditions query customization, data column customization, data column rendering, and data range control.

关 键 词：DIGESTER 动态查询引擎 dhtmlxGrid 组合查询定制 数据范围控制 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]