CN114911775A

CN114911775A - Method and system for configuring and storing dynamic form and field

Info

Publication number: CN114911775A
Application number: CN202210681488.3A
Authority: CN
Inventors: 耿世超; 曲婷
Original assignee: Shandong Zhiying Medical Technology Co ltd
Current assignee: Shandong Zhiying Medical Technology Co ltd
Priority date: 2022-06-16
Filing date: 2022-06-16
Publication date: 2022-08-16

Abstract

The invention provides a method and a system for configuring and storing dynamic forms and fields, which define initial fields of a database, define field format rules and SQL statement dynamic creating rules and complete the creation of preconditions; defining a target field to be added or modified by using a field format rule, and finishing dynamic association storage of a target form and the target field by using an SQL statement dynamic creation rule; acquiring all field data of a target form, traversing and analyzing each field to form an html tag, rendering the html tag to form an html page, verifying input contents of a user on the html tag, and storing the input contents passing verification in a database by using SQL statement dynamic creation rules; the method and the system are based on JSON/XML field format rules and SQL statement dynamic creation rules, carry out configuration and storage of the fields of the dynamic form, realize rendering interaction of the dynamic form, improve the flexibility of field configuration and form generation, and solve the problems of large workload and low code expansibility and maintainability of the existing platform.

Description

Method and system for configuring and storing dynamic form and field

Technical Field

The invention belongs to the technical field of computers, and particularly relates to a method and a system for configuring and storing dynamic forms and fields.

Background

The statements in this section merely provide background information related to the present disclosure and may not constitute prior art.

The remote consultation platform uploads basic information, preliminary diagnosis information and imaging information of a patient to a network, and experts acquire the information of the patient through the network to perform corresponding diagnosis, so that the problems of uneven distribution of medical resources and the like are solved; the consultation platform is deployed on the cloud platform and is in butt joint with different hospital ends (consultation initiating ends) and expert ends (diagnosis result initiating ends); in actual use, different hospitals, third-party inspection institutions and the like have different requirements on patient information and formats, along with the development of the society, the living standard of people is improved, the pathological needs of veterinarians are gradually reflected, and the fact that the remote consultation platform can adapt to various different requirements becomes more important.

When the remote consultation platform is deployed, the same program is used by all clients, and in order to meet different requirements of the clients, a traditional method is a new method or related codes are annotated; for example, if a hospital needs to use the name field in the method c, the method c is changed and the name field code is newly added and read; however, until b hospital does not need to use the name field, the name field is often annotated or the c method of b hospital is changed to meet the customer requirement; the traditional method carries out customized service by compiling a plurality of sets of codes, the platform workload is large, and the expansibility and maintainability of the codes are low.

Disclosure of Invention

In order to solve different requirements of different hospitals, inspection centers or veterinary pathologies in a remote consultation platform on patient information and formats, the invention provides a method and a system for configuring and storing dynamic forms and fields.

In order to achieve the above object, one or more embodiments of the present invention provide the following technical solutions:

the first aspect of the invention provides a method for configuring and storing dynamic forms and fields;

a method for configuring and storing dynamic forms and fields comprises the following steps:

defining initial fields of a database, defining field format rules and SQL statement dynamic creation rules, and completing creation of preconditions;

defining a target field to be added or modified by using a field format rule, and finishing dynamic association storage of a target form and the target field by using an SQL statement dynamic creation rule;

acquiring all field data of the target form, traversing and analyzing each field to form an html tag, rendering to form an html page, checking input contents of a user on the html tag, and storing the input contents passing the checking in a database by using SQL statement dynamic creation rules.

Further, the field format rule is in a JSON/XML format and includes attributes of a field type, a field name, a field display name, a check rule, and a database type.

Further, the SQL statement dynamic creation rule includes an SQL statement template for adding a field, modifying a field type, querying a field, deleting a field, and adding data.

Furthermore, the target field to be added or modified is supplemented with the value of the corresponding attribute according to the attribute in the field format rule, so as to obtain the target field information in the JSON/XML format.

Further, the target form and the target field are dynamically and correlatively stored, all fields of the target form stored in a database are obtained by using SQL sentences of the query field, whether the target field is included is judged, if yes, the database information of the target field is updated by using SQL sentences of the modified field type, the deleted field and the newly added field, and if not, the target field is stored by using SQL sentences of the newly added field, and the correlation between the target form and the target field is stored.

Further, acquiring all field data of the target form according to the incidence relation between the target form and the target field;

and resolving the data of each field into an html tag according to the field type, the field name, the field display name, the check rule and the database type attribute in the field format rule.

