Form generation method and device, equipment and storage medium

Abstract

The invention provides a form generation method and device, equipment and a storage medium, and the method comprises the steps: firstly obtaining the dragging operation of a user on a plurality of components on a form design interface, generating a configuration table corresponding to each component based on the dragging operation, then obtaining the configuration information on the configuration table, analyzing the configuration information, and generating a form according to the analyzed configuration information. An analysis result is converted into an executable DDL statement, and a database table structure and a relation table of the database table structure are generated according to the DDL statement; finally, the database table structure and form definition data of the relation table of the database table structure are obtained, a form analyzer is called in a browser to conduct visual rendering so as to dynamically generate a target form, and the form definition data comprise the overall structure of the form, linkage logic between components and event processing rules. The problems of large adjustment workload and slow response during demand change during form development are solved.

Description

Technical Field

[0001] The present invention relates to the field of form generation, and in particular to a form generation method, device, equipment and storage medium. Background Art

[0002] In modern enterprise information management systems, business data forms serve as the primary vehicle for information collection and presentation. Their design and implementation are often time-consuming and labor-intensive, and they struggle to keep up with rapidly changing business needs. Traditional form development methods require specialized technical personnel to design databases, develop back-end services, and write front-end interfaces. The entire process involves multiple technical steps, each with complex connections. Changing business requirements often require revising database structures, adjusting back-end service logic, and refactoring front-end interfaces, resulting in slow response times and high maintenance costs.

[0003] In addition, the different display requirements for the same data in different business scenarios, as well as complex scenarios such as the associated display and interaction of multi-form data, make it difficult for traditional development methods to respond flexibly.

[0004] In view of this, this application is filed. Summary of the Invention

[0005] The present invention discloses a form generation method, device, equipment and storage medium, aiming to solve the problem of heavy workload and slow response when adjusting forms when requirements change during development.

[0006] A first embodiment of the present invention provides a method for generating a form, comprising:

[0007] Obtaining a user's dragging operation on multiple components on a form design interface, and generating a configuration table corresponding to each component based on the dragging operation, wherein the configuration table includes field codes, field names, field types, field lengths, data validation rules, and interaction event configurations;

[0008] Obtaining configuration information on the configuration table, parsing the configuration information, converting the parsing results into executable DDL statements, and generating a database table structure and its relationship table according to the DDL statements;

[0009] Obtain the form definition data of the database table structure and its relationship table, and call the form parser in the browser for visual rendering to dynamically generate the target form, wherein the form definition data includes the overall form structure, linkage logic between components, and event handling rules.

[0010] Preferably, after obtaining the user's dragging operation on multiple components on the form design interface, the method further includes: recording the relative position relationship between the components and incorporating the position relationship into the configuration table.

[0011] Preferably, it also includes:

[0012] When multiple other form data are introduced into the same form, when it is determined that there are identical fields, the fields are distinguished according to the form data field validity context, wherein the form data field validity context is set according to the form field component;

[0013] Based on the differentiation result, when editing and verifying the form data, the fields belonging to the current form data source are made effective, so that multiple different form data can be associated and referenced in one form.

[0014] Preferably, the acquiring of the user's dragging operation on multiple components on the form design interface and the generating of a configuration table corresponding to each component based on the dragging operation are specifically as follows:

[0015] During the initialization process, a form data model is generated, and corresponding target fields are selected from the form data model according to a user's drag-and-drop operation on multiple components on a form design interface, wherein the form data model is configured with a field library;

[0016] Drag the target field into the form design area, and configure display conditions for the target field and layout components according to the requirements of different business pages, so that the fields and layouts that meet specific conditions are presented in the target business scenario.

[0017] Preferably, the DDL statement includes database table structure definition, field types, primary keys, foreign keys, indexes and constraints.

[0018] Preferably, after obtaining the form definition data of the database table structure and its relationship table, and calling the form parser in the browser for visual rendering to dynamically generate the target form, it also includes: performing real-time interactive response on the target form according to the linkage logic and event processing rules between the components.

[0019] A second embodiment of the present invention provides a form generation device, comprising:

[0020] A configuration table generating unit, configured to obtain a user's dragging operation on multiple components on a form design interface, and generate a configuration table corresponding to each component based on the dragging operation, wherein the configuration table includes a field code, field name, field type, field length, data validation rules, and interaction event configuration;

[0021] A parsing unit, configured to obtain configuration information on the configuration table, parse the configuration information, convert the parsing result into an executable DDL statement, and generate a database table structure and its relationship table according to the DDL statement;

[0022] The target form generation unit is used to obtain the form definition data of the database table structure and its relationship table, and call the form parser in the browser for visual rendering to dynamically generate the target form, wherein the form definition data includes the overall structure of the form, the linkage logic between components and the event processing rules.

[0023] A third embodiment of the present invention provides a form generation device, characterized in that it includes a memory and a processor, the memory stores a computer program, and the computer program can be executed by the processor to implement a form generation method as described in any one of the above.

[0024] A fourth embodiment of the present invention provides a computer-readable storage medium, characterized in that it stores a computer program, and the computer program can be executed by a processor of the device where the computer-readable storage medium is located to implement a form generation method as described in any one of the above items.

[0025] The present invention provides a form generation method, apparatus, device, and storage medium. The method first obtains a user's drag-and-drop operation on multiple components on a form design interface, generates a configuration table corresponding to each component based on the drag-and-drop operation, then obtains configuration information on the configuration table, parses the configuration information, and converts the parsed results into executable DDL statements. A database table structure and its relationship tables are generated based on the DDL statements. Finally, form definition data for the database table structure and its relationship tables is obtained, and a form parser is called in a browser for visual rendering to dynamically generate a target form. The form definition data includes the overall form structure, the linkage logic between components, and event handling rules. This solves the problem of heavy workload and slow response when adjusting forms during development and when requirements change. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] Figure 1 This is a flow chart of a method for generating a form provided by the first embodiment of the present invention;

[0027] Figure 2 It is a module diagram of a form generating device provided by the second embodiment of the present invention. DETAILED DESCRIPTION

[0028] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0029] In order to better understand the technical solution of the present invention, the embodiments of the present invention are described in detail below with reference to the accompanying drawings.

[0030] It should be understood that the embodiments described are only a portion of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative work are within the scope of protection of the present invention.

[0031] The terms used in the embodiments of the present invention are only for the purpose of describing specific embodiments and are not intended to limit the present invention. The singular forms "a", "an", "the" and "the" used in the embodiments of the present invention and the appended claims are also intended to include plural forms unless the context clearly indicates otherwise.

[0032] It should be understood that the term "and / or" as used herein is merely a description of the relationship between associated objects, indicating that three possible relationships exist. For example, "A and / or B" can represent: A exists alone, A and B exist simultaneously, or B exists alone. Furthermore, the character " / " in this document generally indicates that the associated objects are in an "or" relationship.

[0033] The word "if," as used herein, may be interpreted as "at the time of" or "when" or "in response to determining" or "in response to detecting," depending on the context. Similarly, the phrases "if it is determined" or "if (stated condition or event) is detected" may be interpreted as "when it is determined" or "in response to the determination" or "when detecting (stated condition or event)" or "in response to detecting (stated condition or event)," depending on the context.

[0034] The "first" and "second" mentioned in the embodiments are merely used to distinguish similar objects and do not represent a specific ordering of the objects. It is understood that the specific order or precedence of "first" and "second" can be interchanged where appropriate. It should be understood that the objects distinguished by "first" and "second" can be interchanged where appropriate, so that the embodiments described herein can be implemented in an order other than that illustrated or described herein.

[0035] The specific embodiments of the present invention are described in detail below with reference to the accompanying drawings.

[0036] The present invention discloses a form generation method, device, equipment and storage medium, aiming to solve the problem of heavy workload and slow response when adjusting forms when requirements change during development.

[0037] See also Figure 1A first embodiment of the present invention provides a form generation method, which can be executed by a form generation device (hereinafter referred to as a generation device), and in particular, by one or more processors in the generation device, to implement at least the following steps:

[0038] S101, obtaining a user's dragging operation on multiple components on a form design interface, and generating a configuration table corresponding to each component based on the dragging operation, wherein the configuration table includes a field code, field name, field type, field length, data validation rules, and interaction event configuration;

[0039] In this embodiment, the generating device may be a terminal with data processing capabilities such as a server, workstation, or desktop computer, which may be installed with a corresponding operating system and application software, and the functions required by this embodiment may be realized through the combination of the operating system and application software.

[0040] Specifically, in this embodiment, after the user logs into the design interface, the generation device initializes a complete form data model. This model includes a built-in field library that stores predefined field information and its attributes, such as field code, field name, field type, field length, data validation rules, and optional interaction event configuration. On the interface, the user selects the desired form components from the component library on the left by dragging and dropping them into the design area. The generation device captures these drag-and-drop operations in real time and generates a corresponding configuration table based on the operation sequence and component type.

