{"id":1568,"date":"2025-03-05T18:50:06","date_gmt":"2025-03-05T10:50:06","guid":{"rendered":"https:\/\/www.tqazy.com\/?p=1568"},"modified":"2025-03-05T20:59:21","modified_gmt":"2025-03-05T12:59:21","slug":"mybatisplus%ef%bc%88%e4%ba%8c%ef%bc%89%e6%a0%b8%e5%bf%83%e5%8a%9f%e8%83%bd02-%e8%87%aa%e5%ae%9a%e4%b9%89sql","status":"publish","type":"post","link":"https:\/\/www.tqazy.com\/?p=1568","title":{"rendered":"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd02 \u2014 \u81ea\u5b9a\u4e49SQL"},"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=1551\" target=\"_black\">MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd01 \u2014 \u6761\u4ef6\u6784\u9020\u5668<\/a><br \/>\n\u4e0b\u4e00\u8282\uff1a<a href=\"https:\/\/www.tqazy.com\/?p=1585\" target=\"_black\">MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd03 \u2014 IService\u63a5\u53e3<\/a><br \/>\n\u672c\u8282\u5b66\u4e60MybatisPlus\uff08MP\uff09\u7684\u6838\u5fc3\u529f\u80fd \u2014 \u81ea\u5b9a\u4e49SQL\uff1a<\/p>\n<ul>\n<li>\u5728\u4e1a\u52a1\u5c42\u62fc\u63a5SQL\u7684\u95ee\u9898<\/li>\n<li>\u81ea\u5b9a\u4e49SQL\u7684\u7528\u6cd5<\/li>\n<\/ul>\n<\/blockquote>\n<div style=\"height:1.5em\"><\/div>\n<h1>\u4e00\u3001\u81ea\u5b9a\u4e49SQL\u7b80\u4ecb<\/h1>\n<p>\u81ea\u5b9a\u4e49SQL\uff1a\u6211\u4eec\u53ef\u4ee5\u5229\u7528MyBatisPlus\u7684Wrapper\u6765\u6784\u5efa\u590d\u6742\u7684Where\u6761\u4ef6\uff0c\u7136\u540e\u81ea\u5df1\u5b9a\u4e49SQL\u8bed\u53e5\u4e2d\u5269\u4e0b\u7684\u90e8\u5206\u3002<\/p>\n<div style=\"height:1.5em\"><\/div>\n<h1>\u4e8c\u3001\u95ee\u9898\u51fa\u73b0<\/h1>\n<p>\u4e0b\u9762\u7684\u6848\u4f8b\u662f\u5b8c\u5168\u624b\u5199SQL\u7684\u65b9\u5f0f\u3002<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305104736839.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\/20250305104736839.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<div style=\"height:1.5em\"><\/div>\n<p>\u4e0a\u4e00\u8282\u4e2d\u6211\u4eec\u9047\u5230\u4e86\u76f8\u4f3c\u7684\u6848\u4f8b\uff0c\u4f7f\u7528\u4e86 <code>LambdaUpdateWrapper<\/code> \uff0c\u5199\u6cd5\u5982\u4e0b\uff1a<\/p>\n<pre><code class=\"language-java\">    @Test\n    void testLambdaUpdateWrapper() {\n        List&lt;Long&gt; idList = List.of(1L, 2L, 4L);\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<p>\u800c\u4e0a\u9762\u7684\u4ee3\u7801\u662f<strong>\u6709\u95ee\u9898\u7684<\/strong>\uff1a<\/p>\n<p>\u4ee3\u7801\u4e2d <code>.setSql\uff08\uff09<\/code> \u90e8\u5206\u662f\u5199\u7684SQL\u8bed\u53e5\uff0c\u4f46\u662f\u8fd9\u6574\u6bb5\u4ee3\u7801\u4e00\u822c\u60c5\u51b5\u4e0b\u662f\u5728service\u5c42\u7684\uff0c\u4e5f\u5c31\u662f\u4e1a\u52a1\u903b\u8f91\u5c42\u3002<\/p>\n<p>\u800c\u5728\u4e1a\u52a1\u903b\u8f91\u5c42\u4ee3\u7801\u62fc\u5199\u5e94\u8be5\u5728\u6301\u4e45\u5c42\u51fa\u73b0\u7684SQL\u8bed\u53e5\uff0c\u8fd9\u662f\u4e00\u79cd\u5f88\u4e0d\u89c4\u8303\u7684\u5199\u6cd5\u3002<\/p>\n<div style=\"height:1.5em\"><\/div>\n<p><strong>\u90a3\u4e48\u600e\u4e48\u529e\u5462\uff1f<\/strong><\/p>\n<p>\u90a3\u5c31\u5c06\u590d\u6742\u7684SQL\u62fc\u5199\u5206\u4e3a\u4e24\u4e2a\u90e8\u5206\uff1a<\/p>\n<ul>\n<li>\u4e00\u90e8\u5206\u53ef\u4ee5\u7531MP\u76f4\u63a5\u6784\u5efa\u7684\uff0c\u4ea4\u7ed9MP<\/li>\n<li>\u53e6\u4e00\u90e8\u5206\u76f8\u5bf9\u590d\u6742\uff0cMP\u65e0\u6cd5\u6784\u5efa\u7684\u5c31\u81ea\u5b9a\u4e49SQL\uff08\u624b\u5199SQL\uff09<\/li>\n<\/ul>\n<p>\u5f53\u7136\u8fd9\u4e2a\u624b\u5199\u7684SQL\u4e0d\u662f\u5728\u4e1a\u52a1\u5c42\u8fdb\u884c\u62fc\u5199\uff0c\u800c\u662f\u5728Mapper\u5c42\u3002<\/p>\n<p>\u53ea\u8981\u5c06\u4e1a\u52a1\u5c42\u4e2dMP\u6784\u5efa\u7684<strong>\u4f20\u9012<\/strong>\u5230Mapper\u5c42\u548c\u81ea\u5b9a\u4e49SQL<strong>\u7ec4\u88c5<\/strong>\u8d77\u6765\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n<div style=\"height:1.5em\"><\/div>\n<h1>\u4e09\u3001\u81ea\u5b9a\u4e49SQL\u7528\u6cd5<\/h1>\n<p>\u7528\u4e0a\u9762\u7684\u4ee3\u7801\u8fdb\u884c\u6539\u5199\uff1a<\/p>\n<h2>3.1 \u57fa\u4e8eWrapper\u6784\u5efawhere\u6761\u4ef6<\/h2>\n<p>\u6a21\u62df\u5728\u4e1a\u52a1\u5c42\u8fdb\u884cMP\u6784\u5efa\uff1a<\/p>\n<pre><code class=\"language-java\">    @Test\n    void testCustomSqlSegment() {\n        List&lt;Long&gt; idList = List.of(1L, 2L, 4L);\n        int amount = 200;\n        \/\/ 1. \u6784\u5efa\u6761\u4ef6\n        LambdaQueryWrapper&lt;User&gt; wrapper = new LambdaQueryWrapper&lt;User&gt;().in(User::getId, idList);\n        \/\/ 2. \u81ea\u5b9a\u4e49SQL\u65b9\u6cd5\u8c03\u7528\n        userMapper.updateBalanceByIds(wrapper, amount);\n    }<\/code><\/pre>\n<div style=\"height:1.5em\"><\/div>\n<h2>3.2 Mapper.java\u4e2d\u81ea\u5b9a\u4e49\u65b9\u6cd5<\/h2>\n<p>\u5728mapper\u5c42\u7684\u65b9\u6cd5\u53c2\u6570\u4e2d\u7528 <code>@Param<\/code> \u6ce8\u89e3\u58f0\u660ewrapper\u53d8\u91cf\u540d\u79f0\uff0c\u5fc5\u987b\u662f<code>ew<\/code>\u3002<\/p>\n<pre><code class=\"language-java\">void updateBalanceByIds(@Param(&quot;ew&quot;)LambdaQueryWrapper&lt;User&gt; wrapper, @Param(&quot;amount&quot;) int amount);<\/code><\/pre>\n<div style=\"height:1.5em\"><\/div>\n<h2>3.3 Mapper.xml\u4e2d\u81ea\u5b9a\u4e49SQL<\/h2>\n<pre><code class=\"language-xml\">    &lt;update id=&quot;updateBalanceByIds&quot;&gt;\n        UPDATE user SET balance = balance - #{amount} ${ew.customSqlSegment}\n    &lt;\/update&gt;<\/code><\/pre>\n<p>\u4ee3\u7801\u89e3\u6790\uff1a<\/p>\n<ul>\n<li><code>${ew.customSqlSegment}<\/code>\uff1a \u4f1a\u62fc\u63a5MP\u6784\u5efa\u597d\u7684SQL\u7247\u6bb5<\/li>\n<\/ul>\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\/20250305104738552.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\/20250305104738552.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/p>\n<p>\u200b   \u6210\u529f\u4fee\u6539\u6570\u636e\u3002<\/p>\n<div style=\"height:1.5em\"><\/div>\n<h2>3.4 \u603b\u7ed3<\/h2>\n<p>\u901a\u8fc7\u8fd9\u4e2a\u65b9\u5f0f\uff0c\u6211\u4eec\u6210\u529f\u5c06MP\u6784\u5efa\u653e\u5728\u4e86\u4e1a\u52a1\u5c42\uff0c\u628a\u81ea\u5b9a\u4e49SQL\u653e\u5728\u4e86Mapper\u5c42\u3002\u5206\u5c42\u6b63\u786e\u3002<\/p>\n<div style=\"height:1.5em\"><\/div>\n<p>\u4f7f\u7528\u573a\u666f\uff1a<\/p>\n<p>\u200b   SQL\u8bed\u53e5\uff0cwhere\u6761\u4ef6\u4e4b\u5916\u7684\u90e8\u5206\uff0c\u6211\u4eec\u65e0\u6cd5\u901a\u8fc7MP\u66f4\u65b9\u4fbf\u7684\u5b9e\u73b0\uff0c\u53ea\u80fd\u7528\u62fc\u63a5\u3002<\/p>\n<p>\u200b   \u90a3\u4e48\u4e3a\u4e86\u4e0d\u8fdd\u80cc\u7f16\u5199\u89c4\u8303\uff0c\u91c7\u7528\u8fd9\u79cd\u65b9\u5f0f\uff1awhere\u6761\u4ef6\u4f7f\u7528MP\u6784\u5efa\uff0c\u5176\u4f59\u90e8\u5206\u8fdb\u884c\u81ea\u5b9a\u4e49SQL\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5b66\u4e60 MP \u7684 \u81ea\u5b9a\u4e49SQL\uff1a\u6211\u4eec\u53ef\u4ee5\u5229\u7528MyBatisPlus\u7684Wrapper\u6765\u6784\u5efa\u590d\u6742\u7684Where\u6761\u4ef6\uff0c\u7136\u540e\u81ea\u5df1\u5b9a\u4e49SQL\u8bed\u53e5\u4e2d\u5269\u4e0b\u7684\u90e8\u5206\u3002<\/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-1568","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\u80fd02 \u2014 \u81ea\u5b9a\u4e49SQL | \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=1568\" \/>\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\u80fd02 \u2014 \u81ea\u5b9a\u4e49SQL | \u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2\" \/>\n<meta property=\"og:description\" content=\"\u5b66\u4e60 MP \u7684 \u81ea\u5b9a\u4e49SQL\uff1a\u6211\u4eec\u53ef\u4ee5\u5229\u7528MyBatisPlus\u7684Wrapper\u6765\u6784\u5efa\u590d\u6742\u7684Where\u6761\u4ef6\uff0c\u7136\u540e\u81ea\u5df1\u5b9a\u4e49SQL\u8bed\u53e5\u4e2d\u5269\u4e0b\u7684\u90e8\u5206\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tqazy.com\/?p=1568\" \/>\n<meta property=\"og:site_name\" content=\"\u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-05T10:50:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-05T12:59:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305104736839.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=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.tqazy.com\/?p=1568#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.tqazy.com\/?p=1568\"},\"author\":{\"name\":\"\u9676\u5176\",\"@id\":\"https:\/\/www.tqazy.com\/#\/schema\/person\/b2e89d56e70f15c261012417c5ef2c4e\"},\"headline\":\"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd02 \u2014 \u81ea\u5b9a\u4e49SQL\",\"datePublished\":\"2025-03-05T10:50:06+00:00\",\"dateModified\":\"2025-03-05T12:59:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.tqazy.com\/?p=1568\"},\"wordCount\":53,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.tqazy.com\/#\/schema\/person\/b2e89d56e70f15c261012417c5ef2c4e\"},\"image\":{\"@id\":\"https:\/\/www.tqazy.com\/?p=1568#primaryimage\"},\"thumbnailUrl\":\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305104736839.png\",\"keywords\":[\"MybatisPlus\"],\"articleSection\":[\"Spring Boot\",\"\u9ed1\u9a6c\u5546\u57ce\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.tqazy.com\/?p=1568#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tqazy.com\/?p=1568\",\"url\":\"https:\/\/www.tqazy.com\/?p=1568\",\"name\":\"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd02 \u2014 \u81ea\u5b9a\u4e49SQL | \u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2\",\"isPartOf\":{\"@id\":\"https:\/\/www.tqazy.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.tqazy.com\/?p=1568#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.tqazy.com\/?p=1568#primaryimage\"},\"thumbnailUrl\":\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305104736839.png\",\"datePublished\":\"2025-03-05T10:50:06+00:00\",\"dateModified\":\"2025-03-05T12:59:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.tqazy.com\/?p=1568#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tqazy.com\/?p=1568\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.tqazy.com\/?p=1568#primaryimage\",\"url\":\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305104736839.png\",\"contentUrl\":\"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305104736839.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tqazy.com\/?p=1568#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\u80fd02 \u2014 \u81ea\u5b9a\u4e49SQL\"}]},{\"@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\u80fd02 \u2014 \u81ea\u5b9a\u4e49SQL | \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=1568","og_locale":"zh_CN","og_type":"article","og_title":"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd02 \u2014 \u81ea\u5b9a\u4e49SQL | \u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2","og_description":"\u5b66\u4e60 MP \u7684 \u81ea\u5b9a\u4e49SQL\uff1a\u6211\u4eec\u53ef\u4ee5\u5229\u7528MyBatisPlus\u7684Wrapper\u6765\u6784\u5efa\u590d\u6742\u7684Where\u6761\u4ef6\uff0c\u7136\u540e\u81ea\u5df1\u5b9a\u4e49SQL\u8bed\u53e5\u4e2d\u5269\u4e0b\u7684\u90e8\u5206\u3002","og_url":"https:\/\/www.tqazy.com\/?p=1568","og_site_name":"\u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2","article_published_time":"2025-03-05T10:50:06+00:00","article_modified_time":"2025-03-05T12:59:21+00:00","og_image":[{"url":"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305104736839.png","type":"","width":"","height":""}],"author":"\u9676\u5176","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u9676\u5176","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.tqazy.com\/?p=1568#article","isPartOf":{"@id":"https:\/\/www.tqazy.com\/?p=1568"},"author":{"name":"\u9676\u5176","@id":"https:\/\/www.tqazy.com\/#\/schema\/person\/b2e89d56e70f15c261012417c5ef2c4e"},"headline":"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd02 \u2014 \u81ea\u5b9a\u4e49SQL","datePublished":"2025-03-05T10:50:06+00:00","dateModified":"2025-03-05T12:59:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.tqazy.com\/?p=1568"},"wordCount":53,"commentCount":0,"publisher":{"@id":"https:\/\/www.tqazy.com\/#\/schema\/person\/b2e89d56e70f15c261012417c5ef2c4e"},"image":{"@id":"https:\/\/www.tqazy.com\/?p=1568#primaryimage"},"thumbnailUrl":"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305104736839.png","keywords":["MybatisPlus"],"articleSection":["Spring Boot","\u9ed1\u9a6c\u5546\u57ce"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.tqazy.com\/?p=1568#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.tqazy.com\/?p=1568","url":"https:\/\/www.tqazy.com\/?p=1568","name":"MybatisPlus\uff08\u4e8c\uff09\u6838\u5fc3\u529f\u80fd02 \u2014 \u81ea\u5b9a\u4e49SQL | \u9676\u5176\u7684\u4e2a\u4eba\u535a\u5ba2","isPartOf":{"@id":"https:\/\/www.tqazy.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.tqazy.com\/?p=1568#primaryimage"},"image":{"@id":"https:\/\/www.tqazy.com\/?p=1568#primaryimage"},"thumbnailUrl":"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305104736839.png","datePublished":"2025-03-05T10:50:06+00:00","dateModified":"2025-03-05T12:59:21+00:00","breadcrumb":{"@id":"https:\/\/www.tqazy.com\/?p=1568#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tqazy.com\/?p=1568"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.tqazy.com\/?p=1568#primaryimage","url":"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305104736839.png","contentUrl":"https:\/\/oss.tqazy.com\/wordpress\/autoFile\/2025\/03\/20250305104736839.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.tqazy.com\/?p=1568#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\u80fd02 \u2014 \u81ea\u5b9a\u4e49SQL"}]},{"@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\/1568","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=1568"}],"version-history":[{"count":3,"href":"https:\/\/www.tqazy.com\/index.php?rest_route=\/wp\/v2\/posts\/1568\/revisions"}],"predecessor-version":[{"id":1604,"href":"https:\/\/www.tqazy.com\/index.php?rest_route=\/wp\/v2\/posts\/1568\/revisions\/1604"}],"wp:attachment":[{"href":"https:\/\/www.tqazy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tqazy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tqazy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}