CN115357604A - Data query method and device - Google Patents
Data query method and device Download PDFInfo
- Publication number
- CN115357604A CN115357604A CN202211270748.4A CN202211270748A CN115357604A CN 115357604 A CN115357604 A CN 115357604A CN 202211270748 A CN202211270748 A CN 202211270748A CN 115357604 A CN115357604 A CN 115357604A
- Authority
- CN
- China
- Prior art keywords
- query
- target
- field
- determining
- user
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data query method and a data query device, and relates to the technical field of computers. One embodiment of the method comprises: receiving an inquiry request sent by a user, wherein the inquiry request comprises: an identification of the target functional component; determining a target query subject corresponding to the query request according to the corresponding relation between the pre-configured functional component identifier and the query subject; the query body includes: a table name; determining a target category to which a user belongs; determining a target query field corresponding to a user according to a preset corresponding relation between the category and the query field; splicing the target query main body and the target query field to obtain a query statement; querying a database based on the query statement to obtain a query result; and sending the query result to the front end so that the front end displays the query result. According to the embodiment, the read-write permission of the field can be controlled through the preset corresponding relation, the dependence on the database is avoided, and the corresponding relation of the configuration does not need to be changed even if the type of the database is changed.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a data query method and a data query device.
Background
In an actual service scenario, due to service requirements, the fields that can be obtained by different classes of users are usually different for the same service information in the database. For example, the personal information table in the database includes four fields of ID, name, age, and sales, and if the user is a consumer, the fields that can be obtained are ID, name, and age, and if the user is a merchant, the fields that can be obtained are ID, name, age, and sales. That is, different categories of users may query the database for different fields of data.
At present, the query result of a user is generally controlled based on the field read-write authority of the database, and the field read-write authority can be set by database management personnel through a database client. In the prior art, after receiving a query request of a user, a database is directly queried to obtain a query result, and a field included in the query result is determined by a preset field read-write permission. However, the method has strong dependence on the database, when the type of the database is changed, the previously set field read-write permission is often not applicable, the database manager needs to reset the field read-write permission of the user, and the process takes a long time.
Disclosure of Invention
In view of this, embodiments of the present invention provide a data query method and apparatus, which can control field read-write permission through a pre-configured corresponding relationship, avoid dependence on a database, and do not need to change the configured corresponding relationship even if the type of the database changes.
In a first aspect, an embodiment of the present invention provides a data query method, including:
receiving an inquiry request sent by a user, wherein the inquiry request comprises: an identification of the target functional component;
determining a target query main body corresponding to the query request according to a corresponding relation between a pre-configured identifier of the functional component and the query main body; the query body includes: a table name;
determining a target category to which the user belongs;
determining a target query field corresponding to the user according to a preset corresponding relation between the category and the query field;
splicing the target query main body and the target query field to obtain a query statement;
querying a database based on the query statement to obtain a query result;
and sending the query result to a front end so that the front end displays the query result.
In a second aspect, an embodiment of the present invention provides a data query apparatus, including:
a receiving module configured to receive an inquiry request sent by a user, where the inquiry request includes: an identification of the target functional component;
the determining module is configured to determine a target query subject corresponding to the query request according to a corresponding relation between a pre-configured identifier of the functional component and the query subject; determining a target category to which the user belongs; determining a target query field corresponding to the user according to a preset corresponding relation between the category and the query field; splicing the target query main body and the target query field to obtain a query statement; the query body includes: a table name;
the query module is configured to query a database based on the query statement to obtain a query result;
and the sending module is configured to send the query result to a front end so that the front end displays the query result.
In a third aspect, an embodiment of the present invention provides an electronic device, including:
one or more processors;
a storage device to store one or more programs,
when executed by the one or more processors, cause the one or more processors to implement a method as in any one of the embodiments described above.
In a fourth aspect, an embodiment of the present invention provides a computer-readable medium, on which a computer program is stored, where the computer program is configured to, when executed by a processor, implement a method according to any one of the above embodiments.
One embodiment of the above invention has the following advantages or benefits: the fields which can be inquired from the database by the user are determined through the corresponding relation between the pre-configured identification of the functional component and the inquiry main body and the corresponding relation between the category and the inquiry field, namely the fields inquired by the user are controlled through the two corresponding relations. The method does not depend on a database, and can adjust the field read-write permission of the user to the database by adjusting the two corresponding relations. Compared with the prior art, the embodiment of the invention adjusts the field read-write permission of the user in the service level through configuration, avoids the dependence on the database, and does not need to change the corresponding relationship of the configuration even if the type of the database changes.
Further effects of the above-mentioned non-conventional alternatives will be described below in connection with the embodiments.
Drawings
The drawings are included to provide a better understanding of the invention and are not to be construed as unduly limiting the invention. Wherein:
FIG. 1 is a flow chart of a data query method provided by an embodiment of the invention;
FIG. 2 is a flow chart of a data query method according to another embodiment of the present invention;
FIG. 3 is a schematic diagram of a data query device according to an embodiment of the present invention;
fig. 4 is a schematic block diagram of a computer system suitable for use in implementing a terminal device or server of an embodiment of the invention.
Detailed Description
Exemplary embodiments of the present invention are described below with reference to the accompanying drawings, in which various details of embodiments of the invention are included to assist understanding, and which are to be considered as merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
As shown in fig. 1, an embodiment of the present invention provides a data query method, including:
step 101: receiving an inquiry request sent by a user, wherein the inquiry request comprises: identification of the target functional component.
For example, the user clicks on a menu item through the browser, and the identifier of the menu item is the identifier of the target function component.
Step 102: determining a target query main body corresponding to the query request according to the corresponding relation between the pre-configured functional component identifier and the query main body; the query body comprises: the name of the table.
The table name is used to identify a data table in the database. The embodiment of the invention binds the functional component and the data table through the corresponding relation between the identification of the functional component and the query main body, and can determine the data table to be queried through the functional component operated by a user.
Step 103: and determining the target category to which the user belongs.
In an actual service scenario, users of different categories may have different query permissions, and according to service requirements, the users may be divided according to different dimensions, for example, the users are divided into different categories according to age, gender, occupation, position, and the like. The embodiment of the invention can acquire the registration information of the user by inquiring the user identification carried in the request, and determine the target category of the user according to the registration information of the user. The query request can also comprise attribute information of the user, and the target category to which the user belongs is determined based on the attribute information of the user.
Step 104: and determining a target query field corresponding to the user according to the corresponding relation between the pre-configured category and the query field.
Different field read-write authorities can be configured for different types of users through the corresponding relation between the types and the query fields, and if the field read-write authorities are changed, the corresponding relation can be changed.
Step 105: and splicing the target query main body and the target query field to obtain a query statement.
Step 106: and querying the database based on the query statement to obtain a query result.
Step 107: and sending the query result to the front end so that the front end displays the query result.
The fields which can be inquired from the database by the user are determined through the corresponding relation between the pre-configured identification of the functional component and the inquiry main body and the corresponding relation between the category and the inquiry field, namely the fields inquired by the user are controlled through the two corresponding relations. The method does not depend on a database, and can adjust the field read-write permission of the user to the database by adjusting the two corresponding relations. Compared with the prior art, the embodiment of the invention adjusts the field read-write permission of the user in the service level through configuration, avoids the dependence on the database, and does not need to change the corresponding relationship of the configuration even if the type of the database changes.
In the prior art, different pages are often written for different categories of users, so that different styles are displayed for different categories of users, or different editing rights are configured for different categories of users. But the page is respectively written for different types of users, so that the workload is large and the development efficiency is low.
In view of this, in one embodiment of the invention, the method further comprises: determining target metadata corresponding to the target query field according to a preset corresponding relation between the query field and the metadata;
and sending the target metadata to the front end so that the front end displays the query result according to the target metadata.
The embodiment of the invention can respectively configure different metadata for different query fields, and the metadata can comprise editing authority, namely whether the field can be edited or not, and can also comprise display style information of the field and the like. By means of the corresponding relation between the query fields and the metadata, different editing authorities or display styles can be set for different query fields, pages do not need to be written for different types of users, and development workload is reduced.
In an actual application scenario, the method may query the fixed fields according to the category of the user and the triggered functional component. However, in consideration of the difference between the user requirements, in an embodiment of the present invention, the query request further includes: a current query field;
the method further comprises the following steps: and determining whether the current query field is the same as the target query field, if so, executing splicing of the target query main body and the target query field, otherwise, when an intersection field exists between the current query field and the target query field, splicing the target query main body and the intersection field to obtain a query statement, and executing query of the database based on the query statement.
In the embodiment of the present invention, a user may select a current query field to be obtained, where the current query field may include one or more fields, and if the current query field is completely consistent with the target query field, the target query body may be spliced with the target query field (or the current query field), and if the current query field is not completely consistent with the target query field and there is an intersection field, the target query body may be spliced with the intersection field, where the current query field includes A, B, C, the target query field includes B, C, D, and the intersection field is B, C. If the current query field is not completely consistent with the target query field and there is no intersection field, the user may be prompted for a query failure or to modify the current query field.
In one embodiment of the invention, the metadata includes: whether the query field is editable, a display style of the query field, a display name of the query field, and a field type of the query field.
The front end can determine the display style of the query field and the editing authority of the user on the query field according to the metadata.
In one embodiment of the invention, the query body further comprises: and querying the condition.
In the embodiment of the invention, the user can adjust the query body by selecting different functional components, such as changing the data table or query condition of the query. Through the query conditions, the data records in the data table can be screened, and different requirements of users are met. For example, different menu items correspond to different query conditions, and the query conditions may be determined according to the menu item selected by the user. The user can determine the query condition by selecting or typing, i.e. the query condition can be included in the query request.
As shown in fig. 2, an embodiment of the present invention provides a data query method, including:
step 201: receiving an inquiry request sent by a user, wherein the inquiry request comprises: identification of the target functional component.
For example, the target function component is student information editing.
Step 202: determining a target query subject corresponding to the query request according to the corresponding relation between the pre-configured functional component identifier and the query subject; the query body includes: table names and query conditions.
Step 203: and determining the target category to which the user belongs.
Step 204: and determining a target query field corresponding to the user according to the preset corresponding relation between the category and the query field.
For example, the query fields corresponding to category 1 are name, age, birthday, and six, and the query fields corresponding to category 2 are name and age.
Step 205: and splicing the target query main body and the target query field to obtain a query statement.
The query statement structure is as follows: select { # columns } from student. Wherein { # columns } is the query field and the student is the query subject.
Step 206: and querying the database based on the query statement to obtain a query result.
Step 207: and determining target metadata corresponding to the target query field according to the corresponding relation between the pre-configured query field and the metadata.
Step 208: and sending the query result and the target metadata to the front end so that the front end displays the query result according to the target metadata.
The embodiment of the invention does not depend on the characteristics of the database, can more conveniently control the field read-write permission, can change the field editing permission through the metadata, does not need to rewrite the page, and improves the development efficiency.
As shown in fig. 3, an embodiment of the present invention provides a data query apparatus, including:
the receiving module 301 is configured to receive an inquiry request sent by a user, where the inquiry request includes: an identification of the target functional component;
a determining module 302 configured to determine a target query subject corresponding to the query request according to a correspondence between the preconfigured identifier of the functional component and the query subject; determining a target category to which a user belongs; determining a target query field corresponding to a user according to a preset corresponding relation between the category and the query field; splicing the target query main body and the target query field to obtain a query statement; the query body includes: a table name;
a query module 303 configured to query the database based on the query statement to obtain a query result;
the sending module 304 is configured to send the query result to the front end, so that the front end displays the query result.
In an embodiment of the present invention, the determining module 302 is configured to determine target metadata corresponding to a target query field according to a pre-configured corresponding relationship between the query field and the metadata;
the sending module 304 is configured to send the target metadata to the front end, so that the front end displays the query result according to the target metadata.
In an embodiment of the present invention, the query request further includes: a current query field;
the determining module 302 is configured to determine whether the current query field is the same as the target query field, if so, perform splicing of the target query body and the target query field, otherwise, when there is an intersection field between the current query field and the target query field, perform splicing of the target query body and the intersection field to obtain a query statement, and trigger the query module to perform query on the database based on the query statement.
An embodiment of the present invention provides an electronic device, including:
one or more processors;
a storage device for storing one or more programs,
when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the method of any of the embodiments as described above.
An embodiment of the present invention provides a computer-readable medium, on which a computer program is stored, wherein the computer program is configured to implement the method according to any one of the above embodiments when executed by a processor.
Referring now to FIG. 4, shown is a block diagram of a computer system 400 suitable for use with a terminal device implementing embodiments of the present invention. The terminal device shown in fig. 4 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 4, the computer system 400 includes a Central Processing Unit (CPU) 401 that can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM) 402 or a program loaded from a storage section 408 into a Random Access Memory (RAM) 403. In the RAM 403, various programs and data necessary for the operation of the system 400 are also stored. The CPU 401, ROM 402, and RAM 403 are connected to each other via a bus 404. An input/output (I/O) interface 405 is also connected to bus 404.
The following components are connected to the I/O interface 405: an input section 406 including a keyboard, a mouse, and the like; an output section 407 including a display device such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage section 408 including a hard disk and the like; and a communication section 409 including a network interface card such as a LAN card, a modem, or the like. The communication section 409 performs communication processing via a network such as the internet. A driver 410 is also connected to the I/O interface 405 as needed. A removable medium 411 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 410 as necessary, so that a computer program read out therefrom is mounted into the storage section 408 as necessary.
In particular, according to the embodiments of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 409, and/or installed from the removable medium 411. The computer program performs the above-described functions defined in the system of the present invention when executed by a Central Processing Unit (CPU) 401.
It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present invention, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems that perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The modules described in the embodiments of the present invention may be implemented by software or hardware. The described modules may also be provided in a processor, which may be described as: a processor includes a sending module, an obtaining module, a determining module, and a first processing module. The names of these modules do not form a limitation on the modules themselves in some cases, and for example, the sending module may also be described as a "module sending a picture acquisition request to a connected server".
The above-described embodiments should not be construed as limiting the scope of the invention. Those skilled in the art will appreciate that various modifications, combinations, sub-combinations, and substitutions can occur, depending on design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. A method of querying data, comprising:
receiving an inquiry request sent by a user, wherein the inquiry request comprises: an identification of the target functional component;
determining a target query subject corresponding to the query request according to a corresponding relation between the pre-configured functional component identifier and the query subject; the query body includes: a table name;
determining a target category to which the user belongs;
determining a target query field corresponding to the user according to a preset corresponding relation between the category and the query field;
splicing the target query main body and the target query field to obtain a query statement;
querying a database based on the query statement to obtain a query result;
and sending the query result to a front end so that the front end displays the query result.
2. The method of claim 1, further comprising:
determining target metadata corresponding to the target query field according to a corresponding relation between the pre-configured query field and the metadata;
and sending the target metadata to the front end so that the front end displays the query result according to the target metadata.
3. The method of claim 1 or 2,
the query request further comprises: a current query field;
the method further comprises the following steps: and determining whether the current query field is the same as the target query field, if so, executing the splicing of the target query body and the target query field, otherwise, when an intersection field exists between the current query field and the target query field, splicing the target query body and the intersection field to obtain a query statement, and executing the query database based on the query statement.
4. The method of claim 2,
the metadata includes: whether the query field is editable, a display style of the query field, a display name of the query field, and a field type of the query field.
5. The method of claim 1,
the query body further includes: and querying the condition.
6. A data query apparatus, comprising:
a receiving module configured to receive an inquiry request sent by a user, where the inquiry request includes: an identification of the target functional component;
the determining module is configured to determine a target query subject corresponding to the query request according to a corresponding relation between a pre-configured identifier of the functional component and the query subject; determining a target category to which the user belongs; determining a target query field corresponding to the user according to a preset corresponding relation between the category and the query field; splicing the target query main body and the target query field to obtain a query statement; the query body includes: a table name;
the query module is configured to query a database based on the query statement to obtain a query result;
and the sending module is configured to send the query result to a front end so that the front end displays the query result.
7. The apparatus of claim 6,
the determining module is configured to determine target metadata corresponding to the target query field according to a preset corresponding relation between the query field and the metadata;
the sending module is configured to send the target metadata to the front end, so that the front end displays the query result according to the target metadata.
8. The apparatus of claim 6 or 7,
the query request further comprises: a current query field;
the determining module is configured to determine whether the current query field is the same as the target query field, if so, perform the splicing of the target query body and the target query field, otherwise, when an intersection field exists between the current query field and the target query field, splice the target query body and the intersection field to obtain a query statement, and trigger the query module to perform the query on the basis of the query statement.
9. An electronic device, comprising:
one or more processors;
a storage device to store one or more programs,
when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-5.
10. A computer-readable medium, on which a computer program is stored, which, when being executed by a processor, carries out the method according to any one of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211270748.4A CN115357604B (en) | 2022-10-18 | 2022-10-18 | Data query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211270748.4A CN115357604B (en) | 2022-10-18 | 2022-10-18 | Data query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115357604A true CN115357604A (en) | 2022-11-18 |
| CN115357604B CN115357604B (en) | 2023-03-07 |
Family
ID=84008577
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211270748.4A Active CN115357604B (en) | 2022-10-18 | 2022-10-18 | Data query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115357604B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109947788A (en) * | 2017-10-30 | 2019-06-28 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN111552688A (en) * | 2020-03-18 | 2020-08-18 | 北京达佳互联信息技术有限公司 | Data export method and device and electronic equipment |
| CN112307052A (en) * | 2020-10-28 | 2021-02-02 | 北京锐安科技有限公司 | Data management method, service system, terminal and storage medium |
| WO2021189829A1 (en) * | 2020-09-02 | 2021-09-30 | 平安科技（深圳）有限公司 | Data query method and apparatus, electronic device, and storage medium |
| CN113535749A (en) * | 2020-04-17 | 2021-10-22 | 阿里巴巴集团控股有限公司 | Query statement generation method and device |
| CN114780539A (en) * | 2022-03-28 | 2022-07-22 | 徐工汉云技术股份有限公司 | Method, system and storage medium for generating report form in multiple dimensions |
| CN114944210A (en) * | 2022-04-24 | 2022-08-26 | 医渡云（北京）技术有限公司 | Data processing method and device, computer readable storage medium and electronic equipment |
-
2022
- 2022-10-18 CN CN202211270748.4A patent/CN115357604B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109947788A (en) * | 2017-10-30 | 2019-06-28 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN111552688A (en) * | 2020-03-18 | 2020-08-18 | 北京达佳互联信息技术有限公司 | Data export method and device and electronic equipment |
| CN113535749A (en) * | 2020-04-17 | 2021-10-22 | 阿里巴巴集团控股有限公司 | Query statement generation method and device |
| WO2021189829A1 (en) * | 2020-09-02 | 2021-09-30 | 平安科技（深圳）有限公司 | Data query method and apparatus, electronic device, and storage medium |
| CN112307052A (en) * | 2020-10-28 | 2021-02-02 | 北京锐安科技有限公司 | Data management method, service system, terminal and storage medium |
| CN114780539A (en) * | 2022-03-28 | 2022-07-22 | 徐工汉云技术股份有限公司 | Method, system and storage medium for generating report form in multiple dimensions |
| CN114944210A (en) * | 2022-04-24 | 2022-08-26 | 医渡云（北京）技术有限公司 | Data processing method and device, computer readable storage medium and electronic equipment |
Non-Patent Citations (1)
| Title |
|---|
| 爱易网页: "查询的时候，表名可以是拼接的字符串吗?", 《HTTP://WWW.AIYIWEB.COM/ORACLE/8938》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115357604B (en) | 2023-03-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111177231B (en) | Report generation method and report generation device | |
| CN109947788B (en) | Data query method and device | |
| US9959607B2 (en) | Automatic verification of graphic rendition of JSON data | |
| US20110161343A1 (en) | Method and system to dynamically create queries to find related records in a database | |
| CN111813804B (en) | Data query method and device, electronic equipment and storage medium | |
| CN111427971A (en) | Business modeling method, device, system and medium for computer system | |
| CN113971037A (en) | Application processing method and device, electronic equipment and storage medium | |
| CN111008865A (en) | Coupon synchronous display method and device, server and storage medium | |
| US20170124219A1 (en) | Determining data field offsets using a document object model representation | |
| EP3532922B1 (en) | Processing application programming interface (api) queries based on variable schemas | |
| CN114185941A (en) | Report data query method and device, electronic equipment and storage medium | |
| CN108694172B (en) | Information output method and device | |
| CN113626223A (en) | Interface calling method and device | |
| CN115357604B (en) | Data query method and device | |
| US9411836B2 (en) | Facilitating consistency between a glossary and a repository | |
| CN111367500A (en) | Data processing method and device | |
| CN114722108A (en) | Customer service data processing method and device, electronic equipment and storage medium | |
| CN111831179B (en) | Signing method, device and computer readable medium | |
| US11138273B2 (en) | Onboarding services | |
| CN111553711A (en) | Method, system, electronic device and medium for configuring order claim scheme | |
| CN111367898A (en) | Data processing method, device, system, electronic equipment and storage medium | |
| CN111125565A (en) | Method and equipment for inputting information in application | |
| CN113778501B (en) | Code task processing method and device | |
| CN111460273B (en) | Information pushing method and device | |
| US20150293973A1 (en) | Managing electronic records |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |