CN115114321A - Dynamic query method and system - Google Patents

Dynamic query method and system Download PDF

Info

Publication number
CN115114321A
CN115114321A CN202210749703.9A CN202210749703A CN115114321A CN 115114321 A CN115114321 A CN 115114321A CN 202210749703 A CN202210749703 A CN 202210749703A CN 115114321 A CN115114321 A CN 115114321A
Authority
CN
China
Prior art keywords
query
type
mapping
data source
statement
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202210749703.9A
Other languages
Chinese (zh)
Inventor
陈玉昆
徐兆朋
姚奕钰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hangzhou Feixiang Enterprise Service Network Technology Co ltd
Original Assignee
Hangzhou Feixiang Enterprise Service Network Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Hangzhou Feixiang Enterprise Service Network Technology Co ltd filed Critical Hangzhou Feixiang Enterprise Service Network Technology Co ltd
Priority to CN202210749703.9A priority Critical patent/CN115114321A/en
Publication of CN115114321A publication Critical patent/CN115114321A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • G06F16/2448Query languages for particular applications; for extensibility, e.g. user defined types
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application discloses a dynamic query method and a system, which relate to the technical field of information query and comprise the following steps: acquiring a local query data source, a query table and a first mapping between a data type and a query type according to a query data source ID sent by a service party; determining a query type corresponding to each field in the query table according to the mapping model of the data type and the query type and the first mapping, and returning the query type and the corresponding query mode to the service party; receiving a query condition set by a service party, and converting the query condition into a query statement of a target database according to a query data source; and after the query data source and the query table are inserted into the query statement, executing the new query statement to obtain a query result, and returning the query result to the service party. The application provides a query system between a service and a database, which can shield the difference of different databases for a service party, so that codes do not need to be modified or redeveloped when the service is changed or a query field is changed.

Description

