CN103853543B - A kind of method for being applied to rapid build list in enterprise information system development process - Google Patents
A kind of method for being applied to rapid build list in enterprise information system development process Download PDFInfo
- Publication number
- CN103853543B CN103853543B CN201210521801.3A CN201210521801A CN103853543B CN 103853543 B CN103853543 B CN 103853543B CN 201210521801 A CN201210521801 A CN 201210521801A CN 103853543 B CN103853543 B CN 103853543B
- Authority
- CN
- China
- Prior art keywords
- list
- data
- page
- html
- backstage
- Prior art date
- Legal status (The legal status 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 status listed.)
- Expired - Fee Related
Links
Abstract
The invention discloses a kind of method for being applied to rapid build dynamic service list in J2EE enterprise information system development processes, the invention belongs to electronic information technical field software middleware software engineering.It is in form fields UI designs, using HTML dynamic analog platemaking technologies, the form customization page and form fields customized web page of B/S modes are provided, form data is directly operated using JDBC modes, complete after form customization, backstage automatically-generating module youngster defines data according to customized information to whole list and to the design requirement generation table of form fields, and be stored in the basic database of backstage, during front page layout display data, use the Page Template that backstage is unified, True Data is dynamically taken out from corresponding entity table, data display is defined according to table.The present invention has size of code small, simple system, efficiently, system need not restart, the modification operation defined to form fields can promptly appreciate that the advantage of actual effect, can lift the customization efficiency of list, reduce development cost, user is at any time according to customized form the need for itself, and take effect and apply in real time.
Description
Technical field
Art of the present invention be electronic information technology->Software->Middleware software especially relates to list generation skill
Art
Background technology
In most enterprises information system, list is the basic interface of system and user mutual, and list provides information
Show and input the reception of information, realize the collection, processing and circulation of information, list has very heavy in enterprise information system
The status wanted.In the development process of enterprise information system, the list that need to handle is large number of, broad categories；In company information
During the use of system, with the change of enterprise's production procedure, list shows very strong easy mobility again.2 points of the above is to enterprise
The developer of industry system brings very big challenge, can rapid build list and timely and effective change list, largely
On determine the development progress and quality of business system.To solve the above problems, we have proposed dynamic list construction method.
The method that current existing list construction method typically uses online customizing form, this method is described as follows：
The form customization page realized by JavaScript scripts is provided, using mouse drag mode, on the page
The control provided with system builds list；It it is every a whole set of corresponding html page generation of page table list generation after the completion of page makeup
The configuration such as code, Background control code Action/Struts and Dao/Hibernate (Business Logic) service code and Spring
File.The a whole set of page needs to redeploy just come into force.
Advantage：
1st, the visual design --- -- What You See Is What You Get
2nd, it is easy to use, list can be quickly generated
3rd, control A wide selection of colours and designs, interactivity is good
4th, exploitation requires low
Shortcoming：
1st, list related definition quantity of documents is various, redundancy
2nd, the change of form information can not be met
3rd, form data is numerous and diverse, irregular
4th, form customization efficiency is low, development cost is high
5th, system must be restarted, list can just come into force.
The content of the invention
The fast custom of list
The basic parameter of the form customization page and form fields customized web page of B/S modes, customized form and form fields is provided,
Option, jquery scripts verification option, data source capability, output page formatting are shown including the page and whether support the tables such as caching
Single key element.
List is integrated with Batch Processing module
During form customization, except can be in addition to the conventional form types of flexibly customizing, business that can also be with backstage
Functional module is closely connected, and calls short message, the multimedia message transport module on backstage, realizes certain short MMS logic.
The database purchase of list
Complete after form customization, backstage automatically-generating module, to whole list and form fields are set according to customized information
Meter requires that generation table defines data, and is stored in the basic database of backstage.
The dynamic change of list
The operation of all customized forms is come into force, and list can also be dynamically changed when data even if having in entity table
With the definition of form fields, system need not restart, and the modification operation defined to form fields can promptly appreciate that actual effect.
List uniformly shows
During front page layout display data, using the Page Template that backstage is unified, dynamically take out true from corresponding entity table
Real data, data display is defined according to table.All read-write operations to tables of data by the way of JDBC immediate operand according to storehouse
To reach efficient purpose.
The caching of list is read
Form definition data are disposably fitted into system cache when system starts, and form definition demand is changed when there is dynamic
When, system can first update the corresponding table definition of database table, be re-synchronised to system cache, following all behaviour to dynamic table
The table for making all can first read in caching defines data, to lift sheet disposal performance.
This technology invention advantage is summarized：
1st, whole customization procedure is changed, come into force in time at any time, and system is without restarting i.e. it can be seen that effect.
Also the definition of list can be dynamically changed when the 2nd, there is business datum in list, at utmost
Upper guarantee data are not lost.
3rd, using HTML dynamic template technologies, all lists share it is a set of show code, size of code is small.
4th, form data is directly operated using JDBC modes, simple system, efficiently.
Brief description of the drawings
Fig. 1 is that dynamic list of the present invention builds structural representation.
Embodiment
Form customization step：
In the whole list of form customization page customization (Form) and corresponding domain（Field）Base attribute click on determination press
Button is submitted to background processing module.
It is defined on according to user in system html template storehouse and JQuery script banks and generates form fields（Field）Corresponding phase
Html source code segment is closed, form definition information is stored in correlation table (tb_form, tb_form_conf, tb_form_
field)。
The SQL parser of system generates SQL corresponding with list and builds table statement, and dynamic list is generated using JDBC modes
Table data store.
List step display：
Backstage is using 4 unified Page Templates：List.html (list page template), add.html (addition page template);
Edit.html (modification page template), view.html (checks a page template), by taking list page template (list.html) as an example, data
Display process it is as follows：
1) utilizes JDBC modes from form definition correlation table (tb_form, tb_form_conf, tb_form_
Field the particular domain to be shown on original list is read in)（Field）Related column information, including：Row name, Chinese name, sequence
Parameter, is packaged into the SQL statement of an inquiry.
2) inquires about real dynamic list table data store d_xxxxxxxxxx_tb using JDBC modes, returns to correspondence
Paged data collection variable pageList.
3) data display in .list.html Page Templates meeting circular treatment pageList variables.
3. main class and method explanation：
DynamicFormAct.java：Dynamic list Action movement controllers：That is responsible for page request redirects processing,
Call the request processing procedure of corresponding method finishing service data in DynamicFormService.java classes.
DynamicFormService.java:Dynamic list service control layer：It is responsible for the encapsulation of service request, and calls
DynamicFormDao.java generic operation databases.
DynamicFormDao.java：DAO layers of all JDBC operations encapsulation that dynamic list is related to.
The main method of wherein DynamicFormAct.java classes is described as follows：
Public String list () inquire about data method：The list display on the page is provided, processing mode is as follows：
1) queryFormByField () method of DynamicFormService.java classes is called to navigate to Form lists
Object, and obtain the related definition information of Field form fields.
2) getSearchKeys () method is called to assemble the parameter and value for being transmitted through coming in Request inquiry requests on the page
To in the Map variables queryMap specified.
3) necessary paging is encapsulated, the query argument such as sequence is called in DynamicFormService.java classes
Search () method.
4) the search () method of DynamicFormDao.java classes is finally called according to the querying condition in queryMap
Corresponding SQL query statement is assembled into reference to form definition information, database query operations is performed and returns to point of listings format
Page data.
Database table structure is designed.
1) lists essential information allocation list：tb_form
For storing the essential information of list, wherein critical field is as follows：
db_type：Type of database：The Common database classes such as support Oracle, SQL Server, DB2, Mysql
Type.
module_name：Module name belonging to list：
tb_name：The real name of data storage list：Shape such as d_xxxxxxxxxx_tb, is automatically generated by system
Unique name, wherein xxxxxxxxxx represents the unique serial number of system generation.
Wherein, " tb_name " field plays the role of important, and by the information of the field, we could be by information in list
It is mapped with its concrete meaning.
2) lists detailed configuration table：tb_form_conf
With key:The forms traffic relevant configuration that value mode is stored：Including the configuration of form data source, source template is matched somebody with somebody
Put, and cached configuration.
3) lists configuration of territory sublist：tb_form_field
For depositing the concrete meaning of the row in form data storage table.Basic data type including row, length, row
Name, Chinese display name, default value etc..Wherein critical field is as follows:
add_html ：Correspond to the HTML segments of the addition page
edit_html ：Correspond to the HTML segments of the modification page
view_html：Correspond to the HTML segments for checking the page
Pass through the form fields customized on the page（Field）Detailed configuration, system generates corresponding html source code segment
It is saved in database, form fields is determined by these three fields（Field）Be particularly shown effect.
4) form datas storage table, for example：d_20111224134000673_tb
It is the specific storage table of dynamic list data.
Claims (1)
1. it is a kind of be applied to enterprise information system development process in rapid build list method, including list fast custom,
The dynamic change of integrated, list the database purchase, list of list and Batch Processing module, uniformly the showing of list, list
Caching read, it is characterised in that：Realize that the dynamic of list is quickly built with following methods：
1) basic parameter of the form customization page and form fields customized web page of B/S modes, customized form and form fields, bag are provided
Include following list key element：The page show option, jquery scripts verification option, data source capability, output page formatting and whether
Support caching；
2) during form customization, except can be in addition to the conventional form types of flexibly customizing, business work(that can also be with backstage
Energy module is closely connected, and calls short message, the multimedia message transport module on backstage, realizes short MMS logic；
3) complete after form customization, backstage automatically-generating module is wanted according to customized information to whole list and to the design of form fields
Seek survival into table and define data, and be stored in the basic database of backstage；
4) operation of all customized forms comes into force, even if having in entity table can also dynamically be changed when data list and
The definition of form fields, system need not restart, and the modification operation defined to form fields can promptly appreciate that actual effect；
5) during front page layout display data, using the Page Template that backstage is unified, dynamically take out true from corresponding entity table
Data, data display is defined according to table, all read-write operations to tables of data use JDBC mode immediate operand according to storehouse with
Reach efficient purpose；
6) form definition data are disposably fitted into system cache when system starts, and form definition demand is changed when there is dynamic
When, system can first update the corresponding table definition of database table, be re-synchronised to system cache, following all behaviour to dynamic table
The table for making all can first read in caching defines data, to lift sheet disposal performance；
More specifically, the method for rapid build list includes：
1st, form customization step：
In the whole list Form of form customization page customization and correspondence form fields Field base attribute, click on confirming button and carry
It is sent to background processing module；
It is defined on according to user in system html template storehouse and JQuery script banks and generates the corresponding related HTML of form fields Field
Source code segment, correlation table is stored in by form definition information, including：Tb_form tables, tb_form_conf tables, tb_form_field
Table；
The SQL parser of system generates SQL corresponding with list and builds table statement, and generating dynamic list data using JDBC modes deposits
Store up table；
2nd, list step display：
Backstage is using 4 unified Page Templates：Respectively：List.html, i.e.,：List page template；Add.html, i.e.,：Addition
Page template；Edit.html, i.e.,：Modification page template, view.html, i.e.,：Check a page template；When using list page template
List.html, the display process of data is as follows：
1), using JDBC modes from form definition correlation table, i.e.,：Tb_form tables, tb_form_conf tables, tb_form_field
The related column information of the particular domain Field to be shown on original list is read in table, including：Row name, Chinese name, parameters sortnig,
It is packaged into the SQL statement of an inquiry；
2) real dynamic list table data store d_xxxxxxxxxx_tb, is inquired about using JDBC modes, corresponding paging is returned
Data collection variable pageList；
3), the data display in list.html Page Templates circular treatment pageList variables；
Wherein, in the method for rapid build list, use with lower class：
DynamicFormAct.java classes：Dynamic list Action movement controllers：It is responsible for the processing that redirects of page request, tune
With the request processing procedure of corresponding method finishing service data in DynamicFormService.java classes；
DynamicFormService.java classes：Dynamic list service control layer：It is responsible for the encapsulation of service request, and calls
DynamicFormDao.java generic operation databases；
DynamicFormDao.java classes：DAO layers of all JDBC operations encapsulation that dynamic list is related to；
Wherein, the method for DynamicFormAct.java classes is described as follows：
Public String list () inquire about data method：The list display on the page is provided, processing mode is as follows：
1) queryFormByField () method of DynamicFormService.java classes is called to navigate to Form lists pair
As, and obtain the related definition information of Field form fields；
2) getSearchKeys () method is called to assemble the parameter and value to finger for being transmitted through coming in Request inquiry requests on the page
In fixed Map variables queryMap；
3) necessary paging is encapsulated, sorting query parameter calls the search () sides in DynamicFormService.java classes
Method；
4) the search () method of DynamicFormDao.java classes is finally called to be combined according to the querying condition in queryMap
Form definition information is assembled into corresponding SQL query statement, performs database query operations and returns to the paging number of listings format
According to.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210521801.3A CN103853543B (en) | 2012-12-07 | 2012-12-07 | A kind of method for being applied to rapid build list in enterprise information system development process |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210521801.3A CN103853543B (en) | 2012-12-07 | 2012-12-07 | A kind of method for being applied to rapid build list in enterprise information system development process |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103853543A CN103853543A (en) | 2014-06-11 |
| CN103853543B true CN103853543B (en) | 2017-08-08 |
Family
ID=50861245
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210521801.3A Expired - Fee Related CN103853543B (en) | 2012-12-07 | 2012-12-07 | A kind of method for being applied to rapid build list in enterprise information system development process |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103853543B (en) |
Families Citing this family (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9772822B2 (en) * | 2015-03-16 | 2017-09-26 | Microsoft Technology Licensing, Llc | Visualization framework for customizable types in a development environment |
| CN105589959A (en) * | 2015-12-22 | 2016-05-18 | 北京京东尚科信息技术有限公司 | Form processing method and form processing system |
| CN105653509B (en) * | 2015-12-24 | 2019-04-26 | 北京经纬恒润科技有限公司 | A kind of document processing method and device |
| US20170212650A1 (en) * | 2016-01-22 | 2017-07-27 | Microsoft Technology Licensing, Llc | Dynamically optimizing user engagement |
| CN106126569B (en) * | 2016-06-17 | 2018-06-12 | 南京乐运乐科技有限公司 | A kind of rapid data method of servicing and system |
| CN107239285A (en) * | 2017-06-02 | 2017-10-10 | 山东浪潮通软信息科技有限公司 | A kind of document development approach and device, computer-readable recording medium and storage control |
| CN109542878B (en) * | 2018-11-21 | 2021-03-09 | 广州方硅信息技术有限公司 | List creation method and device |
| CN109558125A (en) * | 2018-12-17 | 2019-04-02 | 太原市高远时代科技有限公司 | A kind of implementation method improving general information management software development efficiency |
| CN111124405B (en) * | 2019-12-04 | 2023-11-17 | 浪潮软件股份有限公司 | Implementation method and system for online form design supporting front-end and back-end decoupling |
| CN111222310A (en) * | 2019-12-23 | 2020-06-02 | 福建亿能达信息技术股份有限公司 | Method and system for inputting and displaying irregular form |
| CN113050934B (en) * | 2019-12-26 | 2023-12-26 | 东软集团（上海）有限公司 | Form driving intelligent development method and device and storage medium |
| CN111580794A (en) * | 2020-05-06 | 2020-08-25 | 山东浪潮通软信息科技有限公司 | Method and device for creating business document in business management system |
| CN111625219A (en) * | 2020-05-22 | 2020-09-04 | 杭州指令集智能科技有限公司 | BO component processing method, device and equipment |
| CN112183573B (en) * | 2020-08-20 | 2023-05-05 | 中船重工(武汉)凌久高科有限公司 | Web application system design method based on cluster analysis and rich text |
| CN112099679B (en) * | 2020-08-30 | 2023-09-19 | 浪潮金融信息技术有限公司 | TTU function packaging method based on software configuration |
Citations (2)
| 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 |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102063306A (en) * | 2011-01-06 | 2011-05-18 | 夏春秋 | Technical implementation method for application development through electronic form |
-
2012
- 2012-12-07 CN CN201210521801.3A patent/CN103853543B/en not_active Expired - Fee Related
Patent Citations (2)
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103853543A (en) | 2014-06-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103853543B (en) | A kind of method for being applied to rapid build list in enterprise information system development process | |
| EP3435257B1 (en) | Metadata-based general request translator for distributed computer systems | |
| JP5065056B2 (en) | Method, computer program, and system for processing a workflow (integrating data management operations into a workflow system) | |
| CN100580662C (en) | Heterogeneous report form integration and centralized management device and system | |
| CN103279358B (en) | A kind of explanation type Service Component dynamic fixing method of Industry-oriented application | |
| CN103383645B (en) | Code generating method and system | |
| Carey | Data delivery in a service-oriented world: the bea aqualogic data services platform | |
| US9043750B2 (en) | Automated generation of two-tier mobile applications | |
| CN106873974A (en) | Smart code generates automotive engine system and method | |
| JP2005524138A (en) | Method, computer program, and computer for accessing data in a multi-data repository environment | |
| CN103226478A (en) | Method for automatically generating and using code | |
| US20100057764A1 (en) | Building custom dimension trees | |
| CN101611399A (en) | Webpage, website modeling and generation | |
| CN102129364A (en) | Method for embedding widget toolbar in application program and rapid widget accessing method | |
| US10614062B2 (en) | Data model extension generation | |
| CN103092589A (en) | SSH (Struts, Spring and Hibernate) frame based code automatic generation method | |
| CN101256650A (en) | Method and system for extracting enterprise data based on service entity | |
| CN102999563A (en) | Network resource semantic retrieval method and system based on resource description framework | |
| CN104317595A (en) | Background-push component-based graphical monitoring device based on SVG (scalable vector graphics) and operating method thereof | |
| CN108228762B (en) | Method and system for configuring master database universal templates | |
| CN100397397C (en) | XML data storage and access method based on relational database | |
| Daniel et al. | Advanced prefetching and caching of models with PrefetchML | |
| Jennings | Professional ADO. NET 3.5 with LINQ and the Entity Framework | |
| CN114371845A (en) | Form generation method and device | |
| CN103257855B (en) | A kind of disposal system based on MVC, disposal route and the application in beauty treatment software |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20170808 Termination date: 20171207 |