Furthermore, according to the check rule in the field format rule, checking the input content of the user on the html tag.

The second aspect of the invention provides a system for configuring and storing dynamic forms and fields.

A system for configuring and storing dynamic forms and fields comprises a precondition creation module, a dynamic form field storage module and a dynamic form rendering interaction module;

a precondition creation module configured to: defining initial fields of a database, defining field format rules and SQL statement dynamic creation rules, and completing creation of preconditions;

a dynamic form field storage module configured to: defining a target field to be added or modified by using a field format rule, and finishing dynamic association storage of a target form and the target field by using an SQL statement dynamic creation rule;

a dynamic form rendering interaction module configured to: acquiring all field data of the target form, traversing and analyzing each field to form an html tag, rendering the html tag to form an html page, verifying the input of a user on the html page according to a field format rule, and dynamically creating a rule by using an SQL statement for the input passing the verification to store a database.

A third aspect of the invention provides a computer readable storage medium having stored thereon a program which, when executed by a processor, performs the steps in a method of dynamic form, field configuration and storage according to the first aspect of the invention.

A fourth aspect of the present invention provides an electronic device, comprising a memory, a processor and a program stored in the memory and executable on the processor, wherein the processor implements the steps of the method for configuring and storing dynamic forms and fields according to the first aspect of the present invention when executing the program.

The above one or more technical solutions have the following beneficial effects:

the method for configuring and storing the dynamic form and the field comprises the steps of storing the dynamic field and the associated target form into a database based on JSON/XML format field format rules and SQL statement dynamic creation rules, and realizing dynamic management of the form field; the rendering and interaction of the target form are realized by acquiring the associated fields from the database and performing dynamic analysis rendering;

the method for configuring and storing the dynamic form and the field improves the flexibility of field configuration and form generation, reduces the workload of repeated development of developers, improves the software development efficiency, and solves the problems of large workload and lower code expansibility and maintainability of the conventional platform.

Advantages of additional aspects of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, are included to provide a further understanding of the invention, and are incorporated in and constitute a part of this specification, illustrate exemplary embodiments of the invention and together with the description serve to explain the invention and not to limit the invention.

FIG. 1 is a precondition for a first embodiment;

FIG. 2 is a flowchart of the field storage of the dynamic form according to the first embodiment;

FIG. 3 is the form data of the first embodiment;

FIG. 4 is a flowchart of a dynamic form rendering interaction of the first embodiment;

FIG. 5 is field data of the first embodiment;

fig. 6 is a system configuration diagram of the second embodiment.

Detailed Description

It should be noted that the following detailed description is exemplary and is intended to provide further explanation of the disclosure. Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this disclosure belongs.

It is noted that the terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of example embodiments according to the present disclosure. As used herein, the singular forms "a", "an", and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise, and it should be understood that the terms "comprises" and "comprising", and any variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

The embodiments and features of the embodiments of the present invention may be combined with each other without conflict.

Example one

The embodiment discloses a method for configuring and storing a dynamic form and a field;

step 1: defining initial fields of a database, defining field format rules and SQL statement dynamic creation rules, and completing creation of preconditions, as shown in FIG. 1.

Precondition 1: defining initial fields F of the database, for example: name, gender, age.

Precondition 2: define field format rule H, is JSON/XML format, for example:

{

type:'input',

name: 'name',

key:'input_name',

rules:[{

required:false,

message 'mandatory' item,

regular:'^[A-Za-z0-9]{4,40}$'

}],

datatype:'vachar(50)'

}

and 3, defining an SQL statement dynamic creation rule G, namely an SQL statement template, and dividing into:

precondition 3.1: adding fields

The ALTER TABLE TABLE name ADD COLUMN 'field name' field type default value;

precondition 3.2: modifying field types

The field type after the change of the ALTER TABLE TABLE name ALTER COLUMN 'field name';

precondition 3.3: query field

SELECT FROM information _ schema, column name table _ name ═ table name';

precondition 3.4: deleting a field

The ALTER TABLE TABLE name DROP COLUMN 'field name';

precondition 3.5: adding data

INSERT INTOs table name ('field name 1', 'field name 2', … …) VALUES ('field 1 value', 'field 2 value', … …).

Step 2: defining a target field to be added or modified by using a field format rule, and finishing dynamic association storage of a target form and the target field by using an SQL statement dynamic creation rule;

and acquiring all fields of the target form stored in the database by using the SQL sentences for inquiring the fields, judging whether the target fields are included, if so, updating the database information of the target fields by using the SQL sentences for modifying the field types, deleting the fields and adding the new fields, and if not, storing the target fields by using the SQL sentences for adding the new fields and storing the incidence relation between the target form and the target fields.

