mybatis study notes. Dynamic SQL, if, where, set, choose (when, otherwise), Foreach, SQL fragment explanation.
Dynamic SQL
Official documents:
https://mybatis.net.cn/dynamic-sql.html
What is dynamic SQL: dynamic SQL refers to generating different SQL statements according to different query conditions.
The SQL statements we wrote before are relatively simple. If there are complex businesses, we need to write complex SQL statements, which often ne ...
Posted by squariegoes on Wed, 02 Feb 2022 17:53:06 +0100
Crazy liver strongest Java EE framework high-intensity learning
SpringBean container: Beans are java objects. The container is responsible for the management of the whole life cycle of java objects, including creation, modification and destruction
IOC control reversal IOC: it's an idea IOC container: the implementation container of IOC thought
DI One of the ways to implement IOC, dependency injection, is ...
Posted by Stalingrad on Tue, 01 Feb 2022 20:09:21 +0100
Easy to understand -- Mybaties entry code is a must for farmers to avoid pits
Mybatis actual combat
Tip: you can add the directories of all articles in the series here. You need to add the directories manually For example: the first chapter is the use of pandas, an introduction to Python machine learning
Tip: after writing the article, the directory can be generated automatically. For how to generate it, please refer ...
Posted by crazylegseddie on Tue, 01 Feb 2022 08:56:17 +0100
Hard core! Alibaba P8 takes you to experience the smoother MyBatis. Please watch the paid resources in a low profile
The last one was "Spring Boot - custom Banner pattern", and this one is "smoother MyBatis".
MyBatis's strength comes from its vast ecology and the support of many large domestic factories.
- the plass are gone
From iBatis to MyBatis, and then to many peripheral tools typically represented by MyBatis Plus in domestic tea ...
Posted by Jack_Slocum on Tue, 01 Feb 2022 04:56:59 +0100
Spring learning -- Spring Bean management
Spring Bean management
xml based configuration mode
bean configuration requires spring managed classes id generated object name Class full class name name object alias, which can be multiple scope: Singleton (default): there is only one bean instance in Spring, singleton mode Prototype: when the prototype getBean(), new Bean() Request: each h ...
Posted by tsabar on Mon, 31 Jan 2022 16:59:36 +0100
[graduation project] design and implementation of SSM second-hand trading website based on jsp+mysql+Spring+mybatis
You know how to go to the town building map first
1, Introduction 2
1.1 research background 2
1.2 research purpose and Significance 2
1.3 research contents 3
1.4 feasibility study design 3
1.5 social feasibility 4
1.6 relevant technical description 4
spring 4
Spring 5
jQuery 5
Mysql 6
1) Powerful 6
2) Support cross platform 6
3) ...
Posted by wiseone on Sun, 30 Jan 2022 08:55:27 +0100
MyBatis mapping file
1, SQL label of mapping file
There are 9 top-level sql tags in the remapping file:
SQL splicing and operation: select, delete, update, insert, sql (include)
Cache: cache, cache ref
Parameter mapping: parameterMap (this label has been abolished. For parameter mapping, in-line parameter mapping can be used)
Solution map: resultMap
1. OGN ...
Posted by mindrage00 on Sat, 29 Jan 2022 23:05:13 +0100
Mybatis read write separation
Introduction to off the shelf tools
MyCat
Active and good performance open source database middleware. It is a transparent database agent, which needs to ensure the high availability of services in the production environment.
ShardingSphere
ShardingSphere is composed of JDBC, Proxy and Sidecar (under planning), which can be deployed indepen ...
Posted by zoffi on Sat, 29 Jan 2022 14:22:46 +0100
Common interview questions of Mybatis in SSM framework series
19.
19. One to one and one to many association queries?
<mapper namespace="com.lcb.mapping.userMapper">
<!--association One to one association query -->
<select id="getClass" parameterType="int" resultMap="ClassesResultMap">
select * from class c,teacher t where c.teacher_id=t.t_id ...
Posted by bertfour on Sat, 29 Jan 2022 01:03:13 +0100
Basic summary of spring IOC
Article catalogue
catalogue
Article catalogue
1, What is Spring
2, Advantages of Spring framework
3, Detailed explanation of spring IOC mechanism
IOC role summary
Detailed explanation of spring IOC mechanism
1, First build maven project and add dependencies
2, Create persistence layer and implementation class
3 ...
Posted by Graxeon on Fri, 28 Jan 2022 16:25:03 +0100