Dynamic query function generation method and system and readable storage medium

Abstract

The invention provides a query function dynamic generation method and system and a readable storage medium, and the query function dynamic generation method comprises the steps: responding to query function triggering input from a user, and displaying a visual interface to the user; determining initial configuration information in response to setting input of a user on the visual interface; analyzing and verifying the initial configuration information through a configuration information analysis verification algorithm to obtain configuration information; and performing query statement generation on the configuration information through a dynamic query statement generation algorithm to obtain a query statement, and performing query operation according to the query statement to obtain a query result. According to the technical scheme, the user can flexibly configure the query condition and the query logic according to own requirements, so that the required information can be quickly and accurately obtained.

Description

Technical Field

[0001] The present application relates to the technical field of query statement generation, and in particular to a query function dynamic generation method and system, and a readable storage medium. Background Art

[0002] Currently, query functions are usually implemented by pre-writing fixed code logic. This approach has many limitations, such as: when requirements change, a large number of code modifications and recompilations are required, resulting in a long development cycle and high costs; it cannot flexibly adapt to the personalized query needs of different users; it is difficult to quickly respond to dynamic changes in the business, reducing work efficiency and user experience. Summary of the invention

[0003] This application aims to solve or improve the above technical problems.

[0004] To this end, the first objective of the present application is to provide a method for dynamically generating query functions.

[0005] The second objective of the present application is to provide a query function dynamic generation system.

[0006] The third objective of the present application is to provide a query function dynamic generation system.

[0007] The fourth object of the present application is to provide a readable storage medium.

[0008] To achieve the first purpose of the present application, the technical solution of the first aspect of the present application provides a method for dynamically generating a query function, which is applied to a query function dynamic generation system. The method for dynamically generating a query function is executed by a processor, and the method for dynamically generating a query function includes: in response to a query function trigger input from a user, displaying a visual interface to a user; in response to a setting input from a user on the visual interface, determining initial configuration information; parsing and verifying the initial configuration information through a configuration information parsing and verification algorithm to obtain configuration information; generating a query statement for the configuration information through a dynamic query statement generation algorithm to obtain a query statement, and performing a query operation according to the query statement to obtain a query result.

[0009] According to the query function dynamic generation method provided by the present application, first respond to the query function trigger input from the user and display the visual interface to the user. Then the user enters the custom configuration information through the visual interface, including query fields, query conditions, sorting rules, etc. Then the initial configuration information is parsed and verified by the configuration information parsing and verification algorithm to obtain the configuration information to ensure the legality and validity of the configuration. According to the parsed configuration information, the corresponding query statement is generated by the dynamic query statement generation algorithm, and the query operation is performed to obtain the query result. The configuration information parsing and verification algorithm can accurately identify the various configuration parameters input by the user and determine whether they are legal and valid. The dynamic query statement generation algorithm can quickly generate efficient query statements according to different configuration information. Through the query function dynamic generation method of the present application, users can customize the query function independently, quickly obtain the required data, reduce waiting time and operation complexity, and improve user satisfaction and stickiness to the system. Flexible query configuration enables users to analyze data more deeply and comprehensively, discover potential business rules and trends, and provide strong support for decision-making. Rapid response to changes in business needs helps enterprises to develop new business models and services and enhance market competitiveness. The query logic generated according to the configuration can obtain data more accurately, avoid unnecessary data reading and processing, reduce system resource consumption, and improve overall performance.

[0010] In addition, the technical solution provided by this application may also have the following additional technical features: In some technical solutions, optionally, the method for dynamically generating a query function further includes: displaying the query result to the user according to a preset format.

[0011] In the technical solution, the query function dynamic generation method also includes displaying the query results to the user according to a preset format. Specifically, after the query statement is generated, the system executes the query operation and displays the results according to the format specified by the user.

[0012] In some technical solutions, optionally, the query function dynamic generation method also includes: storing the configuration information in a relational database, and performing data encryption processing on the configuration information.

[0013] In this technical solution, the query function dynamic generation method also includes storing the configuration information in a relational database and performing data encryption processing on the configuration information to ensure data security. Specifically, a relational database (such as MySQL, Oracle) is used to store the user's configuration information. When storing the configuration information, data encryption processing is performed. An efficient and stable configuration information storage solution ensures the security, integrity and rapid retrieval capability of the configuration data.

[0014] In some technical solutions, optionally, the initial configuration information is parsed and verified through a configuration information parsing and verification algorithm to obtain configuration information, including: determining whether the name of the query field exists; if so, determining whether the query condition complies with the grammatical rules; if so, determining whether the sorting rules are valid; if so, the initial configuration information is the configuration information.

[0015] In this technical solution, the initial configuration information is parsed and verified by the configuration information parsing and verification algorithm to obtain the configuration information, specifically, to determine whether the name of the query field exists. If so, it is determined whether the query condition complies with the grammatical rules. If so, it is determined whether the sorting rules are valid. If so, the initial configuration information is the configuration information. By using the pre-written configuration information parsing and verification algorithm to process the initial configuration information, it is possible to accurately identify the various configuration parameters input by the user and determine whether they are legal and valid.

[0016] In some technical solutions, optionally, the initial configuration information includes one of the following or a combination thereof: query field, query condition, sorting rule, and result display format.

[0017] In this technical solution, the initial configuration information includes one of the following or a combination thereof: query field, query condition, sorting rule, and result display format.

[0018] In some technical solutions, optionally, the preset format includes a table and / or a chart.

[0019] In this technical solution, the preset format includes a table and / or a chart.

[0020] In some technical solutions, optionally, the storage structure of the configuration information includes a table structure and / or a document structure, and the table structure and / or the document structure both include a configuration identifier, a user identifier, a query field, a query condition, a sorting rule, and a result display format.

[0021] In this technical solution, for the storage structure of configuration information, a reasonable table structure or document structure is designed, which includes key information such as configuration identification, user identification, query field, query conditions, sorting rules, result display format, etc. At the same time, appropriate indexes are established to improve the retrieval efficiency of configuration information.

[0022] To achieve the second purpose of the present application, the technical solution of the second aspect of the present application provides a query function dynamic generation system, including: a first response module, used to respond to the query function trigger input from the user and display a visual interface to the user; a second response module, used to respond to the setting input from the user in the visual interface and determine the initial configuration information; a parsing and verification module, used to parse and verify the initial configuration information through a configuration information parsing and verification algorithm to obtain the configuration information; a generation module, used to generate a query statement for the configuration information through a dynamic query statement generation algorithm to obtain a query statement, and perform a query operation according to the query statement to obtain a query result.

[0023] According to the query function dynamic generation system provided by the present application, it includes a first response module, a second response module, a parsing and verification module and a generation module. Among them, the first response module is used to respond to the query function trigger input from the user and display the visual interface to the user. The second response module is used to respond to the setting input from the user in the visual interface to determine the initial configuration information. The parsing and verification module is used to parse and verify the initial configuration information through the configuration information parsing and verification algorithm to obtain the configuration information. The generation module is used to generate a query statement for the configuration information through a dynamic query statement generation algorithm to obtain a query statement, and perform a query operation according to the query statement to obtain a query result. Through the query function dynamic generation system of the present application, users can customize the query function independently, quickly obtain the required data, reduce waiting time and operation complexity, and improve user satisfaction and stickiness with the system. Flexible query configuration enables users to analyze data more deeply and comprehensively, discover potential business rules and trends, and provide strong support for decision-making. Rapid response to changes in business needs helps enterprises to develop new business models and services and enhance market competitiveness. The query logic generated according to the configuration can obtain data more accurately, avoid unnecessary data reading and processing, reduce system resource consumption, and improve overall performance.

[0024] To achieve the third purpose of the present application, the technical solution of the third aspect of the present application provides a query function dynamic generation system, including: a memory and a processor, wherein the memory stores programs or instructions that can be run on the processor, and when the processor executes the program or instructions, it implements the query function dynamic generation method of any one of the technical solutions of the first aspect, and thus has the technical effect of any one of the technical solutions of the first aspect, which will not be repeated here.

[0025] In order to achieve the fourth purpose of the present application, the technical solution of the fourth aspect of the present application provides a readable storage medium on which a program or instruction is stored. When the program or instruction is executed by the processor, the steps of the query function dynamic generation method of any one of the technical solutions of the first aspect are implemented, and thus it has the technical effect of any one of the technical solutions of the first aspect mentioned above, which will not be repeated here.