[0041] Specifically, each drag operation generates a configuration record, which includes: field code (an identifier that uniquely identifies the field corresponding to the dragged component), field name (user-defined or default configured field display name), field type (such as text, number, date, drop-down box, etc.), field length (defining the maximum length of data storage or the size of the display area), data validation rules (setting input validity validation logic, such as required fields, format restrictions, etc.), and interactive event configuration (defining the response behavior of the component under specific events (such as clicks, value changes)).

[0042] At the same time, the form data model generated by the generator during initialization provides users with a target field selection mechanism through its built-in field library. During the drag-and-drop process, users are not simply importing components; instead, they are matching them based on the field information stored in the field library. Based on the user's drag-and-drop operation, the generator selects the corresponding target field from the form data model, ensuring that each dragged component remains consistent with the predefined data source.

[0043] Furthermore, to accommodate the needs of diverse business pages, the generator allows users to configure display conditions for dragged-in target fields and corresponding layout components. Users can set conditions for each component within the design area, such as only displaying the field or layout in the final form if it meets specific business logic or user roles. This allows the generator to generate multiple target forms in different configurations based on the same foundation, achieving a "dynamic rendering" effect.

[0044] S102, obtaining configuration information on the configuration table, parsing the configuration information, converting the parsed results into executable DDL statements, and generating a database table structure and its relationship table according to the DDL statements;

[0045] In this embodiment, the generation device first obtains the configuration information for each component from the configuration table generated during the form design process. This configuration information is stored in a JSON data structure and includes data such as field codes, field names, field types, field lengths, data validation rules, and interaction event configurations. The generation device then parses this JSON-formatted configuration information using a specially designed parsing module. The parsing module identifies the attribute information for each field and converts this information into an intermediate data structure based on pre-set mapping rules.

[0046] In the intermediate data structure after parsing, each field not only contains the basic name, data type and length, but also carries the corresponding validation rules and interaction event definitions. The parsing module generates executable DDL statements based on this information, wherein the DDL statements include database table structure definition (using the CREATE TABLE statement to define the table name and each field to ensure that each field in the form has a corresponding database column), field type (specify the appropriate data type (such as VARCHAR, INT, DATE, etc.) and field length for each field to meet data storage requirements), primary key and foreign key constraints (by defining PRIMARY KEY and FOREIGN KEY to ensure the uniqueness and association of data between tables), indexes and constraints (generate CREATE INDEX statements based on the characteristics of the field, and add NOT NULL, CHECK and other constraints in the DDL to ensure data integrity and query performance);

[0047] After the DDL statements are generated, the generation device calls the database interface to automatically submit the DDL statements to the backend database server for execution, thereby generating a complete database table structure and corresponding relationship tables. This ensures that the database structure accurately reflects the component configuration during form design. By automatically generating DDL statements, the risk of errors caused by manual adjustments to the database structure is reduced.

[0048] S103, obtaining the form definition data of the database table structure and its relationship table, and calling the form parser in the browser to perform visual rendering to dynamically generate the target form, wherein the form definition data includes the overall structure of the form, the linkage logic between components, and the event processing rules.

[0049] In this embodiment, the generating device first obtains the form definition data including the table structure and its relationship table from the database through a predefined data interface. The data is saved in a standardized JSON format and describes in detail the overall structure of the form, the arrangement and nesting relationship of each component, and the linkage logic and event handling rules between components. After obtaining the form definition data, the form parser in the front-end browser (for example, a componentized parser implemented based on Vue.js or React.js) is called. The parser first reconstructs the form page layout according to the overall structure of the form and renders each component with a preset template. The parser also parses the linkage logic and event handling rules embedded in the data, and binds these rules to the corresponding components.

[0050] After the target form is rendered, when the user performs interactive operations on the form, such as entering data, clicking a button, or selecting a drop-down menu, the front-end form parser immediately captures these operations and processes them accordingly based on the inter-component linkage logic and event handling rules preset in the data. For example, when a user modifies the content of an input box, the parser will automatically determine whether the display status or value of other components needs to be updated based on the linkage rules, and at the same time trigger the corresponding logical processing (such as verification, data linkage update, style adjustment, etc.), thereby achieving real-time and dynamic interactive response effects.

[0051] In a possible implementation of the present invention, after obtaining the user's dragging operation on multiple components on the form design interface, the method further includes: recording the relative position relationship between the components and incorporating the position relationship into a configuration table.

[0052] It should be noted that after capturing the user's dragging and dropping operations on multiple components on the form design interface, the generating device not only records the basic configuration information of each component, but also obtains and stores the relative position relationship between the components in real time. This position relationship exists in the form of specific coordinates or relative arrangement order, and is included in the generated configuration table, together with other parameters such as field code, field name, field type, field length, data validation rules and interactive event configuration to form complete component configuration data. By integrating the position information between components into the configuration table, the generating device can restore the layout designed by the user during the form parsing and rendering process, effectively solving the problem of interface reconstruction deviation caused by the lack of position information in traditional form design, so that when the target form is dynamically generated, it can meet both functional requirements and the user's personalized customization of the page layout.

[0053] In a possible implementation of the present invention, the present invention further includes:

[0054] When multiple other form data are introduced into the same form, when it is determined that there are identical fields, the fields are distinguished according to the form data field validity context, wherein the form data field validity context is set according to the form field component;

[0055] Based on the differentiation result, when editing and verifying the form data, the fields belonging to the current form data source are made effective, so that multiple different form data can be associated and referenced in one form.

[0056] It should be noted that in this embodiment, in order to solve the problem of confusion in field ownership due to repeated field names when introducing multiple other form data into the same form, the generation device introduces the concept of "form data field effective context" in the form design process. Specifically, when the R&D personnel introduce data from multiple other forms into the same form in the design interface, the generation device will automatically identify each form field component and set an effective context associated with the field to indicate the specific data source to which the field belongs. When the existence of the same field name is detected, the generation device distinguishes the fields based on the effective context, thereby avoiding confusion during data collection, editing and verification caused by repeated fields.

[0057] Subsequently, when the user edits or submits the form data for verification, the generating device reads the effective context set in the field component based on the currently active form data source, and only activates and processes the fields belonging to that data source, while ignoring fields with the same name but different contexts in other data sources, thereby ensuring that each form data set can be processed independently and accurately during the editing and verification process.

[0058] See also Figure 2 A second embodiment of the present invention provides a form generation device, comprising:

[0059] A configuration table generation unit 201 is used to obtain a user's dragging operation on multiple components on the form design interface and generate a configuration table corresponding to each component based on the dragging operation, wherein the configuration table includes field code, field name, field type, field length, data validation rules, and interaction event configuration;

[0060] The parsing unit 202 is used to obtain the configuration information on the configuration table, parse the configuration information, convert the parsing results into executable DDL statements, and generate a database table structure and its relationship table according to the DDL statements;

[0061] The target form generation unit 203 is used to obtain the form definition data of the database table structure and its relationship table, and call the form parser in the browser to perform visual rendering to dynamically generate the target form, wherein the form definition data includes the overall structure of the form, the linkage logic between components and the event processing rules.

[0062] A third embodiment of the present invention provides a form generation device, characterized in that it includes a memory and a processor, the memory stores a computer program, and the computer program can be executed by the processor to implement a form generation method as described in any one of the above.

[0063] A fourth embodiment of the present invention provides a computer-readable storage medium, characterized in that it stores a computer program, and the computer program can be executed by a processor of the device where the computer-readable storage medium is located to implement a form generation method as described in any one of the above items.

[0064] The present invention provides a form generation method, apparatus, device, and storage medium. The method first obtains a user's drag-and-drop operation on multiple components on a form design interface, generates a configuration table corresponding to each component based on the drag-and-drop operation, then obtains configuration information on the configuration table, parses the configuration information, and converts the parsed results into executable DDL statements. A database table structure and its relationship tables are generated based on the DDL statements. Finally, form definition data for the database table structure and its relationship tables is obtained, and a form parser is called in a browser for visual rendering to dynamically generate a target form. The form definition data includes the overall form structure, the linkage logic between components, and event handling rules. This solves the problem of heavy workload and slow response when adjusting forms during development and when requirements change.

[0065] For example, the computer programs described in the third and fourth embodiments of the present invention may be divided into one or more modules, which are stored in the memory and executed by the processor to implement the present invention. The one or more modules may be a series of computer program instruction segments capable of performing specific functions, each of which describes the execution process of the computer program in the device for generating a form. For example, the apparatus described in the second embodiment of the present invention may be included.

[0066] The processor may be a central processing unit (CPU), other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA), other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or any conventional processor. The processor serves as the control center of the form generation method, connecting various parts of the form generation method using various interfaces and circuits.

