List query method, terminal equipment and storage medium

Abstract

The embodiment of the invention provides a list query method, terminal equipment and a storage medium, and belongs to the field of communication. The method comprises the steps that a configuration template file set is obtained, and the configuration file set comprises a data storage template file, a query condition configuration template file and a query result configuration template file; obtaining a list data set, and storing the list data set to a preset database based on the data storage template file; generating a list query statement based on the query condition configuration template file and the input query characters; performing list query in a preset database based on the list query statement to obtain a list query result; and configuring the template file based on the query result, and outputting a list query result. According to the technical scheme, the list query efficiency can be improved.

Description

Technical Field

[0001] The present application relates to the field of communication technology, and in particular to a list query method, a terminal device and a storage medium. Background Art

[0002] List query is a service provided by communication operators to users. Users can query the details of their service usage and the resulting costs through self-service printing, online business halls, wireless application protocols, etc., thereby generating a detailed list (CDR). List query can bring great convenience to users. However, in the existing list query system, if the complexity of the list service increases, the query result code must also be updated synchronously according to the changes in the list service, resulting in low efficiency of list query. Summary of the invention

[0003] The embodiments of the present application provide a list query method, a terminal device and a storage medium, aiming to solve the problem of low efficiency of current list query.

[0004] In a first aspect, an embodiment of the present application provides a list query method, including:

[0005] Obtain a configuration template file set, wherein the configuration file set includes a data storage template file, a query condition configuration template file, and a query result configuration template file;

[0006] Acquire an inventory data set, and based on the data storage template file, store the inventory data set into a preset database;

[0007] Generate a list query statement based on the query condition configuration template file and the input query characters;

[0008] Performing a list query in the preset database based on the list query statement to obtain a list query result;

[0009] A template file is configured based on the query result, and the inventory query result is output.

[0010] In a second aspect, an embodiment of the present application further provides a terminal device, comprising a processor, a memory, a computer program stored in the memory and executable by the processor, and a data bus for realizing connection and communication between the processor and the memory, wherein when the computer program is executed by the processor, any inventory query method provided in the embodiment of the present application is implemented.

[0011] In a third aspect, an embodiment of the present application further provides a storage medium for computer-readable storage, characterized in that the storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement any inventory query method provided in the embodiment of the present application.

[0012] The embodiment of the present application provides a list query method, terminal device and storage medium. The embodiment of the present application obtains a configuration template file set, wherein the configuration file set includes a data storage template file, a query condition configuration template file and a query result configuration template file; obtains a list data set, and based on the data storage template file, stores the list data set to a preset database; generates a list query statement based on the query condition configuration template file and the input query characters; performs a list query in a preset database based on the list query statement to obtain a list query result; and outputs the list query result based on the query result configuration template file. The embodiment of the present application quickly implements the list query function by setting various configuration files, without updating the query result code, which can reduce the phenomenon of errors in the program development process and the list query process, and improve the efficiency and accuracy of the list query. BRIEF DESCRIPTION OF THE DRAWINGS

[0013] Figure 1 A schematic diagram of the steps of a list query method provided in an embodiment of the present application;

[0014] Figure 2 for Figure 1 A flowchart of sub-steps of the inventory query method in FIG.

[0015] Figure 3 A schematic diagram of an interface of a configuration file generator provided in an embodiment of the present application;

[0016] Figure 4 Another schematic diagram of the interface of the configuration file generator provided in the embodiment of the present application;

[0017] Figure 5 A schematic diagram of another interface of the configuration file generator provided in an embodiment of the present application;

[0018] Figure 6 A schematic diagram of another interface of the configuration file generator provided in the embodiment of the present application;

[0019] Figure 7 A schematic diagram of a scenario for implementing the inventory query method provided in an embodiment of the present application;

[0020] Figure 8 A schematic block diagram of the structure of a terminal device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0021] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0022] The flowcharts shown in the accompanying drawings are only examples and do not necessarily include all the contents and operations / steps, nor must they be executed in the order described. For example, some operations / steps may also be decomposed, combined or partially merged, so the actual execution order may change according to actual conditions.

[0023] It should be understood that the terms used in this application specification are only for the purpose of describing specific embodiments and are not intended to limit the application. As used in this application specification and the appended claims, unless the context clearly indicates otherwise, the singular forms "a", "an" and "the" are intended to include plural forms.

[0024] The traditional inventory query system mainly includes the following two aspects of the development process: First, the inventory storage part: the new inventory is hard-coded and stored in the data storage according to the requirements. If the old inventory changes, the inventory processing program must also change. At the same time, an upgrade script must be provided for compatibility processing. Second, the inventory query display part according to the conditions: 1) Customize the hard-coded development interface UI according to the requirements: constraint judgment of the query conditions, and enter the query business logic layer after legality. 2) The process of customizing the logical relationship of the query conditions in the business logic layer: customize the query condition fields and query logic. It is okay to develop with fewer conditions and low logic complexity. If the complexity of the inventory business increases, the logic of the query conditions will also become complex, the amount of development coding will increase, and the system maintenance will also change with the changes in the demand data. It is highly dependent and prone to errors. 3) The development process of obtaining query results according to the query conditions: if the query results change, the query result code must also change.

[0025] It can be seen that the development process of the traditional inventory query system is lengthy and cumbersome. Once the inventory business changes, the query code must be changed to meet the inventory query needs, so the efficiency of the inventory query is low. At the same time, since the code needs to be changed manually, the development process of the inventory query system is prone to errors. It is not only highly dependent on data, but also brings inconvenience to users' use and maintenance.

[0026] Based on this, the embodiment of the present application provides a list query method, a terminal device and a storage medium. Among them, the list query method can be applied to a terminal device, and the terminal device can be an electronic device such as a mobile phone, a tablet computer, a laptop computer, a desktop computer, a personal digital assistant and a wearable device. Through the list query method provided by the present application, the list query function can be quickly implemented without updating the query result code, avoiding the hard coding method with strong data dependence, and reducing the phenomenon of errors in the program development process and the list query process.

[0027] In conjunction with the accompanying drawings, some embodiments of the present application are described in detail below. In the absence of conflict, the following embodiments and features in the embodiments can be combined with each other.

[0028] Please refer to Figure 1 , Figure 1 A schematic diagram of the steps of a list query method provided in an embodiment of the present application.

[0029] like Figure 1 As shown, the inventory query method includes steps S101 to S104.

[0030] Step S101: Obtain a configuration template file set, wherein the configuration file set includes a data storage template file, a query condition configuration template file, and a query result configuration template file.

[0031] Among them, the configuration template file set can be used to generate a list query system with a query function for list data. The data storage template file is used to store a list data set, and the list data set may include multiple list data, such as call list data and work order data. The query condition configuration template file is used to generate a list query statement, and the list data can be retrieved from a preset database through the list query statement. The query result configuration template file is used to output the list query result, and the list query result can be obtained through the list query statement, and the list query result can be output to the list query interface.

[0032] In one embodiment, the interface configuration file generator includes multiple configuration items, and the configuration of the data storage template file, the query condition configuration template file, and the query result configuration template file can be quickly completed based on different configuration items, thereby obtaining a configuration template file set. The configured configuration items can be saved to different configuration files respectively, and the program development process can quickly adjust the query results according to business needs, thereby meeting configurability and query flexibility.

[0033] In one embodiment, if Figure 2 As shown, step S101 includes: sub-steps S1011 to S1014.

[0034] Sub-step S1011, obtaining multiple target configuration files, the target configuration files include a data source configuration file, a data template configuration file, a query condition configuration file, and a query result configuration file.

[0035] Among them, the data source configuration file includes the database type of the preset database, the index identifier used to store the inventory data in the inventory data set, and the field type in the inventory data. The preset database includes but is not limited to supporting relational databases and document databases. Supported relational databases include IQ, Postgres, mysql, sybase, etc., and document databases include elastisearch. The index identifier of the inventory data can be the prefix name of the data table or index used to store the inventory data in the preset database. After the configuration is completed, it will be stored in the data source configuration file. Each inventory data generally corresponds to an index identifier. The field type in the inventory data can be the specific meaning of the field in the inventory data. The field type is, for example, the caller and called party in the call list data.

[0036] For example, Figure 3 As shown in the figure, the data source configuration file is generated based on the data source configuration interface. The data source configuration interface includes multiple configuration items, such as Figure 3 The database type, data source name, and resource prefix are shown. The database type can also be referred to as the database type of the preset database, the data source name can also be referred to as the index identifier for storing inventory data in the inventory data set, and the resource prefix can also be referred to as the field type in the inventory data.

[0037] In one embodiment, the data template configuration file includes multiple field identifiers of the list data, and the field identifier includes a field name, a field type, a field length, a field description, a type identifier, an index field, a query result field, and an aggregate field. The field name can be an English field configured in the data source to store the list. The field name is the only field in the list data and cannot be repeated. The field type can be automatically provided according to the database type of the preset database. For example, according to the database type of the preset database, a suitable field type can be configured for the list data. The field length, index field, result field, and aggregate field can all be used as query conditions. The field description can be used as a query result.

[0038] For example, Figure 4 As shown in the figure, the data template configuration file is generated based on the data template configuration interface. The data template configuration interface includes multiple configuration items, such as Figure 4 The displayed field name, field type, field length, index field, whether it is an index field, whether it is a result field, whether it can be aggregated, field description and other attribute configurations.

[0039] In one embodiment, the query condition configuration file includes query fields, query logic, control categories, and control positions for querying inventory data. The query fields can be freely selected as query conditions. The query logic includes but is not limited to AND, OR, NOT, or other custom logical expressions. The control category is used to set controls such as text boxes, drop-down selection boxes, date types, etc. in the inventory query interface. The control position is used to set the position of the query condition in the inventory query interface.

[0040] For example, Figure 5 As shown in the figure, the query condition configuration file is generated based on the query condition configuration interface. The query condition configuration interface includes multiple configuration items, such as Figure 5 The query fields, logic types, control categories, and control positions shown. The logic type can also be called query logic.

[0041] In one embodiment, the query result configuration file includes a result field, an escape field, a display field, and a field display position for outputting list data. Among them, the result field is used to filter the result field in the data template configuration file, and the escape field is used to indicate whether to escape, that is, whether the field result value needs to be escaped. The display field is used to indicate whether to display, that is, whether the field result value is displayed as a query result on the list query interface. The field display position is used to set the position where the list query result is displayed in the list query interface.

[0042] For example, Figure 6 As shown in the figure, the query result configuration file is generated based on the data source configuration interface. The query result configuration interface includes multiple configuration items, such as Figure 6 The result fields, whether to escape, whether to display and the field display position are shown. Among them, whether to escape can also be understood as escaping fields, whether to display can also be understood as displaying fields, and the result position can also be called the field display position.

[0043] In one embodiment, multiple target configuration files are generated based on multiple inventory data in the inventory data set. It should be noted that the target configuration file can be automatically generated based on the multiple inventory data, and the generated target configuration files can be different for inventory data sets of different business types. In some examples, multiple target configuration files can also be configured by the user based on multiple inventory data in the inventory data set, and the embodiments of the present application do not specifically limit this.

[0044] Sub-step S1012: Generate a data storage template file for storing the inventory data set according to the data source configuration file and the data template configuration file.

[0045] It should be noted that the data storage template file may be generated according to the data source configuration file and the data template configuration file. For example, the data source configuration file and the data template configuration file are merged to obtain a data storage template file for storing the inventory data set.

[0046] Sub-step S1013: Generate a query condition configuration template file for generating a list query statement according to the data template configuration file and the query condition configuration file.

[0047] It should be noted that the query condition configuration file can be quickly generated based on the data template configuration file and the query condition configuration file. For example, the data template configuration file and the query condition configuration file are merged to obtain a query condition configuration template file for generating a list query statement.

[0048] Sub-step S1014: Generate a query result configuration template file for outputting the list query results according to the data template configuration file and the query result configuration file.

[0049] It should be noted that the query result configuration template file can be generated according to the data template configuration file and the query result configuration file. For example, the data template configuration file and the query result configuration file are merged to obtain the query result configuration template file for outputting the list query result.

[0050] In one embodiment, the configuration template file set may be generated by an interface-based configuration file generator, and the configuration file generator may be low-code, so that the generation of the configuration template file set can be completed quickly, and in scenarios such as adding a new inventory business, the development of the inventory query system can be completed quickly, thereby quickly realizing the inventory query function.

[0051] For example, the interface of the configuration file generator is as follows: Figures 3 to 6 As shown, through Figures 3 to 6 The configuration file generator shown can quickly configure the data source configuration file, data template configuration file, query condition configuration file, query result configuration file, and generate data storage template file, query condition configuration template file and query result configuration template file, so as to quickly realize the inventory query function.

[0052] Step S102: Acquire an inventory data set, and store the inventory data set into a preset database based on a data storage template file.

