CN103853543A - Method used for quickly constructing forms in enterprise information system development process - Google Patents

Method used for quickly constructing forms in enterprise information system development process Download PDF

Info

Publication number
CN103853543A
CN103853543A CN 201210521801 CN201210521801A CN103853543A CN 103853543 A CN103853543 A CN 103853543A CN 201210521801 CN201210521801 CN 201210521801 CN 201210521801 A CN201210521801 A CN 201210521801A CN 103853543 A CN103853543 A CN 103853543A
Authority
CN
Grant status
Application
Patent type
Prior art keywords
form
data
table
page
forms
Prior art date
Application number
CN 201210521801
Other languages
Chinese (zh)
Other versions
CN103853543B (en )
Inventor
不公告发明人
Original Assignee
北京云天时空科技有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date

Links

Abstract

The invention discloses a method used for quickly constructing dynamic business forms in a J2EE (java 2 platform enterprise edition) enterprise information system development process, and belongs to the technology of the software middleware software in the technical field of electronic information. In form field UI (user interface) design, the HTML (hypertext markup language) dynamic template technology is adopted, and a form customization page and a form field customization page in a B/S (browser/server) mode are provided; form data is directly operated in a JDBC (java database connectivity) mode; after form customization is finished, a background automatic generation module generates table definition data to the whole form and the design requirement of the form field according to customization information, and the table definition data is stored in a background foundation database; when a foreground page displays data, a background uniform page template is used for dynamically taking truthful data from a corresponding entity table; the truthful data is displayed according to the table definition data. The method used for quickly constructing the form in the enterprise information system development process, which is disclosed by the invention, has the advantages of small code quantity and simple and efficient system; the system does not need to be restarted, practical effect can be immediately seen by the revision operation to the form field definition, the form customization efficiency can be improved, the development cost is lowered, a user can customize the form according to the self requirement, and the form can become effective in real time and can be applied.

Description

一种应用于企业信息系统开发过程中快速构建表单的方法 One kind of enterprise information systems used in the process of developing a method to quickly build forms

技术领域 FIELD

[0001] 本发明所属领域是电子信息技术-> 软件-> 中间件软件特别是涉及到表单生成技术 [0001] The present invention is relevant to the art of electronic information technology -> Software -> middleware particularly relates to a form Generation

背景技术 Background technique

[0002] 在大多数企业信息系统中,表单是系统和用户交互的基本接口,表单提供信息的展现及输入信息的接收,实现信息的收集、处理及流转,表单在企业信息系统中有着十分重要的地位。 [0002] In most enterprise information systems, the form is the basic interface system and user interaction, provide a form to receive input information presentation and information to achieve the collection, processing and circulation of information, the form has a very important enterprise information system status. 在企业信息系统的开发过程中,需处理的表单数量众多、种类繁杂;在企业信息系统的使用过程中,随企业生产流程的变更,表单又表现出很强的易变动性。 During development of enterprise information systems, the large number of forms to be processed, the type of complex; in the course of enterprise information systems, with the production process changes, the form and show a strong and easy volatility. 以上两点给企业系统的开发人员带来很大的挑战,能否快速构建表单和及时有效变更表单,在很大程度上决定了企业系统的开发进度和质量。 The above two points to developers of enterprise systems has brought great challenges, the ability to quickly build forms and timely and effective change form, largely determines the development progress and quality of enterprise systems. 为解决上述问题,我们提出了动态表单构建方法。 To solve these problems, we propose a method for constructing dynamic forms.

[0003]目前已有的表单构建方法一般采用在线自定义表单的方法,该方法描述如下: 提供由JavaScript脚本语言实现的表单定制页面,利用鼠标拖拽方式,在页面上用系 [0003] At present, construction methods commonly used form of online custom form, the method is described as follows: to provide custom form page implemented by the JavaScript scripting language, use the mouse drag and drop, in line with the page

