CN116467334A - Database query method and device - Google Patents
Database query method and device Download PDFInfo
- Publication number
- CN116467334A CN116467334A CN202310315640.0A CN202310315640A CN116467334A CN 116467334 A CN116467334 A CN 116467334A CN 202310315640 A CN202310315640 A CN 202310315640A CN 116467334 A CN116467334 A CN 116467334A
- Authority
- CN
- China
- Prior art keywords
- target
- query
- code
- component
- database
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 61
- 238000012545 processing Methods 0.000 claims description 31
- 238000010276 construction Methods 0.000 claims description 15
- 230000005540 biological transmission Effects 0.000 claims description 12
- 238000004590 computer program Methods 0.000 claims description 10
- 230000008569 process Effects 0.000 abstract description 15
- 238000010586 diagram Methods 0.000 description 10
- 238000011161 development Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 8
- 230000002688 persistence Effects 0.000 description 7
- 238000013461 design Methods 0.000 description 5
- 230000009471 action Effects 0.000 description 4
- 238000012546 transfer Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 3
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 230000002441 reversible effect Effects 0.000 description 1
- 238000009517 secondary packaging Methods 0.000 description 1
- 230000001052 transient effect Effects 0.000 description 1
- 230000007704 transition Effects 0.000 description 1
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
-
- 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
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/31—Programming languages or programming paradigms
- G06F8/315—Object-oriented languages
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application provides a database query method and device, wherein the method comprises the following steps: constructing a storage layer of a database; acquiring an identification to be queried; acquiring a target querier corresponding to the identification to be queried from a storage layer; and transmitting the identification to be queried into a target querier for data query, and obtaining a data query result. Therefore, the single-table query can be realized quickly, query sentences do not need to be written, and the query process is simple, so that the single-table query efficiency is improved.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a database query method and apparatus.
Background
At present, when MyBatis is used as a database layer access framework in Java application, a plurality of repeated codes appear in the database layer, a certain templatization is presented, particularly, single-table operation is performed, and an SQL statement needs to be customized for inquiring certain fields of a single table. Therefore, in the existing method, query sentences are required to be written aiming at single-table query, the query process is complex, and the single-table query efficiency is low.
Disclosure of Invention
The embodiment of the application aims to provide a database query method and device, which can quickly realize single-table query, do not need to write query sentences, and have simple query process, thereby being beneficial to improving the single-table query efficiency.
An embodiment of the present application provides a database query method, including:
constructing a storage layer of a database;
acquiring an identification to be queried;
acquiring a target inquirer corresponding to the identification to be inquired from the storage layer;
and transmitting the identification to be queried into the target querier to perform data query, and obtaining a data query result.
In the implementation process, the method can preferentially construct the storage layer of the database; obtaining the identification to be queried; then, a target inquirer corresponding to the identification to be inquired is obtained from the storage layer; and finally, transmitting the identification to be queried into a target querier for data query to obtain a data query result. Therefore, the method can quickly realize the single-table query without writing query sentences, and the query process is simple, thereby being beneficial to improving the single-table query efficiency.
Further, the obtaining, from the warehouse layer, the target querier corresponding to the identifier to be queried includes:
determining a data transmission object according to the identification to be queried;
and acquiring a target inquirer from the warehouse layer according to the transmission object.
Further, the warehouse layer at least comprises a single-table newly-added code package, a single-table deleted code package, a single-table modified code package, a DAO layer supporting component, a code generating component, a data access layer component, a logic generating component, a logic registry component, a dynamic query statement constructing component and a single-table querier constructing component.
Further, the method further comprises:
receiving a newly added target list table of a database;
generating a single form processing code corresponding to the target single form through the code generation component;
and configuring the single-table processing code into the warehouse layer.
Further, the single form processing code includes a target single form new code packet, a target single form deleting code packet, a target single form modifying code packet and a target single form query device, wherein the target single form new code packet is used for performing new processing on the target single form, the target single form deleting code packet is used for performing deleting processing on the target single form, the target single form modifying code packet is used for performing modifying processing on the target single form, and the target single form query device is used for performing data query processing on the target single form.
A second aspect of the embodiments of the present application provides a database query apparatus, including:
the construction unit is used for constructing a storage layer of the database;
the first acquisition unit is used for acquiring the identification to be queried;
the second acquisition unit is used for acquiring a target inquirer corresponding to the identification to be inquired from the storage layer;
and the query unit is used for transmitting the identification to be queried into the target querier to perform data query, and obtaining a data query result.
In the implementation process, the device can construct a storage layer of the database through a construction unit; acquiring an identification to be queried through a first acquisition unit; acquiring a target inquirer corresponding to the identification to be inquired from the warehouse layer through a second acquisition unit; and transmitting the identification to be queried into a target querier through a query unit to perform data query, and obtaining a data query result. Therefore, the device can quickly realize the single-table query without writing query sentences, and the query process is simple, thereby being beneficial to improving the single-table query efficiency.
Further, the second acquisition unit includes:
a determining subunit, configured to determine a data transmission object according to the identifier to be queried;
and the acquisition subunit is used for acquiring the target inquirer from the warehouse layer according to the transmission object.
Further, the warehouse layer at least comprises a single-table newly-added code package, a single-table deleted code package, a single-table modified code package, a DAO layer supporting component, a code generating component, a data access layer component, a logic generating component, a logic registry component, a dynamic query statement constructing component and a single-table querier constructing component.
Further, the database query device further includes:
the receiving unit is used for receiving the newly added target list table of the database;
the generation unit is used for generating a single-table processing code corresponding to the target single table through the code generation component;
and the configuration unit is used for configuring the single-table processing code into the warehouse layer.
Further, the single form processing code includes a target single form new code packet, a target single form deleting code packet, a target single form modifying code packet and a target single form query device, wherein the target single form new code packet is used for performing new processing on the target single form, the target single form deleting code packet is used for performing deleting processing on the target single form, the target single form modifying code packet is used for performing modifying processing on the target single form, and the target single form query device is used for performing data query processing on the target single form.
A third aspect of the embodiments of the present application provides an electronic device, including a memory and a processor, where the memory is configured to store a computer program, and the processor is configured to execute the computer program to cause the electronic device to perform the database query method according to any one of the first aspect of the embodiments of the present application.
A fourth aspect of the embodiments of the present application provides a computer readable storage medium storing computer program instructions which, when read and executed by a processor, perform a database query method according to any one of the first aspect of the embodiments of the present application.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the embodiments of the present application will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and should not be considered as limiting the scope, and other related drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 is a flow chart of a database query method provided in an embodiment of the present application;
FIG. 2 is a flowchart of another database query method according to an embodiment of the present application;
fig. 3 is a schematic structural diagram of a database query device according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of another database query device according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of a warehouse layer class design according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be described below with reference to the drawings in the embodiments of the present application.
It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further definition or explanation thereof is necessary in the following figures. Meanwhile, in the description of the present application, the terms "first", "second", and the like are used only to distinguish the description, and are not to be construed as indicating or implying relative importance.
Example 1
Referring to fig. 1, fig. 1 is a flowchart of a database query method according to the present embodiment. The database query method comprises the following steps:
s101, constructing a storage layer of a database.
In this embodiment, the repository layer at least includes a single-table add code package, a single-table delete code package, a single-table modify code package, a DAO layer support component, a code generation component, a data access layer component, a logic generation component, a logic registry component, a dynamic query statement construction component, and a single-table querier construction component.
S102, obtaining the identification to be queried.
S103, acquiring a target querier corresponding to the identification to be queried from the warehouse layer.
S104, transmitting the identification to be queried into a target querier for data query, and obtaining a data query result.
In this embodiment, the execution subject of the method may be a computing device such as a computer or a server, which is not limited in this embodiment.
In this embodiment, the execution body of the method may be an intelligent device such as a smart phone or a tablet computer, which is not limited in this embodiment.
Therefore, by implementing the database query method described in the embodiment, the single-table query can be realized quickly, query sentences do not need to be written, and the query process is simple, so that the single-table query efficiency is improved.
Example 2
Referring to fig. 2, fig. 2 is a flowchart of a database query method according to the present embodiment. The database query method comprises the following steps:
s201, constructing a storage layer of a database.
In this embodiment, the repository layer at least includes a single-table add code package, a single-table delete code package, a single-table modify code package, a DAO layer support component, a code generation component, a data access layer component, a logic generation component, a logic registry component, a dynamic query statement construction component, and a single-table querier construction component.
S202, obtaining the identification to be queried.
S203, determining a data transmission object according to the identification to be queried.
S204, acquiring a target inquirer from the warehouse layer according to the transmission object.
S205, transmitting the identification to be queried into a target querier for data query, and obtaining a data query result.
S206, receiving a newly added target list table of the database.
S207, generating a list processing code corresponding to the target list through a code generation component.
In this embodiment, the list processing code includes a target list new code packet, a target list deleting code packet, a target list modifying code packet, and a target list querier, where the target list new code packet is used for performing new processing on the target list, the target list deleting code packet is used for performing deleting processing on the target list, the target list modifying code packet is used for performing modifying processing on the target list, and the target list querier is used for performing data query processing on the target list.
S208, configuring the single-table processing code into the warehouse layer.
In this embodiment, the method aims to solve the problem of limitation of database query at present. Specifically, the method extracts the part into a general warehouse design, so that development work is reduced to a certain extent, and a developer can focus on service code development more.
In the embodiment, the design of the database storage layer mainly depends on Mybatis+Mybatis Plus, and secondary packaging development is completed on the database storage layer; the original development work is simplified, after the tool is used, no meaningless code development is needed to be carried out on the single table, and the code examples are as follows:
FormCounterPartyDTO formCounterPartyDTO=
Repository.of(FormCounterPartyDTO.class).getById(id).get();
according to the code, the database is expected to be queried according to the ID, and the corresponding query device is only required to be acquired from the warehouse layer according to the DTO, and then the ID is transmitted in to return the corresponding result.
In this embodiment MyBatis is an excellent persistence layer framework that supports custom SQL, stored procedures, and advanced mapping. MyBatis avoids almost all JDBC codes and manually set parameters and get result sets. MyBatis can use simple XML or annotations to configure and map native information, map interfaces and Java POJOs (Plain Ordinary Java Object, common Java objects) to records in a database.
In this embodiment, because Mybatis requires writing an XML configuration file, SQL statements need to be written in XML to access the database, and all operations need to be done in XML. And for a CRUD of a single table, it is also necessary to use an XML file to do so. This increases the requirements for the developer, which requires special familiarity with the SQL language to accomplish.
In this embodiment, myBatis-Plus (MP for short) is an enhancement tool based on MyBatis that enhances the basic functions of MyBatis without any changes. The method has the advantages that a developer can directly upgrade the Mybatis development project to Mybatis-plus, and just like the positioning of the developer on the developer, the method can help to further simplify the development process and improve the development efficiency.
In this embodiment, mybatis-Plus can be regarded as a package of Mybatis again, after upgrading, calling the API provided by Mybatis-Plus for CRUD operation of a single table can be easily implemented, and various query modes, paging and other actions are provided. The developer does not need to write XML, so that the development difficulty is greatly reduced.
In this embodiment, a Data Transfer Object (DTO) (Data Transfer Object) is a software application system that transfers data between design modes. The data transfer objective is often for the data access object to retrieve data from a database.
In this embodiment, the warehouse tier class design may be as shown in fig. 5.
In this embodiment, the repositisource is used as an external unique implementation, and provides common single-table adding, deleting, modifying and checking functions, the specific functions of which depend on each Provider, and entrust to execute actual function logic; and rely on the reportosis factor to generate the corresponding reportosis for each list table, which then delegates Persistence to generate various specific logic for database operations.
In this embodiment, the repositive is a data access layer repositive code.
In this embodiment, provider is a data Provider.
In this embodiment, repositor is a code generation component.
In this embodiment, persistence is a mechanism by which program data transitions between a persistent state and an transient state as a Persistence logic generation component. Specifically, persistence (Persistence), i.e., saving data (e.g., objects in memory) to a permanently-storable storage device (e.g., disk). The primary application of persistence is to store objects in memory in a database, or in a disk file, an XML data file, etc.
In this embodiment, the execution subject of the method may be a computing device such as a computer or a server, which is not limited in this embodiment.
In this embodiment, the execution body of the method may be an intelligent device such as a smart phone or a tablet computer, which is not limited in this embodiment.
Therefore, by implementing the database query method described in the embodiment, the single-table query can be realized quickly, query sentences do not need to be written, and the query process is simple, so that the single-table query efficiency is improved.
Example 3
Referring to fig. 3, fig. 3 is a schematic structural diagram of a database query device according to the present embodiment. As shown in fig. 3, the database query apparatus includes:
a construction unit 310, configured to construct a warehouse layer of the database;
a first obtaining unit 320, configured to obtain an identifier to be queried;
a second obtaining unit 330, configured to obtain, from the warehouse layer, a target querier corresponding to the identifier to be queried;
and the query unit 340 is configured to transmit the identifier to be queried to the target querier for data query, so as to obtain a data query result.
In this embodiment, the explanation of the database query apparatus may refer to the description in embodiment 1 or embodiment 2, and the description is not repeated in this embodiment.
Therefore, the database query device described in the embodiment can quickly realize single-table query without writing query sentences, and the query process is simple, so that the single-table query efficiency is improved.
Example 4
Referring to fig. 4, fig. 4 is a schematic structural diagram of a database query device according to the present embodiment. As shown in fig. 4, the database query apparatus includes:
a construction unit 310, configured to construct a warehouse layer of the database;
a first obtaining unit 320, configured to obtain an identifier to be queried;
a second obtaining unit 330, configured to obtain, from the warehouse layer, a target querier corresponding to the identifier to be queried;
and the query unit 340 is configured to transmit the identifier to be queried to the target querier for data query, so as to obtain a data query result.
As an alternative embodiment, the second acquisition unit 330 includes:
a determining subunit 331, configured to determine a data transmission object according to the identifier to be queried;
the obtaining subunit 332 is configured to obtain the target querier from the warehouse layer according to the transmission object.
In this embodiment, the repository layer at least includes a single-table add code package, a single-table delete code package, a single-table modify code package, a DAO layer support component, a code generation component, a data access layer component, a logic generation component, a logic registry component, a dynamic query statement construction component, and a single-table querier construction component.
As an alternative embodiment, the database query apparatus further includes:
a receiving unit 350, configured to receive a target list table newly added in the database;
a generating unit 360, configured to generate, by using a code generating component, a list processing code corresponding to the target list;
a configuration unit 370, configured to configure the single table processing code into the warehouse layer.
In this embodiment, the list processing code includes a target list new code packet, a target list deleting code packet, a target list modifying code packet, and a target list querier, where the target list new code packet is used for performing new processing on the target list, the target list deleting code packet is used for performing deleting processing on the target list, the target list modifying code packet is used for performing modifying processing on the target list, and the target list querier is used for performing data query processing on the target list.
In this embodiment, the explanation of the database query apparatus may refer to the description in embodiment 1 or embodiment 2, and the description is not repeated in this embodiment.
Therefore, the database query device described in the embodiment can quickly realize single-table query without writing query sentences, and the query process is simple, so that the single-table query efficiency is improved.
An embodiment of the present application provides an electronic device, including a memory and a processor, where the memory is configured to store a computer program, and the processor is configured to execute the computer program to cause the electronic device to execute a database query method in embodiment 1 or embodiment 2 of the present application.
The present embodiment provides a computer readable storage medium storing computer program instructions that, when read and executed by a processor, perform the database query method of embodiment 1 or embodiment 2 of the present application.
In the several embodiments provided in this application, it should be understood that the disclosed apparatus and method may be implemented in other manners as well. The apparatus embodiments described above are merely illustrative, for example, flow diagrams and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present application. 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 and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In addition, the functional modules in the embodiments of the present application may be integrated together to form a single part, or each module may exist alone, or two or more modules may be integrated to form a single part.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing is merely exemplary embodiments of the present application and is not intended to limit the scope of the present application, and various modifications and variations may be suggested to one skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principles of the present application should be included in the protection scope of the present application. It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further definition or explanation thereof is necessary in the following figures.
The foregoing is merely specific embodiments of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily think about changes or substitutions within the technical scope of the present application, and the changes and substitutions are intended to be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
It is noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
Claims (10)
1. A database query method, comprising:
constructing a storage layer of a database;
acquiring an identification to be queried;
acquiring a target inquirer corresponding to the identification to be inquired from the storage layer;
and transmitting the identification to be queried into the target querier to perform data query, and obtaining a data query result.
2. The database query method according to claim 1, wherein the obtaining, from the warehouse layer, the target querier corresponding to the to-be-queried identifier includes:
determining a data transmission object according to the identification to be queried;
and acquiring a target inquirer from the warehouse layer according to the transmission object.
3. The database query method of claim 1, wherein the repository layer comprises at least a single table add code package, a single table delete code package, a single table modify code package, a DAO layer support component, a code generation component, a data access layer component, a logic generation component, a logic registry component, a dynamic query statement construction component, and a single table querier construction component.
4. A database query method as claimed in claim 3, wherein the method further comprises:
receiving a newly added target list table of a database;
generating a single form processing code corresponding to the target single form through the code generation component;
and configuring the single-table processing code into the warehouse layer.
5. The database query method of claim 4, wherein the list processing code includes a target list adding code package, a target list deleting code package, a target list modifying code package, and a target list querier, the target list adding code package being used for adding the target list, the target list deleting code package being used for deleting the target list, the target list modifying code package being used for modifying the target list, and the target list querier being used for querying the target list.
6. A database query apparatus, the database query apparatus comprising:
the construction unit is used for constructing a storage layer of the database;
the first acquisition unit is used for acquiring the identification to be queried;
the second acquisition unit is used for acquiring a target inquirer corresponding to the identification to be inquired from the storage layer;
and the query unit is used for transmitting the identification to be queried into the target querier to perform data query, and obtaining a data query result.
7. The database query apparatus of claim 6, wherein the second acquisition unit comprises:
a determining subunit, configured to determine a data transmission object according to the identifier to be queried;
and the acquisition subunit is used for acquiring the target inquirer from the warehouse layer according to the transmission object.
8. The database query apparatus of claim 6, wherein the warehouse tier comprises at least a single table add code package, a single table delete code package, a single table modify code package, a DAO tier support component, a code generation component, a data access tier component, a logic generation component, a logic registry component, a dynamic query statement construction component, and a single table querier construction component.
9. An electronic device comprising a memory for storing a computer program and a processor that runs the computer program to cause the electronic device to perform the database query method of any one of claims 1 to 5.
10. A readable storage medium having stored therein computer program instructions which, when read and executed by a processor, perform the database query method of any of claims 1 to 5.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202310315640.0A CN116467334A (en) | 2023-03-28 | 2023-03-28 | Database query method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202310315640.0A CN116467334A (en) | 2023-03-28 | 2023-03-28 | Database query method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN116467334A true CN116467334A (en) | 2023-07-21 |
Family
ID=87174396
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202310315640.0A Pending CN116467334A (en) | 2023-03-28 | 2023-03-28 | Database query method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN116467334A (en) |
-
2023
- 2023-03-28 CN CN202310315640.0A patent/CN116467334A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107480198B (en) | Distributed NewSQL database system and full-text retrieval method | |
US6240422B1 (en) | Object to relational database mapping infrastructure in a customer care and billing system | |
CN109933571B (en) | Database design document generation method, device and computer readable storage medium | |
US6338069B1 (en) | Method and apparatus for managing functions | |
US20100049692A1 (en) | Apparatus and Method For Retrieving Information From An Application Functionality Table | |
US10210203B2 (en) | Query translation for searching complex structures of objects | |
US8572110B2 (en) | Textual search for numerical properties | |
CN110019111B (en) | Data processing method, data processing device, storage medium and processor | |
CN111797073A (en) | Database management method, electronic device, and computer-readable storage medium | |
CN104423982A (en) | Request processing method and device | |
CN112637305A (en) | Data storage and query method, device, equipment and medium based on cache | |
CN112860802B (en) | Database operation statement processing method and device and electronic equipment | |
CN107609870B (en) | Multi-application key management method and system for POS (point of sale) and POS terminal | |
US20080082535A1 (en) | Method and system for automatically generating a communication interface | |
CN116048478B (en) | Dictionary escape method, device, equipment and computer readable storage medium | |
CN112835638A (en) | Configuration information management method and device based on embedded application program | |
CN112434037A (en) | Data processing method, processing device, data processing apparatus, and storage medium | |
CN116467334A (en) | Database query method and device | |
CN116049193A (en) | Data storage method and device | |
CN113779068B (en) | Data query method, device, equipment and storage medium | |
CN105653277A (en) | Method for querying appointed field data of data table under simplified JAVA program, multi-table conjunctive query method under simplified JAVA program and statistical query method under simplified JAVA program | |
CN115310127A (en) | Data desensitization method and device | |
CN115617773A (en) | Data migration method, device and system | |
CN108228604B (en) | Model construction method based on memory object, information query method and device | |
CN111125229B (en) | Data blood edge generation method and device and electronic equipment |
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 |