CN114461633A

CN114461633A - Application development tool system

Info

Publication number: CN114461633A
Application number: CN202011240151.6A
Authority: CN
Inventors: 高裕金; 谢建云
Original assignee: Shanghai Internet Software Group Co ltd
Current assignee: Shanghai Internet Software Group Co ltd
Priority date: 2020-11-09
Filing date: 2020-11-09
Publication date: 2022-05-10

Abstract

The invention discloses an application development tool system, which comprises a data management module and a form management module; the data management module is used for managing a data structure, a data relation and a database; the data management module comprises: the device comprises a data structure management unit, a data table generation unit, a data table mapping unit, a table name mapping unit and a table field information mapping unit; the form management module is used for managing forms and comprises form element management, list management and query management; the form management module comprises: the system comprises a data form correlation unit, a form modification unit, a data list correlation unit, a list query unit and a table relation mapping unit. The application development tool system provided by the invention can automatically generate the software system according to the setting, and the generation efficiency of the software system is improved.

Description

Application development tool system

Technical Field

The invention belongs to the technical field of software, relates to a software system, and particularly relates to an application development tool system.

Background

The development of information technology application innovation (innovation) is a current national strategy and is also a new kinetic energy of national economic development under the current situation. The industry designed by the letter creation comprises IT basic setting: CPU chip, server, storage, switch, router, various clouds and relevant service content, basic software: database, operating system, middleware, application software: OA, ERP, office software, government applications, etc.

Due to localization of the whole information, many original application software cannot be normally used. If the original office system is developed based on windows +. net + sqlserver, the system cannot be normally used in a domestic environment. According to normal processing, related developers are arranged to redevelop the system from beginning to end, and the system can be ensured to be normally used in a localization environment.

However, this processing mode has many problems, such as the system needs to be compatible with several operating systems, support several CPUs, integrate several middleware, etc.; how the system can deal with the real-time change of the business requirement, quickly respond to the requirement of a client and the like; how to quickly complete the replacement of all relevant systems in a limited time, and the like.

In view of the above, there is an urgent need to design a new modeling method to overcome at least some of the above-mentioned disadvantages of the existing modeling methods.

Disclosure of Invention

The invention provides an application development tool system, which can automatically generate a software system according to setting and improve the generation efficiency of the software system.

In order to solve the technical problem, according to one aspect of the present invention, the following technical solutions are adopted:

an application development tool system, the application development tool system comprising: the data management module and the form management module;

the data management module is used for managing a data structure, a data relation and a database; the data management module comprises:

the data structure management unit is used for managing the data structure and setting the data type of each data;

the data table generating unit is used for selecting the set data table template and setting the data type and the data length of each field in the data table through the data table template;

a data table mapping unit for mapping the data with the setting data table so that the adjustment of the setting data is associated with the corresponding data table;

the table name mapping unit is used for completing the mapping of the data table names so as to associate the adjustment of the set data with the corresponding data tables;

the table field information mapping unit is used for finishing mapping the data table field information;

the form management module is used for managing forms and comprises form element management, list management and query management; the form management module comprises:

the data form association unit is used for associating the data with the setting form;

the form modification unit is used for modifying the data in the forms, acquiring the mapping relation between each form and the data in the corresponding data table, and correspondingly modifying the data in the corresponding data table;

the data list association unit is used for mapping the data and the setting list;

the list inquiry unit is used for finishing the inquiry of the list;

the table relation mapping unit is used for completing the mapping of the data table relation;

as an embodiment of the present invention, the application development tool system further includes a process management module, configured to manage processes, including managing process approval sheets, process configuration, and task configuration;

the flow management module comprises:

the management process approval list unit is used for managing the process approval list;

the flow configuration unit is used for configuring flow information;

the task configuration unit is used for configuring the tasks.

As an embodiment of the present invention, the application development tool system further includes:

the script generation module is used for automatically generating script information according to the operation of a user;

the script information table module is used for storing each script information in a script information table;

the function information table module is used for storing the function information in the function information table;

the code generation module is used for generating a corresponding code according to the setting operation of the user;

the business process interaction module is used for realizing the association between the business data and the form;

and the form list linkage module is used for realizing linkage of the form and the list.

