{"id":1132,"date":"2025-07-28T23:27:00","date_gmt":"2025-07-28T15:27:00","guid":{"rendered":"https:\/\/www.hgfwq.com\/blog\/?p=1132"},"modified":"2025-07-28T23:27:00","modified_gmt":"2025-07-28T15:27:00","slug":"mybatis-plus%e6%a8%a1%e7%b3%8a%e6%9f%a5%e8%af%a2%e6%94%af%e6%8c%81%e5%a4%9a%e5%b0%91%e7%a7%8d%e6%96%b9%e6%b3%95%e4%b8%8e%e7%b1%bb%e5%9e%8b%e8%a7%a3%e6%9e%90","status":"publish","type":"post","link":"https:\/\/www.hgfwq.com\/blog\/1132.html","title":{"rendered":"MyBatis-Plus\u6a21\u7cca\u67e5\u8be2\u652f\u6301\u591a\u5c11\u79cd\u65b9\u6cd5\u4e0e\u7c7b\u578b\u89e3\u6790"},"content":{"rendered":"<p><h3>MyBatis-Plus\u6a21\u7cca\u67e5\u8be2\u6982\u8ff0<\/h3>\n<\/p>\n<p style=\"text-align:center\"><img decoding=\"async\" src=\"https:\/\/www.hgfwq.com\/blog\/wp-content\/uploads\/2025\/07\/5C9x4n4CsB.jpg\" alt=\"MyBatis-Plus\u6a21\u7cca\u67e5\u8be2\u652f\u6301\u591a\u5c11\u79cd\u65b9\u6cd5\u4e0e\u7c7b\u578b\u89e3\u6790\" title=\"MyBatis-Plus\u6a21\u7cca\u67e5\u8be2\u652f\u6301\u591a\u5c11\u79cd\u65b9\u6cd5\u4e0e\u7c7b\u578b\u89e3\u6790\"><\/p>\n<p><p>MyBatis-Plus\u662f\u4e00\u6b3e\u4f18\u79c0\u7684Java\u6301\u4e45\u5c42\u6846\u67b6\uff0c\u5b83\u7b80\u5316\u4e86\u6570\u636e\u5e93\u64cd\u4f5c\uff0c\u63d0\u4f9b\u4e86\u591a\u79cd\u5185\u7f6e\u7684\u67e5\u8be2\u529f\u80fd\uff0c\u5176\u4e2d\u5305\u62ec\u6a21\u7cca\u67e5\u8be2\u3002\u6a21\u7cca\u67e5\u8be2\u5728\u6570\u636e\u5e93\u64cd\u4f5c\u4e2d\u975e\u5e38\u5e38\u89c1\uff0c\u7528\u4e8e\u6839\u636e\u90e8\u5206\u5b57\u6bb5\u5185\u5bb9\u67e5\u627e\u6570\u636e\u3002\u5728MyBatis-Plus\u4e2d\uff0c\u6a21\u7cca\u67e5\u8be2\u53ef\u4ee5\u901a\u8fc7\u591a\u79cd\u65b9\u5f0f\u8fdb\u884c\uff0c\u5305\u62ec\u4f7f\u7528\u6ce8\u89e3\u3001Lambda\u8868\u8fbe\u5f0f\u548cXML\u6620\u5c04\u6587\u4ef6\u3002<\/p>\n<\/p>\n<p><h3>MyBatis-Plus\u6a21\u7cca\u67e5\u8be2\u7c7b\u578b<\/h3>\n<\/p>\n<p><p>MyBatis-Plus\u652f\u6301\u591a\u79cd\u6a21\u7cca\u67e5\u8be2\u7c7b\u578b\uff0c\u5305\u62ec\uff1a<\/p>\n<\/p>\n<ul>\n<li>\u6a21\u7cca\u5339\u914d\uff1a`LIKE`\u64cd\u4f5c\u7b26<\/li>\n<li>\u524d\u7f00\u5339\u914d\uff1a`LIKE &#8216;%value%&#8217;`<\/li>\n<li>\u540e\u7f00\u5339\u914d\uff1a`LIKE &#8216;%value&#8217;`<\/li>\n<li>\u4e2d\u95f4\u5339\u914d\uff1a`LIKE &#8216;%value%&#8217;`<\/li>\n<\/ul>\n<p><h3>MyBatis-Plus\u6a21\u7cca\u67e5\u8be2\u65b9\u6cd5<\/h3>\n<\/p>\n<p><p>\u5728MyBatis-Plus\u4e2d\uff0c\u5b9e\u73b0\u6a21\u7cca\u67e5\u8be2\u4e3b\u8981\u6709\u4ee5\u4e0b\u51e0\u79cd\u65b9\u6cd5\uff1a<\/p>\n<\/p>\n<p><pre><code>\/\/ \u4f7f\u7528LambdaQueryWrapper<\/p>\r\n<p>QueryWrapper<User> queryWrapper = new QueryWrapper<>();<\/p>\r\n<p>queryWrapper.like(\"name\", \"\u5f20\");<\/p>\r\n<p>List<User> users = userMapper.selectList(queryWrapper);<\/p>\r\n\r\n<p>\/\/ \u4f7f\u7528\u6ce8\u89e3<\/p>\r\n<p>@Select(\"SELECT  FROM user WHERE name LIKE CONCAT('%', {name}, '%')\")<\/p>\r\n<p>List<User> getUsersByName(String name);<\/p>\r\n\r\n<p>\/\/ \u4f7f\u7528XML\u6620\u5c04\u6587\u4ef6<\/p>\r\n<p><select id=\"getUsersByName\" resultType=\"User\"><\/p>\r\n<p>  SELECT  FROM user WHERE name LIKE CONCAT('%', {name}, '%')<\/p>\r\n<p><\/select><\/p>\r\n<p><\/code><\/pre>\n<\/p>\n<p><h3>\u63a8\u8350\u4f7f\u7528LambdaQueryWrapper<\/h3>\n<\/p>\n<p><p>\u5728MyBatis-Plus\u4e2d\uff0c\u63a8\u8350\u4f7f\u7528LambdaQueryWrapper\u8fdb\u884c\u6a21\u7cca\u67e5\u8be2\u3002LambdaQueryWrapper\u63d0\u4f9b\u4e86\u7b80\u6d01\u7684\u94fe\u5f0f\u8c03\u7528\u65b9\u5f0f\uff0c\u6613\u4e8e\u9605\u8bfb\u548c\u7ef4\u62a4\u3002\u4ee5\u4e0b\u662f\u4e00\u4e2a\u4f7f\u7528LambdaQueryWrapper\u8fdb\u884c\u6a21\u7cca\u67e5\u8be2\u7684\u793a\u4f8b\uff1a<\/p>\n<\/p>\n<p><pre><code>QueryWrapper<User> queryWrapper = new QueryWrapper<>();<\/p>\r\n<p>queryWrapper.like(User::getName, \"\u5f20\");<\/p>\r\n<p>List<User> users = userMapper.selectList(queryWrapper);<\/p>\r\n<p><\/code><\/pre>\n<\/p>\n<p><h3>\u4e3a\u4ec0\u4e48\u4f7f\u7528LambdaQueryWrapper<\/h3>\n<\/p>\n<p><p>\u4f7f\u7528LambdaQueryWrapper\u8fdb\u884c\u6a21\u7cca\u67e5\u8be2\u7684\u539f\u56e0\u6709\u4ee5\u4e0b\u51e0\u70b9\uff1a<\/p>\n<\/p>\n<ul>\n<li>\u4ee3\u7801\u7b80\u6d01\uff1a\u901a\u8fc7Lambda\u8868\u8fbe\u5f0f\u76f4\u63a5\u6620\u5c04\u5230\u5b9e\u4f53\u7c7b\u7684\u65b9\u6cd5\uff0c\u65e0\u9700\u624b\u52a8\u62fc\u63a5SQL\u8bed\u53e5\u3002<\/li>\n<li>\u6613\u4e8e\u7ef4\u62a4\uff1a\u901a\u8fc7\u94fe\u5f0f\u8c03\u7528\uff0c\u53ef\u4ee5\u65b9\u4fbf\u5730\u6dfb\u52a0\u591a\u4e2a\u67e5\u8be2\u6761\u4ef6\u3002<\/li>\n<li>\u652f\u6301\u591a\u79cd\u67e5\u8be2\u7c7b\u578b\uff1a\u5305\u62ec\u6a21\u7cca\u67e5\u8be2\u3001\u8303\u56f4\u67e5\u8be2\u3001\u6392\u5e8f\u7b49\u3002<\/li>\n<\/ul>\n<p><h3>\u95ee\u7b54\u73af\u8282<\/h3>\n<\/p>\n<p><p><b>\u95ee\uff1a<\/b>MyBatis-Plus\u7684\u6a21\u7cca\u67e5\u8be2\u4e0e\u539f\u751fSQL\u7684\u6a21\u7cca\u67e5\u8be2\u6709\u4ec0\u4e48\u533a\u522b\uff1f<\/p>\n<\/p>\n<p><p>MyBatis-Plus\u7684\u6a21\u7cca\u67e5\u8be2\u901a\u8fc7\u5c01\u88c5\u4e86SQL\u8bed\u53e5\uff0c\u63d0\u4f9b\u4e86\u66f4\u52a0\u7b80\u6d01\u3001\u6613\u7528\u7684\u67e5\u8be2\u65b9\u5f0f\u3002\u4e0e\u539f\u751fSQL\u7684\u6a21\u7cca\u67e5\u8be2\u76f8\u6bd4\uff0cMyBatis-Plus\u7684\u6a21\u7cca\u67e5\u8be2\u66f4\u52a0\u6ce8\u91cd\u4ee3\u7801\u7684\u53ef\u8bfb\u6027\u548c\u53ef\u7ef4\u62a4\u6027\u3002<\/p>\n<\/p>\n<p><p><b>\u95ee\uff1a<\/b>\u5728MyBatis-Plus\u4e2d\uff0c\u5982\u4f55\u5b9e\u73b0\u591a\u4e2a\u5b57\u6bb5\u7684\u6a21\u7cca\u67e5\u8be2\uff1f<\/p>\n<\/p>\n<p><p>\u5728MyBatis-Plus\u4e2d\uff0c\u53ef\u4ee5\u4f7f\u7528`or`\u65b9\u6cd5\u5b9e\u73b0\u591a\u4e2a\u5b57\u6bb5\u7684\u6a21\u7cca\u67e5\u8be2\u3002\u4ee5\u4e0b\u662f\u4e00\u4e2a\u793a\u4f8b\uff1a<\/p>\n<\/p>\n<p><pre><code>QueryWrapper<User> queryWrapper = new QueryWrapper<>();<\/p>\r\n<p>queryWrapper.like(\"name\", \"\u5f20\")<\/p>\r\n<p>           .or().like(\"email\", \"zhang@example.com\");<\/p>\r\n<p>List<User> users = userMapper.selectList(queryWrapper);<\/p>\r\n<p><\/code><\/pre>\n<\/p>\n<p><p><b>\u95ee\uff1a<\/b>MyBatis-Plus\u7684\u6a21\u7cca\u67e5\u8be2\u662f\u5426\u652f\u6301\u4e2d\u6587\uff1f<\/p>\n<\/p>\n<p><p>MyBatis-Plus\u7684\u6a21\u7cca\u67e5\u8be2\u652f\u6301\u4e2d\u6587\u3002\u4f46\u5728\u5b9e\u9645\u4f7f\u7528\u4e2d\uff0c\u9700\u8981\u6ce8\u610f\u6570\u636e\u5e93\u7684\u7f16\u7801\u548c\u914d\u7f6e\uff0c\u786e\u4fdd\u80fd\u591f\u6b63\u786e\u5904\u7406\u4e2d\u6587\u6570\u636e\u3002<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MyBatis-Plus\u6a21\u7cca\u67e5\u8be2\u6982\u8ff0 MyBatis-Plus\u662f\u4e00\u6b3e\u4f18\u79c0\u7684Java\u6301\u4e45\u5c42\u6846\u67b6\uff0c\u5b83\u7b80\u5316\u4e86\u6570\u636e\u5e93\u64cd\u4f5c\uff0c\u63d0\u4f9b\u4e86\u591a\u79cd\u5185\u7f6e\u7684\u67e5\u8be2\u529f\u80fd\uff0c\u5176\u4e2d\u5305\u62ec\u6a21\u7cca\u67e5\u8be2\u3002\u6a21\u7cca\u67e5\u8be2\u5728\u6570\u636e\u5e93\u64cd\u4f5c\u4e2d\u975e\u5e38\u5e38\u89c1\uff0c\u7528\u4e8e\u6839\u636e\u90e8\u5206\u5b57\u6bb5\u5185\u5bb9\u67e5\u627e\u6570\u636e\u3002\u5728MyBatis-P&#8230;<\/p>\n","protected":false},"author":1,"featured_media":1133,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[203,204,458],"topic":[],"class_list":["post-1132","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-haiwai","tag-mybatis","tag-plus","tag-458"],"_links":{"self":[{"href":"https:\/\/www.hgfwq.com\/blog\/wp-json\/wp\/v2\/posts\/1132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hgfwq.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hgfwq.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hgfwq.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hgfwq.com\/blog\/wp-json\/wp\/v2\/comments?post=1132"}],"version-history":[{"count":1,"href":"https:\/\/www.hgfwq.com\/blog\/wp-json\/wp\/v2\/posts\/1132\/revisions"}],"predecessor-version":[{"id":1135,"href":"https:\/\/www.hgfwq.com\/blog\/wp-json\/wp\/v2\/posts\/1132\/revisions\/1135"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hgfwq.com\/blog\/wp-json\/wp\/v2\/media\/1133"}],"wp:attachment":[{"href":"https:\/\/www.hgfwq.com\/blog\/wp-json\/wp\/v2\/media?parent=1132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hgfwq.com\/blog\/wp-json\/wp\/v2\/categories?post=1132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hgfwq.com\/blog\/wp-json\/wp\/v2\/tags?post=1132"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.hgfwq.com\/blog\/wp-json\/wp\/v2\/topic?post=1132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}