[0026] Additional aspects and advantages of the present application will become apparent in the following description or will be learned through practice of the present application. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] The above and / or additional aspects and advantages of the present application will become apparent and easily understood from the description of the embodiments in conjunction with the following drawings, in which: Figure 1 A schematic diagram of the steps of a method for dynamically generating a query function according to an embodiment of the present application; Figure 2 A schematic diagram of the steps of a method for dynamically generating a query function according to an embodiment of the present application; Figure 3 A schematic diagram of the steps of a method for dynamically generating a query function according to an embodiment of the present application; Figure 4 A schematic diagram of the steps of a method for dynamically generating a query function according to an embodiment of the present application; Figure 5 A schematic block diagram of the structure of a query function dynamic generation system according to an embodiment of the present application; Figure 6 A schematic block diagram of the structure of a query function dynamic generation system according to an embodiment of the present application; Figure 7 This is a business flow chart of a method for dynamically generating a query function according to an embodiment of the present application.

[0028] in, Figure 5 and Figure 6 The corresponding relationship between the reference numerals and component names in the figure is: 10: query function dynamic generation system; 110: first response module; 120: second response module; 130: analysis and verification module; 140: generation module; 20: query function dynamic generation system; 300: memory; 400: processor. DETAILED DESCRIPTION

[0029] In order to more clearly understand the above-mentioned purposes, features and advantages of the present application, the present application is further described in detail below in conjunction with the accompanying drawings and specific implementation methods. It should be noted that the embodiments of the present application and the features in the embodiments can be combined with each other without conflict.

[0030] In the following description, many specific details are set forth to facilitate a full understanding of the present application. However, the present application may also be implemented in other ways different from those described herein. Therefore, the scope of protection of the present application is not limited to the specific embodiments disclosed below.

[0031] Refer to the following Figures 1 to 7Describe the query function dynamic generation method and system and readable storage medium of some embodiments of the present application.

[0032] like Figure 1 As shown, the embodiment of the first aspect of the present application provides a query function dynamic generation method, which is applied to a query function dynamic generation system. The query function dynamic generation method is executed by a processor, and the query function dynamic generation method includes the following steps: Step S102: in response to a query function trigger input from a user, displaying a visualization interface to the user; Step S104: determining initial configuration information in response to a setting input from a user on a visual interface; Step S106: parsing and verifying the initial configuration information through a configuration information parsing and verification algorithm to obtain configuration information; Step S108: Generate a query statement for the configuration information using a dynamic query statement generation algorithm to obtain a query statement, and perform a query operation according to the query statement to obtain a query result.

[0033] According to the query function dynamic generation method provided by this embodiment, first respond to the query function trigger input from the user and display the visual interface to the user. Then the user enters the custom configuration information through the visual interface, including query fields, query conditions, sorting rules, etc. Then the initial configuration information is parsed and verified by the configuration information parsing and verification algorithm to obtain the configuration information to ensure the legality and validity of the configuration. According to the parsed configuration information, the corresponding query statement is generated by the dynamic query statement generation algorithm, and the query operation is performed to obtain the query result. The configuration information parsing and verification algorithm can accurately identify the various configuration parameters input by the user and determine whether they are legal and valid. The dynamic query statement generation algorithm can quickly generate efficient query statements according to different configuration information. Through the query function dynamic generation method of the present application, users can customize the query function independently, quickly obtain the required data, reduce waiting time and operation complexity, and improve user satisfaction and stickiness to the system. Flexible query configuration enables users to analyze data more deeply and comprehensively, discover potential business rules and trends, and provide strong support for decision-making. Rapid response to changes in business needs helps enterprises to develop new business models and services and enhance market competitiveness. The query logic generated according to the configuration can obtain data more accurately, avoid unnecessary data reading and processing, reduce system resource consumption, and improve overall performance.

[0034] like Figure 2 As shown, according to an embodiment of the query function dynamic generation method proposed in the present application, the following steps are also included: Step S202: Displaying the query results to the user according to a preset format.

[0035] In this embodiment, the query function dynamic generation method further includes displaying the query result to the user according to a preset format. Specifically, after the query statement is generated, the system executes the query operation and displays the result according to the format specified by the user.

[0036] like Figure 3 As shown, according to an embodiment of the query function dynamic generation method proposed in the present application, the following steps are also included: Step S302: Store the configuration information in a relational database and perform data encryption on the configuration information.

[0037] In this embodiment, the query function dynamic generation method also includes storing the configuration information in a relational database and performing data encryption processing on the configuration information to ensure data security. Specifically, a relational database (such as MySQL, Oracle) is used to store the user's configuration information. When storing the configuration information, data encryption processing is performed. An efficient and stable configuration information storage solution ensures the security, integrity and rapid retrieval capability of the configuration data.

[0038] like Figure 4 As shown, according to a query function dynamic generation method of an embodiment proposed in the present application, the initial configuration information is parsed and verified by a configuration information parsing and verification algorithm to obtain configuration information, which specifically includes the following steps: Step S402: determine whether the name of the query field exists; Step S404: If yes, determine whether the query condition complies with the grammatical rules; Step S406: If yes, determine whether the sorting rule is valid; Step S408: If yes, the initial configuration information is configuration information.

[0039] In this embodiment, the initial configuration information is parsed and verified by the configuration information parsing and verification algorithm to obtain the configuration information, specifically, whether the name of the query field exists. If so, it is determined whether the query condition conforms to the grammatical rules. If so, it is determined whether the sorting rules are valid. If so, the initial configuration information is the configuration information. By using the pre-written configuration information parsing and verification algorithm to process the initial configuration information, it is possible to accurately identify various configuration parameters input by the user and determine whether they are legal and valid.

[0040] In some embodiments, optionally, the initial configuration information includes one of the following or a combination thereof: query field, query condition, sorting rule, and result display format.

[0041] In some embodiments, optionally, the preset format includes a table and / or a chart.

[0042] In some embodiments, for the storage structure of configuration information, a reasonable table structure or document structure is optionally designed, including key information such as configuration identification, user identification, query field, query conditions, sorting rules, result display format, etc. At the same time, an appropriate index is established to improve the retrieval efficiency of configuration information.

[0043] like Figure 5 As shown, an embodiment of the second aspect of the present application provides a query function dynamic generation system 10, including: a first response module 110, used to respond to a query function trigger input from a user and display a visual interface to a user; a second response module 120, used to respond to a setting input from a user in the visual interface and determine initial configuration information; a parsing and verification module 130, used to parse and verify the initial configuration information through a configuration information parsing and verification algorithm to obtain configuration information; a generation module 140, used to generate a query statement for the configuration information through a dynamic query statement generation algorithm to obtain a query statement, and perform a query operation according to the query statement to obtain a query result.

[0044] According to the query function dynamic generation system 10 provided in this embodiment, it includes a first response module 110, a second response module 120, a parsing and verification module 130 and a generation module 140. Among them, the first response module 110 is used to respond to the query function trigger input from the user and display the visual interface to the user. The second response module 120 is used to respond to the setting input from the user in the visual interface to determine the initial configuration information. The parsing and verification module 130 is used to parse and verify the initial configuration information through the configuration information parsing and verification algorithm to obtain the configuration information. The generation module 140 is used to generate a query statement for the configuration information through a dynamic query statement generation algorithm to obtain a query statement, and perform a query operation according to the query statement to obtain a query result. Through the query function dynamic generation system of the present application, users can customize the query function independently, quickly obtain the required data, reduce waiting time and operation complexity, and improve user satisfaction and stickiness to the system. Flexible query configuration enables users to analyze data more deeply and comprehensively, discover potential business rules and trends, and provide strong support for decision-making. Rapid response to changes in business needs helps enterprises to develop new business models and services and enhance market competitiveness. The query logic generated according to the configuration can obtain data more accurately, avoid unnecessary data reading and processing, reduce system resource consumption, and improve overall performance.

[0045] like Figure 6As shown, an embodiment of the third aspect of the present application provides a query function dynamic generation system 20, including: a memory 300 and a processor 400, wherein the memory 300 stores a program or instruction that can be run on the processor 400, and when the processor 400 executes the program or instruction, the steps of the query function dynamic generation method of any one of the embodiments of the first aspect are implemented, so it has the technical effect of any one of the embodiments of the first aspect mentioned above, which will not be repeated here.

[0046] The embodiment of the fourth aspect of the present application provides a readable storage medium on which a program or instruction is stored. When the program or instruction is executed by a processor, the steps of the query function dynamic generation method of any one of the embodiments of the first aspect are implemented, and thus it has the technical effect of any one of the embodiments of the first aspect mentioned above, which will not be repeated here.

[0047] like Figure 7 As shown, according to a specific embodiment of the query function dynamic generation method provided by the present application, the user can flexibly configure the query conditions and query logic according to their own needs, so as to quickly and accurately obtain the required information.

[0048] This embodiment includes the following main steps: 1. Users enter custom configuration information through the visual interface, including query fields, query conditions, sorting rules, etc.

[0049] 2. The system parses and verifies the configuration information entered by the user to ensure the legality and validity of the configuration.

[0050] 3. Based on the parsed configuration information, dynamically generate the corresponding query statement and execute the query operation.

[0051] 4. Display the query results in the format specified by the user.

[0052] 5. Store the user's customized configuration information for subsequent reuse and modification.

[0053] Among them, the configuration information parsing and verification algorithm can accurately identify the various configuration parameters entered by the user and determine whether they are legal and valid. The dynamic query statement generation algorithm can quickly generate efficient query statements based on different configuration information. The customization of the result display format supports users to choose different display methods according to their needs, such as tables, charts, etc. The efficient and stable configuration information storage solution ensures the security, integrity and fast retrieval capability of the configuration data.

[0054] Specifically, (i) User configuration interface: Provide an intuitive and easy-to-use visualization interface where users can select the fields to be queried, set query conditions (such as equal to, greater than, less than, contains, etc.), specify the sorting rule (ascending or descending), and select the result display format.

[0055] (2) Configuration information parsing and verification: When the user submits the configuration information, the system processes it using pre-written parsing and verification algorithms. For example, check whether the field name exists, whether the query condition conforms to the syntax rules, whether the sorting rule is valid, etc.

[0056] (3) Dynamic query statement generation: Based on the configuration information that has passed parsing and verification, the system uses a dynamic query statement generation algorithm to generate the corresponding SQL statement or statements in other database query languages. For example, if the user selects to query "employees with the surname Zhang", the system will generate a query statement similar to "SELECT * FROM FBP_EMPLOYEE WHERE EMPLOYEE_NAME like ‘张%’".

[0057] (4) Query execution and result display: After generating the query statement, the system executes the query operation and displays the result in the format specified by the user. If the user selects table display, the system presents the result in tabular form; if chart display is selected, the system processes the data accordingly and generates a chart.

[0058] (5) Configuration information storage: Use a relational database (such as MySQL, Oracle) to store the user's configuration information. For the storage structure of the configuration information, design a reasonable table structure or document structure that includes key information such as the configuration identifier, user identifier, query fields, query conditions, sorting rules, result display format, etc. At the same time, establish appropriate indexes to improve the retrieval efficiency of the configuration information. When storing the configuration information, perform data encryption processing to ensure data security.

[0059] As Figure 7 shown, the business process of this embodiment is as follows: 1. Enter the query page. 2.1 The system receives and parses. 2.2 Processes the request. 2.3 Returns the configured query page. 3. The user clicks to query. 4.1 The system receives and parses. 4.2 Dynamically parses the query configuration template. 4.3 Returns the query result according to the query conditions and display template.

[0060] In summary, the beneficial effects of the embodiments of this application are: 1. Improve user experience: users can customize query functions and quickly obtain required data, which reduces waiting time and operation complexity, and improves user satisfaction and stickiness with the system.

[0061] 2. Enhance data analysis capabilities. Flexible query configuration enables users to analyze data more deeply and comprehensively, discover potential business rules and trends, and provide strong support for decision-making.

[0062] 3. Promoting business innovation and quickly responding to changes in business needs will help companies develop new business models and services and enhance their market competitiveness.

[0063] 4. Optimize system resource utilization. The query logic generated according to the configuration can obtain data more accurately, avoid unnecessary data reading and processing, reduce system resource consumption, and improve overall performance.

[0064] In this application, the terms "first", "second", and "third" are used for descriptive purposes only and are not to be understood as indicating or implying relative importance; the term "plurality" refers to two or more, unless otherwise expressly defined. Terms such as "installed", "connected", "connected", and "fixed" should be understood in a broad sense. For example, "connected" can be a fixed connection, a detachable connection, or an integral connection; "connected" can be a direct connection or an indirect connection through an intermediate medium. For those of ordinary skill in the art, the specific meanings of the above terms in this application can be understood according to the specific circumstances.

[0065] In the description of the present application, it should be understood that the terms "upper", "lower", "front", "rear", etc., indicating directions or positional relationships, are based on the directions or positional relationships shown in the accompanying drawings, and are only for the convenience of describing the present application and simplifying the description, rather than indicating or implying that the device or module referred to must have a specific direction, be constructed and operated in a specific direction, and therefore, should not be understood as a limitation on the present application.

[0066] In the description of this specification, the description of the terms "one embodiment", "some embodiments", "specific embodiments", etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present application. In this specification, the schematic representation of the above terms does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described can be combined in any one or more embodiments or examples in a suitable manner.

[0067] The above are only preferred embodiments of the present application and are not intended to limit the present application. For those skilled in the art, the present application may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims

1. A method for dynamically generating a query function, characterized in that: Applied to a query function dynamic generation system, the query function dynamic generation method is executed by a processor, and the query function dynamic generation method includes: In response to a query function trigger input from a user, presenting a visualization interface to the user; In response to a setting input from the user on the visualization interface, determining initial configuration information; Parsing and verifying the initial configuration information through a configuration information parsing and verification algorithm to obtain configuration information; A query statement is generated for the configuration information through a dynamic query statement generation algorithm to obtain a query statement, and a query operation is performed according to the query statement to obtain a query result.

2. The method for dynamically generating query functions according to claim 1, characterized in that: Also includes: The query result is displayed to the user according to a preset format.

3. The method for dynamically generating query functions according to claim 2, characterized in that: Also includes: The configuration information is stored in a relational database, and data encryption is performed on the configuration information.

4. The method for dynamically generating query functions according to claim 1, characterized in that: The step of parsing and verifying the initial configuration information by using a configuration information parsing and verification algorithm to obtain configuration information includes: Determine whether the name of the query field exists; If so, determine whether the query condition complies with the grammatical rules; If so, determine whether the sorting rule is valid; If so, the initial configuration information is configuration information.

5. The method for dynamically generating query functions according to any one of claims 1 to 4, characterized in that: The initial configuration information includes one of the following or a combination thereof: query field, query condition, sorting rule, and result display format.

6. The method for dynamically generating query functions according to claim 2, characterized in that: The preset format includes a table and / or a chart.

7. The method for dynamically generating query functions according to claim 3, characterized in that: The storage structure of the configuration information includes a table structure and / or a document structure, and the table structure and / or the document structure both include a configuration identifier, a user identifier, a query field, a query condition, a sorting rule, and a result display format.

8. A query function dynamic generation system, characterized in that: include: A first response module (110), configured to respond to a query function trigger input from a user and display a visual interface to the user; A second response module (120), configured to determine initial configuration information in response to a setting input from the user on the visual interface; A parsing and verification module (130), configured to parse and verify the initial configuration information using a configuration information parsing and verification algorithm to obtain configuration information; The generation module (140) is used to generate a query statement for the configuration information using a dynamic query statement generation algorithm to obtain a query statement, and perform a query operation according to the query statement to obtain a query result.

9. A query function dynamic generation system, characterized in that: include: A memory (300) and a processor (400), wherein the memory (300) stores a program or instruction that can be run on the processor (400), and when the processor (400) executes the program or the instruction, the steps of the query function dynamic generation method according to any one of claims 1 to 7 are implemented.

10. A readable storage medium having a program or instruction stored thereon, characterized in that: When the program or the instruction is executed by a processor, the steps of the method for dynamically generating a query function according to any one of claims 1 to 7 are implemented.

Images