The specific application scenario is that an administrator configures and stores dynamic form fields on a form field configuration page of the consultation platform, and as shown in fig. 2, the specific steps are as follows:

step 2-1: opening a consultation platform form field configuration page, clicking a storage button after the form field information changes, defining fields needing to be added or modified according to a field format rule H, and acquiring JSON/XML structural data of the current form, wherein the added or modified field information and the current form data are sent to a server through an HTTP request as shown in figure 3;

step 2-2: after receiving the field information and the form information, the server calls different JSON or XML analysis methods to analyze the field information and the form information into a field object set M and a form object U respectively;

step 2-3: acquiring a field information list R in a database table by a precondition 3.3 query method in an SQL statement dynamic creation rule G;

step 2-4: traversing the field object set M through a for loop, and setting i to be 0;

step 2-4-1: comparing z.key with data R in the table, judging whether z.key exists in R, and switching to step 2-4-2 if z.key exists and switching to step 2-4-3 if z.key does not exist;

step 2-4-2: acquiring the field type of z.key in R according to a precondition 3.3 query method in an SQL statement dynamic creation rule G, detecting whether the z field type datatype in R is consistent with the type in M, and turning to the step 2-4-4; if the data types are inconsistent, dynamically modifying the field type of the SQL table according to a precondition 3.2 changing method in the SQL statement dynamic creation rule G of the datatype of z in the M, and turning to the step 2-4-4;

step 2-4-3: adding z into a database table by a precondition 3.1 adding method in the SQL statement dynamic creation rule G, and turning to the step 2-4-4;

step 2-4-4: judging whether the form type of z is a drop-down list or not according to the field name and the field type of z in M, and turning to the step 2-4-4-1; instead of going to 2-4-5;

step 2-4-4-1: acquiring a data dictionary table value in a database;

step 2-4-4-2: traversing options of z, and setting j to be 0;

step 2-4-4-3: judging whether each option value in z [ j ] exists in the table, if not, adding a data rule into the data dictionary table through a precondition 3.5 in the SQL statement dynamic creation rule G, and then turning to the step 2-4-4-4; if so, directly going to step 2-4-4-4;

step 2-4-4-4: j + +, if j is less than or equal to the length of the options of z, continuing to loop in the step 2-4-4-3, and if j is greater than z, ending the loop and going to the step 2-4-5;

step 2-4-5: deleting the corresponding field from the R according to z.key, if i + +, the length of i is less than or equal to M, continuing to circulate in the step 4.1, and if the length of i is greater than M, ending to circulate in the step 5;

step 2-5: judging whether the residual length of R is greater than 0, if so, turning to the step 2-6; if the value is larger than 0, traversing the R, deleting the corresponding columns from the data table by the method of deleting the residual fields in the R through the precondition 3.4 in the SQL statement dynamic creation rule G, and turning to the step 2-6;

step 2-6: and after the field storage is finished, updating the M into a database dynamic form data table according to the form object U, and finishing the storage of the dynamic form and the field.

And step 3: acquiring all field data of the target form, traversing and analyzing each field to form an html tag, rendering to form an html page, checking input contents of a user on the html tag, and storing the input contents passing the checking in a database by using SQL statement dynamic creation rules.

Acquiring all field data of the target form according to the incidence relation between the target form and the target field; and resolving the data of each field into an html tag according to the field type, the field name, the field display name, the check rule and the database type attribute in the field format rule. And checking the input content of the user on the html tag according to the check rule in the field format rule.

In a specific application scenario, after the administrator configures the dynamic form and the field by using the method in step 2, as shown in fig. 4, the specific steps of the rendering interaction of the dynamic form are as follows:

step 3-1: opening a consultation platform, acquiring a current form object U according to an entered page, initiating an http request by a browser W, acquiring JSON/XML structural data of a current form according to the U, and acquiring all field data of the current form according to the incidence relation between a target form and a target field as shown in FIG. 3, wherein the JSON/XML structural data is shown in FIG. 5;

step 3-2: after the browser W obtains the form data and the field data, information such as the type, the label, the style, the check rule and the like of each field is obtained through traversal according to the JSON/XML structure of the obtained form, html page labels are rendered according to the information, if input is used, the (input key) label is rendered, the (value) label is rendered, and each rendered label is loaded into the html page, and the step 3-3 is carried out after the process is completed;

step 3-3: after the user inputs information on the page, clicking and storing the information to obtain all the label contents T in the template, circularly traversing each value of the verification T, carrying out validity verification on the value according to a verification rule, if the value is not met, jumping out of the loop to prompt the user to be illegal, and turning to the step 3-8; if the verification rules are all met, turning to the step 3-4;

