CN110046170A - Sentence based on multifile management executes method, apparatus, equipment and medium - Google Patents
Sentence based on multifile management executes method, apparatus, equipment and medium Download PDFInfo
- Publication number
- CN110046170A CN110046170A CN201910322515.6A CN201910322515A CN110046170A CN 110046170 A CN110046170 A CN 110046170A CN 201910322515 A CN201910322515 A CN 201910322515A CN 110046170 A CN110046170 A CN 110046170A
- Authority
- CN
- China
- Prior art keywords
- mapped file
- mapper
- customized
- sql statement
- self
- 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
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
- G06F16/2455—Query 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 embodiment of the invention discloses a kind of, and the sentence based on multifile management executes method, apparatus, equipment and medium.Wherein method includes: to obtain pending SQL statement；The identical self-generating mapper mapped file of name space namespace attribute and customized mapper mapped file are integrated in logical layer, form a mapping space；Based on the mapping space, the SQL statement is executed in the database.Method provided in this embodiment uses multifile administrative mechanism, self-generating mapper mapped file is used directly as a file by other programs, user is not required to modify to it, and in customized mapper mapped file is entirely customized SQL statement, convenient for managing respectively；Moreover, self-generating mapper mapped file can be automatically updated, meanwhile, retain customized SQL and is uncovered.
Description
Technical field
The present embodiments relate to database technology more particularly to a kind of sentence based on multifile management execute method,
Device, equipment and medium.
Background technique
Mybatis is a Persistence Layer Framework, it is packaged JDBC operating database.Currently, being made pair of mybatis
When as relationship map (Object Relational Mapping, ORM) frame, mybatis included tool can be automatic
The corresponding mapper mapped file of table is generated, this mechanism makes user after carrying out DDL operation to table, can automatically update
Mapper mapped file uses easily.
But mybatis generate mapper mapped file in SQL statement be it is fixed, inevitably to be reflected in mapper
It penetrates file and manually writes some customized SQL statements later, to realize required function.So, after being operated to table
When updating mapper mapped file, the SQL statement write manually before can be override, it is inconvenient for operation.
Summary of the invention
The sentence that the embodiment of the present invention provides a kind of multifile management executes method, apparatus, equipment and medium, using more
Document form manages mapper mapped file.
In a first aspect, the embodiment of the invention provides a kind of, the sentence based on multifile management executes method, comprising:
Obtain pending SQL statement；
By the identical self-generating mapper mapped file of name space namespace attribute and customized mapper mapping text
Part is integrated in logical layer, forms a mapping space；
Based on the mapping space, the SQL statement is executed in the database.
Second aspect, the embodiment of the invention also provides a kind of sentence executive device based on multifile management, the devices
Include:
Module is obtained, for obtaining pending SQL statement；
Module is integrated, for the identical self-generating mapper mapped file of name space namespace attribute and will make by oneself
Adopted mapper mapped file is integrated in logical layer, forms a mapping space；
Execution module executes the SQL statement for being based on the mapping space in the database.
The third aspect, the embodiment of the invention also provides a kind of electronic equipment, the electronic equipment includes:
One or more processors；
Memory, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of processing
Device realizes that the sentence described in any embodiment based on multifile management executes method.
Fourth aspect, the embodiment of the invention also provides a kind of computer readable storage mediums, are stored thereon with computer
Program realizes that the sentence described in any embodiment based on multifile management executes method when the program is executed by processor.
The technical solution of the present embodiment, by mapping the identical self-generating mapper of name space namespace attribute
File and customized mapper mapped file are integrated in logical layer, form a mapping space, and empty based on the mapping
Between, the SQL statement is executed in the database, so that the fixation SQL statement and customized SQL to self-generating carry out multifile
Management, i.e., fixed SQL statement are managed in self-generating mapper mapped file, and customized SQL is in customized mapper
It is managed in mapped file, this multifile administrative mechanism allows self-generating mapper mapped file directly as one
File is used by other programs, and user is not required to modify to it, and is entirely to make by oneself in customized mapper mapped file
Adopted SQL statement effectively distinguishes fixed SQL statement and customized SQL statement, convenient for managing respectively；Moreover, subsequent file is more
When new, self-generating mapper mapped file can be automatically updated, meanwhile, retain customized SQL and is uncovered.
Detailed description of the invention
Fig. 1 is the flow chart that a kind of sentence based on multifile management that the embodiment of the present invention one provides executes method；
Fig. 2 is the flow chart that a kind of sentence based on multifile management provided by Embodiment 2 of the present invention executes method；
Fig. 3 is a kind of structural representation for sentence executive device based on multifile management that the embodiment of the present invention three provides
Figure；
Fig. 4 is the structural schematic diagram for a kind of electronic equipment that the embodiment of the present invention four provides.
Specific embodiment
The present invention is described in further detail with reference to the accompanying drawings and examples.It is understood that this place is retouched
The specific embodiment stated is used only for explaining the present invention rather than limiting the invention.It also should be noted that in order to just
Only the parts related to the present invention are shown in description, attached drawing rather than entire infrastructure.
Embodiment one
Fig. 1 is the flow chart that a kind of sentence based on multifile management that the embodiment of the present invention one provides executes method, this
Embodiment can be applied to mybatis frame, when suitable for doing ORM frame with mybatis frame, be held based on mapper mapped file
The case where row SQL statement.This method can be executed by the sentence executive device managed based on multifile, which can be by hard
Part and/or software sharing, and be typically integrated in electronic equipment.In conjunction with Fig. 1, method provided in this embodiment specifically includes following
Operation:
S110, pending SQL statement is obtained.
Mybatis is to support common SQL query, the Persistence Layer Framework of storing process and advanced mapping.Mybatis is eliminated
The manual setting and the retrieval of result set of almost all of JDBC code and parameter, using simple XML or are explained for matching
It sets and original mappings, the common Java object (Plan Old Java Objects, POJOs) of interface and Java is mapped to
Record in database.
User inputs pending SQL statement to mybatis frame, and mybatis frame maps the SQL statement got
In correspondent entity into database, to execute SQL statement by database.
S120, by the identical self-generating mapper mapped file of name space namespace attribute and customized mapper
Mapped file is integrated in logical layer, forms a mapping space.
In the present embodiment, when mybatis frame does ORM mapping framework, mybatis included tool can help life
At the corresponding domain and mapper mapped file of table.In order to facilitate describing and distinguish, this tool carried by mybatis
The mapper mapped file of generation is known as self-generating mapper mapped file.
Due to the SQL statement in self-generating mapper mapped file be it is fixed, in order to realize more flexible mapping, user
A customized mapper mapped file can be created in mybatis frame, and is written in customized mapper mapped file
Some customized SQL statements, the quantity of customized mapper mapped file are at least one.It is worth noting that customized
Mapper mapped file is established and is write by user, is not generated by the tool that mybatis is carried.Therefore, in subsequent more new mappings
When file, mechanism is automatically updated based on what mybatis carried tool, only can automatically update self-generating mapper mapped file, no
Customized mapper mapped file is automatically updated.
Name space (namespace) attribute phase of self-generating mapper mapped file and customized mapper mapped file
Together.On the one hand, the root node of mapped file is<sqlMap>, and namespace is the NameSpace of<sqlMap>, because of SQL
Map mapped file can have multiple, and all mapper mapped files are all of overall importance for SQL Map.This meaning
Mark in SQL Map can only be it is only, can be carried out mapper using the fully qualified name of namespace and mark
Differentiation between mapped file.On the other hand, in mybatis, the namespace in mapper mapped file is for binding
Dao interface, i.e. interface-oriented programming.After namespace binds interface, it can not have to write interface realization class, mybatis meeting
The correspondence SQL statement to be executed is automatically found by the binding.
In one example, self-generating mapper mapped file includes: < mapper namespace=" com.financee
rr.dao.dao.FinanceErrorDealBatchMapper">；Correspondingly, customized mapper mapped file include: <
Mapper namespace=" com.financeerr.dao.dao.FinanceErrorDealBatchMapper " >, it is seen then that
The namespace attribute that the two includes is identical.
Based on above-mentioned analysis, the above two mapper mapped file of identical namespace attribute, does not have on logical layer
Difference.Mybatis frame can map the identical two kinds of mapper of namespace attribute by searching for namespace attribute
File is integrated in logical layer, forms a mapping space.It is, during executing SQL statement, by two kinds
Mapper mapped file regards a file as to call the SQL statement in same Dao interface, logically shares everything.
In specific implementation, mapped file is to need customized mapper mapping text using<mapper>as root node
Part and self-generating mapper mapped file are added under<mappers>element arrangements.
S130, it is based on the mapping space, executes the SQL statement in the database.
Specifically, the SQL of operating database is defined in mapping space, each SQL is a statement.Based on reflecting
It penetrates space to map pending SQL statement, to call the correlation method in Dao interface, in the database according to calling
Method execute SQL statement.
Further, after S130 further include: the self-generating mapper mapped file is automatically updated, not to making by oneself
Adopted mapper mapped file is automatically updated.
Optionally, SQL statement is database schema definitional language (Data Definition Language, DDL), such as
Create database, creation database table, modification database table, deletion database table etc..DDL sentence may make data
Field in library changes, it is necessary to after executing DDL sentence, update the related words in self-generating mapper mapped file
Section；However, SQL statement in customized mapper mapped file is without updating, to retain the original SQL language that user writes
Sentence.
In the embodiment of the present invention, by by the identical self-generating mapper mapped file of name space namespace attribute
It is integrated with customized mapper mapped file in logical layer, forms a mapping space, and be based on the mapping space,
The SQL statement is executed in database, so that the fixation SQL statement and customized SQL to self-generating carry out multifile management,
I.e. fixed SQL statement is managed in self-generating mapper mapped file, and customized SQL maps text in customized mapper
It is managed in part, this multifile administrative mechanism allows self-generating mapper mapped file directly as a file quilt
Other programs are used, and user is not required to modify to it, and in customized mapper mapped file are entirely customized SQL language
Sentence effectively distinguishes fixed SQL statement and customized SQL statement, convenient for managing respectively；Moreover, when subsequent file updates, from
Generating mapper mapped file can be automatically updated, meanwhile, retain customized SQL and is uncovered.
Embodiment two
Fig. 2 is the flow chart that a kind of sentence based on multifile management provided by Embodiment 2 of the present invention executes method.This
Embodiment is defined the integration process of self-generating mapper mapped file and customized mapper mapped file.Specifically,
Method provided in this embodiment includes following operation:
S210, pending SQL statement is obtained.
S220, the corresponding name space namespace attribute of mybatis frame is searched.
Specifically, by fully-qualified name or short name, namespace attribute is searched.
In an optional embodiment, mybatis frame fusion spring frame.Wherein, spring is a lightweight
Control reversion (IoC) and the container frame towards section (AOP) realize dynamic proxy based on spring frame, and then by dynamic
The corresponding name space namespace attribute of state proxy lookups mybatis frame, and namespace attribute is transferred to
Mybatis frame.Then, mybatis frame continues to execute S230 and S240.
Specifically, Mapper interface is write in advance, and (being equivalent to Dao interface) realizes class, spring without writing dao
Frame defines the dynamic proxy object of creation Mapper interface according to Mapper interface, and the method body of agent object is the same as Dao interface
Realize class method；And then by dynamic proxy object, the corresponding name space namespace attribute of mybatis frame is searched.It is real
Existing Mapper interface needs meet condition: in self-generating mapper mapped file and customized mapper mapped file
Namespace is identical as the class.path of Mapper interface.Mapper interface method name is with self-generating mapper mapped file and certainly
The id difference for defining each statement defined in mapper mapped file is identical.The input parameter of Mapper interface method
Each SQL's defined in type and self-generating mapper mapped file and customized mapper mapped file
The type difference of parameterType is identical.Output parameter type and self-generating mapper the mapping text of Mapper interface method
The type difference of the resultType of each SQL defined in part and customized mapper mapped file is identical.
The namepace attribute that S230, basis are found, by the self-generating mapper mapped file of physical layer isolation and certainly
It defines mapper mapped file to be integrated in logical layer, forms a mapping space.
S240, it is based on the mapping space, executes the SQL statement in the database.
In the present embodiment, the corresponding name space of mybatis frame is searched by using the mode of dynamic proxy
Namespace attribute, without writing realization class, simplifies operation to only need to write interface；Moreover, being looked by dynamic proxy
Looking for process not will receive the influence of mapper mapped file, and Agent logic and service logic are independent mutually, does not influence respectively, does not invade
Enter, does not couple.
Embodiment three
Fig. 3 is a kind of structural representation for sentence executive device based on multifile management that the embodiment of the present invention three provides
Figure, as shown in Figure 3, comprising: obtain module 31, integrate module 32 and execution module 33.
Module 31 is obtained, for obtaining pending SQL statement；
Module 32 is integrated, for by the identical self-generating mapper mapped file of name space namespace attribute and certainly
It defines mapper mapped file to be integrated in logical layer, forms a mapping space；
Execution module 33 executes the SQL statement for being based on the mapping space in the database.
In the embodiment of the present invention, by by the identical self-generating mapper mapped file of name space namespace attribute
It is integrated with customized mapper mapped file in logical layer, forms a mapping space, and be based on the mapping space,
The SQL statement is executed in database, so that the fixation SQL statement and customized SQL to self-generating carry out multifile management,
I.e. fixed SQL statement is managed in self-generating mapper mapped file, and customized SQL maps text in customized mapper
It is managed in part, this multifile administrative mechanism allows self-generating mapper mapped file directly as a file quilt
Other programs are used, and user is not required to modify to it, and in customized mapper mapped file are entirely customized SQL language
Sentence effectively distinguishes fixed SQL statement and customized SQL statement, convenient for managing respectively；Moreover, when subsequent file updates, from
Generating mapper mapped file can be automatically updated, meanwhile, retain customized SQL and is uncovered.
Optionally, which further includes automatically updating module, for being based on the mapping space, is executed in the database
After the SQL statement, automatically update the self-generating mapper mapped file, not to customized mapper mapped file into
Row automatically updates.
Optionally, SQL statement is database schema definitional language DDL.
Optionally, module 32 is integrated by the identical self-generating mapper mapped file of name space namespace attribute
It is integrated with customized mapper mapped file in logical layer, when forming a mapping space, is specifically used for: being searched
The corresponding name space namespace attribute of mybatis frame；According to the namepace attribute found, physical layer is isolated
Self-generating mapper mapped file and customized mapper mapped file integrated in logical layer, it is empty to form mapping
Between.
Optionally, mybatis frame fusion spring frame.It integrates module 32 and is searching the corresponding name of mybatis frame
When word space namespace attribute, be specifically used for: it is corresponding to search mybatis frame by the dynamic proxy of spring frame
Name space namespace attribute, and namespace attribute is transferred to mybatis frame.
Optionally, it integrates module 32 and searches the corresponding name of mybatis frame in the dynamic proxy by spring frame
When the namespace attribute of space, it is specifically used for: creation Mapper interface is defined according to Mapper interface by spring frame
Dynamic proxy object；By dynamic proxy object, the corresponding name space namespace attribute of mybatis frame is searched.
Sentence executive device provided in this embodiment based on multifile management can execute any of the above-described embodiment and provide
Sentence based on multifile management execute method, and have the corresponding technical effect of correlation method.
Example IV
Fig. 4 is the structural schematic diagram for a kind of electronic equipment that the embodiment of the present invention four provides, as shown in figure 4, the electronics is set
Standby includes processor 40, memory 41；The quantity of processor 40 can be one or more in server, at one in Fig. 4
For reason device 40；Processor 40, memory 41 in server can be connected by bus or other modes, to pass through in Fig. 4
For bus connection.
Memory 41 is used as a kind of computer readable storage medium, can be used for storing software program, journey can be performed in computer
Sequence and module, as the sentence based on multifile management in the embodiment of the present invention executes the corresponding program instruction/module of method
(for example, acquisition module 31 in the sentence executive device based on multifile management, integrate module 32 and execution module 33).Processing
Software program, instruction and the module that device 40 is stored in memory 41 by operation, thereby executing the various functions of server
Using and data processing, that is, realize that above-mentioned sentence based on multifile management executes method.
Memory 41 can mainly include storing program area and storage data area, wherein storing program area can store operation system
Application program needed for system, at least one function；Storage data area, which can be stored, uses created data etc. according to terminal.This
Outside, memory 41 may include high-speed random access memory, can also include nonvolatile memory, for example, at least a magnetic
Disk storage device, flush memory device or other non-volatile solid state memory parts.In some instances, memory 41 can be further
Including the memory remotely located relative to processor 40, these remote memories can pass through network connection to server.On
The example for stating network includes but is not limited to internet, intranet, local area network, mobile radio communication and combinations thereof.
Embodiment five
The embodiment of the present invention five also provides a kind of computer readable storage medium for being stored thereon with computer program, calculates
Machine program by computer processor when being executed for executing a kind of sentence execution method based on multifile management, this method packet
It includes:
Obtain pending SQL statement；
By the identical self-generating mapper mapped file of name space namespace attribute and customized mapper mapping text
Part is integrated in logical layer, forms a mapping space；
Based on the mapping space, the SQL statement is executed in the database.
Certainly, a kind of computer-readable storage medium being stored thereon with computer program provided by the embodiment of the present invention
Matter, computer program are not limited to method operation as above, can also be performed provided by any embodiment of the invention based on more
Relevant operation in the sentence execution method of file management.
By the description above with respect to embodiment, it is apparent to those skilled in the art that, the present invention
It can be realized by software and required common hardware, naturally it is also possible to which by hardware realization, but in many cases, the former is more
Good embodiment.Based on this understanding, technical solution of the present invention substantially in other words contributes to the prior art
Part can be embodied in the form of software products, which can store in computer readable storage medium
In, floppy disk, read-only memory (Read-Only Memory, ROM), random access memory (Random such as computer
Access Memory, RAM), flash memory (FLASH), hard disk or CD etc., including some instructions are with so that a computer is set
The method that standby (can be personal computer, server or the network equipment etc.) executes each embodiment of the present invention.
It is worth noting that, included is each in the embodiment of the above-mentioned sentence executive device based on multifile management
Unit and module are only divided according to the functional logic, but are not limited to the above division, as long as can be realized corresponding
Function；In addition, the specific name of each functional unit is also only for convenience of distinguishing each other, it is not intended to restrict the invention
Protection scope.
Note that the above is only a better embodiment of the present invention and the applied technical principle.It will be appreciated by those skilled in the art that
The invention is not limited to the specific embodiments described herein, be able to carry out for a person skilled in the art it is various it is apparent variation,
It readjusts and substitutes without departing from protection scope of the present invention.Therefore, although being carried out by above embodiments to the present invention
It is described in further detail, but the present invention is not limited to the above embodiments only, without departing from the inventive concept, also
It may include more other equivalent embodiments, and the scope of the invention is determined by the scope of the appended claims.
Claims (10)
1. a kind of sentence based on multifile management executes method, which is characterized in that be applied to mybatis frame, the method
Include:
Obtain pending SQL statement；
The identical self-generating mapper mapped file of name space namespace attribute and customized mapper mapped file are existed
Logical layer is integrated, and a mapping space is formed；
Based on the mapping space, the SQL statement is executed in the database.
2. the method according to claim 1, wherein executing institute in the database being based on the mapping space
After stating SQL statement, further includes:
The self-generating mapper mapped file is automatically updated, customized mapper mapped file is not automatically updated.
3. the method according to claim 1, wherein the SQL statement is database schema definitional language DDL.
4. the method according to claim 1, wherein described that name space namespace attribute is identical certainly
It generates mapper mapped file and customized mapper mapped file is integrated in logical layer, form a mapping space, wrap
It includes:
Search the corresponding name space namespace attribute of mybatis frame；
According to the namepace attribute found, the self-generating mapper mapped file and customized mapper that physical layer is isolated
Mapped file is integrated in logical layer, forms a mapping space.
5. according to the method described in claim 4, it is characterized in that, the mybatis frame fusion spring frame；
The corresponding name space namespace attribute of the lookup mybatis frame, comprising:
The corresponding name space namespace attribute of mybatis frame is searched by the dynamic proxy of spring frame, and will
Namespace attribute is transferred to mybatis frame.
6. according to the method described in claim 5, it is characterized in that, the dynamic proxy by spring frame is searched
The corresponding name space namespace attribute of mybatis frame, comprising:
The dynamic proxy object of creation Mapper interface is defined according to Mapper interface by spring frame；
By dynamic proxy object, the corresponding name space namespace attribute of mybatis frame is searched.
7. a kind of sentence executive device based on multifile management characterized by comprising
Module is obtained, for obtaining pending SQL statement；
Module is integrated, for by the identical self-generating mapper mapped file of name space namespace attribute and customized
Mapper mapped file is integrated in logical layer, forms a mapping space；
Execution module executes the SQL statement for being based on the mapping space in the database.
8. device according to claim 7, which is characterized in that further include:
Update module, for automatically updating the self-generating mapper mapped file, not to customized mapper mapped file
It is automatically updated.
9. a kind of electronic equipment, which is characterized in that the electronic equipment includes:
One or more processors；
Memory, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of processors are real
Now the sentence as claimed in any one of claims 1 to 6 based on multifile management executes method.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is by processor
Realize that the sentence as claimed in any one of claims 1 to 6 based on multifile management executes method when execution.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910322515.6A CN110046170B (en) | 2019-04-22 | 2019-04-22 | Statement execution method, device, equipment and medium based on multi-file management |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910322515.6A CN110046170B (en) | 2019-04-22 | 2019-04-22 | Statement execution method, device, equipment and medium based on multi-file management |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110046170A true CN110046170A (en) | 2019-07-23 |
| CN110046170B CN110046170B (en) | 2021-07-27 |
Family
ID=67278298
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910322515.6A Active CN110046170B (en) | 2019-04-22 | 2019-04-22 | Statement execution method, device, equipment and medium based on multi-file management |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110046170B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110765152A (en) * | 2019-09-18 | 2020-02-07 | 平安科技（深圳）有限公司 | SQL extraction method and device, computer equipment and storage medium |
| CN111259067A (en) * | 2020-01-21 | 2020-06-09 | 褚晶晶 | Method, device and equipment for realizing DAO interface based on Spring |
| CN111797073A (en) * | 2019-11-26 | 2020-10-20 | 北京京东尚科信息技术有限公司 | Database management method, electronic device, and computer-readable storage medium |
| CN114201504A (en) * | 2021-11-15 | 2022-03-18 | 北京达佳互联信息技术有限公司 | Information acquisition method and device, electronic equipment and storage medium |
| CN114756554A (en) * | 2022-06-13 | 2022-07-15 | 中建电子商务有限责任公司 | Data query processing method based on MyBatis framework |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120047105A1 (en) * | 2010-08-17 | 2012-02-23 | Christopher Sharad Saigal | Medical care treatment decision support system |
| CN102968306A (en) * | 2012-11-29 | 2013-03-13 | 广东全通教育股份有限公司 | Method and system for automatically generating code based on data model drive |
| CN103853718A (en) * | 2012-11-28 | 2014-06-11 | 纽海信息技术（上海）有限公司 | Fragmentation database access method and database system |
| CN104484177A (en) * | 2014-12-17 | 2015-04-01 | 南京莱斯信息技术股份有限公司 | Mybatis namespace mapping method |
| CN107133083A (en) * | 2017-04-13 | 2017-09-05 | 大连理工大学 | A kind of virtual data center resource provider method based on virtualization technology |
| CN107145549A (en) * | 2017-04-27 | 2017-09-08 | 深圳智高点知识产权运营有限公司 | A kind of database caches control method and system |
| CN108021510A (en) * | 2016-10-31 | 2018-05-11 | 三星电子株式会社 | The method for operating the storage device being managed to multiple name space |
| CN108108470A (en) * | 2017-12-31 | 2018-06-01 | 浙江工业大学 | A kind of automatic extraction of elevator data service and method for packing based on REST |
| CN108416035A (en) * | 2018-03-12 | 2018-08-17 | 四川长虹电器股份有限公司 | A kind of Database Mapping file consolidation management method based on disconf |
| CN108536433A (en) * | 2018-04-16 | 2018-09-14 | 云南软捷科技有限公司 | A kind of J2EE Development Frameworks and the development approach based on the J2EE Development Frameworks |
| KR20180111744A (en) * | 2018-10-02 | 2018-10-11 | 제주대학교 산학협력단 | Web service based hybrid coaching method for career guidance |
| CN109254992A (en) * | 2018-10-12 | 2019-01-22 | 北京京东金融科技控股有限公司 | Project generation method and system, computer system and computer readable storage medium storing program for executing |
-
2019
- 2019-04-22 CN CN201910322515.6A patent/CN110046170B/en active Active
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120047105A1 (en) * | 2010-08-17 | 2012-02-23 | Christopher Sharad Saigal | Medical care treatment decision support system |
| CN103853718A (en) * | 2012-11-28 | 2014-06-11 | 纽海信息技术（上海）有限公司 | Fragmentation database access method and database system |
| CN102968306A (en) * | 2012-11-29 | 2013-03-13 | 广东全通教育股份有限公司 | Method and system for automatically generating code based on data model drive |
| CN104484177A (en) * | 2014-12-17 | 2015-04-01 | 南京莱斯信息技术股份有限公司 | Mybatis namespace mapping method |
| CN108021510A (en) * | 2016-10-31 | 2018-05-11 | 三星电子株式会社 | The method for operating the storage device being managed to multiple name space |
| CN107133083A (en) * | 2017-04-13 | 2017-09-05 | 大连理工大学 | A kind of virtual data center resource provider method based on virtualization technology |
| CN107145549A (en) * | 2017-04-27 | 2017-09-08 | 深圳智高点知识产权运营有限公司 | A kind of database caches control method and system |
| CN108108470A (en) * | 2017-12-31 | 2018-06-01 | 浙江工业大学 | A kind of automatic extraction of elevator data service and method for packing based on REST |
| CN108416035A (en) * | 2018-03-12 | 2018-08-17 | 四川长虹电器股份有限公司 | A kind of Database Mapping file consolidation management method based on disconf |
| CN108536433A (en) * | 2018-04-16 | 2018-09-14 | 云南软捷科技有限公司 | A kind of J2EE Development Frameworks and the development approach based on the J2EE Development Frameworks |
| KR20180111744A (en) * | 2018-10-02 | 2018-10-11 | 제주대학교 산학협력단 | Web service based hybrid coaching method for career guidance |
| CN109254992A (en) * | 2018-10-12 | 2019-01-22 | 北京京东金融科技控股有限公司 | Project generation method and system, computer system and computer readable storage medium storing program for executing |
Non-Patent Citations (4)
| Title |
|---|
| PGL2011: "MyBatis系列之映射文件中的ResultMaps", 《HTTPS://WWW.JIANSHU.COM/P/51F11ACFF679》 * |
| YANGTOM249: "mybatis执行自定义SQL语句", 《HTTPS://BLOG.CSDN.NET/WEIXIN_44153121/ARTICLE/DETAILS/86570938》 * |
| 周建旭的博客: "MyBatis学习笔记之resultMap", 《HTTPS://WWW.BBSMAX.COM/A/6PDD4ZMGDW/》 * |
| 莫添杰: "MyBatis自定义关系映射及实现分页查询", 《HTTPS://WWW.CNBLOGS.COM/MOTIANJIE/P/7846467.HTML》 * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110765152A (en) * | 2019-09-18 | 2020-02-07 | 平安科技（深圳）有限公司 | SQL extraction method and device, computer equipment and storage medium |
| CN110765152B (en) * | 2019-09-18 | 2023-05-30 | 平安科技（深圳）有限公司 | SQL extraction method, SQL extraction device, computer equipment and storage medium |
| CN111797073A (en) * | 2019-11-26 | 2020-10-20 | 北京京东尚科信息技术有限公司 | Database management method, electronic device, and computer-readable storage medium |
| CN111259067A (en) * | 2020-01-21 | 2020-06-09 | 褚晶晶 | Method, device and equipment for realizing DAO interface based on Spring |
| CN111259067B (en) * | 2020-01-21 | 2023-06-06 | 褚晶晶 | Method, device and equipment for realizing DAO interface based on Spring |
| CN114201504A (en) * | 2021-11-15 | 2022-03-18 | 北京达佳互联信息技术有限公司 | Information acquisition method and device, electronic equipment and storage medium |
| CN114756554A (en) * | 2022-06-13 | 2022-07-15 | 中建电子商务有限责任公司 | Data query processing method based on MyBatis framework |
| CN114756554B (en) * | 2022-06-13 | 2022-09-30 | 中建电子商务有限责任公司 | Data query processing method based on MyBatis framework |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110046170B (en) | 2021-07-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110046170A (en) | Sentence based on multifile management executes method, apparatus, equipment and medium | |
| CN110291517B (en) | Query language interoperability in graph databases | |
| US9128996B2 (en) | Uniform data model and API for representation and processing of semantic data | |
| US11599535B2 (en) | Query translation for searching complex structures of objects | |
| US7401085B2 (en) | System and method for controlling the release of updates to a database configuration | |
| US7856517B2 (en) | Data management interface with configurable plugins that determines whether to monitor for configuration data | |
| CN109845221A (en) | Access control policy for service layer is synchronous | |
| US10120886B2 (en) | Database integration of originally decoupled components | |
| CN101421726A (en) | Occasionally-connected application server | |
| CN105843867B (en) | Search method based on metadata schema and the retrieval device based on metadata schema | |
| EP2800013A1 (en) | Integration database framework | |
| CN109508339A (en) | A kind of data query method, apparatus, terminal device and storage medium | |
| CN111881223A (en) | Data management method, device, system and storage medium | |
| US20050262128A1 (en) | Apparatus and method for managing and inferencing contextual relationships | |
| CN112182045B (en) | Metadata management method and device, computer equipment and storage medium | |
| CN107145549B (en) | Database cache control method and system | |
| CN104423982A (en) | Request processing method and device | |
| CN115729951B (en) | Data query method, system, device and computer readable storage medium | |
| CN112970011B (en) | Pedigree in record query optimization | |
| CN109614084A (en) | Web program and its Quick Development Framework, development approach and relevant device | |
| US8433729B2 (en) | Method and system for automatically generating a communication interface | |
| US8407242B2 (en) | Temporal binding for semantic queries | |
| CN112698819A (en) | Method, device and storage medium for designing tree-oriented object programming program | |
| JP2003248635A (en) | Database accessing method and system in management information base of network management protocol | |
| US20140019410A1 (en) | Using Database Content for Multiple Business Data Systems Connected to One Database |
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 |