MybatisPlus学习（四）条件构造器Wrapper方法详解

小灰灰 2023-01-22 06:59 57阅读 0赞

[https://www.cnblogs.com/xianz666/p/13857733.html][https_www.cnblogs.com_xianz666_p_13857733.html]

# [MybatisPlus学习（四）条件构造器Wrapper方法详解][https_www.cnblogs.com_xianz666_p_13857733.html] #

### 文章目录 ###

*   *  [1、条件构造器][1]
     *  [2、QueryWrapper][2_QueryWrapper]
     *   *  [2.1、eq、ne][2.1_eq_ne]
         *  [2.2、gt、ge、lt、le][2.2_gt_ge_lt_le]
         *  [2.3、between、notBetween][2.3_between_notBetween]
         *  [2.4、like、notLike、likeLeft、likeRight][2.4_like_notLike_likeLeft_likeRight]
         *  [2.4、isNull、isNotNull][2.4_isNull_isNotNull]
         *  [2.5、in、notIn][2.5_in_notIn]
         *  [2.5、inSql、notInSql][2.5_inSql_notInSql]
         *  [2.6、or、and][2.6_or_and]
         *  [2.6、exists、notExists][2.6_exists_notExists]
         *  [2.7、orderByAsc、orderByDesc][2.7_orderByAsc_orderByDesc]

> [环境搭建请看该链接的MybatisPlus模块][MybatisPlus]

--------------------

## 1、条件构造器 ##

说明:

*  以下出现的第一个入参boolean condition表示该条件是否加入最后生成的sql中
 *  以下代码块内的多个方法均为从上往下补全个别boolean类型的入参,默认为true
 *  以下出现的泛型Param均为Wrapper的子类实例(均具有AbstractWrapper的所有方法)
 *  以下方法在入参中出现的R为泛型,在普通wrapper中是String,在LambdaWrapper中是函数(例:Entity::getId,Entity为实体类,getId为字段id的getMethod)
 *  以下方法入参中的R column均表示数据库字段,当R具体类型为String时则为数据库字段名(字段名是数据库关键字的自己用转义符包裹!)!而不是实体类数据字段名!!!,另当R具体类型为SFunction时项目runtime不支持eclipse自家的编译器!!!
 *  以下举例均为使用普通wrapper,入参为Map和List的均以json形式表现!
 *  使用中如果入参的Map或者List为空,则不会加入最后生成的sql中!!!

--------------------

## 2、QueryWrapper ##

> 说明:  
>   
>       继承自 AbstractWrapper ,自身的内部属性 entity 也用于生成 where 条件  
> 及 LambdaQueryWrapper, 可以通过 new QueryWrapper().lambda() 方法获取

给之后测试提供参考  
![在这里插入图片描述][20200825112351602.png]

> 注意：7号数据已经被逻辑删除了

--------------------

### 2.1、eq、ne ###

> eq：等于，ne：不等于

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][20200825105850822.png]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][20200825110404928.png]

--------------------

### 2.2、gt、ge、lt、le ###

> gt：大于，ge：大于等于，lt：小于，le：小于等于

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 2]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 3]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 4]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 5]

--------------------

### 2.3、between、notBetween ###

> between：在值1和值2之间，notBetween：不在值1和值2之间

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 6]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 7]

--------------------

### 2.4、like、notLike、likeLeft、likeRight ###

> like：’%值%’，notLike：’%值%’，likeLeft：’%值’，likeRight：'值%'

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 8]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 9]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 10]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 11]

--------------------

### 2.4、isNull、isNotNull ###

> isNull：字段 IS NULL，isNotNull：字段 IS NOT NULL

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 12]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 13]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70_pic_center]

--------------------

### 2.5、in、notIn ###

> in：字段 IN (v0, v1, …)，notIn：字段 NOT IN (value.get(0), value.get(1), …)

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 14]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 15]

--------------------

### 2.5、inSql、notInSql ###

> inSql：字段 IN ( sql语句 )，notInSql：字段 NOT IN ( sql语句 )

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 16]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 17]

--------------------

### 2.6、or、and ###

> or：拼接 OR，AND 嵌套

> 注意事项:  
> 主动调用or表示紧接着下一个方法不是用and连接!(不调用or则默认为使用and连接)

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 18]

![在这里插入图片描述][20200825122512925.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 19]  
![在这里插入图片描述][20200825123501643.png]

> 不使用and默认就是and连接

--------------------

### 2.6、exists、notExists ###

> exists：拼接 EXISTS ( sql语句 )，notExists：拼接 NOT EXISTS ( sql语句 )

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 20]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 21]

--------------------

### 2.7、orderByAsc、orderByDesc ###

> orderByAsc：排序：ORDER BY 字段, … ASC，orderByDesc：排序：ORDER BY 字段, … DESC

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 22]  
![在这里插入图片描述][20200825124344523.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 23]  
![在这里插入图片描述][20200825124421772.png]

分类: [java学习笔记][java]

[https_www.cnblogs.com_xianz666_p_13857733.html]: https://www.cnblogs.com/xianz666/p/13857733.html
[1]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108216957#1_5
[2_QueryWrapper]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108216957#2QueryWrapper_17
[2.1_eq_ne]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108216957#21eqne_29
[2.2_gt_ge_lt_le]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108216957#22gtgeltle_38
[2.3_between_notBetween]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108216957#23betweennotBetween_52
[2.4_like_notLike_likeLeft_likeRight]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108216957#24likenotLikelikeLeftlikeRight_58
[2.4_isNull_isNotNull]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108216957#24isNullisNotNull_66
[2.5_in_notIn]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108216957#25innotIn_74
[2.5_inSql_notInSql]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108216957#25inSqlnotInSql_80
[2.6_or_and]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108216957#26orand_87
[2.6_exists_notExists]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108216957#26existsnotExists_100
[2.7_orderByAsc_orderByDesc]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108216957#27orderByAscorderByDesc_107
[MybatisPlus]: https://blog.csdn.net/llllllkkkkkooooo/article/details/108130682
[20200825112351602.png]: /images/20221020/426f4278e37a4f82bf3afdf938d9aefe.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70]: /images/20221020/7f2ed32611aa4d3b9c482474aaea15a8.png
[20200825105850822.png]: /images/20221020/2ee677912c784b4b96eebb324b1a5737.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 1]: /images/20221020/3a3cb837f70f4deb9a545481d3f796c3.png
[20200825110404928.png]: /images/20221020/abdffd63ca084742bc01a613298620e0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 2]: /images/20221020/ace3cab2897f4041b86ca42224481d71.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 3]: /images/20221020/a1c71b1eab17431d92c6a90e14788108.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 4]: /images/20221020/4236cf7b73174c76927a59ac61275690.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 5]: /images/20221020/09bfa669238c49b4baea29f5f9557a46.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 6]: /images/20221020/eddb58e6cd084d0eb02ad94f129d1afb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 7]: /images/20221020/d1d24544d5db4850a8c9c117061e0b63.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 8]: /images/20221020/eb820f1d1dd74afebe751a20831bd99d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 9]: /images/20221020/e789bbb9c9504f4cbccc3dd98d8a256d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 10]: /images/20221020/c286e2ff2a0f4f4188e568748605a862.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 11]: /images/20221020/418aa8cd82254bc99aceea6573a53006.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 12]: /images/20221020/02c6fc84485f4d9199c70d945ecd130f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 13]: /images/20221020/ba6603164e2445638a81e55a16814877.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70_pic_center]: /images/20221020/3cbe57203f504f6eb8de8cd2a39f0b61.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 14]: /images/20221020/4a510c75bc574b3ebbf3740bcdd9bc3c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 15]: /images/20221020/20591882a4e947f0ab2b33991e96a231.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 16]: /images/20221020/5d3141d0ebb941eaa079e234cfbe2ff4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 17]: /images/20221020/9066a42b941449f18e2e008fb6848c04.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 18]: /images/20221020/1403c677608f400aa9798ec6fe0cc21f.png
[20200825122512925.png]: /images/20221020/03565fcd3b214f7fa2cfe50201955612.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 19]: /images/20221020/40155cbdb62f4af5a85919bcdab566f2.png
[20200825123501643.png]: /images/20221020/ebb8e81dfa1a4f26a1c509db1d4873c2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 20]: /images/20221020/94335c5e25414775b7fca7bfd0ff7dbb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 21]: /images/20221020/d9bdb6d2ef91437f9f4636bec4528b6a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 22]: /images/20221020/a132b500d5c0424e8e795fd95ccf4564.png
[20200825124344523.png]: /images/20221020/6b7c43cf2f564dbeb2487ba33f50d051.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsbGxsbGtra2trb29vb28_size_16_color_FFFFFF_t_70 23]: /images/20221020/0c9836b7dd5e4b8080c07deb103eb8af.png
[20200825124421772.png]: /images/20221020/cf4c0af4559742faa7e3b50d2605135e.png
[java]: https://www.cnblogs.com/xianz666/category/1608994.html