As an embodiment of the present invention, the application development tool system further includes a function creation module, configured to create functions including adding data, a data list, querying data, and approving tasks.

As an embodiment of the present invention, the application development tool system further includes an application creation module, configured to create an application, including setting an application name, a unit to which the application belongs, and selecting an application icon.

The invention has the beneficial effects that: the application development tool system provided by the invention can automatically generate the software system according to the setting, and the generation efficiency of the software system is improved.

The invention can complete the development of the application program without programming, and reduces the requirement on the professional technical ability of related personnel, thereby reducing the resource cost; the system configured by the invention can quickly change related services, thereby reducing the time cost; the system configured by the system can quickly enable a user to experience the system with another appearance, so that more complete requirements are provided, and the ambiguity of the requirements is avoided; the process application is seamlessly integrated, so that the integration of the approval business and the module business of the system is facilitated.

Compared with the traditional system development mode, the invention has the following advantages:

(1) the professional skill requirement of personnel is reduced: general personnel can rapidly complete the configuration and release work of the system through simple training without professional technical knowledge.

(2) Quick and relevant requirement change, and quality guarantee: the requirements of the customers can be configured in the system in real time, so that the customers can verify the relevant requirements, and the implementation of the system is rapidly promoted.

(3) Adapting to the existing localization platform:

(4) and the process platform is seamlessly integrated, so that the examination and approval business is conveniently implemented.

In a use scene of the invention, the invention establishes an application migration platform which is designed from a table, a form, a presentation design, a front-end solution generation and a background solution generation in a Web operation mode and in combination with a code generation tool. The invention has the following characteristics:

(1) autonomous safety: the technology and software and hardware platform support domestic independent intellectual property from project management, code development, testing and formal deployment. The related technologies of software and hardware products related to the tool are owned by domestic manufacturers.

(2) Cross-platform: and autonomous security basic software and hardware platforms such as a mainstream chip (million cores, dragon cores, Feiteng and the like), an operating system (winning bid kylin, Galaxy kylin and the like), a database, middleware, a browser and the like are supported.

(3) And (3) guiding operation: the method is friendly to interaction, and by using a guided WEB operation interface, an implementer can quickly complete the table design, form design and display design of the module without professional technical knowledge.

(4) Automatic generation: and related front-end and back-end solutions are automatically generated, so that the working efficiency is improved.

(5) A seamless integration flow: the configuration application can seamlessly integrate the service data with the process platform according to the service condition, so that the service data can be interactively used in the process.

Drawings

Fig. 1 is a schematic diagram illustrating an application development tool system according to an embodiment of the present invention.

Detailed Description

Preferred embodiments of the present invention will be described in detail below with reference to the accompanying drawings.

For a further understanding of the invention, reference will now be made to the preferred embodiments of the invention by way of example, and it is to be understood that the description is intended to further illustrate features and advantages of the invention, and not to limit the scope of the claims.

The description in this section is for several exemplary embodiments only, and the present invention is not limited only to the scope of the embodiments described. It is within the scope of the present disclosure and protection that the same or similar prior art means and some features of the embodiments may be interchanged.

The steps in the embodiments in the specification are only expressed for convenience of description, and the implementation manner of the present application is not limited by the order of implementation of the steps. The term "connected" in the specification includes both direct connection and indirect connection.

The invention discloses an application development tool system, and fig. 1 is a schematic composition diagram of the application development tool system in an embodiment of the invention; referring to fig. 1, the application development tool system includes: a data management module 100 and a form management module 200; the data management module 100 is used for managing data structures, data relationships and databases; the data management module 100 includes: data structure management section 101, data table generation section 102, data table mapping section 103, table name mapping section 104, and table field information mapping section 105.

The data structure management unit 101 is used for managing a data structure and setting the data type of each data; the data table generating unit 102 is configured to select a set data table template, and set a data type and a data length of each field in the data table through the data table template; the data table mapping unit 103 is used for mapping the data with the setting data table so that the adjustment of the setting data is associated with the corresponding data table; the table name mapping unit 104 is configured to complete mapping of the data table names, so that adjustment of the setting data is associated with corresponding data tables; the table field information mapping unit 105 is used for completing mapping of data table field information;

