Custom query method and device, equipment and storage medium

Abstract

The invention discloses a user-defined query method and device, equipment and a storage medium, and relates to the technical field of computers.The method comprises the steps that at least one query condition selected by a user in a preset query box is obtained, and a drop-down box of the query box is associated with a plurality of pieces of field information of a preset database; generating a query statement according to at least one query condition selected by the user; and querying according to the query statement, and displaying a query result. According to the method, the query box is preset on the interface, the drop-down box of the query box is associated with the multiple pieces of field information of the preset database, a user can directly select multiple query conditions in the query box, the user is allowed to select multiple condition combination query in one query box, the operation steps and time of the user are reduced, and in addition, the user experience is improved. The number of the query boxes on the interface is small, so that the user can easily set the query condition and check the query result.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a user-defined query method, device, equipment and storage medium. Background Art

[0002] In the current management systems, the data background tables display a lot of data, and users cannot quickly locate the data they need, especially when there are many fields in the table. They can only set multiple filters and search boxes for different fields. Furthermore, according to the data to be queried, users click on the required query content in different filters or different search boxes, and finally click the query button to query the required data.

[0003] However, when there are too many query condition boxes, users need to carefully check each query box to find the corresponding query condition. When filtering multiple conditions, they need to confirm repeatedly in multiple query boxes. If they are not adjacent, they need to jump and confirm repeatedly, which is cumbersome. In addition, there are currently too many operation boxes on the interface, which occupy more space on the interface, lack of organization and planning on the overall page, reduce visual appeal and affect the effect of information communication. Summary of the invention

[0004] Based on this, it is necessary to provide a custom query method, device, equipment and storage medium for the above technical problems to solve at least one of the above technical problems.

[0005] The present invention provides a user-defined query method, comprising:

[0006] Acquire at least one query condition selected by a user in a preset query box, wherein a drop-down box of the query box is associated with several field information of a preset database;

[0007] Generate a query statement according to at least one query condition selected by the user;

[0008] Perform a query according to the query statement and display the query results.

[0009] Optionally, according to a custom query method provided by the present invention, before obtaining at least one query condition selected by the user in a preset query box, the method further includes:

[0010] Obtaining various historical query conditions of the user within a preset time period;

[0011] Determine the number of queries corresponding to each of the historical query conditions;

[0012] The historical query condition with the most queries is displayed in the first position of the drop-down box.

[0013] Optionally, according to a custom query method provided by the present invention, before obtaining at least one query condition selected by the user in a preset query box, the method further includes:

[0014] Obtaining the historical query records of the user within a preset time period;

[0015] Extracting features from the historical query records to obtain feature information;

[0016] Based on the feature information, a query recommendation list is predicted using a preset recommendation model, and the query recommendation list is displayed in the drop-down box.

[0017] Optionally, according to a custom query method provided by the present invention, before obtaining at least one query condition selected by the user in a preset query box, the method further includes:

[0018] Obtain user needs;

[0019] Analyze the user's needs to determine various field information as query conditions according to the analysis results;

[0020] The field information is displayed in the drop-down box of the query box.

[0021] Optionally, according to a custom query method provided by the present invention, performing a query according to the query statement and displaying the query result includes:

[0022] Sending the query statement to the preset database to perform a query operation and obtain the query result;

[0023] The query results are pushed to the front-end interface for display so that the user can view them.

[0024] Optionally, according to a custom query method provided by the present invention, after obtaining at least one query condition selected by the user in a preset query box, the method further includes:

[0025] When a saving request from the user is received, the at least one query condition is stored.

[0026] Optionally, according to a custom query method provided by the present invention, after querying according to the query statement and displaying the query result, the method further includes:

[0027] When a query reset request of the user is received, at least one query condition currently selected by the user is cleared.

[0028] The present invention also provides a user-defined query device, comprising:

[0029] An acquisition module, used to acquire at least one query condition selected by a user in a preset query box, wherein a drop-down box of the query box is associated with several field information of a preset database;

[0030] A generating module, used to generate a query statement according to at least one query condition selected by a user;

[0031] The query module is used to perform a query according to the query statement and display the query results.

[0032] The present invention also provides a computer device, comprising a memory, a processor, and computer-readable instructions stored in the memory and executable on the processor, wherein the processor implements the above-mentioned custom query method when executing the computer-readable instructions.

[0033] The present invention also provides one or more readable storage media storing computer-readable instructions, and the computer-readable instructions implement the above-mentioned custom query method when executed by a processor.

[0034] The above-mentioned custom query method, device, equipment and storage medium include: obtaining at least one query condition selected by the user in a preset query box, wherein the drop-down box of the query box is associated with several field information of a preset database; generating a query statement according to the at least one query condition selected by the user; querying according to the query statement, and displaying the query results. The present invention presets a query box on the interface, and the drop-down box of the query box is associated with several field information of a preset database. The user can directly select multiple query conditions in the query box, thereby allowing the user to select multiple conditions in one query box for combined query, reducing the user's operation steps and time. In addition, the number of query boxes on the interface is small, which allows the user to easily set query conditions and view query results. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the accompanying drawings required for use in the description of the embodiments of the present invention will be briefly introduced below. Obviously, the accompanying drawings in the following description are only some embodiments of the present invention. For ordinary technicians in this field, other accompanying drawings can be obtained based on these accompanying drawings without paying creative labor.

[0036] Figure 1 is a flow chart of a custom query method in one embodiment of the present invention;

[0037] Figure 2 is a structural diagram of a user-defined query device in one embodiment of the present invention;

[0038] Figure 3 is a schematic diagram of a computer device in one embodiment of the present invention. DETAILED DESCRIPTION

[0039] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are 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 creative work are within the scope of protection of the present invention.

[0040] The terms used in one or more embodiments of the present invention are only for the purpose of describing specific embodiments, and are not intended to limit one or more embodiments of the present invention. The singular forms of "a", "said" and "the" used in one or more embodiments of the present invention are also intended to include plural forms, unless the context clearly indicates other meanings. It should also be understood that the term "and / or" used in one or more embodiments of the present invention refers to and includes any or all possible combinations of one or more associated listed items.

[0041] In the current management systems, the data background tables display a lot of data, and users cannot quickly locate the data they need, especially when there are many fields in the table. They can only set multiple filters and search boxes for different fields. Furthermore, according to the data to be queried, users click on the required query content in different filters or different search boxes, and finally click the query button to query the required data.

[0042] However, when there are too many query condition boxes, users need to carefully check each query box to find the corresponding query condition. When filtering multiple conditions, they need to confirm repeatedly in multiple query boxes. If they are not adjacent, they need to jump and confirm repeatedly, which is cumbersome. In addition, there are currently many operation boxes on the interface, which occupy a lot of space on the interface. There is a lack of organization and planning on the overall page, which reduces visual appeal and affects the effect of information communication. For example: User A needs to query a host on the operation and maintenance platform. This host needs to meet the conditions of cloud vendor ALY, environment PRD, model 86_64, memory 128, and status online at the same time; at this time, the user needs to operate in 5 query boxes once, and then click the [Query] button. The operation is cumbersome, and there are many query boxes on the interface, and even one line cannot fit, which looks messy.

[0043] To solve the above problems, the present invention provides the following embodiments. Specifically, in one embodiment, Figure 1 As shown, Figure 1 : is a flow chart of a custom query method in an embodiment of the present invention. The embodiment of the present invention provides a custom query method, comprising the following steps:

[0044] Step S11, obtaining at least one query condition selected by the user in a preset query box, wherein the drop-down box of the query box is associated with several field information of a preset database;

[0045] It should be noted that a query box is pre-set on the interface, and the query box is configured with a drop-down box. The user can select at least one query condition in the drop-down box to perform a search or query operation. Among them, the drop-down box of the query box is associated with several field information of a preset database, that is, the drop-down menu in the query box is associated with the field information in the database. The user can specify the database field to be queried by selecting a field name from the drop-down menu. When multiple query conditions need to be filtered, the user does not need to repeatedly confirm the query conditions in multiple query boxes.

[0046] It should be noted that before obtaining at least one query condition selected by the user in the preset query box, the user's needs are obtained; then the user's needs are analyzed to determine the various field information used as query conditions based on the analysis results; and the field information is displayed in the drop-down box of the query box. In addition, users can be divided according to the analysis results to provide different query methods for different users. For example, users can be divided into users who clearly want to query a single content, users who clearly need to query more content, etc. For users who clearly need to query more content, the solution provided by the embodiment of the present invention can be used for querying.

[0047] Step S12, generating a query statement according to at least one query condition selected by the user;

[0048] It should be noted that the query condition is a specific field selected by the user from the drop-down box according to the needs, and the query statement is an SQL statement command for database query constructed based on these conditions. The user can select one or more query conditions in the drop-down box of the query box, and then generate a query statement based on at least one query condition selected by the user. In addition, if the user can select multiple query conditions in the drop-down box, each query condition can be used separately or in combination, for example, multiple query conditions can be connected using AND or OR logic.

[0049] Step S13, perform a query according to the query statement and display the query result.

[0050] Specifically, the query statement is sent to the preset database to perform the query operation, the query result is obtained, and then the query result is pushed to the front-end interface for display for the user to view. It should be noted that in order to allow the user to better view the query results, the layout of the query interface can be preset. In one embodiment, the interface layout is divided into an upper and lower structure, with the query box on the top and the content display area on the bottom. For example, the position occupied by the query box is set to one-fifth of the entire interface.

[0051] The embodiment of the present invention, through the above scheme, includes: obtaining at least one query condition selected by the user in a preset query box, wherein the drop-down box of the query box is associated with several field information of a preset database; generating a query statement according to the at least one query condition selected by the user; querying according to the query statement, and displaying the query results. The embodiment of the present invention presets a query box on the interface, and the drop-down box of the query box is associated with several field information of a preset database. The user can directly select multiple query conditions in the query box, thereby allowing the user to select multiple conditions in one query box for combined query, reducing the user's operation steps and time. In addition, the number of query boxes on the interface is small, allowing the user to easily set query conditions and view query results.

[0052] In one embodiment of the present invention, performing a query according to the query statement and displaying the query results include:

[0053] The query statement is sent to the preset database to perform a query operation to obtain the query result; the query result is pushed to the front-end interface for display so that the user can view it.

[0054] Specifically, the constructed query statement is sent to a preset database, wherein the preset database may be a database such as MySQL, PostgreSQL, Oracle, MongoDB, etc. After receiving the query statement, the preset database executes the query operation to retrieve the data that meets the conditions. After the query is executed, a result set is returned, and the result includes a collection containing the query results, which may be a table (in SQL) or a document (in a NoSQL database). Status information: indicates whether the query is successfully executed, and any possible error information. Further, the back-end program returns the query results and status information to the front-end as a response. The front-end usually obtains data from the back-end through an HTTP request. Optionally, the request may be a GET request, a POST request, or other types of requests, depending on the communication protocol between the front-end and the back-end. After receiving the data, the front-end converts the returned data into a format that can be used by the front-end, and then dynamically updates the display content of the web page or application according to the parsed data. Thus, the user can see the query results in the front-end interface. Optionally, the query results may be in the form of a table, a list, a chart, or other suitable form for displaying data.

[0055] In addition, in order to speed up multi-dimensional queries, in one embodiment, a multi-dimensional index structure is used for retrieval, for example, using R-tree or KD-tree technology to quickly retrieve in high-dimensional data space. In order to ensure the accuracy and timeliness of query results, a dynamic index update algorithm can also be applied in combination, so that the index data structure can be efficiently and accurately maintained when data is constantly changing, and when data is inserted, deleted or updated, it is ensured that the index can immediately reflect these changes while maintaining query performance.

[0056] In addition, in order to improve query performance and scalability, large-scale data in the database is partitioned and stored. Optionally, data partitioning can be performed in the form of horizontal partitioning or vertical partitioning. Optionally, horizontal partitioning divides data by rows, and each partition contains a portion of data rows. For example, data is partitioned according to one or more key values ​​(such as date, region, ID, etc.). For example, sales data for each month can be stored in a separate partition. Vertical partitioning divides data by columns, and each partition contains a portion of data columns. For example, columns that are frequently updated (such as order status) and columns that are less updated (such as customer name) are stored separately. It can also be combined with compression algorithms to further reduce the storage space occupied by column storage data and improve data reading speed. In other embodiments, a suitable partitioning method can be selected according to the characteristics of the data and query requirements.

[0057] The embodiment of the present invention, through the above scheme, includes: sending the query statement to the preset database to perform the query operation and obtain the query result; pushing the query result to the front-end interface for display so that the user can view it. The user can select multiple conditions in a query box to query and display the query results, so that the user can easily set the query conditions and view the query results.

[0058] In one embodiment of the present invention, after obtaining at least one query condition selected by the user in a preset query box, the method further includes:

[0059] When a saving request from the user is received, the at least one query condition is stored.

[0060] It should be noted that a save button is added to the query box, and when a save request from the user is received, the query conditions set by the user are saved, so that the user does not need to repeat the operation of re-filtering the conditions during each query process, saving time and improving work efficiency.

[0061] In one embodiment, when a query reset request from the user is received, at least one query condition currently selected by the user is cleared.

[0062] It should be noted that a reset button is added after the query box. When a query reset request from the user is received, all query conditions currently selected by the user are cleared, and the user can reselect query conditions to start querying.

[0063] In one embodiment of the present invention, before obtaining at least one query condition selected by the user in the preset query box, the method further includes:

[0064] Acquire various historical query conditions of the user within a preset time period; determine the number of queries corresponding to each of the historical query conditions; and display the historical query condition with the largest number of queries in the first position of the drop-down box.

[0065] Specifically, the user's various historical query conditions within a preset time period are queried; the query times of each historical query condition are then counted, and further, the historical query condition with the most query times is displayed in the first position of the drop-down box, that is, the query condition with the most query times is placed at the first position of the drop-down box on the interface so that the user can access it most conveniently. In other embodiments, the query conditions are sorted in descending order according to the query times and added to the drop-down box.

[0066] The embodiment of the present invention, through the above scheme, includes: obtaining each historical query condition of the user within a preset time period; determining the query times corresponding to each historical query condition; and displaying the historical query condition with the most query times in the first position of the drop-down box. This achieves placing the query condition with the most query times in the first position of the drop-down box on the interface, thereby improving the convenience and efficiency of user operation.

[0067] In one embodiment of the present invention, before obtaining at least one query condition selected by the user in a preset query box, the method further includes:

[0068] Obtain the historical query records of the user within a preset time period; perform feature extraction on the historical query records to obtain feature information; based on the feature information, use a preset recommendation model to predict a query recommendation list, and display the query recommendation list in the drop-down box.

[0069] Specifically, the user's historical query records are collected, including query conditions, query time, usage of query results, etc. The historical query records are preprocessed, for example, noise data such as repeated queries or outliers are removed. Further, feature extraction is performed on the historical query records to obtain feature information, such as the frequency of query keywords, the frequency of user behaviors, etc. In one embodiment, TF-IDF (term frequency-inverse document frequency) is used to vectorize the text data. Further, based on the feature information, a preset recommendation model is used to predict the query recommendation list. For example, a collaborative filtering algorithm model is used to perform recommendation prediction. Based on the similarity between the user's feature information and the feature information of other users, a target user with a high similarity is determined, and then the query conditions that the target user with a high similarity likes are used as a query recommendation list, so that personalized recommendations can be made based on the query recommendation list. In other embodiments, association rules in query records are mined to discover potential relationships between different queries. For example, algorithms such as Apriori and Eclat are used to discover implicit relationships between queries and provide meaningful recommendations. Finally, the recommendation list is displayed in a drop-down box on the front-end interface for user selection and interaction.