统提供的控件构建表单;页面构建完成后,为每页表单生成相应的一整套HTML页面代码、后台控制代码Action/Struts和Dao/Hibernate (业务逻辑层)业务代码及Spring等配置文件。 Construction of control system provides a form; constructed after the completion of the page, generating a corresponding set of HTML pages per code for the form, the background control codes Action / Struts and Dao / Hibernate (business logic), and service code Spring like profile. 整套页面需要重新部署才能生效。 The entire page need to be redeployed to take effect.

[0004]优点: [0004] The advantages:

1、可视化设计——所见即所得 1, visual design - WYSIWYG

2、易于使用,可以快速生成表单 2, easy to use, you can quickly generate form

3、控件种类齐全,交互性好 3, the control range, good interaction

4、开发要求低缺点: 4, low development requirements Disadvantages:

1、表单相关定义文件数量繁多、冗余 1, the vast amount of relevant form definition file redundancy

2、不能满足表单信息项的变化 2, can not meet the changing form information items

3、表单数据繁杂、无规律 3, complex form data, irregular

4、表单定制效率低、开发成本高 4, low form customization efficiency and high development costs

5、必须重启系统,表单才能生效。 5, you must restart the system, the form to take effect.

发明内容 SUMMARY

[0005] 表单的快速定制 [0005] Forms of rapid customization

提供B/S方式的表单定制页面和表单域定制页面,定制表单及表单域的基本参数,包括页面显示选项、jquery脚本校验选项、数据源选择、输出页面格式及是否支持缓存等表单要素。 Providing B / S mode form fields and forms customized page customized page, the basic parameters of custom forms and form fields, page including display options, jQuery script verification options, data source selecting, page format, and output caching form support elements.

[0006] 表单与后台业务模块的集成 [0006] forms with back-business integration module

在表单定制过程中,除了可灵活自定义常规的表单类型外,还可以与后台的业务功能模块紧密衔接,调用后台的短信、彩信传输模块,实现一定的短彩信业务逻辑。 In the form customization process, in addition flexibility to customize conventional form types, you can also closely co-ordinated with back-office business function module is called SMS background, MMS transmission module, to achieve a certain degree of short multimedia business logic. [0007] 表单的数据库存储 [0007] Forms database storage

完成表单定制后,后台自动生成模块,根据定制信息对整个表单及对表单域的设计要求生成表定义数据,并存放在后台基础数据库中。 After completion of the form customization, automatically in the background generation module, according to the form and the customization information to the entire design of the form field table definition data requirements, and deposited in the background underlying database.

[0008] 表单的动态变更 [0008] dynamically change form

所有定制表单的操作立即生效,即使实体表里有数据的时候也可以动态修改表单和表单域的定义,系统不需要重启,对表单域定义的修改操作可以立即看到实际效果。 All custom form's action takes effect immediately, even if the entity table data, they also can dynamically modify the definition of forms and form fields, the system without rebooting, modify the operation of the form field definitions can see the actual effect immediately.

[0009] 表单的统一展现 [0009] form a unified show

前台页面显示数据时,使用后台统一的页面模板,从对应的实体表中动态取出真实数据,根据表定义数据显示。 When the front page display data, using a uniform background page templates, dynamic real data taken from the corresponding entity table, according to the display table definition data. 所有对数据表的读写操作采用JDBC的方式直接操作数据库以达到高效的目的。 All read and write operations on the data table of directly using JDBC database operations in order to achieve efficient purpose.

[0010] 表单的缓存读取 [0010] Form cache reads

表单定义数据在系统启动时一次性装入系统缓存中,当有动态修改表单定义需求时,系统会先更新到数据库表对应的表定义,再同步到系统缓存,接下来所有对动态表的操作都会先读取缓存中的表定义数据,以提升表单处理性能。 Form definition data loaded at system boot-time cache system, when there is demand to dynamically modify the form definition, the system will be updated to the database table corresponding to the table definition, and then synchronized to the system cache, all subsequent operations on the dynamic table will first read the table definition data cache to improve the processing performance of the form.

[0011 ] 本技术发明优点总结: [0011] A technical advantage of the present invention are summarized:

1、整个定制过程随时修改、及时生效,系统不用重启即可看到效果。 1, the entire customization process modified at any time, in time to take effect, the system does not restart to see the effect.

[0012] 2、即使在表单里存在业务数据时也可动态修改表单的定义,最大程度上保证数据不丢失。 [0012] 2, may be defined dynamically modified form even if the traffic exists in the form of data, to ensure that the maximum degree of data loss.

[0013] 3、采用HTML动态模板技术,所有表单共用一套展现代码,代码量小。 [0013] 3, using dynamic HTML template technology, all forms show a common code and a small amount of code.

[0014] 4、利用JDBC方式直接操作表单数据,系统简单、高效。 [0014] 4, using JDBC directly form operation data, the system is simple and efficient.

附图说明 BRIEF DESCRIPTION

[0015] 图1是本发明动态表单构建结构示意图。 [0015] FIG. 1 is a schematic structural diagram of the present invention forms a dynamic construct.

具体实施方式 detailed description

[0016] 表单定制步骤: [0016] form customization steps:

在表单定制页面定制整个表单(Form)及对应域(Field)的基本属性.点击确定按钮提交到后台处理模块。 In the basic properties of form customization page customization entire form (Form) and the corresponding domain (Field) in. Click the OK button to submit background processing module.

[0017] 根据用户定义在系统HTML模板库及JQuery脚本库中生成表单域(Field)对应的相关HTML源码片断,将表单定义信息存入相关表.(tb_form, tb_form_conf , tb_form_field)。 [0017] The user defined in the system to generate the HTML template database and script library JQuery form fields (Field) corresponds to the relevant HTML source code fragment, the correlation table is stored in the form definition information. (Tb_form, tb_form_conf, tb_form_field).

[0018] 系统的SQL分析器生成与表单对应的SQL建表语句,利用JDBC方式生成动态表单数据存储表。 [0018] SQL parser generator systems with a form corresponding SQL statements to build the table, dynamically generated using JDBC data storage table form.

[0019] 表单显示步骤: [0019] Form display step:

后台采用统一的4个页面模板:list.html (列表页模板),add.html (添加页模板);edit, html (修改页模板),view, html (查看页模板),以列表页模板(list, html)为例,数据的显示过程如下: Background unified 4 page templates: list.html (list page template), add.html (add a page template); edit, html (Modify page template), view, html (see page template) to the list of page templates ( list, html) as an example, the data display process is as follows:

I).利用JDBC 方式从表单定义相关表(tb_form, tb_form_conf , tb_form_field)中读出列表页面上要显示的具体域(Field)的相关列信息,包括:列名、中文名、排序参数,封装成一个查询用的SQL语句。 I) using JDBC define correlation table (tb_form, tb_form_conf, tb_form_field) reads out the relevant sequence information specific field (Field) is on the list page to be displayed, from the form: column name, Chinese name, the sort parameter, packaged into SQL statement with a query.

[0020] 2).利用JDBC方式查询真实的动态表单数据存储返回对应的分页数据集变量pageList。 [0020] 2) Using the actual dynamic query JDBC embodiment form data corresponding to the page dataset returned pageList variable.

[0021] 3).list, html页面模板会循环处理pageList变量中的数据显示。 [0021] 3) .list, html page template data processing cycle pageList variable display.

[0022] [0022]

3.主要类及方法说明: 3. The main class and method descriptions:

DynamicFormAct.java:动态表单Action动作控制器:负责页面请求的跳转处理,调用DynamicFormService.java类中相应的方法完成业务数据的请求处理过程。 DynamicFormAct.java: Action Action Controller dynamic form: page request is responsible for jump processing, call the appropriate request processing method to complete service data DynamicFormService.java class.

[0023] DynamicFormService.java:动态表单业务控制层:负责业务请求的封装,并调用DynamicFormDa0.java 类操作数据库。 [0023] DynamicFormService.java: dynamic form the service control layer: a package is responsible for the service request, and calls the class DynamicFormDa0.java database operation.

[0024] DynamicFormDa0.java:动态表单涉及到的所有JDBC操作封装DAO层。 [0024] DynamicFormDa0.java: dynamic form all involved operations JDBC DAO encapsulation layer.

[0025] 其中DynamicFormAct.java类的主要方法说明如下: [0025] The method wherein the main class DynamicFormAct.java follows:

public String list O查询数据方法:提供页面上的列表显示,处理方式如下: public String list O data query method: provide a list on the page display, processing as follows:

I)调用DynamicFormService.java 类的queryFormByField O 方法定位到Form 表单对象,并获取Field表单域的相关定义信息。 I) Method call queryFormByField O DynamicFormService.java target class Form form objects, and access to relevant fields of the form definition information Field.

[0026] 2)调用getSearchKeys O方法组装页面上Request查询请求里传过来的参数和值到指定的Map变量queryMap里。 Map queryMap Request query request in the variable pass over the parameter values ​​and [0026] 2) The method of assembling getSearchKeys O call to the specified page's.

[0027] 3) 封装必要的分页,排序等查询参数,调用DynamicFormService.java类中的search O 方法。 [0027] 3) the necessary package tab, sorting query parameters, the method calls the search O DynamicFormService.java class.

[0028] 4) 最后调用DynamicFormDa0.java类的search O方法根据queryMap里的查询条件结合表单定义信息拼装成对应的SQL查询语句,执行数据库查询操作并返回列表格式的分页数据。 [0028] 4) Finally, the method calls the search O DynamicFormDa0.java class binding form definition information according to the query criteria in queryMap assembled to the corresponding SQL query, performs a database query and returns the page data list format.

[0029] 数据库表结构设计。 [0029] Design of the database table structure.

[0030] I).表单基本信息配置表:tb_form . [0030] I) form the basic configuration information table: tb_form

用来存储表单的基本信息,其中关键字段如下: Basic form for storing information, wherein the key fields as follows:

db_type:数据库类型:支持Oracle, SQL Server, DB2, Mysql等常见数据库类型。 db_type: Database Type: Support for common database type Oracle, SQL Server, DB2, Mysql and so on.

[0031] module_name:表单所属的模块名: [0031] module_name: Form belongs module name:

tb_name:数据存储表单的真实名字:形如d_xxxxxxxxxx_tb,是由系统自动生成唯一的名字,其中xxxxxxxxxx表示系统生成的唯一序号。 tb_name: real name data stored in the form: the form d_xxxxxxxxxx_tb, unique name is automatically generated by the system, which represents a unique serial number xxxxxxxxxx system-generated.

[0032] 其中,“ tb_name ”字段有着重要的作用,通过该字段的信息我们才能将表单中信息与其具体含义对应起来。 [0032] where, "tb_name" field has an important role in this field through the information that we can be in the form of information and its association with specific meanings.

[0033] 2).表单详细配置表:tb_form_conf [0033] 2) Detailed configuration table form: tb_form_conf

以key:value的方式存储的表单业务相关配置:包括表单数据源配置,消息模板配置,及缓存配置。 In key: value of the stored service configuration forms: the form includes a data source configured message template configuration, and cache configuration.

[0034] 3).表单域配置子表:tb_form_field [0034] 3) Form a sub domain configuration table: tb_form_field

用来存放表单数据存储表中的列的具体含义。 Used to store the specific meaning of the form data stored in the columns in the table. 包括列的基本数据类型,长度,列名,中文显示名,默认值等。 The basic data types including column length, column name, Chinese display name, default values, etc. 其中关键字段如下:add_html:对应到添加页面的HTML片断edit_html:对应到修改页面的HTML片断view_html:对应到查看页面的HTML片断 In which the key fields as follows: add_html: corresponds to HTML snippet edit_html Add the page: corresponds to modify the HTML snippet view_html page: HTML fragment corresponds to viewing the page

通过页面上定制的表单域(Field)的详细配置,系统生成相对应的HTML源码片断保存到数据库中,由这三个字段决定表单域(Field)的具体显示效果。 Detailed configuration page customized by the form fields (Field), the system generates an HTML source code stored fragment corresponding to a database, display specific form fields (Field) is determined by the three fields.

[0035] 4).表单数据存储表,例如:d_20111224134000673_tb 是动态表单数据的具体存储表。 [0035] 4) data storage table form, for example:. D_20111224134000673_tb specific dynamic storage table form data.

Claims (1)

  1. 1.一种应用于企业信息系统开发过程中快速构建动表单的方法,在包括表单的快速定制、表单与后台业务模块的集成、表单的数据库存储、表单的动态变更、表单的统一展现、表单的缓存读取,其特征在于:用下述方法实现表单的动态快速的构建: (1)提供B/S方式的表单定制页面和表单域定制页面,定制表单及表单域的基本参数,包括页面显示选项、jquery脚本校验选项、数据源选择、输出页面格式及是否支持缓存等表单要素; (2)在表单定制过程中,除了可灵活自定义常规的表单类型外,还可以与后台的业务功能模块紧密衔接,调用后台的短信、彩信传输模块,实现一定的短彩信业务逻辑; (3)完成表单定制后,后台自动生成模块儿根据定制信息对整个表单及对表单域的设计要求生成表定义数据,并存放在后台基础数据库中; (4)所有定制表单的操作立即 An enterprise information system used in the process of developing a method to quickly build dynamic forms, including in the form of rapid customization, forms and back-office business integration module, forms, database storage, dynamic change form, the form of unified show, form read cache, wherein: a dynamic rapid build forms implemented by the following methods: (1) providing a forms and form fields customized page customized page, the basic parameters of custom forms and form fields B / S mode, including page display options, jquery script check option, select the data source, the output page format and supports caching and other form factors; (2) in the form customization process, in addition to the flexibility to customize the form of conventional type, but also with the business background function module closely together, call back SMS, MMS transmission module, certain short MMS logic; (3) complete the form custom background automatically generating module children according to the customized information for the entire form and design of the form fields required to generate the table define the data and store it in the background underlying database; (4) all custom form's action immediately 效,即使实体表里有数据的时候也可以动态修改表单和表单域的定义,系统不需要重启,对表单域定义的修改操作可以立即看到实际效果; (5)前台页面显示数据时,使用后台统一的页面模板,从对应的实体表中动态取出真实数据,根据表定义数据显示,所有对数据表的读写操作采用JDBC的方式直接操作数据库以达到闻效的目的; (6)表单定义数据在系统启动时一次性装入系统缓存中,当有动态修改表单定义需求时,系统会先更新到数据库表对应的表定义,再同步到系统缓存,接下来所有对动态表的操作都会先读取缓存中的表定义数据,以提升表单处理性能。 Effect, even when the data entity table may be dynamically modified forms and form field definitions, without rebooting the system, modify the operation form field definitions can immediately see the actual results; (5) the front page display data, using background uniform page template and dynamic data taken from the corresponding real entity table, according to table definition data, all read and write operations on the data table directly using JDBC database operations in order to achieve effective smell; (6) form definition at system start-time data into the system cache, when a demand to dynamically modify the form definition, the system will be updated to the database table corresponding to the table definition, and then synchronized to the system cache, all subsequent operations will first dynamic table read the table definition data cache to improve the processing performance of the form.
CN 201210521801 2012-12-07 2012-12-07 One kind of enterprise information systems used in the process of developing a method to quickly build forms CN103853543B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 201210521801 CN103853543B (en) 2012-12-07 2012-12-07 One kind of enterprise information systems used in the process of developing a method to quickly build forms

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 201210521801 CN103853543B (en) 2012-12-07 2012-12-07 One kind of enterprise information systems used in the process of developing a method to quickly build forms

Publications (2)

Publication Number Publication Date
CN103853543A true true CN103853543A (en) 2014-06-11
CN103853543B CN103853543B (en) 2017-08-08

Family

ID=50861245

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 201210521801 CN103853543B (en) 2012-12-07 2012-12-07 One kind of enterprise information systems used in the process of developing a method to quickly build forms

Country Status (1)

Country Link
CN (1) CN103853543B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105589959A (en) * 2015-12-22 2016-05-18 北京京东尚科信息技术有限公司 Form processing method and form processing system
CN106126569B (en) * 2016-06-17 2018-06-12 南京乐运乐科技有限公司 Kind of method and system for fast data services

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7596564B1 (en) * 2000-09-29 2009-09-29 Vignette Corporation Method and system for cache management of a cache including dynamically-generated content
CN101685393A (en) * 2008-08-20 2010-03-31 大唐软件技术股份有限公司 Method and system for realizing interface dynamic customization and generation
CN102063306A (en) * 2011-01-06 2011-05-18 夏春秋 Technical implementation method for application development through electronic form

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7596564B1 (en) * 2000-09-29 2009-09-29 Vignette Corporation Method and system for cache management of a cache including dynamically-generated content
CN101685393A (en) * 2008-08-20 2010-03-31 大唐软件技术股份有限公司 Method and system for realizing interface dynamic customization and generation
CN102063306A (en) * 2011-01-06 2011-05-18 夏春秋 Technical implementation method for application development through electronic form

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105589959A (en) * 2015-12-22 2016-05-18 北京京东尚科信息技术有限公司 Form processing method and form processing system
CN106126569B (en) * 2016-06-17 2018-06-12 南京乐运乐科技有限公司 Kind of method and system for fast data services

Also Published As

Publication number Publication date Type
CN103853543B (en) 2017-08-08 grant

Similar Documents

Publication Publication Date Title
Di Lorenzo et al. Data integration in mashups
US20120284664A1 (en) Caching intermediate data for scroll view rendering
US20100251143A1 (en) Method, system and computer program for creating and editing a website
US8812625B1 (en) Tracking changes in on-line spreadsheet
US20080307301A1 (en) Web Clip Using Anchoring
US20100037150A1 (en) Synchronous to Asynchronous Web Page Conversion
US20110087708A1 (en) Business object based operational reporting and analysis
US20100293523A1 (en) Development environment configured to generate application source code from database objects
CN101216817A (en) Heterogeneous report form integration and centralized management device and system
US20120102095A1 (en) Templates For Displaying Data
US20100161713A1 (en) Method and system for personalizing a desktop widget
CN101477462A (en) Model-driven software development method used for dynamically changing system behavior
CN103135976A (en) Code automatic generation method and device
CN102063306A (en) Technical implementation method for application development through electronic form
US20140033015A1 (en) Comment presentation in electronic documents
US20060020608A1 (en) Cube update tool
CN101908040A (en) Data report system
US20140033013A1 (en) Document comment management
US20130091419A1 (en) Contextual commenting on the web
US20150074513A1 (en) Webpage Browsing Method, Webapp Framework, Method and Device for Executing Javascript and Mobile Terminal
CN101788994A (en) Method for constructing data display model and method and device for displaying data
CN102325191A (en) Fully automatic treatment method and frame without page refresh
US8788935B1 (en) Systems and methods for creating or updating an application using website content
US20070300145A1 (en) Method and system to persist state
CN102646039A (en) Software interface generating system and method based on extensible markup language (XML) Schema

Legal Events

Date Code Title Description
C06 Publication
C10 Entry into substantive examination
GR01