the form management module 200 is used for managing forms, including form element management, list management, and query management; the form management module comprises: a data form associating unit 201, a form modifying unit 202, a data list associating unit 203, a list inquiring unit 204 and a table relation mapping unit 205.

The data form association unit 201 is configured to associate data with a setting form; the form modification unit 202 is configured to modify data in a form, obtain a mapping relationship between each form and data in a corresponding data table, and modify data in the corresponding data table correspondingly; the data list associating unit 203 is used for mapping the data with the setting list; the list query unit 204 is configured to complete query on the list; the table relationship mapping unit 205 is used for completing mapping of data table relationships;

in an embodiment of the present invention, the application development tool system further includes a process management module 300 for managing processes, including managing process approval sheets, process configuration, and task configuration; the process management module 300 includes: a process approval sheet management unit 301, a process configuration unit 302 and a task configuration unit 303. The management process approval sheet unit 301 is configured to manage the process approval sheet; the process configuration unit 302 is used for configuring process information; the task configuration unit 303 is used to configure tasks.

In one embodiment, the application development tool system further comprises a function creation module 400 for creating functions, including adding data, listing data, querying data, and approving tasks. The application development tool system further comprises an application creation module 500 for creating an application, including setting an application name, a unit to which the application belongs, and selecting an application icon.

In an embodiment of the invention, the application development tool system further includes: the system comprises a script generation module 610, a script information table module 620, a function information table module 630, a code generation module 640, a business process interaction module 650 and a form list linkage module 660. The script generating module 610 is used for automatically generating script information according to the operation of a user; the script information table module 620 is used for storing each script information in the script information table; the function information table module 630 is used to store the function information in the function information table; the code generation module 640 is used for generating a corresponding code according to the setting operation of the user; the business process interaction module 650 is used for associating business data with a form; the form list linkage module 660 is used to realize linkage of the form and the list.

In an embodiment of the present invention, the application development tool system includes: the system comprises a metadata management module, a form modeling module, a flow modeling module and a modeling maintenance module.

The metadata management module is used for managing metadata; the metadata management module comprises a table management unit, a view management unit, a relation management unit, a data import unit and a database maintenance unit.

The form modeling module is used for carrying out form modeling; the form modeling module comprises an element configuration unit, a list configuration unit, a query configuration unit, a script configuration unit and a form issuing unit.

The process modeling module is used for performing process modeling; the process modeling module comprises a approval sheet configuration unit, a process configuration unit, a to-do configuration unit, an already-done configuration unit and a process release unit.

The modeling maintenance module is used for modeling maintenance; the modeling maintenance module comprises a function management unit, a form maintenance unit, a process maintenance unit, a solution downloading unit and an authority configuration unit.

In an embodiment of the present invention, the application development tool system further includes a front-end configuration module, configured to implement front-end configuration of the system; the front-end configuration module comprises a plurality of terminal connection units which are respectively used for connecting different terminals.

In an embodiment of the present invention, the application development tool system further includes a back-end support module, configured to implement back-end support of the system; the back-end support module comprises an application management unit, an authorization management unit, a user management unit, a single sign-on unit, a configuration management unit and an interface management unit.

The invention further discloses an application development tool method of the application development tool system, which comprises the following steps:

creating an application, and setting an application name, a unit to which the application belongs and an application icon of the application;

creating metadata, and setting a metadata structure, a data relation and a database;

creating a form, and setting element management, list management and query management of the form;

establishing a flow, and setting an examination and approval sheet, flow configuration and task configuration;

and a creating function, namely setting a newly added data function, a data list function, a data query function and an approval task function.

In an embodiment of the invention, the method further comprises: and (4) program release, namely, a solution downloading function, a release preview function, an application release function and an authority configuration function are realized.

In a use scene of the invention, a one-stop service of a creating application and a publishing function is established through a modeling guide, a data structure is established according to a service requirement, a data relation is set, a data management function is configured, an examination and approval form and an examination and approval process are configured at the same time, the binding of the modeling function and the service requirement is realized, and the aim of final customer use is achieved.

The customer requirements are analyzed and combed, instantiated function points are formed, function construction is completed through configuration means, development efficiency is greatly improved, development cost is saved, and conventional functions can be completed and used online in 1-2 weeks generally.