[0070] The embodiment of the present invention, through the above scheme, includes: obtaining the historical query records of the user within a preset time period; extracting features from the historical query records to obtain feature information; based on the feature information, using a preset recommendation model to predict a query recommendation list, and displaying the query recommendation list in the drop-down box. This realizes providing intelligent query suggestions to users based on the user's historical query behavior using a machine learning algorithm.

[0071] It should be understood that the order of execution of the steps in the above embodiment does not necessarily mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiment of the present invention.

[0072] In one embodiment, a custom query device is provided, which corresponds one-to-one to the custom query method in the above embodiment. Figure 2 As shown, Figure 2 : is a schematic diagram of a structure of a user-defined query device in one embodiment of the present invention, the user-defined query device comprises:

[0073] The acquisition module 21 is used to acquire at least one query condition selected by the user in a preset query box, wherein the drop-down box of the query box is associated with several field information of a preset database;

[0074] A generating module 22, configured to generate a query statement according to at least one query condition selected by a user;

[0075] The query module 23 is used to perform a query according to the query statement and display the query result.

[0076] The user-defined query device comprises:

[0077] A query condition acquisition module, used to acquire various historical query conditions of the user within a preset time period;

[0078] A determination module, used to determine the number of queries corresponding to each of the historical query conditions;

[0079] The first display module is used to display the historical query condition with the most queries in the first position of the drop-down box.

[0080] The user-defined query device comprises:

[0081] A query record acquisition module, used to acquire the historical query records of the user within a preset time period;

[0082] A feature extraction module is used to extract features from the historical query records to obtain feature information;

[0083] The recommendation module is used to predict a query recommendation list based on the feature information using a preset recommendation model, and display the query recommendation list in the drop-down box.

[0084] The user-defined query device comprises:

[0085] User demand acquisition module, used to obtain user needs;

[0086] An analysis module, used to analyze the user's needs and determine the various field information used as query conditions according to the analysis results;

[0087] The second display module is used to display each field information in the drop-down box of the query box.

[0088] The query module 23 is also used for:

[0089] Sending the query statement to the preset database to perform a query operation and obtain the query result;

[0090] The query results are pushed to the front-end interface for display so that the user can view them.

[0091] The user-defined query device comprises:

[0092] The storage module is used to store the at least one query condition when receiving a save request from the user.

[0093] The user-defined query device comprises:

[0094] The clearing and resetting module is used to clear at least one query condition currently selected by the user when receiving a query reset request from the user.

[0095] For the specific definition of the custom query device, please refer to the definition of the custom query method above, which will not be repeated here. Each module in the above custom query device can be implemented in whole or in part by software, hardware and a combination thereof. The above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0096] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Figure 3 As shown, Figure 3: is a schematic diagram of a computer device in an embodiment of the present invention. The computer device includes a processor, a memory, a network interface and a database connected by a device bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a readable storage medium and an internal memory. The readable storage medium stores an operating device, a computer-readable instruction and a database. The internal memory provides an environment for the operation of the operating device and the computer-readable instruction in the readable storage medium. The database of the computer device is used to store data involved in a custom query method. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer-readable instruction is executed by the processor, a custom query method is implemented. The method includes: obtaining at least one query condition selected by a user in a preset query box, wherein the drop-down box of the query box is associated with several field information of a preset database; generating a query statement according to at least one query condition selected by the user; querying according to the query statement, and displaying the query result. The readable storage medium provided in this embodiment includes a non-volatile readable storage medium and a volatile readable storage medium.

[0097] In one embodiment, a computer device is provided. The computer device may be a terminal device, and its internal structure diagram may be as follows: Figure 3 As shown. The computer device includes a processor, a memory, and a network interface connected through a device bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a readable storage medium. The readable storage medium stores computer-readable instructions. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer-readable instructions are executed by the processor, a custom query method is implemented. The readable storage medium provided in this embodiment includes a non-volatile readable storage medium and a volatile readable storage medium.

[0098] In one embodiment, a computer device is provided, including a memory, a processor, and computer-readable instructions stored in the memory and executable on the processor, and the processor implements the steps of the above-mentioned custom query method when executing the computer-readable instructions. The method includes: obtaining at least one query condition selected by a user in a preset query box, wherein the drop-down box of the query box is associated with several field information of a preset database; generating a query statement according to the at least one query condition selected by the user; performing a query according to the query statement, and displaying the query results.

[0099] In one embodiment, a readable storage medium is provided, the readable storage medium stores computer-readable instructions, and the computer-readable instructions are executed by the processor to implement the steps of the above-mentioned custom query method. It can be understood by a person of ordinary skill in the art that all or part of the processes in the above-mentioned embodiment method can be completed by instructing the relevant hardware through computer-readable instructions, and the computer-readable instructions can be stored in a non-volatile readable storage medium or a volatile readable storage medium. When the computer-readable instructions are executed, they may include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application may include non-volatile and / or volatile memory. Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory may include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

[0100] Those skilled in the art can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example. In actual applications, the above-mentioned functions can be distributed and completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above.

[0101] The embodiments described above are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention, and should all be included in the protection scope of the present invention.

Claims

1. A custom query method, characterized in that: include: Acquire at least one query condition selected by a user in a preset query box, wherein a drop-down box of the query box is associated with several field information of a preset database; Generate a query statement according to at least one query condition selected by the user; Perform a query according to the query statement and display the query results.

2. The user-defined query method according to claim 1, characterized in that: Before obtaining at least one query condition selected by the user in the preset query box, the method further includes: Obtaining various historical query conditions of the user within a preset time period; Determine the number of queries corresponding to each of the historical query conditions; The historical query condition with the most queries is displayed in the first position of the drop-down box.

3. The user-defined query method according to claim 1, characterized in that: Before obtaining at least one query condition selected by the user in the preset query box, the method further includes: Obtaining the historical query records of the user within a preset time period; Extracting features from the historical query records to obtain feature information; Based on the feature information, a query recommendation list is predicted using a preset recommendation model, and the query recommendation list is displayed in the drop-down box.

4. The user-defined query method according to claim 1, characterized in that: Before obtaining at least one query condition selected by the user in the preset query box, the method further includes: Obtain user needs; Analyze the user's needs to determine various field information as query conditions according to the analysis results; The field information is displayed in the drop-down box of the query box.

5. The user-defined query method according to claim 1, characterized in that: The query is performed according to the query statement, and the query results are displayed, including: Sending the query statement to the preset database to perform a query operation and obtain the query result; The query results are pushed to the front-end interface for display so that the user can view them.

6. The user-defined query method according to claim 1, characterized in that: After obtaining at least one query condition selected by the user in the preset query box, the method further includes: When a saving request from the user is received, the at least one query condition is stored.

7. The user-defined query method according to claim 1, characterized in that: After performing the query according to the query statement and displaying the query result, the method further includes: When a query reset request of the user is received, at least one query condition currently selected by the user is cleared.

8. A custom query device, characterized in that: include: An acquisition module, used to acquire at least one query condition selected by a user in a preset query box, wherein a drop-down box of the query box is associated with several field information of a preset database; A generating module, used to generate a query statement according to at least one query condition selected by a user; The query module is used to perform a query according to the query statement and display the query results.

9. A computer device comprising a memory, a processor, and computer-readable instructions stored in the memory and executed on the processor, characterized in that: When the processor executes the computer-readable instructions, the user-defined query method according to any one of claims 1 to 7 is implemented.

10. A readable storage medium having computer readable instructions stored thereon, characterized in that: When the computer-readable instructions are executed by a processor, the user-defined query method according to any one of claims 1 to 7 is implemented.

Images