CN111026756A - Method for dynamically generating form and associated query - Google Patents

Abstract

The invention discloses a method for dynamically generating a form and performing associated query, which comprises the following steps: s1, configuring the data unit attribute of the dynamic form according to the user service requirement; s2, performing data operation of adding, deleting, modifying and inquiring on the dynamic form; s3, modifying the dynamically generated form again, and reserving corresponding data; and S4, defining association rules and realizing the joint query of a plurality of dynamic forms. The form dynamic generation and correlation query method of the invention enables a user to easily generate a new form according to own business dynamics, and perform data operations such as addition, modification, deletion, query and the like on the new form, and also can modify the dynamically generated form again, retain corresponding data, and can define correlation rules to realize the joint query of a plurality of dynamic forms.

Description

Method for dynamically generating form and associated query

Technical Field

The invention belongs to the technical field of computer data processing, and particularly relates to a method for dynamically generating a form and performing associated query.

Background

With the popularization of information technology, the application of information management systems is more and more extensive, and forms occupy a very important position in the information management systems. In the development of forms, specific forms are generally customized according to the business requirements of users. However, when the business is changed, the information input by the form needs to be changed, the customized form is not flexible, and the form needs to be developed again by developers. Or the service types are many, the number of forms to be customized is large, the development workload is large, the development efficiency is low, and the cost is high.

Disclosure of Invention

The invention aims to overcome the defects of the prior art and provide a form dynamic generation and correlation query method which can enable a user to easily dynamically generate a new form according to own service, perform data operations such as addition, modification, deletion, query and the like on the new form, modify the dynamically generated form again, define correlation rules and realize the joint query of a plurality of dynamic forms.

The purpose of the invention is realized by the following technical scheme: a method for dynamically generating and associating a query with a form, comprising the steps of:

s1, configuring the data unit attribute of the dynamic form according to the user service requirement;

s2, performing data operation of adding, deleting, modifying and inquiring on the dynamic form;

s3, modifying the dynamically generated form again, and reserving corresponding data;

and S4, defining association rules and realizing the joint query of a plurality of dynamic forms.

Further, the step S1 includes the following sub-steps:

s11, configuring the data unit attribute of the dynamic form according to the user service requirement;

s12, converting the data unit attribute configured by the user into a template attribute;

s13, respectively storing the dynamic form information and the template attribute information into a form information table and a template attribute information table of a database;

s14, creating an actually existing physical table in the database, and storing the information of the physical table in the form information table.

Further, the step S2 includes the following sub-steps:

s21, selecting a form to be operated by a user;

s22, inquiring information corresponding to the form needing to be operated in the database;

s23, finding out template information in a database according to the form information;

s24, the foreground page respectively calls corresponding foreground plug-ins according to the template information;

s25, obtaining a corresponding physical table according to the form information, and loading the physical table to a foreground plug-in;

and S26, performing data operation of adding, deleting, modifying and inquiring on the dynamically generated form.

Further, the step S3 includes the following sub-steps:

s31, modifying the data unit attribute of the dynamic form by the user according to the new requirement;

s32, judging whether a new physical table needs to be created for the modified data unit attribute, if so, executing a step S33, otherwise, executing a step S34;

s33, creating a new physical table, saving the modified data unit attribute in the created physical table, and recording the abandoned physical table in a special cleaning table;

s34, storing the modified data unit attribute into the physical table of the original data unit attribute;

s35, deleting the old table according to the data in the cleaning table at regular intervals;

and S36, modifying the attribute of the template according to the newly modified attribute of the data unit, and recording the modified attribute into the attribute table of the template.

Further, the step S4 includes the following sub-steps:

s41, selecting 2 or more dynamic forms needing to be associated and selecting the attributes needing to be associated in the selected forms;

s42, adding and saving the association rule;

s43, generating a corresponding view script by analyzing the rule and creating the view in the database;

s44, loading rules;

s45, checking whether the dynamic form is changed, if not, executing the step S47, and if so, executing the step S46;

s46, prompting that the form is dynamically changed and the query rule needs to be re-formulated, and returning to the step S41;

and S47, searching a corresponding view, and jointly displaying a plurality of dynamic tables.

The invention has the beneficial effects that: the invention provides a method for dynamically generating and associating the query form, which can enable a user to easily dynamically generate a new form according to own business, perform data operations such as addition, modification, deletion, query and the like on the new form, modify the dynamically generated form again, retain corresponding data, define association rules and realize the combined query of a plurality of dynamic forms.

Drawings

FIG. 1 is a flow chart of a method of dynamically generating and correlating queries for a form in accordance with the present invention;

FIG. 2 is a flow chart of the present invention for configuring data unit attributes of a dynamic form based on user business requirements;

FIG. 3 is a flow chart of the present invention for performing add, delete, modify, and query data operations on a dynamic form;

FIG. 4 is a flow chart of the present invention for modifying a dynamically generated form again;

FIG. 5 is a flowchart illustrating the method for defining association rules to implement joint query of multiple dynamic forms according to the present invention.

Detailed Description

The invention relates to the following contents:

and the user dynamically generates a new form according to own service.

And performing data operations such as adding, deleting, modifying, inquiring and the like on the dynamically generated form.

And modifying the dynamically generated form again, and reserving the corresponding data.

And defining association rules to realize the joint query of a plurality of dynamic forms.

The technical scheme of the invention is further explained by combining the attached drawings. As shown in FIG. 1, a method for dynamically generating and associating a query with a form of the present invention comprises the following steps:

s1, configuring the data unit attribute of the dynamic form according to the user service requirement; as shown in fig. 2, the following sub-steps are included:

s11, configuring the data unit attribute of the dynamic form according to the user service requirement; for example, common forms include character string types such as names and native place, date types such as birth year and month and graduation year, and pull-down enumeration types such as political features and academic degree.

S12, converting the data unit attribute configured by the user into a template attribute;

s13, respectively storing the dynamic form information and the template attribute information into a form information table and a template attribute information table of a database;

s14, creating an actually existing physical table in the database, and storing the information of the physical table in the form information table.

S2, performing data operation of adding, deleting, modifying and inquiring on the dynamic form; as shown in fig. 3, the following sub-steps are included:

s21, selecting a form to be operated by a user;

s22, inquiring information corresponding to the form needing to be operated in the database;

s23, finding out template information in a database according to the form information;

s24, the foreground page respectively calls corresponding foreground plug-ins according to the template information;

s25, obtaining a corresponding physical table according to the form information, and loading the physical table to a foreground plug-in;

and S26, performing data operation of adding, deleting, modifying and inquiring on the dynamically generated form.

S3, modifying the dynamically generated form again, and reserving corresponding data; as shown in fig. 4, the following sub-steps are included:

s31, modifying the data unit attribute of the dynamic form by the user according to the new requirement;

s32, judging whether a new physical table needs to be created for the modified data unit attribute, if so, executing a step S33, otherwise, executing a step S34;

s33, creating a new physical table, saving the modified data unit attribute in the created physical table, and recording the abandoned physical table in a special cleaning table;

s34, storing the modified data unit attribute into the physical table of the original data unit attribute;

s35, deleting the old table according to the data in the cleaning table at regular intervals;

and S36, modifying the attribute of the template according to the newly modified attribute of the data unit, and recording the modified attribute into the attribute table of the template.

S4, defining association rules to realize the joint query of a plurality of dynamic forms; as shown in fig. 5, the following sub-steps are included:

s41, selecting 2 or more dynamic forms needing to be associated and selecting the attributes needing to be associated in the selected forms;

s42, adding and saving the association rule;

s43, generating a corresponding view script by analyzing the rule and creating the view in the database;

s44, loading rules;

s45, checking whether the dynamic form is changed, if not, executing the step S47, and if so, executing the step S46;

s46, prompting that the form is dynamically changed and the query rule needs to be re-formulated, and returning to the step S41;

and S47, searching a corresponding view, and jointly displaying a plurality of dynamic tables.

It will be appreciated by those of ordinary skill in the art that the embodiments described herein are intended to assist the reader in understanding the principles of the invention and are to be construed as being without limitation to such specifically recited embodiments and examples. Those skilled in the art can make various other specific changes and combinations based on the teachings of the present invention without departing from the spirit of the invention, and these changes and combinations are within the scope of the invention.

Claims (5)

1. A method for dynamically generating and associating a query with a form, comprising the steps of:

s1, configuring the data unit attribute of the dynamic form according to the user service requirement;

s2, performing data operation of adding, deleting, modifying and inquiring on the dynamic form;

s3, modifying the dynamically generated form again, and reserving corresponding data;

and S4, defining association rules and realizing the joint query of a plurality of dynamic forms.

2. The method for dynamically generating and associating queries with forms as claimed in claim 1, wherein said step S1 includes the following sub-steps:

s11, configuring the data unit attribute of the dynamic form according to the user service requirement;

s12, converting the data unit attribute configured by the user into a template attribute;

s13, respectively storing the dynamic form information and the template attribute information into a form information table and a template attribute information table of a database;

s14, creating an actually existing physical table in the database, and storing the information of the physical table in the form information table.

3. The method for dynamically generating and associating queries with forms as claimed in claim 1, wherein said step S2 includes the following sub-steps:

s21, selecting a form to be operated by a user;

s22, inquiring information corresponding to the form needing to be operated in the database;

s23, finding out template information in a database according to the form information;

s24, the foreground page respectively calls corresponding foreground plug-ins according to the template information;

s25, obtaining a corresponding physical table according to the form information, and loading the physical table to a foreground plug-in;

and S26, performing data operation of adding, deleting, modifying and inquiring on the dynamically generated form.

4. The method for dynamically generating and associating queries with forms as claimed in claim 1, wherein said step S3 includes the following sub-steps:

s31, modifying the data unit attribute of the dynamic form by the user according to the new requirement;

s32, judging whether a new physical table needs to be created for the modified data unit attribute, if so, executing a step S33, otherwise, executing a step S34;

s33, creating a new physical table, saving the modified data unit attribute in the created physical table, and recording the abandoned physical table in a special cleaning table;

s34, storing the modified data unit attribute into the physical table of the original data unit attribute;

s35, deleting the old table according to the data in the cleaning table at regular intervals;

and S36, modifying the attribute of the template according to the newly modified attribute of the data unit, and recording the modified attribute into the attribute table of the template.

5. The method for dynamically generating and associating queries with forms as claimed in claim 1, wherein said step S4 includes the following sub-steps:

s41, selecting 2 or more dynamic forms needing to be associated and selecting the attributes needing to be associated in the selected forms;

s42, adding and saving the association rule;

s43, generating a corresponding view script by analyzing the rule and creating the view in the database;

s44, loading rules;

s45, checking whether the dynamic form is changed, if not, executing the step S47, and if so, executing the step S46;

s46, prompting that the form is dynamically changed and the query rule needs to be re-formulated, and returning to the step S41;

and S47, searching a corresponding view, and jointly displaying a plurality of dynamic tables.

Images