{"id":1551,"date":"2025-03-05T16:17:58","date_gmt":"2025-03-05T08:17:58","guid":{"rendered":"https:\/\/www.tqazy.com\/?p=1551"},"modified":"2025-09-30T14:50:56","modified_gmt":"2025-09-30T06:50:56","slug":"mybatisplus%ef%bc%88%e4%ba%8c%ef%bc%89%e6%a0%b8%e5%bf%83%e5%8a%9f%e8%83%bd01-%e6%9d%a1%e4%bb%b6%e6%9e%84%e9%80%a0%e5%99%a8","status":"publish","type":"post","link":"https:\/\/www.tqazy.com\/?p=1551","title":{"rendered":"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd01 \u2014 \u6761\u4ef6\u6784\u9020\u5668"},"content":{"rendered":"<blockquote>\n<p>\u89c6\u9891\u8bfe\u7a0b\u5730\u5740\uff1a<a href=\"https:\/\/www.bilibili.com\/video\/BV1S142197x7\" target=\"_black\">\u9ed1\u9a6c\u5546\u57ce\u9879\u76ee<\/a><\/p>\n<p>\u4e0a\u4e00\u8282\uff1a<a href=\"https:\/\/www.tqazy.com\/?p=1459\" target=\"_black\">MybatisPlus\uff08\u4e00\uff09\u5feb\u901f\u5165\u95e8<\/a><br \/>\n\u4e0b\u4e00\u8282\uff1a<a href=\"https:\/\/www.tqazy.com\/?p=1568\" target=\"_black\">MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd02 \u2014 \u81ea\u5b9a\u4e49SQL<\/a><br \/>\n\u672c\u8282\u5b66\u4e60MybatisPlus\uff08MP\uff09\u7684\u6838\u5fc3\u529f\u80fd \u2014 \u6761\u4ef6\u6784\u9020\u5668\uff1a<\/p>\n<ul>\n<li><code>Wrapper<\/code><\/li>\n<li><code>AbstractWrapper<\/code>\u8be6\u89e3<\/li>\n<li><code>QueryWrapper<\/code> \u4e0e <code>LambdaQueryWrapper<\/code>\uff0c\u4ee5\u53ca\u76f8\u5173\u793a\u4f8b<\/li>\n<li><code>UpdateWrapper<\/code> \u4e0e <code>LambdaUpdateWrapper<\/code>\uff0c\u4ee5\u53ca\u76f8\u5173\u793a\u4f8b<\/li>\n<\/ul>\n<\/blockquote>\n<hr>\n<p>PS\uff1a\u5728\u5f00\u59cb\u4e4b\u524d\uff0c\u672c\u7ae0\u5185\u5bb9\u672a\u5305\u542b\u5168\u90e8\u6761\u4ef6\u6784\u9020\u5668\uff0c\u8be6\u7ec6\u5185\u5bb9\u53ef\u4ee5\u67e5\u8be2<a href =\"https:\/\/baomidou.com\/\" target=\"_black\">MybatisPlus\u5b98\u7f51<\/a>\u5173\u4e8e<a href =\"https:\/\/baomidou.com\/guides\/wrapper\/\" target=\"_black\">\u6761\u4ef6\u6784\u9020\u5668<\/a>\u7684\u6587\u6863\u3002<\/p>\n<h1>\u4e00\u3001Wrapper<\/h1>\n<p>MyBatisPlus\u652f\u6301\u5404\u79cd\u590d\u6742\u7684where\u6761\u4ef6\uff0c\u53ef\u4ee5\u6ee1\u8db3\u65e5\u5e38\u5f00\u53d1\u7684\u6240\u6709\u9700\u6c42\u3002<\/p>\n<p><code>Wrapper<\/code>\uff1a\u6761\u4ef6\u6784\u9020\u5668\u3002\u7528\u4e8e\u6784\u9020\u590d\u6742SQL\u8bed\u53e5\u7684\u3002<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075258670.png'><img class=\"lazyload lazyload-style-6\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075258670.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<div style=\"height:1.5em\"><\/div>\n<h2>1.1 Wrapper\u7684\u7ee7\u627f\u5173\u7cfb<\/h2>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075300792.png'><img class=\"lazyload lazyload-style-6\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075300792.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<div style=\"height:1.5em\"><\/div>\n<h1>\u4e8c\u3001AbstractWrapper\u8be6\u89e3<\/h1>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075301570.png'><img class=\"lazyload lazyload-style-6\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075301570.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<div style=\"height:1.5em\"><\/div>\n<p>\u4ee5\u4e0b\u662f <code>AbstractWrapper<\/code> \u4e2d\u4e00\u4e9b\u5e38\u7528\u65b9\u6cd5\u7684\u4ecb\u7ecd\uff1a<\/p>\n<h2>2.1 \u5b9e\u4f53\u4fe1\u606f\u64cd\u4f5c\u65b9\u6cd5<\/h2>\n<ul>\n<li><code>getEntity(): T<\/code>\uff1a\u7528\u4e8e\u83b7\u53d6\u5f53\u524d\u6761\u4ef6\u6784\u9020\u5668\u6240\u5173\u8054\u7684\u5b9e\u4f53\u5bf9\u8c61<\/li>\n<li><code>setEntity(T): Children<\/code>\uff1a\u7528\u4e8e\u8bbe\u7f6e\u5f53\u524d\u6761\u4ef6\u6784\u9020\u5668\u6240\u5173\u8054\u7684\u5b9e\u4f53\u5bf9\u8c61<\/li>\n<li><code>getEntityClass(): Class&lt;T&gt;<\/code>\uff1a\u7528\u4e8e\u83b7\u53d6\u5f53\u524d\u6761\u4ef6\u6784\u9020\u5668\u6240\u5173\u8054\u7684\u5b9e\u4f53\u7c7b\u7684 <code>Class<\/code> \u5bf9\u8c61<\/li>\n<li><code>setEntityClass(Class&lt;T&gt;): Children<\/code>\uff1a\u7528\u4e8e\u8bbe\u7f6e\u5f53\u524d\u6761\u4ef6\u6784\u9020\u5668\u6240\u5173\u8054\u7684\u5b9e\u4f53\u7c7b\u7684 <code>Class<\/code> \u5bf9\u8c61<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h2>2.2 \u7b49\u503c\u6bd4\u8f83\u65b9\u6cd5<\/h2>\n<ul>\n<li><code>eq(boolean, R, Object):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa\u7b49\u4e8e\uff08<code>=<\/code>\uff09\u6761\u4ef6\u3002\n<ul>\n<li>\u7b2c\u4e00\u4e2a\u5e03\u5c14\u53c2\u6570\u7528\u4e8e\u63a7\u5236\u662f\u5426\u6dfb\u52a0\u8be5\u6761\u4ef6\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u4e3a\u6570\u636e\u5e93\u5b57\u6bb5\uff0c\u7b2c\u4e09\u4e2a\u53c2\u6570\u4e3a\u8981\u6bd4\u8f83\u7684\u503c\u3002<\/li>\n<\/ul>\n<\/li>\n<li><code>ne(boolean, R, Object):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa\u4e0d\u7b49\u4e8e\uff08<code>&lt;&gt;<\/code>\uff09\u6761\u4ef6\u3002\u903b\u8f91\u540c <code>eq<\/code> \u65b9\u6cd5\u3002<\/li>\n<li><code>gt(boolean, R, Object):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa\u5927\u4e8e\uff08<code>&gt;<\/code>\uff09\u6761\u4ef6\u3002\u903b\u8f91\u540c <code>eq<\/code> \u65b9\u6cd5\u3002<\/li>\n<li><code>ge(boolean, R, Object):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa\u5927\u4e8e\u7b49\u4e8e\uff08<code>&gt;=<\/code>\uff09\u6761\u4ef6\u3002\u903b\u8f91\u540c <code>eq<\/code> \u65b9\u6cd5\u3002<\/li>\n<li><code>lt(boolean, R, Object):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa\u5c0f\u4e8e\uff08<code>&lt;<\/code>\uff09\u6761\u4ef6\u3002\u903b\u8f91\u540c <code>eq<\/code> \u65b9\u6cd5\u3002<\/li>\n<li><code>le(boolean, R, Object):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa\u5c0f\u4e8e\u7b49\u4e8e\uff08<code>&lt;=<\/code>\uff09\u6761\u4ef6\u3002\u903b\u8f91\u540c <code>eq<\/code> \u65b9\u6cd5\u3002<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h2>2.3 \u591a\u6761\u4ef6\u7b49\u503c\u5339\u914d\u65b9\u6cd5<\/h2>\n<ul>\n<li><code>allEq(boolean, Map&lt;R, V&gt;, boolean): Children<\/code>\uff1a\u5f53\u7b2c\u4e00\u4e2a\u5e03\u5c14\u53c2\u6570\u4e3a <code>true<\/code> \u65f6\uff0c\u6839\u636e <code>Map<\/code> \u4e2d\u7684\u952e\u503c\u5bf9\u6784\u5efa\u591a\u4e2a\u7b49\u503c\u6761\u4ef6\uff0c\u7b2c\u4e09\u4e2a\u5e03\u5c14\u53c2\u6570\u63a7\u5236\u5bf9 <code>Map<\/code> \u4e2d\u503c\u4e3a <code>null<\/code> \u7684\u952e\u503c\u5bf9\u7684\u5904\u7406\u65b9\u5f0f\uff0c\u82e5\u4e3a <code>true<\/code> \u5219\u6784\u5efa <code>IS NULL<\/code> \u6761\u4ef6\uff0c\u5426\u5219\u5ffd\u7565\u8be5\u952e\u503c\u5bf9<\/li>\n<li><code>allEq(boolean, BiPredicate&lt;R, V&gt;, Map&lt;R, V&gt;, boolean): Children<\/code>\uff1a\u5f53\u7b2c\u4e00\u4e2a\u5e03\u5c14\u53c2\u6570\u4e3a <code>true<\/code> \u65f6\uff0c\u6839\u636e <code>Map<\/code> \u4e2d\u7684\u952e\u503c\u5bf9\u6784\u5efa\u591a\u4e2a\u7b49\u503c\u6761\u4ef6\uff0c\u7b2c\u4e8c\u4e2a <code>BiPredicate<\/code> \u53c2\u6570\u7528\u4e8e\u5bf9\u952e\u503c\u5bf9\u8fdb\u884c\u8fc7\u6ee4\uff0c\u53ea\u6709\u6ee1\u8db3 <code>BiPredicate<\/code> \u6761\u4ef6\u7684\u952e\u503c\u5bf9\u624d\u4f1a\u7528\u4e8e\u6784\u5efa\u6761\u4ef6\uff0c\u7b2c\u56db\u4e2a\u5e03\u5c14\u53c2\u6570\u63a7\u5236\u5bf9 <code>Map<\/code> \u4e2d\u503c\u4e3a <code>null<\/code> \u7684\u952e\u503c\u5bf9\u7684\u5904\u7406\u65b9\u5f0f<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h2>2.4 \u8303\u56f4\u6bd4\u8f83\u65b9\u6cd5<\/h2>\n<ul>\n<li><code>between(boolean, R, Object, Object):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa <code>BETWEEN...AND...<\/code> \u8303\u56f4\u6761\u4ef6\u3002\n<ul>\n<li>\u7b2c\u4e00\u4e2a\u5e03\u5c14\u53c2\u6570\u63a7\u5236\u662f\u5426\u6dfb\u52a0\u6761\u4ef6\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u4e3a\u6570\u636e\u5e93\u5b57\u6bb5\uff0c\u540e\u4e24\u4e2a\u53c2\u6570\u5206\u522b\u4e3a\u8303\u56f4\u7684\u8d77\u59cb\u548c\u7ed3\u675f\u503c\u3002<\/li>\n<\/ul>\n<\/li>\n<li><code>notBetween(boolean, R, Object, Object):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa <code>NOT BETWEEN...AND...<\/code> \u8303\u56f4\u6761\u4ef6\u3002\u903b\u8f91\u540c <code>between<\/code> \u65b9\u6cd5\u3002<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h2>2.5 \u6a21\u7cca\u67e5\u8be2\u65b9\u6cd5<\/h2>\n<ul>\n<li><code>like(boolean, R, Object):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa <code>LIKE<\/code> \u6a21\u7cca\u67e5\u8be2\u6761\u4ef6\uff0c\u4f1a\u5728\u503c\u524d\u540e\u81ea\u52a8\u6dfb\u52a0 <code>%<\/code>\u3002<\/li>\n<li><code>notLike(boolean, R, Object):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa <code>NOT LIKE<\/code> \u6a21\u7cca\u67e5\u8be2\u6761\u4ef6\u3002\u903b\u8f91\u540c <code>like<\/code> \u65b9\u6cd5\u3002<\/li>\n<li><code>likeLeft(boolean, R, Object):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa\u5de6\u6a21\u7cca\u67e5\u8be2\u6761\u4ef6\uff0c\u4f1a\u5728\u503c\u524d\u6dfb\u52a0 <code>%<\/code>\u3002<\/li>\n<li><code>likeRight(boolean, R, Object):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa\u53f3\u6a21\u7cca\u67e5\u8be2\u6761\u4ef6\uff0c\u4f1a\u5728\u503c\u540e\u6dfb\u52a0 <code>%<\/code>\u3002<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h2>2.6 \u8303\u56f4\u67e5\u8be2\u65b9\u6cd5<\/h2>\n<ul>\n<li><code>between(boolean, R, Object, Object): Children<\/code>\uff1a\u5f53\u5e03\u5c14\u53c2\u6570\u4e3a <code>true<\/code> \u65f6\uff0c\u7528\u4e8e\u6784\u5efa\u8303\u56f4\uff08<code>BETWEEN...AND...<\/code>\uff09\u6761\u4ef6<\/li>\n<li><code>notBetween(boolean, R, Object, Object): Children<\/code>\uff1a\u5f53\u5e03\u5c14\u53c2\u6570\u4e3a <code>true<\/code> \u65f6\uff0c\u7528\u4e8e\u6784\u5efa\u4e0d\u5728\u67d0\u4e2a\u8303\u56f4\uff08<code>NOT BETWEEN...AND...<\/code>\uff09\u6761\u4ef6<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h2>2.7 \u6a21\u7cca\u67e5\u8be2\u5426\u5b9a\u65b9\u6cd5<\/h2>\n<ul>\n<li><code>notLikeLeft(boolean, R, Object): Children<\/code>\uff1a\u5f53\u5e03\u5c14\u53c2\u6570\u4e3a <code>true<\/code> \u65f6\uff0c\u7528\u4e8e\u6784\u5efa\u5de6\u6a21\u7cca\u4e0d\u5339\u914d\uff08<code>NOT LIKE &#039;%\u503c&#039;<\/code>\uff09\u6761\u4ef6<\/li>\n<li><code>notLikeRight(boolean, R, Object): Children<\/code>\uff1a\u5f53\u5e03\u5c14\u53c2\u6570\u4e3a <code>true<\/code> \u65f6\uff0c\u7528\u4e8e\u6784\u5efa\u53f3\u6a21\u7cca\u4e0d\u5339\u914d\uff08<code>NOT LIKE &#039;\u503c%&#039;<\/code>\uff09\u6761\u4ef6<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h2>2.8 \u7a7a\u503c\u5224\u65ad\u65b9\u6cd5<\/h2>\n<ul>\n<li><code>isNull(boolean, R):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa\u5b57\u6bb5\u4e3a\u7a7a\uff08<code>IS NULL<\/code>\uff09\u7684\u6761\u4ef6\u3002<\/li>\n<li><code>isNotNull(boolean, R):Children<\/code>\uff1a\u7528\u4e8e\u6784\u5efa\u5b57\u6bb5\u4e0d\u4e3a\u7a7a\uff08<code>IS NOT NULL<\/code>\uff09\u7684\u6761\u4ef6\u3002<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h2>2.9 \u903b\u8f91\u7ec4\u5408\u65b9\u6cd5<\/h2>\n<ul>\n<li><code>and(Consumer&lt;Children&gt;):Children<\/code>\uff1a\u7528\u4e8e\u6dfb\u52a0 <code>AND<\/code> \u903b\u8f91\u7684\u5b50\u6761\u4ef6\u3002<\/li>\n<li><code>or():Children<\/code>\uff1a\u7528\u4e8e\u7b80\u5355\u7684 <code>OR<\/code> \u903b\u8f91\u8fde\u63a5\u3002<\/li>\n<li><code>or(Consumer&lt;Children&gt;):Children<\/code>\uff1a\u7528\u4e8e\u6dfb\u52a0\u5e26\u62ec\u53f7\u7684 <code>OR<\/code> \u903b\u8f91\u5b50\u6761\u4ef6\u3002<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h2>2.10 \u6392\u5e8f\u65b9\u6cd5<\/h2>\n<ul>\n<li><code>orderByAsc(R...):Children<\/code>\uff1a\u7528\u4e8e\u6309\u6307\u5b9a\u5b57\u6bb5\u8fdb\u884c\u5347\u5e8f\u6392\u5e8f\u3002<\/li>\n<li><code>orderByDesc(R...):Children<\/code>\uff1a\u7528\u4e8e\u6309\u6307\u5b9a\u5b57\u6bb5\u8fdb\u884c\u964d\u5e8f\u6392\u5e8f\u3002<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h2>2.11 \u5206\u7ec4\u548c\u805a\u5408\u65b9\u6cd5<\/h2>\n<ul>\n<li><code>groupBy(R...):Children<\/code>\uff1a\u7528\u4e8e\u6309\u6307\u5b9a\u5b57\u6bb5\u8fdb\u884c\u5206\u7ec4\u67e5\u8be2\u3002<\/li>\n<li><code>having(String, Object...):Children<\/code>\uff1a\u7528\u4e8e\u6dfb\u52a0 <code>HAVING<\/code> \u5b50\u53e5\uff0c\u53ef\u7528\u4e8e\u5bf9\u5206\u7ec4\u7ed3\u679c\u8fdb\u884c\u8fc7\u6ee4\u3002<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h1>\u4e09\u3001QueryWrapper<\/h1>\n<p>\u5728\u7236\u7c7b\u57fa\u7840\u4e0a\uff0c\u6269\u5c55\u4e86select\u529f\u80fd\uff0c\u5141\u8bb8\u5728\u6784\u9020SQL\u8bed\u53e5\u65f6\u53ef\u4ee5\u6307\u5b9aselect\u54ea\u4e9b\u5b57\u6bb5\u3002<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075303346.png'><img class=\"lazyload lazyload-style-6\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075303346.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<ul>\n<li><code>select(String...)<\/code>\uff1a\u53c2\u6570\u4f20\u9700\u8981\u7684\u5b57\u6bb5\u5373\u53ef\uff0c\u591a\u4e2a\u5b57\u6bb5\u4f7f\u7528<code>,<\/code>\u95f4\u9694\u3002\u4f8b\u5982\uff1a<code>select(&quot;id&quot;, &quot;username&quot;, &quot;info&quot;, &quot;balance&quot;)<\/code><\/li>\n<li><code>select(List&lt;String&gt;)<\/code>\uff1a\u53c2\u6570\u4f20\u9700\u8981\u7684\u5b57\u6bb5\u7684List\u96c6\u5408\u3002<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h1>\u56db\u3001UpdateWrapper<\/h1>\n<p>\u5728\u7236\u7c7b\u57fa\u7840\u4e0a\uff0c\u6269\u5c55\u4e86set\u90e8\u5206\u3002<\/p>\n<p>\u7ea2\u6846\u5185\u7684\u65b9\u6cd5\u662f\u4f7f\u7528\u5b57\u7b26\u4e32\u7684\u5f62\u5f0f\u628aset\u90e8\u5206\u5199\u51fa\u6765\uff0c\u6700\u540e\u62fc\u5230SQL\u8bed\u53e5\u4e2d\u3002\uff08\u6bd4\u8f83\u5c11\u89c1\uff09<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075304884.png'><img class=\"lazyload lazyload-style-6\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075304884.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<ul>\n<li><code>setSql(boolean, String)<\/code>\uff1a\n<ul>\n<li>\u7b2c\u4e00\u4e2a\u53c2\u6570\uff1a<code>true<\/code>\uff08\u540e\u9762\u7684SQL\u8bed\u53e5\u62fc\u63a5\u5230SQL\u8bed\u53e5\u4e2d\uff09\u3001<code>false<\/code>\uff08\u540e\u9762SQL\u8bed\u53e5\u4f1a\u88ab\u5ffd\u7565\uff0c\u4e0d\u88ab\u4f7f\u7528\uff09<\/li>\n<li>\u7b2c\u4e8c\u4e2a\u53c2\u6570\uff1a<code>set<\/code>\u90e8\u5206\u7684SQL\u3002\u4f8b\u5982\uff1a&#8220;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h1>\u4e94\u3001\u4f7f\u7528Lambda\u8bed\u6cd5\u5b50\u7c7b\uff08\u63a8\u8350\uff09<\/h1>\n<ul>\n<li><code>AbstractLambdaaWrapper<\/code>\n<ul>\n<li><code>LambdaUpdateWrapper<\/code><\/li>\n<li><code>LambdaQueryWrapper<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\u8fd9\u4e09\u4e2a\u548c\u4e0a\u9762\u4e09\u4e2a\u4f5c\u7528\u5176\u5b9e\u76f8\u540c\uff0c\u53ea\u662f\u6269\u5c55\u4e86\u53ef\u4ee5\u4f7f\u7528lambda\u7684\u5199\u6cd5\u3002<\/p>\n<p><strong>\u4e3a\u4ec0\u4e48\u8981\u7528Lambda\u8bed\u6cd5\uff1f<\/strong><\/p>\n<p>\u56e0\u4e3a\u5982\u4e0b\u65b9<a href=\"#6.3\">6.3<\/a>\u4e2d\u7684\u67e5\u8be2\u4ee3\u7801\u4e00\u6837\uff0c\u5c06\u9700\u8981\u67e5\u8be2\u7684\u5b57\u6bb5\u540d\u76f4\u63a5\u786c\u7f16\u7801\u5230\u4ee3\u7801\u4e2d\uff0c\u8fd9\u79cd\u65b9\u5f0f\u662f\u4e0d\u63a8\u8350\u7684\u3002<\/p>\n<p>LambdaWrapper\u5c31\u662f\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u7684\u3002<\/p>\n<p>\u5177\u4f53\u600e\u4e48\u4f7f\u7528\u770b\u4e0b\u9762\u7684<a href=\"#\u516b\u3001\u57fa\u4e8eLambdaWrapper\u67e5\u8be2\">\u7b2c\u516b\u8282<\/a><\/p>\n<div style=\"height:1.5em\"><\/div>\n<h1>\u516d\u3001\u6848\u4f8b\u4e00\uff1a\u57fa\u4e8eQueryWrapper\u7684\u67e5\u8be2<\/h1>\n<h2>6.1 \u6848\u4f8b<\/h2>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075305913.png'><img class=\"lazyload lazyload-style-6\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075305913.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<p>\u7ea2\u8272\u7684SQL\u8bed\u53e5\u662f\u6211\u9488\u5bf9\u8fd9\u4e2a\u6848\u4f8b\u5199\u51fa\u7684SQL\uff0c\u4e0b\u9762\u5c31\u8981\u4f7f\u7528MP\u6784\u9020\u76f8\u5173SQL\u3002<\/p>\n<div style=\"height:1.5em\"><\/div>\n<h2>6.2 UserMaper<\/h2>\n<p>\u4f9d\u65e7\u4e0d\u7528\u5199\u4efb\u4f55\u65b9\u6cd5<\/p>\n<pre><code class=\"language-java\">public interface UserMapper extends BaseMapper&lt;User&gt;{\n\n}<\/code><\/pre>\n<div style=\"height:1.5em\"><\/div>\n<p><a id=\"6.3\"><\/a><\/p>\n<h2>6.3 \u5355\u5143\u6d4b\u8bd5\u4ee3\u7801\uff08\u2460\uff09<\/h2>\n<pre><code class=\"language-java\">    @Test\n    void testQueryWrapper() {\n        \/\/ 1. \u6784\u5efa\u67e5\u8be2\u6761\u4ef6\n        QueryWrapper&lt;User&gt; wrapper = new QueryWrapper&lt;User&gt;()\n                .select(&quot;id&quot;, &quot;username&quot;, &quot;info&quot;, &quot;balance&quot;)\n                .like(&quot;username&quot;, &quot;o&quot;)\n                .ge(&quot;balance&quot;, &quot;1000&quot;);\n\n        \/\/ 2. \u67e5\u8be2\n        List&lt;User&gt; users = userMapper.selectList(wrapper);\n        users.forEach(System.out::println);\n    }<\/code><\/pre>\n<p>\u8fd0\u884c\u7ed3\u679c\uff1a<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075307777.png'><img class=\"lazyload lazyload-style-6\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075307777.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<p><strong>\u4ee3\u7801\u89e3\u6790\uff1a<\/strong><\/p>\n<ul>\n<li>\n<p>\u6784\u5efa\u67e5\u8be2\u6761\u4ef6\uff08wrapper\uff09\u65f6\u91c7\u7528\u94fe\u5f0f\u7f16\u7a0b\u65b9\u5f0f\u3002<\/p>\n<\/li>\n<li>\n<p><code>new QueryWrapper&lt;User&gt;<\/code>\uff1a\u521b\u5efaQueryWrapper\u7c7b\u7684\u5b9e\u4f8b\uff0c\u5e76\u4f7f\u7528\u65b9\u6cd5\u5bf9\u6784\u9020\u6761\u4ef6\u8fdb\u884c\u4e30\u5bcc\uff0c\u540c\u65f6\u4f20\u5165<code>User<\/code>\u4e3a\u6cdb\u578b<\/p>\n<\/li>\n<li>\n<p><code>.select(&quot;id&quot;, &quot;username&quot;, &quot;info&quot;, &quot;balance&quot;)<\/code>\uff1a\u6784\u5efaSQL\u7684<code>select<\/code>\u90e8\u5206\uff0c\u6307\u5b9a\u9700\u8981\u67e5\u8be2\u7684\u5b57\u6bb5<\/p>\n<\/li>\n<li>\n<p><code>.like(&quot;username&quot;, &quot;o&quot;)<\/code>\uff1a\u6784\u9020<code>where<\/code>\u90e8\u5206\u7684\u6761\u4ef6\uff1a\u6a21\u7cca\u67e5\u8be2<code>username<\/code>\u5b57\u6bb5\u503c\u5e26\u6709<code>o<\/code>\u5b57\u7b26\u4e32\u7684<\/p>\n<\/li>\n<li>\n<p><code>.ge(&quot;balance&quot;, &quot;1000&quot;)<\/code>\uff1a\u6784\u9020<code>where<\/code>\u90e8\u5206\u7684\u6761\u4ef6\uff1a<code>balance<\/code>\u5b57\u6bb5\u5927\u4e8e\u7b49\u4e8e1000\u7684<\/p>\n<\/li>\n<li>\n<p>\u5982\u4e0a\u7684\u6784\u9020\u6761\u4ef6\u62fc\u63a5\u6210SQL\u5373\u4e3a\uff1a<\/p>\n<ul>\n<li>\n<pre><code class=\"language-sql\">select id, username, info, balance \nfrom user\nwhere username like CONCAT('%', 'o' ,'%') \nAND balance >= 1000;<\/code><\/pre>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p><code>List&lt;User&gt; users = userMapper.selectList(wrapper);<\/code>\uff1a\u4f7f\u7528<code>UserMapper<\/code>\u5229\u7528\u8fd9\u4e2a\u6784\u9020\u67e5\u8be2\u5e76\u8fd4\u56de<code>User<\/code>\u7684\u5217\u8868<\/p>\n<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h3>1.6.4 \u5355\u5143\u6d4b\u8bd5\u4ee3\u7801\uff08\u2461\uff09<\/h3>\n<pre><code class=\"language-java\">    @Test\n    void testUpdateByQueryWrapper() {\n        \/\/ 1. \u8981\u66f4\u65b0\u7684\u6570\u636e\n        User user = new User();\n        user.setBalance(2000);\n\n        \/\/ 2. \u66f4\u65b0\u7684\u6761\u4ef6\n        QueryWrapper&lt;User&gt; wrapper = new QueryWrapper&lt;User&gt;()\n                .eq(&quot;username&quot;, &quot;jack&quot;);\n\n        \/\/ 3. \u6267\u884c\u66f4\u65b0\n        userMapper.update(user, wrapper);\n    }<\/code><\/pre>\n<p>\u8fd0\u884c\u7ed3\u679c\uff1a<\/p>\n<p>\u200b   \u5df2\u6210\u529f\u66f4\u65b0\u6570\u636e\u3002<\/p>\n<p><strong>\u4ee3\u7801\u89e3\u6790\uff1a<\/strong><\/p>\n<ul>\n<li>\n<p><code>User user = new User();user.setBalance(2000);<\/code>\uff1a\u5148\u5c06\u9700\u8981\u66f4\u65b0\u7684\u6570\u636e\uff08<code>set<\/code>\u90e8\u5206\u5b57\u6bb5\uff09\u5199\u6210\u5bf9\u8c61<\/p>\n<\/li>\n<li>\n<p><code>QueryWrapper&lt;User&gt; wrapper = new QueryWrapper&lt;User&gt;().eq(&quot;username&quot;, &quot;jack&quot;);<\/code>\uff1a\u518d\u6784\u5efaSQL\u8bed\u53e5\u7684<code>WHERE<\/code>\u6761\u4ef6<\/p>\n<\/li>\n<li>\n<p><code>userMapper.update(user, wrapper)<\/code>\uff1a\u6700\u540e\u6267\u884c\u66f4\u65b0<\/p>\n<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<h1>\u4e03\u3001\u6848\u4f8b\u4e8c\uff1a\u57fa\u4e8eUpdateWrapper\u7684\u66f4\u65b0<\/h1>\n<h2>7.1 \u6848\u4f8b<\/h2>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075308274.png'><img class=\"lazyload lazyload-style-6\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075308274.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<div style=\"height:1.5em\"><\/div>\n<h2>7.2 \u5355\u5143\u6d4b\u8bd5\u4ee3\u7801<\/h2>\n<pre><code class=\"language-java\">    @Test\n    void testUpdateWrapper() {\n        List&lt;Long&gt; idList = List.of(1L, 2L, 3L);\n        UpdateWrapper&lt;User&gt; wrapper = new UpdateWrapper&lt;User&gt;()\n                .setSql(true, &quot;balance = (balance - 200)&quot;)\n                .in(&quot;id&quot;, idList);\n\n        userMapper.update(null, wrapper);\n    }<\/code><\/pre>\n<p>\u8fd0\u884c\u7ed3\u679c\uff1a<\/p>\n<p>\u200b   \u5df2\u6210\u529f\u66f4\u65b0\u6570\u636e\u3002<\/p>\n<p><strong>\u4ee3\u7801\u89e3\u6790\uff1a<\/strong><\/p>\n<ul>\n<li><code>UpdateWrapper&lt;User&gt; wrapper = new UpdateWrapper&lt;User&gt;()<\/code>\uff1a\u521b\u5efa\u4e00\u4e2aUpdateWrapper\u5b9e\u4f8b<\/li>\n<li><code>.setSql(true, &quot;balance = (balance - 200)&quot;)<\/code>\uff1a\u624b\u5199<code>set<\/code>\u90e8\u5206\u7684\u4ee3\u7801\uff08\u4e0d\u8981<code>set<\/code>\u5173\u952e\u5b57\uff09<\/li>\n<li><code>.in(&quot;id&quot;, idList)<\/code>\uff1a\u8fd9\u662f<code>WHERE<\/code>\u90e8\u5206\u7684\u7b5b\u9009\u6761\u4ef6<\/li>\n<li><code>userMapper.update(null, wrapper)<\/code>\uff1a\u6267\u884c\u4fee\u6539\u65b9\u6cd5\uff0c\u56e0\u4e3a\u4e0d\u9700\u8981\u4f20\u5165<code>User<\/code>\u5b9e\u4f53\u7c7b\u4f5c\u4e3a\u4fee\u6539\u5bf9\u8c61\uff0c\u6240\u4ee5\u76f4\u63a5\u4f20<code>null<\/code>\u3002<\/li>\n<\/ul>\n<div style=\"height:1.5em\"><\/div>\n<p><a id=\"\u516b\u3001\u57fa\u4e8eLambdaWrapper\u67e5\u8be2\"><\/a><\/p>\n<h1>\u516b\u3001\u57fa\u4e8eLambdaWrapper\u67e5\u8be2<\/h1>\n<h2>8.1 \u91cd\u67846.3\u7684\u4ee3\u7801<\/h2>\n<pre><code class=\"language-java\">    @Test\n    void testLambdaQueryWrapper() {\n        \/\/ 1. \u6784\u5efa\u67e5\u8be2\u6761\u4ef6\n        LambdaQueryWrapper&lt;User&gt; wrapper = new LambdaQueryWrapper&lt;User&gt;()\n                .select(User::getId, User::getUsername, User::getInfo, User::getBalance)\n                .like(User::getUsername, &quot;o&quot;)\n                .ge(User::getBalance, &quot;1000&quot;);\n\n        \/\/ 2. \u67e5\u8be2\n        List&lt;User&gt; users = userMapper.selectList(wrapper);\n        users.forEach(System.out::println);\n    }<\/code><\/pre>\n<p>\u8fd0\u884c\u7ed3\u679c\u4e0e\u4e4b\u524d\u7684\u4ee3\u7801\u6548\u679c\u76f8\u540c\u3002<\/p>\n<p><strong>\u4ee3\u7801\u89e3\u6790\uff1a<\/strong><\/p>\n<p>\u4e3e\u4f8b\uff1a\u5c06<code>&quot;id&quot;<\/code>\u6362\u6210<code>User::getId<\/code>\u3002<\/p>\n<p>\u5176\u5b9e\u662f\u5229\u7528\u53cd\u5c04\uff0c\u4f7f\u7528\u51fd\u6570<code>User::getId<\/code>\u627e\u5230\u5bf9\u5e94\u7684\u5b57\u6bb5\u540d\uff0c\u7136\u540e\u62fc\u63a5\u5230SQL\u4e2d\uff0c\u4ece\u800c\u907f\u514d\u4e86\u9b54\u6cd5\u503c\u548c\u786c\u7f16\u7801\u3002<\/p>\n<div style=\"height:1.5em\"><\/div>\n<h2>8.2 \u91cd\u67846.4\u7684\u4ee3\u7801<\/h2>\n<pre><code class=\"language-java\">    @Test\n    void testUpdateByLambdaQueryWrapper() {\n        \/\/ 1. \u8981\u66f4\u65b0\u7684\u6570\u636e\n        User user = new User();\n        user.setBalance(2000);\n\n        \/\/ 2. \u66f4\u65b0\u7684\u6761\u4ef6\n        LambdaQueryWrapper&lt;User&gt; wrapper = new LambdaQueryWrapper&lt;User&gt;()\n                .eq(User::getUsername, &quot;jack&quot;);\n\n        \/\/ 3. \u6267\u884c\u66f4\u65b0\n        userMapper.update(user, wrapper);\n    }<\/code><\/pre>\n<div style=\"height:1.5em\"><\/div>\n<h2>8.3 \u91cd\u67847.2\u7684\u4ee3\u7801<\/h2>\n<pre><code class=\"language-java\">    @Test\n    void testLambdaUpdateWrapper() {\n        List&lt;Long&gt; idList = List.of(1L, 2L, 3L);\n        LambdaUpdateWrapper&lt;User&gt; wrapper = new LambdaUpdateWrapper&lt;User&gt;()\n                .setSql(true, &quot;balance = (balance - 200)&quot;)\n                .in(User::getId, idList);\n\n        userMapper.update(null, wrapper);\n    }<\/code><\/pre>\n<div style=\"height:1.5em\"><\/div>\n<h2>1.9 \u603b\u7ed3<\/h2>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075310428.png'><img class=\"lazyload lazyload-style-6\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075310428.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5b66\u4e60MP\u7684\u6761\u4ef6\u6784\u9020\u5668\uff1aQueryWrapper\u3001UpdateWrapper\uff0c\u4ee5\u53ca\u5bf9\u5e94\u7684LambdaQueryWrapper\u548cLambdaUpdateWrapper\u3002\u4ee5\u6b64\u6765\u901a\u8fc7MP\u62fc\u63a5\u8f83\u4e3a\u590d\u6742\u7684\u67e5\u8be2\u548c\u66f4\u65b0SQL<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[102,110],"tags":[111],"class_list":["post-1551","post","type-post","status-publish","format-standard","hentry","category-spring_boot","category-heima_mall","tag-mybatisplus"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd01 \u2014 \u6761\u4ef6\u6784\u9020\u5668 | \u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.tqazy.com\/?p=1551\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd01 \u2014 \u6761\u4ef6\u6784\u9020\u5668 | \u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2\" \/>\n<meta property=\"og:description\" content=\"\u5b66\u4e60MP\u7684\u6761\u4ef6\u6784\u9020\u5668\uff1aQueryWrapper\u3001UpdateWrapper\uff0c\u4ee5\u53ca\u5bf9\u5e94\u7684LambdaQueryWrapper\u548cLambdaUpdateWrapper\u3002\u4ee5\u6b64\u6765\u901a\u8fc7MP\u62fc\u63a5\u8f83\u4e3a\u590d\u6742\u7684\u67e5\u8be2\u548c\u66f4\u65b0SQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tqazy.com\/?p=1551\" \/>\n<meta property=\"og:site_name\" content=\"\u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-05T08:17:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-30T06:50:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075258670.png\" \/>\n<meta name=\"author\" content=\"\u9676\u5176\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u9676\u5176\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.tqazy.com\/?p=1551#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.tqazy.com\/?p=1551\"},\"author\":{\"name\":\"\u9676\u5176\",\"@id\":\"https:\/\/www.tqazy.com\/#\/schema\/person\/b2e89d56e70f15c261012417c5ef2c4e\"},\"headline\":\"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd01 \u2014 \u6761\u4ef6\u6784\u9020\u5668\",\"datePublished\":\"2025-03-05T08:17:58+00:00\",\"dateModified\":\"2025-09-30T06:50:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.tqazy.com\/?p=1551\"},\"wordCount\":46,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.tqazy.com\/#\/schema\/person\/b2e89d56e70f15c261012417c5ef2c4e\"},\"image\":{\"@id\":\"https:\/\/www.tqazy.com\/?p=1551#primaryimage\"},\"thumbnailUrl\":\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075258670.png\",\"keywords\":[\"MybatisPlus\"],\"articleSection\":[\"Spring Boot\",\"\u9ed1\u9a6c\u5546\u57ce\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.tqazy.com\/?p=1551#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tqazy.com\/?p=1551\",\"url\":\"https:\/\/www.tqazy.com\/?p=1551\",\"name\":\"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd01 \u2014 \u6761\u4ef6\u6784\u9020\u5668 | \u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2\",\"isPartOf\":{\"@id\":\"https:\/\/www.tqazy.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.tqazy.com\/?p=1551#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.tqazy.com\/?p=1551#primaryimage\"},\"thumbnailUrl\":\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075258670.png\",\"datePublished\":\"2025-03-05T08:17:58+00:00\",\"dateModified\":\"2025-09-30T06:50:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.tqazy.com\/?p=1551#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tqazy.com\/?p=1551\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.tqazy.com\/?p=1551#primaryimage\",\"url\":\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075258670.png\",\"contentUrl\":\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075258670.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tqazy.com\/?p=1551#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.tqazy.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd01 \u2014 \u6761\u4ef6\u6784\u9020\u5668\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tqazy.com\/#website\",\"url\":\"https:\/\/www.tqazy.com\/\",\"name\":\"\u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2\",\"description\":\"\u5f53\u4e0b\uff0c\u5373\u662f\u672a\u6765\",\"publisher\":{\"@id\":\"https:\/\/www.tqazy.com\/#\/schema\/person\/b2e89d56e70f15c261012417c5ef2c4e\"},\"alternateName\":\"TaoQi's Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.tqazy.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.tqazy.com\/#\/schema\/person\/b2e89d56e70f15c261012417c5ef2c4e\",\"name\":\"\u9676\u5176\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.tqazy.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2024\/06\/20240604021741672.jpg\",\"contentUrl\":\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2024\/06\/20240604021741672.jpg\",\"width\":940,\"height\":940,\"caption\":\"\u9676\u5176\"},\"logo\":{\"@id\":\"https:\/\/www.tqazy.com\/#\/schema\/person\/image\/\"},\"description\":\"\u4e00\u4e2a\u5f88\u61d2\u7684\u7a0b\u5e8f\u5458\",\"sameAs\":[\"https:\/\/www.tqazy.com\"],\"url\":\"https:\/\/www.tqazy.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd01 \u2014 \u6761\u4ef6\u6784\u9020\u5668 | \u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tqazy.com\/?p=1551","og_locale":"zh_CN","og_type":"article","og_title":"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd01 \u2014 \u6761\u4ef6\u6784\u9020\u5668 | \u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2","og_description":"\u5b66\u4e60MP\u7684\u6761\u4ef6\u6784\u9020\u5668\uff1aQueryWrapper\u3001UpdateWrapper\uff0c\u4ee5\u53ca\u5bf9\u5e94\u7684LambdaQueryWrapper\u548cLambdaUpdateWrapper\u3002\u4ee5\u6b64\u6765\u901a\u8fc7MP\u62fc\u63a5\u8f83\u4e3a\u590d\u6742\u7684\u67e5\u8be2\u548c\u66f4\u65b0SQL","og_url":"https:\/\/www.tqazy.com\/?p=1551","og_site_name":"\u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2","article_published_time":"2025-03-05T08:17:58+00:00","article_modified_time":"2025-09-30T06:50:56+00:00","og_image":[{"url":"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075258670.png","type":"","width":"","height":""}],"author":"\u9676\u5176","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u9676\u5176","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.tqazy.com\/?p=1551#article","isPartOf":{"@id":"https:\/\/www.tqazy.com\/?p=1551"},"author":{"name":"\u9676\u5176","@id":"https:\/\/www.tqazy.com\/#\/schema\/person\/b2e89d56e70f15c261012417c5ef2c4e"},"headline":"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd01 \u2014 \u6761\u4ef6\u6784\u9020\u5668","datePublished":"2025-03-05T08:17:58+00:00","dateModified":"2025-09-30T06:50:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.tqazy.com\/?p=1551"},"wordCount":46,"commentCount":0,"publisher":{"@id":"https:\/\/www.tqazy.com\/#\/schema\/person\/b2e89d56e70f15c261012417c5ef2c4e"},"image":{"@id":"https:\/\/www.tqazy.com\/?p=1551#primaryimage"},"thumbnailUrl":"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075258670.png","keywords":["MybatisPlus"],"articleSection":["Spring Boot","\u9ed1\u9a6c\u5546\u57ce"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.tqazy.com\/?p=1551#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.tqazy.com\/?p=1551","url":"https:\/\/www.tqazy.com\/?p=1551","name":"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd01 \u2014 \u6761\u4ef6\u6784\u9020\u5668 | \u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2","isPartOf":{"@id":"https:\/\/www.tqazy.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.tqazy.com\/?p=1551#primaryimage"},"image":{"@id":"https:\/\/www.tqazy.com\/?p=1551#primaryimage"},"thumbnailUrl":"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075258670.png","datePublished":"2025-03-05T08:17:58+00:00","dateModified":"2025-09-30T06:50:56+00:00","breadcrumb":{"@id":"https:\/\/www.tqazy.com\/?p=1551#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tqazy.com\/?p=1551"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.tqazy.com\/?p=1551#primaryimage","url":"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075258670.png","contentUrl":"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305075258670.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.tqazy.com\/?p=1551#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.tqazy.com\/"},{"@type":"ListItem","position":2,"name":"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd01 \u2014 \u6761\u4ef6\u6784\u9020\u5668"}]},{"@type":"WebSite","@id":"https:\/\/www.tqazy.com\/#website","url":"https:\/\/www.tqazy.com\/","name":"\u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2","description":"\u5f53\u4e0b\uff0c\u5373\u662f\u672a\u6765","publisher":{"@id":"https:\/\/www.tqazy.com\/#\/schema\/person\/b2e89d56e70f15c261012417c5ef2c4e"},"alternateName":"TaoQi's Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tqazy.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/www.tqazy.com\/#\/schema\/person\/b2e89d56e70f15c261012417c5ef2c4e","name":"\u9676\u5176","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.tqazy.com\/#\/schema\/person\/image\/","url":"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2024\/06\/20240604021741672.jpg","contentUrl":"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2024\/06\/20240604021741672.jpg","width":940,"height":940,"caption":"\u9676\u5176"},"logo":{"@id":"https:\/\/www.tqazy.com\/#\/schema\/person\/image\/"},"description":"\u4e00\u4e2a\u5f88\u61d2\u7684\u7a0b\u5e8f\u5458","sameAs":["https:\/\/www.tqazy.com"],"url":"https:\/\/www.tqazy.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.tqazy.com\/index.php?rest_route=\/wp\/v2\/posts\/1551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tqazy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tqazy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tqazy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tqazy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1551"}],"version-history":[{"count":8,"href":"https:\/\/www.tqazy.com\/index.php?rest_route=\/wp\/v2\/posts\/1551\/revisions"}],"predecessor-version":[{"id":1951,"href":"https:\/\/www.tqazy.com\/index.php?rest_route=\/wp\/v2\/posts\/1551\/revisions\/1951"}],"wp:attachment":[{"href":"https:\/\/www.tqazy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tqazy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tqazy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}