Dynamic query method and system
Technical Field
The present application relates to the field of information query technologies, and in particular, to a dynamic query method and system.
Background
The current query schemes are developed individually for specific services to implement specific query logic, and query codes need to be changed or redeveloped every time the services change.
When the service fields are few and relatively fixed, the implementation mode of targeted development has no big problem, and the maintainability is higher, but the queries of different services and the same type of data or different display modes of the same service are basically the same, so that a large amount of codes with repeated logics exist.
If the service field changes frequently or needs to be added or changed dynamically, the code of the implementation mode developed specifically will be changed frequently and is not stable.
Disclosure of Invention
The application provides a dynamic query method, which aims to solve the problem that query codes need to be frequently changed when service changes in the prior art.
In order to achieve the purpose, the following technical scheme is adopted in the application:
the dynamic query method comprises the following steps:
acquiring a query data source, a query table and a first mapping between a data type and a query type which are locally and correspondingly stored according to a query data source ID sent by a service party;
determining a query type corresponding to each field in the query table according to a mapping model of a data type and the query type established in advance and the first mapping, and returning the query type and a query mode corresponding to the query type to the service party;
receiving a query condition set by the service party according to the query type and the query mode, and converting the query condition into a query statement of a target database according to the query data source;
and inserting the query data source and the query table into the query statement, executing a new query statement to obtain a query result, and returning the query result to the service party.
Preferably, the obtaining, according to the query data source ID sent by the service party, the query data source and the query table stored locally and correspondingly, and the first mapping between the data type and the query type includes:
checking a query data source, a query table and a first mapping between a data type and a query type configured by a service party, if the checking is passed, storing the query data source, the query table and the first mapping, and returning an ID corresponding to the query data source to the service party.
Preferably, the determining, according to the mapping model of the data type and the query type established in advance and the first mapping, the query type corresponding to each field in the query table includes:
mapping each field in the query table to a corresponding query type according to a pre-established mapping model of the data type and the query type;
and loading the first mapping, determining whether the first mapping specifies the query type of each field in the query table, and if so, giving priority to the first mapping.
Preferably, if yes, giving priority to the first mapping further includes:
and when a field of the lookup table is not supported by the first mapping, deleting the field according to the query type obtained by the mapping model.
Preferably, the converting the query condition into a query statement of a target database according to the query data source includes:
analyzing the query condition to obtain a target field name, a target query type, a target query mode and a target matching value;
determining the type of a target database according to the query data source, and calling a query converter corresponding to the target database;
and inputting the target field name, the target query type, the target query mode and the target matching value into the query converter to output a query statement corresponding to the target database.
Preferably, the inserting the query data source and the query table into the query statement, then executing a new query statement to obtain a query result, and returning the query result to the service provider includes:
assembling the query table and the query data source into the query statement to obtain a new query statement, and executing the new query statement in the target database to obtain a query result;
and converting the query result into a field name according to the first mapping and mapping model, and returning the field name and a field value corresponding to the field name to the service party.
A dynamic query apparatus, comprising:
the acquisition module is used for acquiring a query data source and a query table which are locally and correspondingly stored and a first mapping between a data type and a query type according to a query data source ID sent by a service party;
the interaction module is used for determining the query type corresponding to each field in the query table according to the mapping model of the data type and the query type established in advance and the first mapping, and returning the query type and the query mode corresponding to the query type to the service party;
the conversion module is used for receiving the query conditions set by the business party according to the query type and the query mode and converting the query conditions into query statements of a target database according to the query data source;
and the query module is used for inserting the query data source and the query table into the query statement, then executing a new query statement to obtain a query result, and returning the query result to the service party.
Preferably, the system further includes a checking module, where the checking module is configured to check a query data source, a query table, and a first mapping between a data type and a query type, and if the checking is passed, store the query data source, the query table, and the first mapping, and return an ID corresponding to the query data source to the service party.
An electronic device comprising a memory and a processor, the memory for storing one or more computer instructions, wherein the one or more computer instructions are executed by the processor to implement a dynamic query method as claimed in any one of the preceding claims.
A computer readable storage medium storing a computer program which, when executed, causes a computer to implement a dynamic query method as claimed in any one of the preceding claims.
The invention has the following beneficial effects:
the application provides a stable query system, which is positioned between a service and a database, can shield the difference of different databases for a service party, does not need to modify codes or redevelop when the service is changed or a query field is changed, and can change related configuration when necessary, so that the system is more stable.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without inventive exercise.
Fig. 1 is a first flowchart of implementing a dynamic query method according to embodiment 1 of the present application;
FIG. 2 is a second flowchart of implementing a dynamic query method in embodiment 2 of the present application
Fig. 3 is a schematic diagram of a dynamic query system implemented in embodiment 3 of the present application;
fig. 4 is a schematic diagram of an electronic device implementing a dynamic query method in embodiment 4 of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be described clearly and completely with reference to the accompanying drawings, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The terms "first," "second," and the like in the claims and in the description of the present application are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order, it being understood that the terms so used are interchangeable under appropriate circumstances and are merely used to describe a distinguishing manner between similar elements in the embodiments of the present application and that the terms "comprising" and "having" and any variations thereof are intended to cover a non-exclusive inclusion such that a process, method, system, article, or apparatus that comprises a list of elements is not necessarily limited to those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus.
Example 1
As shown in fig. 1, a dynamic query method includes the following steps:
s110, acquiring a query data source and a query table which are locally and correspondingly stored and a first mapping between a data type and a query type according to a query data source ID sent by a service party;
s120, determining a query type corresponding to each field in the query table according to a pre-established mapping model of the data type and the query type and the first mapping, and returning the query type and a query mode corresponding to the query type to the service party;
s130, receiving a query condition set by the service party according to the query type and the query mode, and converting the query condition into a query statement of a target database according to the query data source;
s140, inserting the query data source and the query table into the query statement, executing the new query statement to obtain a query result, and returning the query result to the service party.
The embodiment mainly relates to interaction among a business party, a dynamic query system and a database, wherein the dynamic query system is a main body described by the method and is also a medium between the business party and the database, and the dynamic query system has the function of shielding differences of various different databases from the business party so that codes do not need to be rewritten for business change. The business side configures query data source, query table and first mapping between data type and query type in the dynamic query system, wherein the first mapping is configured manually, after the business side configures, the dynamic query system checks the configured information, mainly checks whether the data source information is correct, that is, whether the dynamic query system can be connected to the query data source, determines whether the query table exists, whether the configuration format of the first mapping is correct, and the like, after the check is passed, the information of the query data source, the query table and the first mapping is stored locally, and the ID corresponding to the query data source is returned to the business side, the business side acquires the corresponding query data source, the query table and the first mapping in the dynamic query system according to the ID of the query data source, if the acquisition is failed, the query table is returned in error, if the acquisition is successful, all queryable field information is determined according to the query table, then determining the query type and query mode corresponding to each field according to a mapping model and a first mapping of a data type and a query type which are established in advance, wherein the mapping model is automatic mapping, returning the obtained query type and the corresponding query mode to a business side, the business side sets the query condition according to the query type and the query mode, then going to a dynamic query system for querying after setting the query condition, the dynamic query system determines the type of a database to be queried according to a query data source, and then calls a corresponding query converter according to the type of the database, wherein the principle of the query converter is to develop corresponding language conversion logic according to the type of the database to be supported, for example, the queried data is data with the name of Zhang III, the data source is configured as a mysql database and a user data table, the set query condition is that a data source ID is 123, when inquiring, the database to be inquired is mysql which can be found by a data source, the inquired table is a user, a converter which is equal to the character string of the mysql database, namely (type equals to the string of the mysql database) is found according to the (name equals to the third) table, the (name equals to the third) table is transmitted to be converted into a corresponding mysql query statement (name equals to the third) table, therefore, the query condition is input into the corresponding query converter to be converted, the query statement of the target database is obtained, finally, the query data source and the query table are assembled into the query statement to obtain a new query statement, the new query statement is executed, the query result can be obtained, and then the query result is returned to a service party. Through the dynamic query system, only the data source information needs to be configured in the early stage, all queries in the later stage can be realized by using the dynamic query system, and the query code of a business party does not need to be changed even if the business is changed, the query field is changed or the query field is dynamically added.
Example 2
As shown in fig. 2, a dynamic query method includes the following steps:
s210, checking a query data source and a query table configured by a service party and a first mapping between a data type and a query type, if the checking is passed, storing the query data source, the query table and the first mapping, and returning an ID corresponding to the query data source to the service party;
s220, acquiring a query data source and a query table which are locally and correspondingly stored and a first mapping between a data type and a query type according to a query data source ID sent by a service party;
s230, mapping each field in the query table into a corresponding query type according to a pre-established mapping model of the data type and the query type;
s240, loading the first mapping, and determining whether the first mapping specifies the query type of each field in the query table, if so, mainly specifying the first mapping;
s250, receiving the query conditions set by the service party according to the query type and the query mode, and analyzing the query conditions to obtain a target field name, a target query type, a target query mode and a target matching value;
s260, determining the type of a target database according to the query data source, and calling a query converter corresponding to the target database;
s270, inputting the target field name, the target query type, the target query mode and the target matching value into the query converter and outputting a query statement corresponding to the target database;
s280, inserting the query data source and the query table into the query statement, executing a new query statement to obtain a query result, and returning the query result to the service party.
According to embodiment 2, the mapping relationships between the data types and the query types are divided into two types, one type is a first mapping configured manually, the first mapping mainly includes three types of mapping relationships, the first type is a mapping relationship of special data, such as 0 and 1 stored in a database, and the mapping relationship is to be correspondingly rendered into a drop-down box or a radio box for men and women in the rendering of the page query condition; JSON of the personnel information is stored in the database, but the query only needs to be carried out according to the names of the personnel; the second is field information which does not need to be displayed, such as creation time and modification time in data do not need to be rendered in a page query condition; the information (name, unit price, picture, etc.) of the commodity in the database does not need to be displayed during query; the third is that the data table has no query information to be supported, for example, the number of commodities in an order is not calculated in advance and is stored in the data table, and the data table can be assigned with a mapping relation in a manual configuration mode; the other type is a pre-established basic data mapping model, belongs to automatic mapping, and maps corresponding data such as fields in a query table into basic query types (numerical values, texts, time, addresses and the like) by automatic mapping and manual mapping according to data types (numbers, characters, time, sets and the like) in combination with application scenes (addresses, organization personnel frameworks and the like) and query display modes (drop-down boxes, search boxes, time selectors and the like), and each query type can correspond to one or more query modes (such as accurate and fuzzy search of texts; numerical values are greater than, equal to, less than or equal to, and in a range; sets contain one, all contain, none and the like).
The method comprises the steps of obtaining a corresponding query data source, a query table and first mapping between data types and query types according to a query data source ID, determining to obtain query table structure information according to the query table information, obtaining all queryable field information in the query table including the data types corresponding to the fields, inputting the corresponding data types into a pre-established mapping model of the data types and the query types to obtain the query types supported by the fields correspondingly, searching for the first mapping at the same time, determining whether the fields are configured or not, if the step is not directly skipped, if the mapping relation of a certain field is specified in the first mapping, mainly specifying the first mapping, and if the field is definitely indicated to not be queried in the first mapping, deleting the query types obtained by the field according to the mapping model, and not querying.
And returning the finally obtained query type and the corresponding query mode to the service party, setting query conditions by the service party according to the query type and the query mode, sending the query conditions to a dynamic query system, analyzing the query conditions by the dynamic query system to obtain a target field name, a target query type, a target query mode and a target matching value, wherein the matching value is a specific value to be queried, for example, the query name is Zhang III data, and the query conditions comprise: a field name of a name (the name represents the name), a query type code (string represents a character string), a query mode code (eq represents the same) and a matching value (Zhang III), then a database type to be queried is obtained according to a query data source, namely a target database type, a corresponding query converter is called according to the target database type, the query converter is as described in embodiment 1, a field to be queried, the matching value, the query type and the query mode are transmitted into the corresponding query converter to be converted so as to obtain a query statement corresponding to the target database, then the query statement is assembled according to the query data source and a query table so as to obtain a complete query statement, the complete query statement is executed in the target database so as to obtain a query result, and a dynamic query system converts the query result into a format (the field name: the field value) and then returns the query result to a service party, the returned results of different database queries may not be consistent, the format of all query results is unified by the dynamic query system as (field name: field value), the conversion here is mainly conversion of data types, such as 0 and 1 stored in the database, the result that is desired to be returned in the query is male and female, whether conversion is performed or not is judged first in the conversion, if conversion is performed (in the conversion, an identifier [ transform ] that needs to be converted is added to a query condition), a corresponding mapping relationship is obtained through a query data source ID transmitted in the query, and the data type and the conversion value corresponding to the query result are determined according to the mapping relationship (for example, the corresponding value is converted into the meaning of a specific representation thereof according to a special mapping relationship (male 0/female 1)).
Through the dynamic query system, as long as data source information is configured in the early stage, all queries in the later stage can be realized through the dynamic query system, even if business change, query field change or dynamic addition of query fields and the like occur, business side query codes do not need to be changed, only the lower mapping configuration is changed, if the query requirement of special data not contained in dynamic query exists, only a query type and a corresponding query mode need to be added in a dynamic form according to a specified mode, and the data is specified as a new query type in the mapping configuration, so that the stability is better.
Example 3
As shown in fig. 3, a dynamic query system includes a checking module, an obtaining module, an interacting module, a transforming module, and a query module:
and the checking module is used for checking a query data source, a query table and a first mapping between a data type and a query type which are configured by a service party, if the checking is passed, storing the query data source, the query table and the first mapping, and returning an ID corresponding to the query data source to the service party.
The acquisition module is used for acquiring a query data source and a query table which are locally and correspondingly stored and a first mapping between a data type and a query type according to a query data source ID sent by a service party;
the interaction module is used for determining the query type corresponding to each field in the query table according to the mapping model of the data type and the query type established in advance and the first mapping, and returning the query type and the query mode corresponding to the query type to the service party;
the conversion module is used for receiving the query conditions set by the business party according to the query type and the query mode and converting the query conditions into query statements of a target database according to the query data source;
and the query module is used for inserting the query data source and the query table into the query statement, then executing a new query statement to obtain a query result, and returning the query result to the service party.
Example 4
As shown in fig. 4, an electronic device comprises a memory 401 and a processor 402, wherein the memory 401 is used for storing one or more computer instructions, and the one or more computer instructions are executed by the processor 402 to implement one of the dynamic query methods described above.
It can be clearly understood by those skilled in the art that, for convenience and simplicity of description, the specific working process of the electronic device described above may refer to the corresponding process in the foregoing method embodiment, and details are not described herein again.
A computer-readable storage medium storing a computer program which, when executed, causes a computer to implement a dynamic querying method as described above.
Illustratively, a computer program may be divided into one or more modules/units, one or more modules/units are stored in the memory 401 and executed by the processor 402, and the input interface 405 and the output interface 406 perform I/O interface transmission of data to accomplish the present invention, and one or more modules/units may be a series of computer program instruction segments for describing the execution of the computer program in a computer device, which can accomplish specific functions.
The computer device may be a desktop computer, a notebook, a palm computer, a cloud server, or other computing devices. The computer device may include, but is not limited to, the memory 401 and the processor 402, and those skilled in the art will appreciate that the present embodiment is only an example of the computer device and does not constitute a limitation of the computer device, and may include more or less components, or combine some components, or different components, for example, the computer device may further include the input device 407, a network access device, a bus, etc.
The Processor 402 may be a Central Processing Unit (CPU), other general purpose Processor 402, a Digital Signal Processor 402 (DSP), an Application Specific Integrated Circuit (ASIC), a Field-Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. The general purpose processor 402 may be a microprocessor 402 or the processor 402 may be any conventional processor 402 or the like.
The storage 401 may be an internal storage unit of the computer device, such as a hard disk or a memory of the computer device. The memory 401 may also be an external storage device of the computer device, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card) and the like provided on the computer device, furthermore, the memory 401 may also include both an internal storage unit and an external storage device of the computer device, the memory 401 is used for storing computer programs and other programs and data required by the computer device, the memory 401 may also be used for temporarily storing the program codes in the output device 408, and the aforementioned storage Media include various Media capable of storing program codes, such as a usb disk, a removable hard disk, a ROM403, a RAM404, a disk and an optical disk.
The above description is only an embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions within the technical scope of the present invention are intended to be covered by the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the appended claims.