step 3-4: sending the content T to a server through a browser W, calling different JSON or XML analysis methods, analyzing the content T into a field object set M and a form object U, adding a data method through a precondition 3.5 in a rule G to store the M into a database, updating the field object set M, returning a success result and the M to the browser W, and turning to the step 3-5;

step 3-5: the browser W prompts the user that the operation is successful, after the browser W obtains the field object set, M is traversed, and e is set to be 0;

step 3-6: matching a label which is the same as the M [ e ] key in the html page through the M [ e ] key, and writing back the value of the M [ e ] to a label value;

step 3-7: e + +, if e is less than or equal to the length of M, going to step 3-6 to continue page rendering, and if e is greater than M, ending the cycle and going to step 3-8;

step 3-8: the dynamic form rendering interaction ends.

Example two

The embodiment discloses a system for configuring and storing dynamic forms and fields;

as shown in fig. 6, a system for configuring and storing dynamic forms and fields includes a precondition creation module, a dynamic form field storage module, and a dynamic form rendering interaction module;

a dynamic form field storage module configured to: defining a target field to be added or modified by using a field format rule, and completing dynamic association storage of a target form and the target field by using an SQL statement dynamic creation rule;

EXAMPLE III

An object of the present embodiment is to provide a computer-readable storage medium.

A computer readable storage medium, on which a computer program is stored, which when executed by a processor implements the steps in a method of dynamic form, field configuration and storage as described in embodiment 1 of the present disclosure.

Example four

An object of the present embodiment is to provide an electronic device.

An electronic device comprising a memory, a processor and a program stored in the memory and executable on the processor, wherein the processor executes the program to implement the steps of the method for configuring and storing dynamic forms and fields according to embodiment 1 of the present disclosure.

The steps involved in the apparatuses of the above second, third and fourth embodiments correspond to the first embodiment of the method, and the detailed description thereof can be found in the relevant description of the first embodiment. The term "computer-readable storage medium" should be taken to include a single medium or multiple media containing one or more sets of instructions; it should also be understood to include any medium that is capable of storing, encoding or carrying a set of instructions for execution by a processor and that cause the processor to perform any of the methods of the present invention.

Those skilled in the art will appreciate that the modules or steps of the present invention described above can be implemented using general purpose computer means, or alternatively, they can be implemented using program code that is executable by computing means, such that they are stored in memory means for execution by the computing means, or they are separately fabricated into individual integrated circuit modules, or multiple modules or steps of them are fabricated into a single integrated circuit module. The present invention is not limited to any specific combination of hardware and software.

Although the embodiments of the present invention have been described with reference to the accompanying drawings, it is not intended to limit the scope of the present invention, and it should be understood by those skilled in the art that various modifications and variations can be made without inventive efforts by those skilled in the art based on the technical solution of the present invention.

Claims

1. A method for configuring and storing dynamic forms and fields is characterized by comprising the following steps:

2. The method of claim 1, wherein the field format rule is JSON/XML format and includes attributes of field type, field name, field display name, check rule, and database type.

3. The method of claim 1, wherein the SQL statement dynamically creates rules including add fields, modify field types, query fields, delete fields, add SQL statement templates for data.

4. The method according to claim 1, wherein the target field to be added or modified is supplemented with the value of the corresponding attribute according to the attribute in the field format rule, so as to obtain the target field information in the JSON/XML format.

5. The method according to claim 1, wherein the dynamic association between the target form and the target field is stored, the SQL statement for querying the field is used to obtain all the fields stored in the database of the target form, and determine whether the target field is included, if yes, the SQL statement for modifying the field type, deleting the field, and adding the field is used to update the database information of the target field, and if not, the SQL statement for adding the field is used to store the target field, and the association between the target form and the target field is stored.

6. The method of claim 1, wherein all field data of the target form are obtained according to the association relationship between the target form and the target field;

7. The method of claim 1, wherein the input content of the html tag by the user is checked according to a check rule in the field format rule.

8. A system for configuring and storing dynamic forms and fields is characterized in that: the dynamic form rendering interaction module comprises a precondition creation module, a dynamic form field storage module and a dynamic form rendering interaction module;

9. Computer-readable storage medium, on which a program is stored which, when being executed by a processor, carries out the steps of a method for dynamic form, field configuration and storage according to any one of claims 1 to 7.

10. Electronic device comprising a memory, a processor and a program stored on the memory and executable on the processor, characterized in that the processor implements the steps of a method of dynamic form, field configuration and storage according to any of claims 1-7 when executing the program.