The system tool function configuration comprises metadata management, form modeling, process modeling and modeling maintenance. The configuration process is guided, the configuration of the whole function is completed step by step without writing any code.

In the process modeling, relevant process forms and process configuration are completed according to actual process requirements. Firstly, configuring a flow sheet; after the form configuration is completed, the relevant flow needs to be configured.

After the above configuration is completed, the relevant process application needs to be configured. The configuration of the data is then presented in the configuration. And completing the configuration of the related flow display application through the configuration tool.

In element modeling, information of related applications and modules needs to be configured firstly; configuring relevant table information; when configuring a table, information such as table basic information, table field information, multi-table relationship, and the like needs to be configured.

Configuring information of the script;

the configured script can be used in the current configuration to complete the calling of information such as the service of the related third party and the like.

Configuring a module form;

configuring a relevant list;

and after the configuration is completed, displaying the related page.

The application configuration system of the tool is introduced above, and the actual operation steps of the configuration of the system are introduced below.

The process application configuration is as follows: and completing the configuration of information forms and business processes related to the processes through a process configuration tool. And then, according to the configured flow form information, finishing the flow information display and operation configuration of the relevant state, thereby finishing the configuration and release of the flow relevant application. The flow configuration tool is used for completing the configuration of the display form and the configuration of the circulation process of the flow; and the process application configuration selectively displays the relevant information of the process according to the requirements.

The configuration of the element functions is as follows: the system decomposes a functional module into several dimensions of basic information, data storage, data entry, data display and system release, and then guides configuration personnel to complete the configuration function of the module step by step through a guide type operation page.

In one embodiment of the invention, the database table includes: (1) data table names, the table names ensuring their uniqueness; (2) a table field name; (3) determining a field type; (4) determining field attributes; (5) the primary key field, i.e., the primary key, in the table that uniquely identifies the record is determined.

The system needs to be in a mode of page display at the Web end, so that the user can complete the definition of the related content. And after the definition is completed, submitting the definition to a background service, and converting the definition content into SQL identified by the database by the service. And then, executing related SQL to finish the operations of adding, modifying and deleting the database table.

The content mapping is completed through the following four tables:

mode _ DATA _ TABLE: completing name mapping of the table;

mode _ DATA _ TABLE _ COLUMN: completing the mapping of the table field information;

MODEL _ DATA _ TABLE _ COLUMN _ PUBLISHED: recording the release content;

mode _ DATA _ TABLE _ relative: the relationship between tables.

The background service stores the contents of the table definitions in the tables, and then assembles related SQL statements through the stored contents to complete the operation of related database tables. And the subsequent design operation of the forms and the lists can be completed according to the four tables.

The above has explained how metadata converts a relational definition into a database table; three tables of stored definitions are also illustrated:

mode _ DATA _ TABLE: completing name mapping of the table;

MODEL _ DATA _ TABLE _ COLUMN _ PUBLISHED: and recording the release content.

When designing a form, it is necessary to obtain the information of the TABLE designed in the system from the MODEL _ DATA _ TABLE, and then obtain the relevant field information (MODEL _ DATA _ TABLE _ COLUMN) of the TABLE through the selected TABLE information.

After the above operations are completed, when the form is designed, the contents of the form and the fields of the data table are mapped in a relevant manner (the control of the form maps the fields), and then the relevant form design is saved.

After the above operation is completed, the form will be submitted to the background service, and what is stored in the field of the service form. The background service will convert this information into SQL and execute the related SQL. Thus completing the addition, modification and deletion of the form content.

Storing metadata in the system allows the user to define relationships between tables and store these table relationships, in addition to storing table-related content information.

Mode _ DATA _ TABLE _ relative: the relationship between tables.

When designing a list, firstly, TABLE information designed in the system needs to be acquired from the MODEL _ DATA _ TABLE, then, a related multi-TABLE association relationship (MODEL _ DATA _ TABLE _ relationship) (which may be a single-TABLE query) is acquired through the selected TABLE information, after the TABLE information related to the list is confirmed, field information (columns corresponding to the list) needing to be displayed can be selected from the related TABLE, and query DATA query conditions, sorting rules and the like are set.

The list is a data query, so that the data source of the query needs to be confirmed, and the content needing to be presented is selected from the data source. Since it is a query, information such as query conditions and rules for ranking needs to be set.

After the design is completed, when the list is displayed, the background service can generate dynamic statements according to the content of the design, inquire field information involved in the design, and execute related statements to complete related SQL inquiry.

When designing related system modules, if some service functions cannot be completed through the existing configuration, such as: and performing business interaction with other existing modules, and then performing related JS operation to call related services to complete data acquisition and transmission.

In the tool, a program does not know which script operation is required to be performed by a configurator, so the configurator needs to complete the informing process, and the process is divided into two parts, namely, the injection of a script; the other is the injection of the function. Scripts are an integral class of functions, and functions are specific functional methods.

After the above operations are completed, the related script information is stored in the table:

MODEL _ JS _ REGISTER: a script information table;

mode _ JS _ FUNREGISTER: a function information table;

when configuring the form and the list, acquiring relevant script information through the MODEL _ JS _ REGISTER, then acquiring function information under the script through the MODEL _ JS _ FUNREGISTER according to the selected script, and then selecting relevant functions from the form and the list to be bound to corresponding functions.

When the form or the list is operated, the bound script is obtained according to the interface, then the related script is loaded into the page before the page is operated, and then the page is loaded, so that the related function can be triggered and called.

The back-end service code mainly adds, deletes, and checks the function, only for different table data. Therefore, a set of universal templates is designed to complete related functions. And FreeMarker is used for this code generation.

FreeMarker is a template engine: a general-purpose tool for generating output text (HTML web pages, emails, configuration files, source code, etc.) based on templates and data to be changed. Namely: output ═ template + data. In short, the usage principle is similar to String's place method, or MessageFormat's format method, which changes (replaces) some content in a certain code. However, Freemarker is more powerful, the template source can be an external file or a character string format, the replaced data format is various, and logic judgment is supported, so that the replaced content is more flexible.

In summary, the application development tool system provided by the present invention can automatically generate a software system according to the setting, thereby improving the efficiency of software system generation.

It should be noted that the present application may be implemented in software and/or a combination of software and hardware; for example, it may be implemented using Application Specific Integrated Circuits (ASICs), general purpose computers or any other similar hardware devices. In some embodiments, the software programs of the present application may be executed by a processor to implement the above steps or functions. As such, the software programs (including associated data structures) of the present application can be stored in a computer-readable recording medium; such as RAM memory, magnetic or optical drives or diskettes, and the like. In addition, some steps or functions of the present application may be implemented using hardware; for example, as circuitry that cooperates with the processor to perform various steps or functions.

The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The description and applications of the invention herein are illustrative and are not intended to limit the scope of the invention to the embodiments described above. Effects or advantages referred to in the embodiments may not be reflected in the embodiments due to interference of various factors, and the description of the effects or advantages is not intended to limit the embodiments. Variations and modifications of the embodiments disclosed herein are possible, and alternative and equivalent various components of the embodiments will be apparent to those skilled in the art. It will be clear to those skilled in the art that the present invention may be embodied in other forms, structures, arrangements, proportions, and with other components, materials, and parts, without departing from the spirit or essential characteristics thereof. Other variations and modifications of the embodiments disclosed herein may be made without departing from the scope and spirit of the invention.

Claims

1. An application development tool system, the application development tool system comprising: the data management module and the form management module;

the list inquiry unit is used for finishing the inquiry of the list;

and the table relation mapping unit is used for completing the mapping of the data table relation.

2. The application development tool system of claim 1, wherein:

the application development tool system further comprises a process management module used for managing processes, including managing process approval sheets, process configuration and task configuration;

the flow management module comprises:

the flow configuration unit is used for configuring flow information;

and the task configuration unit is used for configuring the tasks.

3. The application development tool system of claim 1, wherein:

the application development tool system further comprises:

the script generating module is used for automatically generating script information according to the operation of a user;

4. The application development tool system of claim 1, wherein:

the application development tool system further comprises a function creation module used for creating functions including newly added data, a data list, data query and approval tasks.

5. The application development tool system of claim 1, wherein:

the application development tool system further comprises an application creation module used for creating the application, wherein the application creation module comprises the steps of setting an application name, an application unit and selecting an application icon.