[0067] The memory can be used to store the computer program and / or module, and the processor implements various functions of a form generation method by running or executing the computer program and / or module stored in the memory and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application required for a function (such as a sound playback function, a text conversion function, etc.); the data storage area can store data created based on the use of the mobile phone (such as audio data, text message data, etc.). In addition, the memory can include a high-speed random access memory and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (Flash Card), at least one disk storage device, a flash memory device, or other volatile solid-state storage device.

[0068] Wherein, if the implemented module is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the present invention implements all or part of the process in the above-mentioned embodiment method, and can also be completed by a computer program to instruct the relevant hardware. The computer program can be stored in a computer-readable storage medium. When the computer program is executed by the processor, it can implement the steps of each of the above-mentioned method embodiments. Wherein, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, USB flash drive, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electric carrier signal, telecommunication signal and software distribution medium. It should be noted that the content contained in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, computer-readable media do not include electric carrier signals and telecommunication signals.

[0069] It should be noted that the device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed across multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the present embodiment. In addition, in the drawings of the device embodiments provided by the present invention, the connection relationship between the modules indicates that there is a communication connection between them, which may be specifically implemented as one or more communication buses or signal lines. A person of ordinary skill in the art can understand and implement the present invention without inventive effort.

[0070] The above description is merely a preferred embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any changes or substitutions that can be easily conceived by a person skilled in the art within the technical scope disclosed in the present invention should be included in the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be based on the scope of protection of the claims.

Claims

1. A method for generating a form, characterized in that: include: Obtaining a user's dragging operation on multiple components on a form design interface, and generating a configuration table corresponding to each component based on the dragging operation, wherein the configuration table includes field code, field name, field type, field length, data validation rules, and interaction event configuration; Obtaining configuration information on the configuration table, parsing the configuration information, converting the parsing results into executable DDL statements, and generating a database table structure and its relationship table according to the DDL statements; Obtain the form definition data of the database table structure and its relationship table, and call the form parser in the browser for visual rendering to dynamically generate the target form, wherein the form definition data includes the overall form structure, linkage logic between components, and event handling rules.

2. The method for generating a form according to claim 1, wherein: After obtaining the user's dragging operation on multiple components on the form design interface, the method further includes: recording the relative position relationship between the components and including the position relationship in the configuration table.

3. The method for generating a form according to claim 1, wherein: Also includes: When multiple other form data are introduced into the same form, when it is determined that there are identical fields, the fields are distinguished according to the form data field validity context, wherein the form data field validity context is set according to the form field component; Based on the differentiation result, when editing and verifying the form data, the fields belonging to the current form data source are made effective, so that multiple different form data can be associated and referenced in one form.

4. The method for generating a form according to claim 1, wherein: The method of obtaining a user's dragging operation on multiple components on a form design interface and generating a configuration table corresponding to each component based on the dragging operation is as follows: During the initialization process, a form data model is generated, and corresponding target fields are selected from the form data model according to a user's drag-and-drop operation on multiple components on a form design interface, wherein the form data model is configured with a field library; Drag the target field into the form design area, and configure display conditions for the target field and layout components according to the requirements of different business pages, so that the fields and layouts that meet specific conditions are presented in the target business scenario.

5. The method for generating a form according to claim 1, wherein: The DDL statement includes database table structure definition, field types, primary keys, foreign keys, indexes and constraints.

6. The method for generating a form according to claim 1, wherein: After obtaining the form definition data of the database table structure and its relationship table, and calling the form parser in the browser for visual rendering to dynamically generate the target form, it also includes: performing real-time interactive response on the target form according to the linkage logic and event processing rules between the components.

7. A form generating device, characterized in that: include: A configuration table generating unit, configured to obtain a user's dragging operation on multiple components on a form design interface, and generate a configuration table corresponding to each component based on the dragging operation, wherein the configuration table includes a field code, field name, field type, field length, data validation rules, and interaction event configuration; A parsing unit, configured to obtain configuration information on the configuration table, parse the configuration information, convert the parsing result into an executable DDL statement, and generate a database table structure and its relationship table according to the DDL statement; The target form generation unit is used to obtain the form definition data of the database table structure and its relationship table, and call the form parser in the browser for visual rendering to dynamically generate the target form, wherein the form definition data includes the overall structure of the form, the linkage logic between components and the event processing rules.

8. A form generating device, characterized in that: The system comprises a memory and a processor, wherein the memory stores a computer program, and the computer program can be executed by the processor to implement a form generation method according to any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that A computer program is stored, and the computer program can be executed by a processor of the device where the computer-readable storage medium is located to implement a form generation method as described in any one of claims 1 to 6.

Images