[0053] The inventory data set includes multiple inventory data, which may include call order data, work order data, etc., and of course, may also include inventory data of other business types. Based on the data storage template file, the inventory data set can be accurately stored in the preset database, thereby avoiding the slow query speed or inability to query due to data storage capacity or other problems, which is conducive to the rapid query of inventory data.

[0054] In one embodiment, based on the data storage template file, the inventory data set is stored in a preset database, including: based on the data template configuration file, multiple inventory data in the inventory data set are screened to obtain multiple first inventory data; based on the data source configuration file, the multiple first inventory data are converted to obtain multiple second inventory data; and the multiple second inventory data are stored in the preset database.

[0055] It should be noted that the basis for filtering the multiple list data can be pre-set field data, or other filtering methods. The data storage template file includes a data source configuration file, and the data source configuration file can include a data type of a preset database. Therefore, based on the data type of the preset database in the data source configuration file, data conversion can be performed on the multiple first list data, and the text data can be converted into the data type of the preset database, thereby improving the storage reliability and query reliability of the list data.

[0056] Step S103: Generate a list query statement based on the query condition configuration template file and the input query characters.

[0057] It should be noted that the query character can be input by the user based on the list query interface, or can be input in other ways, such as sent by a server or electronic device. The query condition configuration template file includes a data template configuration file and a query condition configuration file. Based on the data template configuration file, the query condition configuration file and the query character, a list query statement matching the preset database can be conveniently generated.

[0058] In one embodiment, a list query interface is generated based on a query condition configuration template file; corresponding query characters are obtained in response to an input operation on the list query interface; and a list query statement is generated based on the query condition configuration template file and the query characters. It should be noted that the list query interface can be displayed on a display screen of a terminal device, and corresponding query characters can be obtained through a user's input operation on the list query interface, and a list query statement of a preset database can be quickly generated based on the corresponding query characters.

[0059] It should be noted that both the inventory query interface and the inventory query statement can be generated based on the query condition configuration template file. The query condition configuration template file can include a data template configuration file and a query condition configuration file. The data template configuration file can include multiple field identifiers of the inventory data. The field identifier includes the field name, field type, field length, field description, type identifier, index field, query result field, and aggregation field. The query condition configuration file can include query fields, query logic, control categories, and control positions for querying inventory data.

[0060] Exemplarily, based on the query condition configuration template file and the query characters, a list query statement is generated, including: based on the data template configuration file, determining the target field identifier that matches the query characters; based on the query condition configuration file, generating the constraint logical relationship of the target field identifier; based on the constraint logical relationship of the target field identifier, generating a list query statement.

[0061] It should be noted that the data template configuration file can be used to quickly determine the target field identifier that matches the query character. The query fields and query logic lighting data in the query condition configuration file can be used to accurately generate the constraint logic relationship of the target field identifier, thereby satisfying the diverse flexibility of the query conditions.

[0062] It should be noted that the list query statement may be matched with a preset database. For example, if the preset database is a MySQL database, the list query statement generated according to the constraint logic relationship identified by the target field may be a SQL query statement.

[0063] Step S104: perform a list query in a preset database based on the list query statement to obtain a list query result.

[0064] It should be noted that the list query statement may include a target field identifier and a constraint logic relationship of the target field identifier. According to the list query statement, a list query can be accurately and quickly performed in a preset database to obtain a list query result.

[0065] Step S105: configure the template file based on the query result and output the list query result.

[0066] After obtaining the inventory query result, the inventory query result can be output based on the query result configuration template file. The query result configuration template file may include a data template configuration file and a query result configuration file. The data template configuration file includes multiple field identifiers of the inventory data. The field identifiers include field name, field type, field length, field description, type identifier, index field, query result field, and aggregate field. The query result configuration file includes result fields, escape fields, display fields, and field display positions for outputting inventory data.

[0067] In one embodiment, based on the query result configuration template file, the list query result is annotated to obtain a new list query result; and the new list query result is displayed on the list query interface. The annotation method includes but is not limited to the spring annotation technology. It should be noted that by annotating the list query result through the escape field, display field and field display position information in the query result configuration template file, the new list query result can be quickly obtained. The new list query result can be displayed on the list query interface for user reference.

[0068] It should be noted that based on the configured query result configuration template file, the query configuration program of the inventory query results can be greatly optimized. Only by modifying the query result configuration template file, the inventory query results can be automatically processed according to the query result configuration template file, thereby eliminating the need to update the query result code, and reducing errors in the program development process and the inventory query process.

[0069] The inventory query method provided in the above embodiment obtains a configuration template file set, wherein the configuration file set includes a data storage template file, a query condition configuration template file, and a query result configuration template file; obtains an inventory data set, and based on the data storage template file, stores the inventory data set to a preset database; generates an inventory query statement based on the query condition configuration template file and the input query characters; performs an inventory query in a preset database based on the inventory query statement to obtain an inventory query result; and outputs the inventory query result based on the query result configuration template file. The embodiment of the present application quickly implements the inventory query function by setting various configuration files, without the need to update the query result code, and can reduce the phenomenon of errors in the program development process and the inventory query process.

[0070] In one embodiment, please refer to Figure 7 , Figure 7 A schematic diagram of a scenario for implementing the inventory query method provided in an embodiment of the present application.

[0071] like Figure 7 As shown, the inventory query system includes a configuration file generator 10, a search engine processor 20, a query condition user interface generator 30, a query condition generator 40 and a query result generator 50.

[0072] Among them, the configuration file generator 10 is used to generate four parts: a data source configuration file, a data template configuration file, a query condition configuration file, and a query result configuration file. The configuration file generator 10 is also used to generate a data storage template file 11 according to the data source configuration file and the data template configuration file, and to generate a query condition configuration template file 12 according to the data template configuration file and the query condition configuration file, and to generate a query result configuration template file 13 according to the data template configuration file and the query result configuration file. The search engine processor 20 is used to obtain a list data set, and store the list data set to a preset database 21 based on the data storage template file 11. The query condition user interface generator 30 is used to generate a list query interface based on the query condition configuration template file 12, and obtain corresponding query characters 31 in response to input operations on the list query interface. The query condition generator 40 is used to generate a list query statement based on the query condition configuration template file 12 and the query characters 31, and perform a list query in the preset database 21 based on the list query statement to obtain a list query result 41. The query result generator 50 is used to annotate the list query result 41 based on the query result configuration template file 13 and display it on the list query interface.

[0073] It should be noted that the inventory query system of this application can be used in the development environment that provides inventory data retrieval needs for operators in the communication industry. The software environment of this inventory query system is installed with JDK1.8 and above, SPRING framework dependency package, and various data storage dependency packages. The Spring dependency package allows the reflection mechanism and annotations used by various reviewers to automatically implement some basic classes required in the framework. The data storage dependency package is the necessary application programming interface API to query various data stores, and obtain data results from the data store through the API.

[0074] Specifically, the corresponding examples of the configuration file generator 10 generating the data storage template file 11, the query condition configuration template file 12, and the query result configuration template file 13 can be implemented by using the reflection mechanism of Java. The corresponding examples of the search engine processor 20, the query condition user interface generator 30, the query condition generator 40, and the query result generator 50 can be implemented by using the annotation technology of Spring. By using the reflection mechanism of Java and the annotation principle of Spring to realize the low-code framework structure of the inventory query system, the configuration items of various configuration files are read to quickly realize the inventory query function.

[0075] See also Figure 8 , Figure 8 A schematic block diagram of the structure of a terminal device provided in an embodiment of the present application.

[0076] like Figure 8As shown, the terminal device 300 includes a processor 301 and a memory 302, and the processor 301 and the memory 302 are connected via a bus 303, such as an I2C (Inter-integrated Circuit) bus.

[0077] Specifically, the processor 301 is used to provide computing and control capabilities to support the operation of the entire terminal device. The processor 301 can be a central processing unit (CPU), and the processor 301 can also be other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, etc. Among them, the general-purpose processor can be a microprocessor or the processor can also be any conventional processor, etc.

[0078] Specifically, the memory 302 may be a Flash chip, a read-only memory (ROM) disk, an optical disk, a USB flash drive, or a mobile hard disk.

[0079] Those skilled in the art will understand that Figure 8 The structure shown in the figure is merely a block diagram of a partial structure related to the embodiments of the present application, and does not constitute a limitation on the terminal device to which the embodiments of the present application are applied. The specific terminal device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0080] The processor is used to run a computer program stored in the memory, and implement any one of the inventory query methods provided in the embodiments of the present application when executing the computer program.

[0081] In one embodiment, the processor is used to run a computer program stored in the memory, and implements the following steps when executing the computer program:

[0082] Obtain a configuration template file set, wherein the configuration file set includes a data storage template file, a query condition configuration template file, and a query result configuration template file;

[0083] Acquire an inventory data set, and based on the data storage template file, store the inventory data set into a preset database;

[0084] Generate a list query statement based on the query condition configuration template file and the input query characters;

[0085] Performing a list query in the preset database based on the list query statement to obtain a list query result;

[0086] A template file is configured based on the query result, and the inventory query result is output.

[0087] In one embodiment, when implementing the acquisition of the configuration template file set, the processor is used to implement:

[0088] Acquire multiple target configuration files, wherein the target configuration files include a data source configuration file, a data template configuration file, a query condition configuration file, and a query result configuration file;

[0089] Generate a data storage template file for storing the inventory data set according to the data source configuration file and the data template configuration file;

[0090] Generate a query condition configuration template file for generating the inventory query statement according to the data template configuration file and the query condition configuration file;

[0091] A query result configuration template file for outputting the inventory query result is generated according to the data template configuration file and the query result configuration file.

[0092] In one embodiment, the data source configuration file includes a database type of the preset database, an index identifier for storing inventory data in the inventory data set, and a field type in the inventory data;

[0093] The data template configuration file includes a plurality of field identifiers of the inventory data, wherein the field identifiers include a field name, a field type, a field length, a field description, a type identifier, an index field, a query result field, and an aggregation field;

[0094] The query condition configuration file includes query fields, query logic, control categories and control locations for querying the inventory data;

[0095] The query result configuration file includes a result field, an escape field, a display field and a field display position for outputting the list data.

[0096] In one embodiment, the plurality of target configuration files are generated according to a plurality of inventory data in the inventory data set.

[0097] In one embodiment, when implementing the storing of the inventory data set to a preset database based on the data storage template file, the processor is configured to implement:

[0098] Based on the data template configuration file, screening multiple inventory data in the inventory data set to obtain multiple first inventory data;

[0099] Based on the data source configuration file, performing data conversion on the plurality of first inventory data to obtain a plurality of second inventory data;

[0100] The plurality of second list data are stored in a preset database.

[0101] In one embodiment, when the processor generates a list query statement based on the query condition configuration template file and the input query characters, it is used to implement:

[0102] Configure the template file based on the query conditions to generate a list query interface;

[0103] In response to an input operation on the list query interface, obtaining a corresponding query character;

[0104] A list query statement is generated based on the query condition configuration template file and the query characters.

[0105] In one embodiment, the query condition configuration template file includes a data template configuration file and a query condition configuration file;

[0106] When the processor generates a list query statement based on the query condition configuration template file and the query character, it is used to implement:

[0107] Based on the data template configuration file, determining a target field identifier that matches the query character;

[0108] Based on the query condition configuration file, generating a constraint logic relationship of the target field identifier;

[0109] The list query statement is generated according to the constraint logic relationship identified by the target field.

[0110] In one embodiment, when implementing the configuration template file based on the query result and outputting the list query result, the processor is used to implement:

[0111] Based on the query result configuration template file, annotating the inventory query result to obtain a new inventory query result;

[0112] The new list query result is displayed on the list query interface.

[0113] It should be noted that those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working process of the terminal device described above can refer to the corresponding process in the aforementioned inventory query method embodiment, and will not be repeated here.

[0114] An embodiment of the present application also provides a storage medium for computer-readable storage, wherein the storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement the steps of any inventory query method provided in the embodiment of the present application.

[0115] The storage medium may be an internal storage unit of the terminal device described in the foregoing embodiment, such as a hard disk or memory of the terminal device. The storage medium may also be an external storage device of the terminal device, such as a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (SecureDigital, SD) card, a flash card (Flash Card), etc., equipped on the terminal device.

[0116] It will be appreciated by those skilled in the art that all or some of the steps, systems, and functional modules / units in the methods disclosed above may be implemented as software, firmware, hardware, and appropriate combinations thereof. In hardware implementations, the division between the functional modules / units mentioned in the above description does not necessarily correspond to the division of physical components; for example, a physical component may have multiple functions, or a function or step may be performed by several physical components in cooperation. Some or all physical components may be implemented as software executed by a processor, such as a central processing unit, a digital signal processor, or a microprocessor, or implemented as hardware, or implemented as an integrated circuit, such as an application-specific integrated circuit. Such software may be distributed on a computer-readable medium, which may include a computer storage medium (or non-transitory medium) and a communication medium (or temporary medium). As known to those skilled in the art, the term computer storage medium includes volatile and non-volatile, removable and non-removable media implemented in any method or technology for storing information (such as computer-readable instructions, data structures, program modules, or other data). Computer storage media include, but are not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, digital versatile disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tapes, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to store the desired information and can be accessed by a computer. In addition, it is well known to those of ordinary skill in the art that communication media typically contain computer-readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave or other transport mechanism, and may include any information delivery media.

[0117] The serial numbers of the embodiments of the present application are for description only and do not represent the advantages and disadvantages of the embodiments. The above description is only a specific implementation mode of the present application, but the protection scope of the present application is not limited thereto. Any technician familiar with the technical field can easily think of various equivalent modifications or replacements within the technical scope disclosed in the present application, and these modifications or replacements should be included in the protection scope of the present application. Therefore, the protection scope of the present application shall be based on the protection scope of the claims.

Claims

1. A method for querying a list, characterized in that: include: Obtain a configuration template file set, wherein the configuration file set includes a data storage template file, a query condition configuration template file, and a query result configuration template file; Acquire an inventory data set, and based on the data storage template file, store the inventory data set into a preset database; Generate a list query statement based on the query condition configuration template file and the input query characters; Performing a list query in the preset database based on the list query statement to obtain a list query result; A template file is configured based on the query result, and the inventory query result is output.

2. The inventory query method according to claim 1, characterized in that: The step of obtaining the configuration template file set includes: Acquire multiple target configuration files, wherein the target configuration files include a data source configuration file, a data template configuration file, a query condition configuration file, and a query result configuration file; Generate a data storage template file for storing the inventory data set according to the data source configuration file and the data template configuration file; Generate a query condition configuration template file for generating the inventory query statement according to the data template configuration file and the query condition configuration file; A query result configuration template file for outputting the inventory query result is generated according to the data template configuration file and the query result configuration file.

3. The inventory query method according to claim 2, characterized in that: The data source configuration file includes a database type of the preset database, an index identifier for storing inventory data in the inventory data set, and a field type in the inventory data; The data template configuration file includes a plurality of field identifiers of the inventory data, wherein the field identifiers include a field name, a field type, a field length, a field description, a type identifier, an index field, a query result field, and an aggregation field; The query condition configuration file includes query fields, query logic, control categories and control locations for querying the inventory data; The query result configuration file includes a result field, an escape field, a display field and a field display position for outputting the list data.

4. The inventory query method according to claim 3, characterized in that: The plurality of target configuration files are generated according to a plurality of inventory data in the inventory data set.

5. The inventory query method according to claim 2, characterized in that: The storing the inventory data set to a preset database based on the data storage template file includes: Based on the data template configuration file, screening multiple inventory data in the inventory data set to obtain multiple first inventory data; Based on the data source configuration file, performing data conversion on the plurality of first inventory data to obtain a plurality of second inventory data; The plurality of second list data are stored in a preset database.

6. The inventory query method according to any one of claims 1 to 5, characterized in that: The step of generating a list query statement based on the query condition configuration template file and the input query characters includes: Configure the template file based on the query conditions to generate a list query interface; In response to an input operation on the list query interface, obtaining a corresponding query character; A list query statement is generated based on the query condition configuration template file and the query characters.

7. The inventory query method according to claim 6, characterized in that: The query condition configuration template file includes a data template configuration file and a query condition configuration file; The step of configuring the template file based on the query condition and the query character to generate a list query statement includes: Based on the data template configuration file, determining a target field identifier that matches the query character; Based on the query condition configuration file, generating a constraint logic relationship of the target field identifier; The list query statement is generated according to the constraint logic relationship identified by the target field.

8. The inventory query method according to any one of claims 1 to 5, characterized in that: The configuring a template file based on the query result and outputting the inventory query result comprises: Based on the query result configuration template file, annotating the inventory query result to obtain a new inventory query result; The new list query result is displayed on the list query interface.

9. A terminal device, characterized in that: The terminal device includes a processor, a memory, a computer program stored in the memory and executable by the processor, and a data bus for realizing connection and communication between the processor and the memory, wherein when the computer program is executed by the processor, the inventory query method according to any one of claims 1 to 8 is realized.

10. A storage medium for computer-readable storage, characterized in that: The storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement the inventory query method according to any one of claims 1 to 8.

Images