Claims (10)

1. A dynamic query method, comprising the steps of:
acquiring a query data source and a query table which are locally and correspondingly stored and a first mapping between a data type and a query type according to a query data source ID sent by a service party;
determining a query type corresponding to each field in the query table according to a mapping model of a data type and the query type established in advance and the first mapping, and returning the query type and a query mode corresponding to the query type to the service party;
receiving a query condition set by the service party according to the query type and the query mode, and converting the query condition into a query statement of a target database according to the query data source;
and inserting the query data source and the query table into the query statement, executing a new query statement to obtain a query result, and returning the query result to the service party.
2. The dynamic query method according to claim 1, wherein the obtaining a query data source and a query table stored locally and correspondingly according to a query data source ID sent by a service party, and a first mapping between a data type and a query type includes:
checking a query data source, a query table and a first mapping between a data type and a query type configured by a service party, if the checking is passed, storing the query data source, the query table and the first mapping, and returning an ID corresponding to the query data source to the service party.
3. The dynamic query method according to claim 1, wherein the determining the query type corresponding to each field in the query table according to the first mapping and a mapping model of a pre-established data type and a query type includes:
mapping each field in the query table to a corresponding query type according to a pre-established mapping model of the data type and the query type;
and loading the first mapping, determining whether the first mapping specifies the query type of each field in the query table, and if so, giving priority to the first mapping.
4. The dynamic query method of claim 3, wherein if so, the giving priority to the first mapping further comprises:
and when a field of the lookup table is not supported by the first mapping, deleting the field according to the query type obtained by the mapping model.
5. The dynamic query method of claim 1, wherein the converting the query condition into the query statement of the target database according to the query data source comprises:
analyzing the query condition to obtain a target field name, a target query type, a target query mode and a target matching value;
determining the type of a target database according to the query data source, and calling a query converter corresponding to the target database;
and inputting the target field name, the target query type, the target query mode and the target matching value into the query converter to output a query statement corresponding to the target database.
6. The dynamic query method of claim 1, wherein the inserting the query data source and the query table into the query statement, executing a new query statement to obtain a query result, and returning the query result to the service provider comprises:
assembling the query table and the query data source into the query statement to obtain a new query statement, and executing the new query statement in the target database to obtain a query result;
and converting the query result into a field name according to the first mapping and mapping model, and returning the field name and a field value corresponding to the field name to the service party.
7. A dynamic query system, comprising:
the acquisition module is used for acquiring a query data source and a query table which are locally and correspondingly stored and a first mapping between a data type and a query type according to a query data source ID sent by a service party;
the interaction module is used for determining the query type corresponding to each field in the query table according to the mapping model of the data type and the query type established in advance and the first mapping, and returning the query type and the query mode corresponding to the query type to the service party;
the conversion module is used for receiving the query conditions set by the business party according to the query type and the query mode and converting the query conditions into query statements of a target database according to the query data source;
and the query module is used for inserting the query data source and the query table into the query statement, then executing a new query statement to obtain a query result, and returning the query result to the service party.
8. The dynamic query system of claim 7, further comprising a checking module, wherein the checking module is configured to check a query data source, a query table, and a first mapping between a data type and a query type configured by the service provider, and if the check is passed, store the query data source, the query table, and the first mapping, and return an ID corresponding to the query data source to the service provider.
9. An electronic device comprising a memory and a processor, the memory configured to store one or more computer instructions, wherein the one or more computer instructions are executable by the processor to implement a dynamic query method as claimed in any one of claims 1 to 6.
10. A computer-readable storage medium storing a computer program, the computer program causing a computer to implement a dynamic query method according to any one of claims 1 to 6 when executed.
CN202210749703.9A 2022-06-28 2022-06-28 Dynamic query method and system Pending CN115114321A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210749703.9A CN115114321A (en) 2022-06-28 2022-06-28 Dynamic query method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210749703.9A CN115114321A (en) 2022-06-28 2022-06-28 Dynamic query method and system

Publications (1)

Publication Number Publication Date
CN115114321A true CN115114321A (en) 2022-09-27

Family

ID=83329980

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210749703.9A Pending CN115114321A (en) 2022-06-28 2022-06-28 Dynamic query method and system

Country Status (1)

Country Link
CN (1) CN115114321A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117891847A (en) * 2024-03-18 2024-04-16 辽宁牧龙科技有限公司 Data query device and method based on data center

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117891847A (en) * 2024-03-18 2024-04-16 辽宁牧龙科技有限公司 Data query device and method based on data center

Similar Documents

Publication Publication Date Title
CN111400387B (en) Conversion method and device for import and export data, terminal equipment and storage medium
CN111259643B (en) Method and equipment for generating graphic report
CN113704243A (en) Data analysis method, data analysis device, computer device, and storage medium
CN112800730A (en) Report form filling method and device
CN109062906B (en) Translation method and device for program language resources
CN115114321A (en) Dynamic query method and system
CN114356333A (en) Service function configuration method, equipment, storage medium and service system thereof
CN110888672A (en) Metadata architecture-based expression engine implementation method and system
CN114282129A (en) Information system page generation method, system, electronic equipment and storage medium
CN113760961A (en) Data query method and device
CN112947900A (en) Web application development method and device, server and development terminal
CN116303622A (en) Database query method, device, equipment and storage medium
CN108196921B (en) Document development method and device, computer equipment and storage medium
CN113900755B (en) Alarm page processing method and device, computer equipment and readable storage medium
CN112491943A (en) Data request method, device, storage medium and electronic equipment
US20220284371A1 (en) Method, device and medium for a business function page
CN114358596A (en) Index calculation method and device
CN113468258A (en) Heterogeneous data conversion method and device and storage medium
CN110471708B (en) Method and device for acquiring configuration items based on reusable components
CN114385540A (en) Data unit conversion method and device
CN114116712A (en) Extended field processing method and device, electronic equipment and storage medium
CN115114280A (en) Report generation processing method, device and equipment
CN112445811A (en) Data service method, device, storage medium and component based on SQL configuration
CN115208960B (en) Protocol switching method and related equipment
CN112052418B (en) Data configuration method and device

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination