![\"\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/09\/20260905131706-6a9c1652086e9.jpg\")
<\/p>\n\u6458\u8981：<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4e3b\u8981\u4ecb\u7ecdMyBatis-Plus\u6761\u4ef6\u6784\u9020\u5668，\u5305\u62ec\u5b9a\u4e49\u3001\u5e38\u89c1\u6784\u9020\u5668（QueryWrapper\u3001UpdateWrapper\u3001LambdaQueryWrapper\u3001LambdaUpdateWrapper）\u3001\u81ea\u5b9a\u4e49SQL\u3001\u793a\u4f8b，\u4ee5\u53ca\u4f7f\u7528\u5efa\u8bae.<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0MyBatis-Plus \u63d0\u4f9b\u4e86\u4e00\u5957\u5f3a\u5927\u7684\u6761\u4ef6\u6784\u9020\u5668（Wrapper），\u7528\u4e8e\u6784\u5efa\u590d\u6742\u7684\u00a0\u6570\u636e\u5e93\u67e5\u8be2\u6761\u4ef6\u3002Wrapper \u7c7b\u5141\u8bb8\u5f00\u53d1\u8005\u4ee5\u94fe\u5f0f\u8c03\u7528\u7684\u65b9\u5f0f\u6784\u9020\u67e5\u8be2\u6761\u4ef6，\u65e0\u9700\u7f16\u5199\u7e41\u7410\u7684 SQL \u8bed\u53e5，\u4ece\u800c\u63d0\u9ad8\u5f00\u53d1\u6548\u7387\u5e76\u51cf\u5c11 SQL \u6ce8\u5165\u7684\u98ce\u9669.<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Wrapper\u7c7b\u4e0b\u9762\u7684\u66f4\u591a\u64cd\u4f5c，\u8be6\u60c5\u89c1\u6761\u4ef6\u6784\u9020\u5668.<\/p>\n
<\/p>\n
AbstractWrapper：\u8fd9\u662f\u4e00\u4e2a\u62bd\u8c61\u57fa\u7c7b<\/span>，\u63d0\u4f9b\u4e86\u6240\u6709 Wrapper \u7c7b\u5171\u6709\u7684\u65b9\u6cd5\u548c\u5c5e\u6027\u3002\u5b83\u5b9a\u4e49\u4e86\u6761\u4ef6\u6784\u9020\u7684\u57fa\u672c\u903b\u8f91，\u5305\u62ec\u5b57\u6bb5（column）\u3001\u503c（value）\u3001\u64cd\u4f5c\u7b26（condition）\u7b49\u3002\u6240\u6709\u7684 QueryWrapper\u3001UpdateWrapper\u3001LambdaQueryWrapper \u548c LambdaUpdateWrapper \u90fd\u7ee7\u627f\u81ea AbstractWrapper.<\/p>\n<\/li>\n QueryWrapper：\u4e13\u95e8\u7528\u4e8e\u6784\u9020\u67e5\u8be2\u6761\u4ef6<\/span>，\u652f\u6301\u57fa\u672c\u7684\u7b49\u4e8e（eq）\u3001\u4e0d\u7b49\u4e8e（ne）\u3001\u5927\u4e8e（gt）\u3001\u5c0f\u4e8e（lt）\u7b49\u5404\u79cd\u5e38\u89c1\u64cd\u4f5c\u3002\u5b83\u5141\u8bb8\u4f60\u4ee5\u94fe\u5f0f\u8c03\u7528\u7684\u65b9\u5f0f\u6dfb\u52a0\u591a\u4e2a\u67e5\u8be2\u6761\u4ef6，\u5e76\u4e14\u53ef\u4ee5\u7ec4\u5408\u4f7f\u7528\u00a0and\u00a0\u548c\u00a0or\u00a0\u903b\u8f91.<\/p>\n<\/li>\n UpdateWrapper：\u7528\u4e8e\u6784\u9020\u66f4\u65b0\u6761\u4ef6<\/span>，\u53ef\u4ee5\u5728\u66f4\u65b0\u6570\u636e\u65f6\u6307\u5b9a\u6761\u4ef6\u3002\u4e0e QueryWrapper \u7c7b\u4f3c，\u5b83\u4e5f\u652f\u6301\u94fe\u5f0f\u8c03\u7528\u548c\u903b\u8f91\u7ec4\u5408\u3002\u4f7f\u7528 UpdateWrapper \u53ef\u4ee5\u5728\u4e0d\u521b\u5efa\u5b9e\u4f53\u5bf9\u8c61\u7684\u60c5\u51b5\u4e0b，\u76f4\u63a5\u8bbe\u7f6e\u66f4\u65b0\u5b57\u6bb5\u548c\u6761\u4ef6.<\/p>\n<\/li>\n LambdaQueryWrapper：\u8fd9\u662f\u4e00\u4e2a\u57fa\u4e8e Lambda \u8868\u8fbe\u5f0f\u7684\u67e5\u8be2\u6761\u4ef6\u6784\u9020\u5668<\/span>，\u5b83\u901a\u8fc7 Lambda \u8868\u8fbe\u5f0f\u6765\u5f15\u7528\u5b9e\u4f53\u7c7b\u7684\u5c5e\u6027，\u4ece\u800c\u907f\u514d\u4e86\u786c\u7f16\u7801\u5b57\u6bb5\u540d\u3002\u8fd9\u79cd\u65b9\u5f0f\u63d0\u9ad8\u4e86\u4ee3\u7801\u7684\u53ef\u8bfb\u6027\u548c\u53ef\u7ef4\u62a4\u6027，\u5c24\u5176\u662f\u5728\u5b57\u6bb5\u540d\u53ef\u80fd\u53d1\u751f\u53d8\u5316\u7684\u60c5\u51b5\u4e0b.<\/p>\n<\/li>\n LambdaUpdateWrapper：\u7c7b\u4f3c\u4e8e LambdaQueryWrapper，LambdaUpdateWrapper \u662f\u57fa\u4e8e Lambda \u8868\u8fbe\u5f0f\u7684\u66f4\u65b0\u6761\u4ef6\u6784\u9020\u5668<\/span>\u3002\u5b83\u5141\u8bb8\u4f60\u4f7f\u7528 Lambda \u8868\u8fbe\u5f0f\u6765\u6307\u5b9a\u66f4\u65b0\u5b57\u6bb5\u548c\u6761\u4ef6，\u540c\u6837\u907f\u514d\u4e86\u786c\u7f16\u7801\u5b57\u6bb5\u540d\u7684\u95ee\u9898.<\/p>\n<\/li>\n<\/ul>\n \u67e5\u8be2\u793a\u4f8b：<\/p>\n \u95ee\u9898：<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u67e5\u8be2\u4e00\u4e2a\u540d\u5b57\u5e26O\u7684，\u5b58\u6b3e\u5927\u4e8e\u7b49\u4e8e1000\u5143\u7684\u4eba\u7684id\u3001username\u3001info\u3001balance.<\/p>\n SQL\u8bed\u53e5：<\/p>\n SELECT id, username, info, balance FROM user WHERE username LIKE '%O%' AND balance >= 1000; <\/p>\n Wrapper：<\/p>\n @Test \/\/2.\u67e5\u8be2 \u66f4\u65b0\u793a\u4f8b\u4e00：<\/p>\n \u95ee\u9898：<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 \u66f4\u65b0\u7528\u6237\u540d\u4e3ajack\u7684\u7528\u6237\u4f59\u989d\u4e3a200.<\/p>\n SQL：<\/p>\n UPDATE user SET balance = 200 WHERE(username = "jack") <\/p>\n Wrapper：<\/p>\n @Test \/\/2.\u66f4\u65b0\u7684\u6761\u4ef6 \/\/3.\u6267\u884c\u66f4\u65b0 \u66f4\u65b0\u793a\u4f8b\u4e8c：<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 \u66f4\u65b0id\u4e3a1\u30012\u30014\u7528\u6237\u7684\u4f59\u989d，\u6263200\u4f59\u989d.<\/p>\n \u4e0a\u9762\u662f\u76f4\u63a5\u66f4\u65b0\u6570\u636e，\u5728\u66f4\u65b0\u4e2d，\u8fd8\u6709\u53e6\u4e00\u4e2d\u662f\u57fa\u4e8e\u539f\u6765\u7684\u6570\u636e\u8fdb\u884c\u52a0\u51cf\u4e58\u9664\u7b49\u8fd0\u7b97.<\/p>\n SQL：<\/p>\n UPDATE user SET balance = balance – 200 WHERE id in (1, 2, 4) <\/p>\n Wrapper：<\/p>\n @Test \/\/2\u3001\u66f4\u65b0\u6761\u4ef6 \/\/3\u3001\u6267\u884c\u66f4\u65b0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u76ee\u524d\u5927\u591a\u4f1a\u9009\u62e9\u4f7f\u7528\u00a0AbstractLambdaWrapper \u7684\u5b50\u7c7b，\u907f\u514d\u786c\u6027\u7f16\u7801，\u540c\u65f6\u65b9\u4fbf\u8fc1\u79fb\u6570\u636e\u5e93\u800c\u4e0d\u4f1a\u4f7f\u7528\u51fa\u73b0\u95ee\u9898.<\/p>\n \u4f7f\u7528\u793a\u4f8b（\u67e5\u8be2\u4e3a\u4f8b，\u95ee\u9898\u4f9d\u65e7\u91c7\u7528\u4e0a\u8ff0）：<\/p>\n \u95ee\u9898：<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u67e5\u8be2\u4e00\u4e2a\u540d\u5b57\u5e26O\u7684，\u5b58\u6b3e\u5927\u4e8e\u7b49\u4e8e1000\u5143\u7684\u4eba\u7684id\u3001username\u3001info\u3001balance.<\/p>\n LambdaWrapper：<\/p>\n @Test \/\/2.\u67e5\u8be2 \u00a0 \u7efc\u4e0a\u6240\u8ff0：<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 1\u3001\u5c3d\u91cf\u4f7f\u7528AbstrctLambdaWrapper\u4e0b\u9762\u7684\u5b50\u7c7b，\u907f\u514d\u786c\u6027\u7f16\u7801.<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 2\u3001\u5173\u4e8eUpdateWrapper\u548cLambdaUpdateWrapper\u5e38\u5e38\u53ea\u5728SET\u8bed\u53e5\u7279\u6b8a\u7684\u65f6\u5019\u624d\u4f1a\u91c7\u7528<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 3\u3001\u5927\u90e8\u5206\u90fd\u662f\u4f7f\u7528QueryWrapper\u548cLambdaQueryWrapper\u8fdb\u884cselect\u3001delete\u3001update\u7684where\u6761\u4ef6\u90e8\u5206.<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0MyBatis-Plus \u63d0\u4f9b\u4e86\u5f3a\u5927\u7684 Wrapper \u6761\u4ef6\u6784\u9020\u5668，\u5141\u8bb8\u5f00\u53d1\u8005\u81ea\u5b9a\u4e49 SQL \u8bed\u53e5，\u4ee5\u6ee1\u8db3\u66f4\u590d\u6742\u7684\u6570\u636e\u5e93\u67e5\u8be2\u9700\u6c42，\u7b80\u5355\u6765\u8bb2\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528Wrapper\u6765\u6784\u9020\u590d\u6742\u7684Where\u6761\u4ef6，\u7136\u540e\u81ea\u5df1\u5728\u5b9a\u4e49SQL\u7684\u5269\u4e0b\u8bed\u53e5.<\/p>\n \u4f7f\u7528\u539f\u56e0：<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 \u65e2\u6ee1\u8db3\u4e0d\u5728\u4e1a\u52a1\u5c42\u8fdb\u884cSQL\u8bed\u53e5\u7684\u7f16\u5199，\u9075\u5b88\u4f01\u4e1a\u89c4\u8303\u3002\u53c8\u5c06Mybatis\u2014Plus\u7684Wrappe\u7c7b\u751f\u6210SQL\u8bed\u53e5\u7684\u4fbf\u6377\u6027.<\/p>\n \u4f7f\u7528\u6b65\u9aa4：<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 1\u3001\u57fa\u4e8eWrapper\u6784\u5efaWhere\u6761\u4ef6.<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 2\u3001\u5728mapper\u65b9\u6cd5\u53c2\u6570\u4e2d\u7528Param\u6ce8\u89e3\u58f0\u660ewrapper\u53d8\u91cf\u540d\u79f0，\u5fc5\u987b\u662few（\u56fa\u5b9a\u5199\u6cd5）.<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 3\u3001\u81ea\u5b9a\u4e49SQL\u8bed\u53e5，\u5e76\u4f7f\u7528Wrapper\u6761\u4ef6.<\/p>\n \u793a\u4f8b：<\/p>\n \u00a0 \u00a0 \u00a0 \u00a0 \u5c06id\u5728\u6307\u5b9a\u8303\u56f4\u7684\u7528\u6237（\u4f8b：1\u30012\u30014）\u7684\u4f59\u989d\u6263\u51cf\u6307\u5b9a\u503c.<\/p>\n SQL：<\/p>\n <update id="updateBalanceByIds"> Wrapper + \u81ea\u5b9a\u4e49SQL：<\/p>\n 1\u3001\u57fa\u4e8eWrapper\u6784\u5efaWhere\u6761\u4ef6<\/p>\n List<Long> ids = List.of(1L, 2L, 4L); 2\u3001\u5728mapper\u65b9\u6cd5\u53c2\u6570\u4e2d\u7528Param\u6ce8\u89e3\u58f0\u660ewrapper\u53d8\u91cf\u540d\u79f0，\u5fc5\u987b\u662few（\u56fa\u5b9a\u5199\u6cd5）<\/p>\n void updateBalanceByIds(@Param("ew") LambdaQueryWrapper<User> wrapper, @Param("amount") int amount); <\/p>\n 3\u3001\u81ea\u5b9a\u4e49SQL\u8bed\u53e5，\u5e76\u4f7f\u7528Wrapper\u6761\u4ef6<\/p>\n <update id="updateBalanceByIds"> \u6458\u8981： \u4e3b\u8981\u4ecb\u7ecdMyBatis-Plus\u6761\u4ef6\u6784\u9020\u5668，\u5305\u62ec\u5b9a\u4e49\u3001\u5e38\u89c1\u6784\u9020\u5668（QueryWrapper\u3001UpdateWrapper\u3001LambdaQueryWrapper\u3001LambdaUpdateWrapper）\u3001\u81ea\u5b9a\u4e49SQL\u3001\u793a\u4f8b，\u4ee5\u53ca\u4f7f\u7528\u5efa\u8bae.
\n
\nvoid QueryWrapper(){
\n \/\/1.\u6784\u5efa\u67e5\u8be2\u6761\u4ef6
\n QueryWrapper<User> wrapper = new QueryWrapper<User>()
\n .select("id", "username", "info", "balance")
\n .like("username", "o")
\n .ge("balance", "1000");<\/p>\n
\n userMapper.selectList(wrapper);
\n} <\/p>\n
\n
\nvoid testupdateByQueryWrapper(){
\n \/\/1.\u8981\u66f4\u65b0\u7684\u6570\u636e
\n User user = new User();
\n user.setBalance(200);<\/p>\n
\n QueryWrapper<User> wrapper = new QueryWrapper<User>().eq("username", "jack");<\/p>\n
\n userMapper.update(user, wrapper);
\n) <\/p>\n
\n
\nvoid testUpdateWrapper(){
\n \/\/1\u3001\u6784\u9020ids
\n List<long> ids = List.of(1L, 2L, 4L);<\/p>\n
\n UpdateWrapper<User> wrapper = new UpdateWrapper<User>()
\n .setSql("balance = balance – 200")
\n .in("id", ids);<\/p>\n
\n userMapper.update(null,wrapper);
\n} <\/p>\n
\nvoid LambdaQueryWrapper(){
\n \/\/1.\u6784\u5efa\u67e5\u8be2\u6761\u4ef6
\n LambdaQueryWrapper<User> wrapper = new LambdaQueryWrapper<User>()
\n .select(User::getId, User::getUsername, User::getInfo, User::getBalance)
\n .like(User::getUsername, "o")
\n .ge(User::getBalance, "1000");<\/p>\n
\n userMapper.selectList(wrapper);
\n} <\/p>\n\u4e09\u3001\u81ea\u5b9a\u4e49SQL<\/h2>\n
\n UPDATE user
\n SET balance = balance – #{amount}
\n WHERE id IN
\n <foreach collection="ids" separator="," item="id" open="("close=")">
\n #{id}
\n <\/foreach>
\n<\/update> <\/p>\n
\n int amount = 200;
\n \/\/1\u3001\u6784\u5efa\u6761\u4ef6
\n LambdaQueryWrapper<User> wrapper = new LambdaQueryWrapper<User>().in(User::getIds, ids);
\n \/\/2\u3001\u81ea\u5b9a\u4e49SQL\u65b9\u6cd5\u8c03\u7528
\n userMapper.updateBalanceByIds(wrapper, amount); <\/p>\n
\n UPDATE user SET balance = balance – #{amount} ${ew.customSqlSegment}
\n<\/update><\/p>\n","protected":false},"excerpt":{"rendered":"
\n\u4e00\u3001\u5b9a\u4e49 MyBatis-Plus \u63d0\u4f9b\u4e86\u4e00\u5957\u5f3a\u5927\u7684\u6761\u4ef6\u6784\u9020\u5668（Wrapper），\u7528\u4e8e\u6784\u5efa\u590d\u6742\u7684\u00a0\u6570\u636e\u5e93\u67e5\u8be2\u6761\u4ef6\u3002Wrap<\/p>\n","protected":false},"author":2,"featured_media":100962,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[1769,100],"topic":[],"class_list":["post-100963","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-mybatis","tag-100"],"yoast_head":"\n