CN115510052A - Dynamic form and database-based dynamic verification method and system - Google Patents
Dynamic form and database-based dynamic verification method and system Download PDFInfo
- Publication number
- CN115510052A CN115510052A CN202210815952.3A CN202210815952A CN115510052A CN 115510052 A CN115510052 A CN 115510052A CN 202210815952 A CN202210815952 A CN 202210815952A CN 115510052 A CN115510052 A CN 115510052A
- Authority
- CN
- China
- Prior art keywords
- service
- field
- dynamic form
- dynamic
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Abstract
The invention discloses a method and a system based on dynamic verification of a dynamic form and a database, wherein the method comprises the following steps: respectively listing service names, service comments and service types of different service requirements according to the service requirements to create a plurality of service data tables respectively corresponding to the different service requirements, and configuring service field data items to the service data tables corresponding to the current service requirements according to the service requirements, wherein the service field data items comprise service rules SQL; creating a dynamic form and a display page corresponding to the dynamic form; detecting a field value input into the dynamic form in the display page by a user; executing a business rule SQL by combining a database corresponding to the current business requirement to obtain a result, and returning the result to the display page through the database; the invention can meet the requirement of linkage of the data items of the service field and the data of the database, and improves the service compatibility of the dynamic form.
Description
Technical Field
The invention relates to the technical field of dynamic verification, in particular to a dynamic verification method and a dynamic verification system based on a dynamic form and a database.
Background
At present, with the popularization of modes of handling business on the internet plus such as electronic government affairs, various forms need to be filled in a webpage when the business is handled, a user clicks data items filled in the forms when submitting to carry out compliance verification according to business rules, and the problems of the filled information are prompted; in order to meet the requirement of rapid development rhythm, a plurality of software companies develop agile development type and low-code development platforms, a configurable data structure and a configurable simple verification rule are used, a user request is forwarded through a route by configuration of a predefined route forwarding rule, an html template file, a dynamic form definition, a form verification rule and the like, the user request data is analyzed, the rendering of a page file which is requested to be accessed by the user is completed at a server side, and the page file is finally output to a browser for the user to use.
The above mode is based on a configuration mode, only simple format check of data items in the form is realized, and service linkage check with other service data cannot be realized, for example, only checking and judging that the quantity of the discharged stock is a positive integer when the commodity is discharged from the stock is carried out, if the stock is required to be judged to be satisfied, a code needs to be compiled and then judged in a background after the form is submitted, or the data is acquired before the interface form of the commodity stock is compiled and the quantity of the discharged stock of the form is judged, so that the development workload is increased; in practice, multiple services are parallel in most service systems, the corresponding contents of forms are many, often, one page form associates multiple service data, and the data are interdependent, so that the original simple data format verification based on the dynamic form page configuration cannot meet the complex service logic requirement, and a method capable of realizing the automatic service verification of configurable dynamic form data items and database data is needed.
Disclosure of Invention
Aiming at the problems, the invention discloses a method and a system for dynamic verification based on a dynamic form and a database, wherein the method comprises the following steps:
respectively listing service names, service comments and service types of different service requirements according to the service requirements to create a plurality of service data tables respectively corresponding to the different service requirements, and configuring service field data items to the service data tables corresponding to the current service requirements according to the service requirements, wherein the service field data items comprise service rules SQL;
creating a dynamic form and a display page corresponding to the dynamic form, wherein the dynamic form comprises a plurality of service data tables which are configured with service field data items;
receiving field values input into the dynamic form in the display page by a user;
assembling the field values according to the business rule SQL, and executing the business rule SQL by combining with a database corresponding to the current business requirement to obtain a result, wherein the result is returned to the display page through the database, and the result comprises enabling the field values in the dynamic form, disabling the field values in the dynamic form and processing field display, field hiding and displaying of the business field data items in the dynamic form;
and displaying the result, and prompting the user to meet or not meet the requirement of the business rule SQL.
Further, the service field data item further includes a field name, a field type, and a field check format.
Further, the configuring of the service field data item to the service data table corresponding to the current service requirement according to the service requirement includes: according to the business requirements, writing a business rule SQL with a specific format, and configuring a triggering mode of the business rule.
Further, the business rule SQL specifically includes:
further, the triggering method includes: an entry box of a field gets focus, an entry box of a field loses focus, an entry box value of a field changes.
Further, the system comprises:
the configuration module is used for creating a plurality of service data tables respectively corresponding to different service requirements and configuring service field data items to the service data tables corresponding to the current service requirements according to the service requirements; the service data table comprises service names, service comments and service types required by the services; the service field data item comprises a service rule SQL;
the page generation module is used for generating a dynamic form and a display page corresponding to the dynamic form, wherein the dynamic form comprises a plurality of service data tables which are configured with service field data items;
the input module is used for receiving fields input by a user and transmitting the fields to the verification module;
the verification module is used for verifying the fields input by the user and outputting results to the display module;
and the display module is used for displaying the output result and prompting the user whether to meet the requirements of the business rule SQL.
Has the beneficial effects that: the method and the system based on dynamic verification of the dynamic form and the database can meet the requirement of linkage of the data items of the business fields and the data of the database, improve the business compatibility of the dynamic form, reduce the development cost and improve the economic benefit.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
Fig. 1 is a schematic diagram illustrating a method for dynamic checking based on a dynamic form and a database according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
As shown in fig. 1, the present invention discloses a dynamic verification method based on a dynamic form and a database, which comprises:
respectively listing service names, service comments and service types of different service requirements on a front-end page according to a plurality of service requirements to create a plurality of service data tables respectively corresponding to the different service requirements, and configuring service field data items to the service data tables corresponding to the current service requirements according to the service requirements, wherein the service field data items comprise service rules SQL;
in the actual process of the invention, a background business data model engine calls a business data model stored in a database to create a display page corresponding to the dynamic form, the display page can return instruction display contents through the database, and the dynamic form comprises a plurality of business data tables which are configured with business field data items;
receiving a field value input into the dynamic form in the display page by a user;
assembling the field values according to the business rules SQL, executing the business rules SQL by combining with a database corresponding to the current business requirements to obtain results, returning the results to the display page through the database, in the actual process, interacting the business rules SQL with the database through a background business verification engine and completing verification, wherein the results comprise enabling the field values in the dynamic form, disabling the field values in the dynamic form and processing field display, field hiding and displaying linkage business field data sets of the business field data items in the dynamic form;
displaying the result and prompting the user to meet or not meet the requirement of the business rule SQL; and prompting the unsatisfied reason when the dynamic form data does not meet the requirement, and clicking a 'submit' button by a user to store the dynamic form data after the dynamic form data meets the requirement.
As an embodiment of the present invention, the service field data item further includes a field name, a field type, and a field check format.
As an embodiment of the present invention, the configuring a service field data item to the service data table corresponding to the current service requirement according to a service requirement includes: according to the business requirements, writing a business rule SQL with a specific format, and configuring a trigger mode of the business rule, wherein the trigger mode comprises the following steps: an entry box of a field gets focus, an entry box of a field loses focus, an entry box value of a field changes.
As an embodiment of the present invention, the business rule SQL specifically includes:
for example, in the case of a liquid,
example 1: the user fills in the quantity of the commodities to be delivered out of the warehouse, triggers the business rule when the input box loses focus, calls the business rule sql, and obtains whether the quantity of the commodities in the warehouse meets the requirement of the quantity of the commodities to be delivered out of the warehouse or not; if the requirement is not met, forbidding the ex-warehouse person and the ex-warehouse date field according to the returned result and prompting that the inventory of the commodity is insufficient on the form page; the specific business rule SQL is as follows:
example 2: the method comprises the steps that epidemic situation management and control personnel register, and when the personnel management and control type is centralized isolation, centralized isolation point data in a street are triggered to be obtained, and an isolation point entering time field is started; when the house isolation is selected, the name of the isolation point and the time field of the access isolation point are forbidden; the specific business rule SQL is as follows:
the embodiment of the invention also discloses a system based on dynamic verification of the dynamic form and the database, which comprises:
the configuration module is used for creating a plurality of service data tables respectively corresponding to different service requirements and configuring service field data items to the service data tables corresponding to the current service requirements according to the service requirements; the service data table comprises service names, service comments and service types required by the services; the service field data item comprises a service rule SQL;
the page generation module is used for generating a dynamic form and a display page corresponding to the dynamic form, wherein the dynamic form comprises a plurality of service data tables which are configured with service field data items;
the input module is used for receiving fields input by a user and transmitting the fields to the verification module;
the verification module is used for verifying the fields input by the user and outputting results to the display module;
and the display module is used for displaying the output result and prompting the user whether to meet the requirements of the business rule SQL.
In summary, the method and the system for dynamically verifying the dynamic form and the database, which are designed by the invention, meet the requirement of linkage between the data items of the business field and the data of the database, improve the business compatibility of the dynamic form, reduce the development cost and improve the economic benefit.
Finally, it is further noted that, herein, relational terms such as one and the other, and the like, may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrases "comprising one of 8230; \8230;" 8230; "does not exclude the presence of additional like elements in a process, method, article, or apparatus that comprises the element.
Although the present invention has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (6)
1. A method for dynamic verification based on a dynamic form and a database is characterized in that the method comprises the following steps:
respectively listing service names, service comments and service types of different service requirements according to the service requirements to create a plurality of service data tables respectively corresponding to the different service requirements, and configuring service field data items to the service data tables corresponding to the current service requirements according to the service requirements, wherein the service field data items comprise service rules SQL;
creating a dynamic form and a display page corresponding to the dynamic form, wherein the dynamic form comprises a plurality of service data tables which are configured with service field data items;
receiving a field value input into the dynamic form in the display page by a user;
assembling the field values according to the business rule SQL, and executing the business rule SQL by combining with a database corresponding to the current business requirement to obtain a result, wherein the result is returned to the display page through the database, and the result comprises enabling the field values in the dynamic form, disabling the field values in the dynamic form and processing field display, field hiding and displaying of the business field data items in the dynamic form;
and displaying the result, and prompting the user to meet or not meet the requirement of the business rule SQL.
2. The method of claim 1, wherein the service field data item further comprises a field name, a field type, and a field check format.
3. The method according to claim 1, wherein the configuring of the service field data item according to the service requirement to the service data table corresponding to the current service requirement comprises: according to the business requirements, writing a business rule SQL with a specific format, and configuring a triggering mode of the business rule.
4. The method for dynamic verification of a dynamic form and a database according to claim 3, wherein the SQL service rule specifically comprises:
{
service field data item: {
The field name: the number of fields 1 is set to be,
the field type: in the case of the format 1,
the field check format is as follows: [ regular expression 1, \ 8230; ],
the business rule SQL: {
And (3) disabling: the "field 2, field 3',
starting: the "field 4, field 5',
as a result: 'satisfy/not satisfy',
and (4) prompting: ' text prompt! ',
linkage service field data set: { field 7, field 8}
}
}
}。
5. The method according to claim 3, wherein the triggering method comprises: an entry box of a field gets focus, an entry box of a field loses focus, an entry box value of a field changes.
6. A system for dynamic verification of a dynamic form against a database, the system comprising:
the configuration module is used for creating a plurality of service data tables respectively corresponding to different service requirements and configuring service field data items to the service data tables corresponding to the current service requirements according to the service requirements; the service data table comprises service names, service comments and service types required by the services; the service field data item comprises a service rule SQL;
the page generation module is used for generating a dynamic form and a display page corresponding to the dynamic form, wherein the dynamic form comprises a plurality of service data tables which are configured with service field data items;
the input module is used for receiving a field input by a user and transmitting the field to the verification module;
the verification module is used for verifying the fields input by the user and outputting results to the display module;
and the display module is used for displaying the output result and prompting the user whether to meet the requirement of the business rule SQL.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210815952.3A CN115510052A (en) | 2022-07-12 | 2022-07-12 | Dynamic form and database-based dynamic verification method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210815952.3A CN115510052A (en) | 2022-07-12 | 2022-07-12 | Dynamic form and database-based dynamic verification method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115510052A true CN115510052A (en) | 2022-12-23 |
Family
ID=84501271
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210815952.3A Pending CN115510052A (en) | 2022-07-12 | 2022-07-12 | Dynamic form and database-based dynamic verification method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115510052A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116049268A (en) * | 2023-03-22 | 2023-05-02 | 广东粤港澳大湾区国家纳米科技创新研究院 | Method and device for realizing local dynamic form display |
-
2022
- 2022-07-12 CN CN202210815952.3A patent/CN115510052A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116049268A (en) * | 2023-03-22 | 2023-05-02 | 广东粤港澳大湾区国家纳米科技创新研究院 | Method and device for realizing local dynamic form display |
| CN116049268B (en) * | 2023-03-22 | 2023-06-16 | 广东粤港澳大湾区国家纳米科技创新研究院 | Method and device for realizing local dynamic form display |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108027833B (en) | Method for creating structured data language query | |
| Bernstein et al. | Information integration in the enterprise | |
| US11106675B2 (en) | System and method for identifying optimal test cases for software development | |
| US8321356B2 (en) | System and method for calculating real-time costing information | |
| US9280569B2 (en) | Schema matching for data migration | |
| US7702609B2 (en) | Adapting to inexact user input | |
| US10042921B2 (en) | Robust and readily domain-adaptable natural language interface to databases | |
| US20140344297A1 (en) | System and method for managing master data to resolve reference data of business transactions | |
| US20060173672A1 (en) | Processing health care transactions using a semantic network | |
| CN101004814A (en) | Data element naming system and method | |
| CN112907333B (en) | Intelligent matching method, device and equipment based on block chain and storage medium | |
| US20110246535A1 (en) | Apparatus and Method for Constructing Data Applications in an Unstructured Data Environment | |
| US20050033583A1 (en) | Processing transactions using a structured natural language | |
| US20070156977A1 (en) | Automatic location data determination in an electronic document | |
| CN115510052A (en) | Dynamic form and database-based dynamic verification method and system | |
| US8406384B1 (en) | Universally tagged frequent call-routing user queries as a knowledge base for reuse across applications | |
| US20060150082A1 (en) | Multimodal markup language tags | |
| Nakajima et al. | An object-oriented modeling method for algebraic specifications in CafeOBJ | |
| US11176324B2 (en) | Creating line item information from free-form tabular data | |
| US8341176B1 (en) | Structure-based expansion of user element selection | |
| CN113687827B (en) | Data list generation method, device and equipment based on widget and storage medium | |
| US20130300562A1 (en) | Generating delivery notification | |
| US7694307B2 (en) | Analytical task invocation | |
| Forcher et al. | Semantic logging: Towards explanation-aware das | |
| Weigand et al. | An extensible business communication language |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |