{"id":750,"date":"2025-03-06T18:07:16","date_gmt":"2025-03-06T10:07:16","guid":{"rendered":"http:\/\/www.cmd137blog.top\/?p=750"},"modified":"2025-03-12T15:26:45","modified_gmt":"2025-03-12T07:26:45","slug":"mybatisplus","status":"publish","type":"post","link":"http:\/\/www.cmd137blog.top\/?p=750","title":{"rendered":"MybatisPlus"},"content":{"rendered":"\n<p><a href=\"https:\/\/baomidou.com\/\">MyBatis-Plus \ud83d\ude80 \u4e3a\u7b80\u5316\u5f00\u53d1\u800c\u751f<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/b11et3un53m.feishu.cn\/wiki\/PsyawI04ei2FQykqfcPcmd7Dnsc\">day01-MybatisPlus &#8211; \u98de\u4e66\u4e91\u6587\u6863<\/a><\/p>\n\n\n\n<h1 class=\"wp-block-heading\">1 \u4f7f\u7528\u6b65\u9aa4\uff1a<\/h1>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5f15\u5165\u8d77\u6b65\u4f9d\u8d56\uff1amybatisPlus\u7684start\u4f9d\u8d56\u96c6\u6210\u4e86mybatis\u548cmybatisPlus\u7684\u6240\u6709\u529f\u80fd\uff0c\u56e0\u6b64\u4e0d\u518d\u5f15\u5165mybatis\u7684\u4f9d\u8d56\u3002<\/li>\n\n\n\n<li>\u4f7f\u76ee\u6807mapper\u7ee7\u627f mybatisPlus\u63d0\u4f9b\u7684BaseMapper\u63a5\u53e3<\/li>\n<\/ol>\n\n\n\n<h1 class=\"wp-block-heading\">2 \u5e38\u7528\u6ce8\u89e3\uff1a<\/h1>\n\n\n\n<p>MybatisPlus\u5982\u4f55\u77e5\u9053\u6211\u4eec\u8981\u67e5\u8be2\u7684\u662f\u54ea\u5f20\u8868\uff1f\u8868\u4e2d\u6709\u54ea\u4e9b\u5b57\u6bb5\u5462\uff1f<\/p>\n\n\n\n<p>MybatisPlus\u5c31\u662f\u6839\u636ePO\u5b9e\u4f53(\u6cdb\u578b\u4e2d\u6307\u5b9a\u7684\u7c7b)\u7684\u4fe1\u606f\u6765\u63a8\u65ad\u51fa\u8868\u7684\u4fe1\u606f\uff0c\u4ece\u800c\u751f\u6210SQL\u7684\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>MybatisPlus\u4f1a\u628aPO\u5b9e\u4f53\u7684\u7c7b\u540d\u9a7c\u5cf0\u8f6c\u4e0b\u5212\u7ebf\u4f5c\u4e3a\u8868\u540d<\/li>\n\n\n\n<li>MybatisPlus\u4f1a\u628aPO\u5b9e\u4f53\u7684\u6240\u6709\u53d8\u91cf\u540d\u9a7c\u5cf0\u8f6c\u4e0b\u5212\u7ebf\u4f5c\u4e3a\u8868\u7684\u5b57\u6bb5\u540d\uff0c\u5e76\u6839\u636e\u53d8\u91cf\u7c7b\u578b\u63a8\u65ad\u5b57\u6bb5\u7c7b\u578b<\/li>\n\n\n\n<li>MybatisPlus\u4f1a\u628a\u540d\u4e3aid\u7684\u5b57\u6bb5\u4f5c\u4e3a\u4e3b\u952e<\/li>\n<\/ul>\n\n\n\n<p>\u4f46\u5f88\u591a\u60c5\u51b5\u4e0b\uff0c\u9ed8\u8ba4\u7684\u5b9e\u73b0\u4e0e\u5b9e\u9645\u573a\u666f\u4e0d\u7b26\uff0c\u56e0\u6b64MybatisPlus\u63d0\u4f9b\u4e86\u4e00\u4e9b\u6ce8\u89e3\u4fbf\u4e8e\u6211\u4eec\u58f0\u660e\u8868\u4fe1\u606f\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2.1.@<\/strong><strong>TableName<\/strong><\/h2>\n\n\n\n<p>\u8bf4\u660e\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u63cf\u8ff0\uff1a\u8868\u540d\u6ce8\u89e3\uff0c\u6807\u8bc6\u5b9e\u4f53\u7c7b\u5bf9\u5e94\u7684\u8868<\/li>\n\n\n\n<li><strong>\u4f7f\u7528\u4f4d\u7f6e\uff1a\u5b9e\u4f53\u7c7b<\/strong><\/li>\n<\/ul>\n\n\n\n<p>\u793a\u4f8b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>@TableName(\"user\")\npublic class User {\n    private Long id;\n    private String name;\n}<\/code><\/pre>\n\n\n\n<p>TableName\u6ce8\u89e3\u9664\u4e86\u6307\u5b9a\u8868\u540d\u4ee5\u5916\uff0c\u8fd8\u53ef\u4ee5\u6307\u5b9a\u5f88\u591a\u5176\u5b83\u5c5e\u6027\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>\u5c5e\u6027<\/strong><\/td><td><strong>\u7c7b\u578b<\/strong><\/td><td><strong>\u5fc5\u987b\u6307\u5b9a<\/strong><\/td><td><strong>\u9ed8\u8ba4\u503c<\/strong><\/td><td><strong>\u63cf\u8ff0<\/strong><\/td><\/tr><tr><td>value<\/td><td>String<\/td><td>\u5426<\/td><td>&#8220;&#8221;<\/td><td>\u8868\u540d<\/td><\/tr><tr><td>schema<\/td><td>String<\/td><td>\u5426<\/td><td>&#8220;&#8221;<\/td><td>schema<\/td><\/tr><tr><td>keepGlobalPrefix<\/td><td>boolean<\/td><td>\u5426<\/td><td>false<\/td><td>\u662f\u5426\u4fdd\u6301\u4f7f\u7528\u5168\u5c40\u7684 tablePrefix \u7684\u503c\uff08\u5f53\u5168\u5c40 tablePrefix \u751f\u6548\u65f6\uff09<\/td><\/tr><tr><td>resultMap<\/td><td>String<\/td><td>\u5426<\/td><td>&#8220;&#8221;<\/td><td>xml \u4e2d resultMap \u7684 id\uff08\u7528\u4e8e\u6ee1\u8db3\u7279\u5b9a\u7c7b\u578b\u7684\u5b9e\u4f53\u7c7b\u5bf9\u8c61\u7ed1\u5b9a\uff09<\/td><\/tr><tr><td>autoResultMap<\/td><td>boolean<\/td><td>\u5426<\/td><td>false<\/td><td>\u662f\u5426\u81ea\u52a8\u6784\u5efa resultMap \u5e76\u4f7f\u7528\uff08\u5982\u679c\u8bbe\u7f6e resultMap \u5219\u4e0d\u4f1a\u8fdb\u884c resultMap \u7684\u81ea\u52a8\u6784\u5efa\u4e0e\u6ce8\u5165\uff09<\/td><\/tr><tr><td>excludeProperty<\/td><td>String[]<\/td><td>\u5426<\/td><td>{}<\/td><td>\u9700\u8981\u6392\u9664\u7684\u5c5e\u6027\u540d @since 3.3.1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2.2.@TableId<\/strong><\/h2>\n\n\n\n<p>\u8bf4\u660e\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u63cf\u8ff0\uff1a\u4e3b\u952e\u6ce8\u89e3\uff0c\u6807\u8bc6\u5b9e\u4f53\u7c7b\u4e2d\u7684\u4e3b\u952e\u5b57\u6bb5<\/li>\n\n\n\n<li>\u4f7f\u7528\u4f4d\u7f6e\uff1a\u5b9e\u4f53\u7c7b\u7684\u4e3b\u952e\u5b57\u6bb5<\/li>\n<\/ul>\n\n\n\n<p>\u793a\u4f8b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>@TableName(\"user\")\npublic class User {\n    @TableId\n    private Long id;\n    private String name;\n}<\/code><\/pre>\n\n\n\n<p><code>TableId<\/code>\u6ce8\u89e3\u652f\u6301\u4e24\u4e2a\u5c5e\u6027\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><strong>\u5c5e\u6027<\/strong><\/th><th><strong>\u7c7b\u578b<\/strong><\/th><th><strong>\u5fc5\u987b\u6307\u5b9a<\/strong><\/th><th><strong>\u9ed8\u8ba4\u503c<\/strong><\/th><th><strong>\u63cf\u8ff0<\/strong><\/th><\/tr><\/thead><tbody><tr><td>value<\/td><td>String<\/td><td>\u5426<\/td><td>&#8220;&#8221;<\/td><td>\u8868\u540d<\/td><\/tr><tr><td>type<\/td><td>Enum<\/td><td>\u5426<\/td><td>IdType.NONE<\/td><td>\u6307\u5b9a\u4e3b\u952e\u7c7b\u578b<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><code>IdType<\/code>\u652f\u6301\u7684\u7c7b\u578b\u6709\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><strong>\u503c<\/strong><\/th><th><strong>\u63cf\u8ff0<\/strong><\/th><\/tr><\/thead><tbody><tr><td>AUTO<\/td><td>\u6570\u636e\u5e93 ID \u81ea\u589e<\/td><\/tr><tr><td>NONE<\/td><td>\u65e0\u72b6\u6001\uff0c\u8be5\u7c7b\u578b\u4e3a\u672a\u8bbe\u7f6e\u4e3b\u952e\u7c7b\u578b\uff08\u6ce8\u89e3\u91cc\u7b49\u4e8e\u8ddf\u968f\u5168\u5c40\uff0c\u5168\u5c40\u91cc\u7ea6\u7b49\u4e8e INPUT\uff09<\/td><\/tr><tr><td>INPUT<\/td><td>insert \u524d\u81ea\u884c set \u4e3b\u952e\u503c<\/td><\/tr><tr><td>ASSIGN_ID\uff08<strong>\u9ed8\u8ba4\u503c<\/strong>\uff09<\/td><td>\u5206\u914d ID(\u4e3b\u952e\u7c7b\u578b\u4e3a Number(Long \u548c Integer)\u6216 String)(since 3.3.0),\u4f7f\u7528\u63a5\u53e3IdentifierGenerator\u7684\u65b9\u6cd5nextId(\u9ed8\u8ba4\u5b9e\u73b0\u7c7b\u4e3aDefaultIdentifierGenerator\u96ea\u82b1\u7b97\u6cd5)<\/td><\/tr><tr><td>ASSIGN_UUID<\/td><td>\u5206\u914d UUID,\u4e3b\u952e\u7c7b\u578b\u4e3a String(since 3.3.0),\u4f7f\u7528\u63a5\u53e3IdentifierGenerator\u7684\u65b9\u6cd5nextUUID(\u9ed8\u8ba4 default \u65b9\u6cd5)<\/td><\/tr><tr><td><s>ID_WORKER<\/s><\/td><td>\u5206\u5e03\u5f0f\u5168\u5c40\u552f\u4e00 ID \u957f\u6574\u578b\u7c7b\u578b(please use ASSIGN_ID)<\/td><\/tr><tr><td><s>UUID<\/s><\/td><td>32 \u4f4d UUID \u5b57\u7b26\u4e32(please use ASSIGN_UUID)<\/td><\/tr><tr><td><s>ID_WORKER_STR<\/s><\/td><td>\u5206\u5e03\u5f0f\u5168\u5c40\u552f\u4e00 ID \u5b57\u7b26\u4e32\u7c7b\u578b(please use ASSIGN_ID)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u8fd9\u91cc\u6bd4\u8f83\u5e38\u89c1\u7684\u6709\u4e09\u79cd\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>AUTO<\/code>\uff1a\u5229\u7528\u6570\u636e\u5e93\u7684id\u81ea\u589e\u957f<\/li>\n\n\n\n<li><code>INPUT<\/code>\uff1a\u624b\u52a8\u751f\u6210id<\/li>\n\n\n\n<li><code>ASSIGN_ID<\/code>\uff1a\u96ea\u82b1\u7b97\u6cd5\u751f\u6210<code>Long<\/code>\u7c7b\u578b\u7684\u5168\u5c40\u552f\u4e00id\uff0c\u8fd9\u662f\u9ed8\u8ba4\u7684ID\u7b56\u7565<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2.3.@TableField<\/strong><\/h2>\n\n\n\n<p>\u8bf4\u660e\uff1a<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\u63cf\u8ff0\uff1a\u666e\u901a\u5b57\u6bb5\u6ce8\u89e3<\/p>\n<\/blockquote>\n\n\n\n<p>\u793a\u4f8b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>@TableName(\"user\")\npublic class User {\n    @TableId\n    private Long id;\n    private String name;\n    private Integer age;\n    @TableField(is_married\")\n    private Boolean isMarried;\n    @TableField(\"`concat`\")\n    private String concat;\n}<\/code><\/pre>\n\n\n\n<p>\u4e00\u822c\u60c5\u51b5\u4e0b\u6211\u4eec\u5e76\u4e0d\u9700\u8981\u7ed9\u5b57\u6bb5\u6dfb\u52a0<code>@TableField<\/code>\u6ce8\u89e3\uff0c\u4e00\u4e9b\u7279\u6b8a\u60c5\u51b5\u9664\u5916\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6210\u5458\u53d8\u91cf\u540d\u4e0e\u6570\u636e\u5e93\u5b57\u6bb5\u540d\u4e0d\u4e00\u81f4<\/li>\n\n\n\n<li>\u6210\u5458\u53d8\u91cf\u662f\u4ee5<code>isXXX<\/code>\u547d\u540d\uff0c\u6309\u7167<code>JavaBean<\/code>\u7684\u89c4\u8303\uff0c<code>MybatisPlus<\/code>\u8bc6\u522b\u5b57\u6bb5\u65f6\u4f1a\u628a<code>is<\/code>\u53bb\u9664\uff0c\u8fd9\u5c31\u5bfc\u81f4\u4e0e\u6570\u636e\u5e93\u4e0d\u7b26\u3002<\/li>\n\n\n\n<li>\u6210\u5458\u53d8\u91cf\u540d\u4e0e\u6570\u636e\u5e93\u4e00\u81f4\uff0c\u4f46\u662f\u4e0e\u6570\u636e\u5e93\u7684\u5173\u952e\u5b57\u51b2\u7a81\u3002\u4f7f\u7528<code>@TableField<\/code>\u6ce8\u89e3\u7ed9\u5b57\u6bb5\u540d\u6dfb\u52a0\u8f6c\u4e49\u5b57\u7b26\uff1a<code>``<\/code><\/li>\n<\/ul>\n\n\n\n<p>\u652f\u6301\u7684\u5176\u5b83\u5c5e\u6027\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>\u5c5e\u6027<\/strong><\/td><td><strong>\u7c7b\u578b<\/strong><\/td><td><strong>\u5fc5\u586b<\/strong><\/td><td><strong>\u9ed8\u8ba4\u503c<\/strong><\/td><td><strong>\u63cf\u8ff0<\/strong><\/td><\/tr><tr><td>value<\/td><td>String<\/td><td>\u5426<\/td><td>&#8220;&#8221;<\/td><td>\u6570\u636e\u5e93\u5b57\u6bb5\u540d<\/td><\/tr><tr><td>exist<\/td><td>boolean<\/td><td>\u5426<\/td><td>true<\/td><td>\u662f\u5426\u4e3a\u6570\u636e\u5e93\u8868\u5b57\u6bb5<\/td><\/tr><tr><td>condition<\/td><td>String<\/td><td>\u5426<\/td><td>&#8220;&#8221;<\/td><td>\u5b57\u6bb5 where \u5b9e\u4f53\u67e5\u8be2\u6bd4\u8f83\u6761\u4ef6\uff0c\u6709\u503c\u8bbe\u7f6e\u5219\u6309\u8bbe\u7f6e\u7684\u503c\u4e3a\u51c6\uff0c\u6ca1\u6709\u5219\u4e3a\u9ed8\u8ba4\u5168\u5c40\u7684 %s=#{%s}\uff0c<a href=\"https:\/\/github.com\/baomidou\/mybatis-plus\/blob\/3.0\/mybatis-plus-annotation\/src\/main\/java\/com\/baomidou\/mybatisplus\/annotation\/SqlCondition.java\">\u53c2\u8003(opens new window)<\/a><\/td><\/tr><tr><td>update<\/td><td>String<\/td><td>\u5426<\/td><td>&#8220;&#8221;<\/td><td>\u5b57\u6bb5 update set \u90e8\u5206\u6ce8\u5165\uff0c\u4f8b\u5982\uff1a\u5f53\u5728version\u5b57\u6bb5\u4e0a\u6ce8\u89e3update=&#8221;%s+1&#8243; \u8868\u793a\u66f4\u65b0\u65f6\u4f1a set version=version+1 \uff08\u8be5\u5c5e\u6027\u4f18\u5148\u7ea7\u9ad8\u4e8e el \u5c5e\u6027\uff09<\/td><\/tr><tr><td>insertStrategy<\/td><td>Enum<\/td><td>\u5426<\/td><td>FieldStrategy.DEFAULT<\/td><td>\u4e3e\u4f8b\uff1aNOT_NULL insert into table_a(&lt;if test=&#8221;columnProperty != null&#8221;&gt;column&lt;\/if&gt;) values (&lt;if test=&#8221;columnProperty != null&#8221;&gt;#{columnProperty}&lt;\/if&gt;)<\/td><\/tr><tr><td>updateStrategy<\/td><td>Enum<\/td><td>\u5426<\/td><td>FieldStrategy.DEFAULT<\/td><td>\u4e3e\u4f8b\uff1aIGNORED update table_a set column=#{columnProperty}<\/td><\/tr><tr><td>whereStrategy<\/td><td>Enum<\/td><td>\u5426<\/td><td>FieldStrategy.DEFAULT<\/td><td>\u4e3e\u4f8b\uff1aNOT_EMPTY where &lt;if test=&#8221;columnProperty != null and columnProperty!=&#8221;&#8221;&gt;column=#{columnProperty}&lt;\/if&gt;<\/td><\/tr><tr><td>fill<\/td><td>Enum<\/td><td>\u5426<\/td><td>FieldFill.DEFAULT<\/td><td>\u5b57\u6bb5\u81ea\u52a8\u586b\u5145\u7b56\u7565<\/td><\/tr><tr><td>select<\/td><td>boolean<\/td><td>\u5426<\/td><td>true<\/td><td>\u662f\u5426\u8fdb\u884c select \u67e5\u8be2<\/td><\/tr><tr><td>keepGlobalFormat<\/td><td>boolean<\/td><td>\u5426<\/td><td>false<\/td><td>\u662f\u5426\u4fdd\u6301\u4f7f\u7528\u5168\u5c40\u7684 format \u8fdb\u884c\u5904\u7406<\/td><\/tr><tr><td>jdbcType<\/td><td>JdbcType<\/td><td>\u5426<\/td><td>JdbcType.UNDEFINED<\/td><td>JDBC \u7c7b\u578b (\u8be5\u9ed8\u8ba4\u503c\u4e0d\u4ee3\u8868\u4f1a\u6309\u7167\u8be5\u503c\u751f\u6548)<\/td><\/tr><tr><td>typeHandler<\/td><td>TypeHander<\/td><td>\u5426<\/td><td><\/td><td>\u7c7b\u578b\u5904\u7406\u5668 (\u8be5\u9ed8\u8ba4\u503c\u4e0d\u4ee3\u8868\u4f1a\u6309\u7167\u8be5\u503c\u751f\u6548)<\/td><\/tr><tr><td>numericScale<\/td><td>String<\/td><td>\u5426<\/td><td>&#8220;&#8221;<\/td><td>\u6307\u5b9a\u5c0f\u6570\u70b9\u540e\u4fdd\u7559\u7684\u4f4d\u6570<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">3 \u5e38\u89c1\u914d\u7f6e\uff1a<\/h1>\n\n\n\n<p><a href=\"https:\/\/baomidou.com\/reference\/\">\u4f7f\u7528\u914d\u7f6e | MyBatis-Plus<\/a><\/p>\n\n\n\n<p>\u5927\u591a\u6570\u914d\u7f6e\u90fd\u6709\u9ed8\u8ba4\u503c\uff0c\u65e0\u9700\u624b\u52a8\u914d\u7f6e\u3002<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">4 \u6838\u5fc3\u529f\u80fd\uff1a<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">4.1 \u6761\u4ef6\u6784\u9020\u5668 Wrapper <\/h2>\n\n\n\n<p><code>Wrapper<\/code>\u7684\u5b50\u7c7b<code>AbstractWrapper<\/code>\u63d0\u4f9b\u4e86where\u4e2d\u5305\u542b\u7684\u6240\u6709\u6761\u4ef6\u6784\u9020\u65b9\u6cd5\uff1b<\/p>\n\n\n\n<p>\u800cQueryWrapper\u5728AbstractWrapper\u7684\u57fa\u7840\u4e0a\u62d3\u5c55\u4e86\u4e00\u4e2aselect\u65b9\u6cd5\uff0c\u5141\u8bb8\u6307\u5b9a\u67e5\u8be2\u5b57\u6bb5\uff1a<\/p>\n\n\n\n<p>\u800cUpdateWrapper\u5728AbstractWrapper\u7684\u57fa\u7840\u4e0a\u62d3\u5c55\u4e86\u4e00\u4e2aset\u65b9\u6cd5\uff0c\u5141\u8bb8\u6307\u5b9aSQL\u4e2d\u7684SET\u90e8\u5206\uff1a<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u4f8b1 QueryWrapper\uff1a<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\u67e5\u8be2\uff1a<\/h4>\n\n\n\n<p>\u539fSQL\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT id,username,info,balance\nFrom user\nWHERE username LIKE o AND balance &gt;= 1000<\/code><\/pre>\n\n\n\n<p>MB\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ 1.\u6784\u5efa\u67e5\u8be2\u6761\u4ef6 where name like \"%o%\" AND balance &gt;= 1000\n    QueryWrapper&lt;User&gt; wrapper = new QueryWrapper&lt;User&gt;()\n            .select(\"id\", \"username\", \"info\", \"balance\")\n            .like(\"username\", \"o\")\n            .ge(\"balance\", 1000);\n\/\/ 2.\u67e5\u8be2\u6570\u636e\n    List&lt;User&gt; users = userMapper.selectList(wrapper);<\/code><\/pre>\n\n\n\n<p>\u65e0\u8bba\u662f\u4fee\u6539\u3001\u5220\u9664\u3001\u67e5\u8be2\uff0c\u90fd\u53ef\u4ee5\u4f7f\u7528QueryWrapper\u6765\u6784\u5efa\u67e5\u8be2\u6761\u4ef6\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u4f8b2 UpdateWrapper\uff1a<\/h3>\n\n\n\n<p>\u539fSQL\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE user SET balance = balance - 200 WHERE id in (1, 2, 4)<\/code><\/pre>\n\n\n\n<p>MB\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>List&lt;Long&gt; ids = List.of(1L, 2L, 4L);\n    \/\/ 1.\u751f\u6210SQL\n    UpdateWrapper&lt;User&gt; wrapper = new UpdateWrapper&lt;User&gt;()\n            .setSql(\"balance = balance - 200\") \/\/ SET balance = balance - 200\n            .in(\"id\", ids); \/\/ WHERE id in (1, 2, 4)\n    \/\/ 2.\u66f4\u65b0\uff0c\u6ce8\u610f\u7b2c\u4e00\u4e2a\u53c2\u6570\u53ef\u4ee5\u7ed9null\uff0c\u4e5f\u5c31\u662f\u4e0d\u586b\u66f4\u65b0\u5b57\u6bb5\u548c\u6570\u636e\uff0c\n    \/\/ \u800c\u662f\u57fa\u4e8eUpdateWrapper\u4e2d\u7684setSQL\u6765\u66f4\u65b0\n    userMapper.update(null, wrapper);<\/code><\/pre>\n\n\n\n<p>LambdaXXXWapper\u53ea\u628a\u5bf9\u5e94\u5b57\u6bb5\u540d\u6539\u4e3a\u5bf9\u5e94get\u65b9\u6cd5\u5373\u53ef\uff0c\u907f\u514d\u4e86\u786c\u7f16\u7801\uff08\u5417\uff1f\uff09<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">4.2 \u81ea\u5b9a\u4e49SQL<\/h2>\n\n\n\n<p>MybatisPlus\u63d0\u4f9b\u4e86\u81ea\u5b9a\u4e49SQL\u529f\u80fd\uff0c\u53ef\u4ee5\u8ba9\u6211\u4eec\u5229\u7528Wrapper\u751f\u6210\u67e5\u8be2\u6761\u4ef6\uff0c\u518d\u7ed3\u5408Mapper.xml\u7f16\u5199SQL\u3002  <\/p>\n\n\n\n<p>\u4f7f\u7528\u6b65\u9aa4\uff1a<\/p>\n\n\n\n<p>1.\u57fa\u4e8eWrapper\u6784\u5efawhere\u6761\u4ef6\uff0c\u5c06\u5176\u4f5c\u4e3a\u53c2\u6570\u4f20\u5165mapper\u65b9\u6cd5<\/p>\n\n\n\n<p>2. \u5728mapper\u65b9\u6cd5\u53c2\u6570\u4e2d\u7528Param\u6ce8\u89e3\u58f0\u660eWrapper\u53d8\u91cf\u540d\u79f0\u3001<strong>\u5fc5\u987b\u662few<\/strong>\/Constans.WRAPPER<\/p>\n\n\n\n<p>3.\u7f16\u5199SQL\uff0c\u901a\u8fc7 ${ew.customSqlSegment} \u4f7f\u7528\u6761\u4ef6<\/p>\n\n\n\n<p>\u4f8b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\/\/service\uff1a\n\nvoid testCustomWrapper() {\n    \/\/ 1.\u51c6\u5907\u81ea\u5b9a\u4e49\u67e5\u8be2\u6761\u4ef6\n    List&lt;Long&gt; ids = List.of(1L, 2L, 4L);\n    QueryWrapper&lt;User&gt; wrapper = new QueryWrapper&lt;User&gt;().in(\"id\", ids);\n\n    \/\/ 2.\u8c03\u7528mapper\u7684\u81ea\u5b9a\u4e49\u65b9\u6cd5\uff0c\u76f4\u63a5\u4f20\u9012Wrapper\n    userMapper.deductBalanceByIds(200, wrapper);\n}\n\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\/\/mapper\uff1a\n\n@Select(\"UPDATE user SET balance = balance - #{money} ${ew.customSqlSegment}\")\n    void deductBalanceByIds(@Param(\"money\") int money, @Param(\"ew\") QueryWrapper&lt;User&gt; wrapper);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">4.3 IService\u63a5\u53e3<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u4f7f\u7528\u6d41\u7a0b\uff1a<\/h3>\n\n\n\n<p>1.\u81ea\u5b9a\u4e49Service\u63a5\u53e3\u7ee7\u627fIService\u63a5\u53e3\uff1b<\/p>\n\n\n\n<p>2.\u81ea\u5b9a\u4e49\u5b9e\u73b0\u7c7bServiceImpl\u7ee7\u627fIService\u63a5\u53e3\u7684\u9ed8\u8ba4\u5b9e\u73b0\u7c7b\uff1aextends ServiceImpl &lt;UserMapper,User&gt;\uff0c\u5b9e\u73b0\u81ea\u5b9a\u4e49Service\u63a5\u53e3.<\/p>\n\n\n\n<p>\u901a\u7528\u63a5\u53e3\u4e3a<code>IService<\/code>\uff0c\u9ed8\u8ba4\u5b9e\u73b0\u4e3a<code>ServiceImpl<\/code>\uff0c\u5176\u4e2d\u5c01\u88c5\u7684\u65b9\u6cd5\u53ef\u4ee5\u5206\u4e3a\u4ee5\u4e0b\u51e0\u7c7b\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>save<\/code>\uff1a\u65b0\u589e<\/li>\n\n\n\n<li><code>remove<\/code>\uff1a\u5220\u9664<\/li>\n\n\n\n<li><code>update<\/code>\uff1a\u66f4\u65b0<\/li>\n\n\n\n<li><code>get<\/code>\uff1a\u67e5\u8be2\u5355\u4e2a\u7ed3\u679c<\/li>\n\n\n\n<li><code>list<\/code>\uff1a\u67e5\u8be2\u96c6\u5408\u7ed3\u679c<\/li>\n\n\n\n<li><code>count<\/code>\uff1a\u8ba1\u6570<\/li>\n\n\n\n<li><code>page<\/code>\uff1a\u5206\u9875\u67e5\u8be2<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">CRUD:<\/h3>\n\n\n\n<p>1.<strong>\u65b0\u589e<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>save<\/code>\u662f\u65b0\u589e\u5355\u4e2a\u5143\u7d20<\/li>\n\n\n\n<li><code>saveBatch<\/code>\u662f\u6279\u91cf\u65b0\u589e<\/li>\n\n\n\n<li><code>saveOrUpdate<\/code>\u662f\u6839\u636eid\u5224\u65ad\uff0c\u5982\u679c\u6570\u636e\u5b58\u5728\u5c31\u66f4\u65b0\uff0c\u4e0d\u5b58\u5728\u5219\u65b0\u589e<\/li>\n\n\n\n<li><code>saveOrUpdateBatch<\/code>\u662f\u6279\u91cf\u7684\u65b0\u589e\u6216\u4fee\u6539<\/li>\n<\/ul>\n\n\n\n<p>2.<strong>\u5220\u9664<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>removeById<\/code>\uff1a\u6839\u636eid\u5220\u9664<\/li>\n\n\n\n<li><code>removeByIds<\/code>\uff1a\u6839\u636eid\u6279\u91cf\u5220\u9664<\/li>\n\n\n\n<li><code>removeByMap<\/code>\uff1a\u6839\u636eMap\u4e2d\u7684\u952e\u503c\u5bf9\u4e3a\u6761\u4ef6\u5220\u9664<\/li>\n\n\n\n<li><code>remove(Wrapper&lt;T&gt;)<\/code>\uff1a\u6839\u636eWrapper\u6761\u4ef6\u5220\u9664<\/li>\n<\/ul>\n\n\n\n<p>3.<strong>\u4fee\u6539<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>updateById<\/code>\uff1a\u6839\u636eid\u4fee\u6539<\/li>\n\n\n\n<li><code>update(Wrapper&lt;T&gt;)<\/code>\uff1a\u6839\u636e<code>UpdateWrapper<\/code>\u4fee\u6539\uff0c<code>Wrapper<\/code>\u4e2d\u5305\u542b<code>set<\/code>\u548c<code>where<\/code>\u90e8\u5206<\/li>\n\n\n\n<li><code>update(T\uff0cWrapper&lt;T&gt;)<\/code>\uff1a\u6309\u7167<code>T<\/code>\u5185\u7684\u6570\u636e\u4fee\u6539\u4e0e<code>Wrapper<\/code>\u5339\u914d\u5230\u7684\u6570\u636e<\/li>\n\n\n\n<li><code>updateBatchById<\/code>\uff1a\u6839\u636eid\u6279\u91cf\u4fee\u6539<\/li>\n<\/ul>\n\n\n\n<p>4.<strong>\u67e5\u8be2<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>getById<\/code>\uff1a\u6839\u636eid\u67e5\u8be21\u6761\u6570\u636e<\/li>\n\n\n\n<li><code>getOne(Wrapper&lt;T&gt;)<\/code>\uff1a\u6839\u636e<code>Wrapper<\/code>\u67e5\u8be21\u6761\u6570\u636e<\/li>\n\n\n\n<li><code>getBaseMapper<\/code>\uff1a\u83b7\u53d6<code>Service<\/code>\u5185\u7684<code>BaseMapper<\/code>\u5b9e\u73b0\uff0c\u67d0\u4e9b\u65f6\u5019\u9700\u8981\u76f4\u63a5\u8c03\u7528<code>Mapper<\/code>\u5185\u7684\u81ea\u5b9a\u4e49<code>SQL<\/code>\u65f6\u53ef\u4ee5\u7528\u8fd9\u4e2a\u65b9\u6cd5\u83b7\u53d6\u5230<code>Mapper<\/code><\/li>\n<\/ul>\n\n\n\n<p><strong>5.list\uff1a<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>listByIds<\/code>\uff1a\u6839\u636eid\u6279\u91cf\u67e5\u8be2<\/li>\n\n\n\n<li><code>list(Wrapper&lt;T&gt;)<\/code>\uff1a\u6839\u636eWrapper\u6761\u4ef6\u67e5\u8be2\u591a\u6761\u6570\u636e<\/li>\n\n\n\n<li><code>list()<\/code>\uff1a\u67e5\u8be2\u6240\u6709<\/li>\n<\/ul>\n\n\n\n<p><strong>6.count\uff1a<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>count()<\/code>\uff1a\u7edf\u8ba1\u6240\u6709\u6570\u91cf<\/li>\n\n\n\n<li><code>count(Wrapper&lt;T&gt;)<\/code>\uff1a\u7edf\u8ba1\u7b26\u5408<code>Wrapper<\/code>\u6761\u4ef6\u7684\u6570\u636e\u6570\u91cf<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">4.4 Lambda<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">lambdaQuery<\/h3>\n\n\n\n<p>\u4f8b\uff1a<\/p>\n\n\n\n<p>\u6ce8\uff1a\u6b64\u5904\u4f7f\u7528\u4e86\u67e5\u8be2\u5bf9\u8c61\u6a21\u5f0f\uff0c\u5f53\u67e5\u8be2\u6761\u4ef6\u8fc7\u591a\u65f6\uff0c\u5c01\u88c5\u4e3a\u4e00\u4e2a\u5bf9\u8c61\u4fbf\u4e8e\u7ba1\u7406\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>@GetMapping(\"\/list\")\n@ApiOperation(\"\u6839\u636eid\u96c6\u5408\u67e5\u8be2\u7528\u6237\")\npublic List&lt;UserVO&gt; queryUsers(UserQuery query){\n    \/\/ 1.\u7ec4\u7ec7\u6761\u4ef6\n    String username = query.getName();\n    Integer status = query.getStatus();\n    Integer minBalance = query.getMinBalance();\n    Integer maxBalance = query.getMaxBalance();\n    \/\/ 2.\u67e5\u8be2\u7528\u6237\n    List&lt;User&gt; users = userService.lambdaQuery()\n            .like(username != null, User::getUsername, username)\n            .eq(status != null, User::getStatus, status)\n            .ge(minBalance != null, User::getBalance, minBalance)\n            .le(maxBalance != null, User::getBalance, maxBalance)\n            .list();\n    \/\/ 3.\u5904\u7406vo\n    return BeanUtil.copyToList(users, UserVO.class);\n}<\/code><\/pre>\n\n\n\n<p>lambdaQuery\u65b9\u6cd5\u4e2d\u9664\u4e86\u53ef\u4ee5\u6784\u5efa\u6761\u4ef6\uff0c\u8fd8\u9700\u8981\u5728\u94fe\u5f0f\u7f16\u7a0b\u7684\u6700\u540e\u6dfb\u52a0\u4e00\u4e2a<code>list()<\/code>\uff0c\u53ef\u9009\u7684\u65b9\u6cd5\u8fd8\u6709\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>.one()<\/code>\uff1a\u6700\u591a1\u4e2a\u7ed3\u679c<\/li>\n\n\n\n<li><code>.list()<\/code>\uff1a\u8fd4\u56de\u96c6\u5408\u7ed3\u679c<\/li>\n\n\n\n<li><code>.count()<\/code>\uff1a\u8fd4\u56de\u8ba1\u6570\u7ed3\u679c<\/li>\n<\/ul>\n\n\n\n<p>MybatisPlus\u4f1a\u6839\u636e\u94fe\u5f0f\u7f16\u7a0b\u7684\u6700\u540e\u4e00\u4e2a\u65b9\u6cd5\u6765\u5224\u65ad\u6700\u7ec8\u7684\u8fd4\u56de\u7ed3\u679c\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">lambdaUpdate<\/h3>\n\n\n\n<p>\u4f8b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>@Transactional\npublic void deductBalance(Long id, Integer money) {\n    \/\/ 1.\u67e5\u8be2\u7528\u6237\n    User user = getById(id);\n    \/\/ 2.\u6821\u9a8c\u7528\u6237\u72b6\u6001\n    if (user == null || user.getStatus() == 2) {\n        throw new RuntimeException(\"\u7528\u6237\u72b6\u6001\u5f02\u5e38\uff01\");\n    }\n    \/\/ 3.\u6821\u9a8c\u4f59\u989d\u662f\u5426\u5145\u8db3\n    if (user.getBalance() &lt; money) {\n        throw new RuntimeException(\"\u7528\u6237\u4f59\u989d\u4e0d\u8db3\uff01\");\n    }\n    \/\/ 4.\u6263\u51cf\u4f59\u989d update tb_user set balance = balance - ?\n    int remainBalance = user.getBalance() - money;\n    lambdaUpdate()\n            .set(User::getBalance, remainBalance) \/\/ \u66f4\u65b0\u4f59\u989d\n            .set(remainBalance == 0, User::getStatus, 2) \/\/ \u52a8\u6001\u5224\u65ad\uff0c\u662f\u5426\u66f4\u65b0status\n            .eq(User::getId, id)\n            .eq(User::getBalance, user.getBalance()) \/\/ \u4e50\u89c2\u9501\n            .update();\n}<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">4.5 \u6279\u91cf\u65b0\u589e\uff1a<\/h2>\n\n\n\n<p>userService.saveBatch(list);<\/p>\n\n\n\n<p>MB\u7684\u6279\u91cf\u65b0\u589e\u6bd4\u9010\u6761\u65b0\u589e\u6548\u7387\u63d0\u9ad8\u4e8610\u500d\u5de6\u53f3\uff0c\u4f46\u662f\u5b9e\u9645\u6267\u884c\u4f9d\u7136\u662f\u5355\u6761SQL\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Preparing: INSERT INTO user ( username, password, phone, info, balance, create_time, update_time ) VALUES ( ?, ?, ?, ?, ?, ?, ? )\nParameters: user_1, 123, 18688190001, \"\", 2000, 2023-07-01, 2023-07-01\nParameters: user_2, 123, 18688190002, \"\", 2000, 2023-07-01, 2023-07-01\nParameters: user_3, 123, 18688190003, \"\", 2000, 2023-07-01, 2023-07-01<\/code><\/pre>\n\n\n\n<p>\u5982\u679c\u60f3\u8981\u5f97\u5230\u6700\u4f73\u6027\u80fd\uff0c\u6700\u597d\u662f\u5c06\u591a\u6761SQL\u5408\u5e76\u4e3a\u4e00\u6761\uff0c\u50cf\u8fd9\u6837\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO user ( username, password, phone, info, balance, create_time, update_time )\nVALUES \n(user_1, 123, 18688190001, \"\", 2000, 2023-07-01, 2023-07-01),\n(user_2, 123, 18688190002, \"\", 2000, 2023-07-01, 2023-07-01),\n(user_3, 123, 18688190003, \"\", 2000, 2023-07-01, 2023-07-01),\n(user_4, 123, 18688190004, \"\", 2000, 2023-07-01, 2023-07-01);<\/code><\/pre>\n\n\n\n<p><strong>\u4f18\u5316\u65b9\u6cd5\uff1a<\/strong><\/p>\n\n\n\n<p>\u4fee\u6539\u9879\u76ee\u4e2d\u7684application.yml\u6587\u4ef6\uff0c\u5728jdbc\u7684url\u540e\u9762\u6dfb\u52a0\u53c2\u6570<code>&amp;rewriteBatchedStatements=true<\/code><\/p>\n\n\n\n<p>\uff08<code>rewriteBatchedStatements<\/code>&nbsp;\u662f MySQL JDBC \u9a71\u52a8\u4e2d\u7684\u4e00\u4e2a\u8fde\u63a5\u53c2\u6570\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0cJDBC \u7684\u6279\u91cf\u64cd\u4f5c\u662f\u5c06\u591a\u6761 SQL \u8bed\u53e5\u9010\u4e2a\u53d1\u9001\u5230\u6570\u636e\u5e93\u6267\u884c\u3002\u800c\u5f53&nbsp;<code>rewriteBatchedStatements<\/code>&nbsp;\u53c2\u6570\u8bbe\u7f6e\u4e3a&nbsp;<code>true<\/code>&nbsp;\u65f6\uff0cMySQL JDBC \u9a71\u52a8\u4f1a\u5c06\u591a\u4e2a&nbsp;<code>INSERT<\/code>\u3001<code>UPDATE<\/code>&nbsp;\u6216&nbsp;<code>DELETE<\/code>&nbsp;\u8bed\u53e5\u91cd\u5199\u4e3a\u4e00\u4e2a\u591a\u503c\u7684 SQL \u8bed\u53e5\uff0c\u7136\u540e\u4e00\u6b21\u6027\u53d1\u9001\u5230\u6570\u636e\u5e93\u6267\u884c\u3002\u8fd9\u6837\u53ef\u4ee5\u51cf\u5c11\u4e0e\u6570\u636e\u5e93\u4e4b\u95f4\u7684\u7f51\u7edc\u901a\u4fe1\u6b21\u6570\uff0c\u4ece\u800c\u63d0\u9ad8\u6279\u91cf\u64cd\u4f5c\u7684\u6548\u7387\u3002\uff09<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">5 \u6269\u5c55\u529f\u80fd\uff1a<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">5.1 \u4ee3\u7801\u751f\u6210\uff1a<\/h2>\n\n\n\n<p>\u4f7f\u7528IDEA\u63d2\u4ef6MybatisPlus\uff08\u521d\u97f3\u672a\u6765\uff09\u6839\u636e\u6570\u636e\u5e93\u8868\u7ed3\u6784\u751f\u6210<code>PO<\/code>\u3001<code>Mapper<\/code>\u3001<code>Service<\/code>\u7b49\u76f8\u5173\u4ee3\u7801\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">5.2 \u9759\u6001\u5de5\u5177<\/h2>\n\n\n\n<p>\u6709\u7684\u65f6\u5019Service\u4e4b\u95f4\u4e5f\u4f1a\u76f8\u4e92\u8c03\u7528\uff0c\u4e3a\u4e86\u907f\u514d\u51fa\u73b0\u5faa\u73af\u4f9d\u8d56\u95ee\u9898\uff0cMybatisPlus\u63d0\u4f9b\u4e00\u4e2a\u9759\u6001\u5de5\u5177\u7c7b\uff1a<code>Db<\/code>\uff0c\u5176\u4e2d\u7684\u4e00\u4e9b\u9759\u6001\u65b9\u6cd5\u4e0e<code>IService<\/code>\u4e2d\u65b9\u6cd5\u7b7e\u540d\u57fa\u672c\u4e00\u81f4\uff0c\u4e5f\u53ef\u4ee5\u5e2e\u52a9\u6211\u4eec\u5b9e\u73b0CRUD\u529f\u80fd\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">5.3 \u903b\u8f91\u5220\u9664<\/h2>\n\n\n\n<p>\u5bf9\u4e8e\u4e00\u4e9b\u6bd4\u8f83\u91cd\u8981\u7684\u6570\u636e\uff0c\u6211\u4eec\u5f80\u5f80\u4f1a\u91c7\u7528\u903b\u8f91\u5220\u9664\u7684\u65b9\u6848\uff0c\u5373\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5728\u8868\u4e2d\u6dfb\u52a0\u4e00\u4e2a\u5b57\u6bb5\u6807\u8bb0\u6570\u636e\u662f\u5426\u88ab\u5220\u9664<\/li>\n\n\n\n<li>\u5f53\u5220\u9664\u6570\u636e\u65f6\u628a\u6807\u8bb0\u7f6e\u4e3atrue<\/li>\n\n\n\n<li>\u67e5\u8be2\u65f6\u8fc7\u6ee4\u6389\u6807\u8bb0\u4e3atrue\u7684\u6570\u636e<\/li>\n<\/ul>\n\n\n\n<p>\u4e00\u65e6\u91c7\u7528\u4e86\u903b\u8f91\u5220\u9664\uff0c\u6240\u6709\u7684\u67e5\u8be2\u548c\u5220\u9664\u903b\u8f91\u90fd\u8981\u8ddf\u7740\u53d8\u5316\uff0c\u975e\u5e38\u9ebb\u70e6\u3002<\/p>\n\n\n\n<p>\u4e3a\u4e86\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff0cMybatisPlus\u5c31\u6dfb\u52a0\u4e86\u5bf9\u903b\u8f91\u5220\u9664\u7684\u652f\u6301\u3002<\/p>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\"><strong>\u6ce8\u610f<\/strong>\uff0c\u53ea\u6709MybatisPlus\u751f\u6210\u7684SQL\u8bed\u53e5\u624d\u652f\u6301\u81ea\u52a8\u7684\u903b\u8f91\u5220\u9664\uff0c\u81ea\u5b9a\u4e49SQL\u9700\u8981\u81ea\u5df1\u624b\u52a8\u5904\u7406\u903b\u8f91\u5220\u9664<\/mark><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>MybatisPlus\u7684\u903b\u8f91\u5220\u9664\u529f\u80fd\uff0c\u65e0\u9700\u6539\u53d8\u65b9\u6cd5\u8c03\u7528\u7684\u65b9\u5f0f\uff0c\u63d2\u4ef6\u4f1a\u81ea\u52a8\u5728\u5e95\u5c42\u4fee\u6539SQL\u8bed\u53e5\u3002\u8981\u4f7f\u7528\uff0c\u9700\u8981\u5728yaml\u6587\u4ef6\u4e2d\u8fdb\u884c\u5982\u4e0b\u914d\u7f6e\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mybatis-plus:\n  global-config:\n    db-config:\n      logic-delete-field: deleted # \u5168\u5c40\u903b\u8f91\u5220\u9664\u7684\u5b9e\u4f53\u5b57\u6bb5\u540d(since 3.3.0,\u914d\u7f6e\u540e\u53ef\u4ee5\u5ffd\u7565\u4e0d\u914d\u7f6e\u6b65\u9aa42)\n      logic-delete-value: 1 # \u903b\u8f91\u5df2\u5220\u9664\u503c(\u9ed8\u8ba4\u4e3a 1)\n      logic-not-delete-value: 0 # \u903b\u8f91\u672a\u5220\u9664\u503c(\u9ed8\u8ba4\u4e3a 0)<\/code><\/pre>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p><strong>\u6ce8\u610f<\/strong>\uff1a \u903b\u8f91\u5220\u9664\u672c\u8eab\u4e5f\u6709\u81ea\u5df1\u7684\u95ee\u9898\uff0c\u6bd4\u5982\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4f1a\u5bfc\u81f4\u6570\u636e\u5e93\u8868\u5783\u573e\u6570\u636e\u8d8a\u6765\u8d8a\u591a\uff0c\u4ece\u800c\u5f71\u54cd\u67e5\u8be2\u6548\u7387<\/li>\n\n\n\n<li>SQL\u4e2d\u5168\u90fd\u9700\u8981\u5bf9\u903b\u8f91\u5220\u9664\u5b57\u6bb5\u505a\u5224\u65ad\uff0c\u5f71\u54cd\u67e5\u8be2\u6548\u7387<\/li>\n<\/ul>\n\n\n\n<p>\u56e0\u6b64\uff0c\u4e0d\u592a\u63a8\u8350\u91c7\u7528\u903b\u8f91\u5220\u9664\u529f\u80fd\uff0c\u5982\u679c\u6570\u636e\u4e0d\u80fd\u5220\u9664\uff0c\u53ef\u4ee5\u91c7\u7528\u628a\u6570\u636e\u8fc1\u79fb\u5230\u5176\u5b83\u8868\u7684\u529e\u6cd5\u3002<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">5.4 \u679a\u4e3e\u5904\u7406\u5668 <\/h2>\n\n\n\n<p>\u5148\u8fc7&#8230;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">5.5 <strong>JSON\u7c7b\u578b\u5904\u7406\u5668<\/strong><\/h2>\n\n\n\n<p>\u7528\u4e8e\u5904\u7406\u5b57\u6bb5\u7c7b\u578b\u4e3aJSON\u800c\u5728\u7a0b\u5e8f\u4e2d\u4ee5string\u5b58\u50a8\u7684\u5c5e\u6027<\/p>\n\n\n\n<p>\u6b65\u9aa4\uff1a<\/p>\n\n\n\n<p>1.\u5b9a\u4e49\u5bf9\u5e94\u5b9e\u4f53<\/p>\n\n\n\n<p>2.\u4f7f\u7528JSON\u7c7b\u578b\u5904\u7406\u5668<\/p>\n\n\n\n<p>2.1 \u5728\u5bf9\u5e94\u5b57\u6bb5\u4e0a\u7c7b\u578b\u5904\u7406\u5668<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code> \/\/ \u6307\u5b9a\u81ea\u5b9a\u4e49\u7c7b\u578b\u5904\u7406\u5668 springMVC\u9ed8\u8ba4\u4e3aJacksonJSON\n    @TableField(typeHandler = JacksonTypeHandler.class)\n    private Map&lt;String, Object> extraInfo;<\/code><\/pre>\n\n\n\n<p>2.2 \u5728\u7c7b\u4e0a\u58f0\u660e\u81ea\u52a8\u6620\u5c04<\/p>\n\n\n\n<p>@TableName(value = &#8220;user&#8221; ,autoResultMap = true)<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">6 \u63d2\u4ef6\u62d3\u5c55-\u5206\u9875\u63d2\u4ef6<\/h1>\n\n\n\n<p>\u9ebb\u70e6\uff0c\u4e0d\u5982pagehelper\uff0c\u8fc7<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MyBatis-Plus \ud83d\ude80 \u4e3a\u7b80\u5316\u5f00\u53d1\u800c\u751f day01-MybatisPlus &#8211; \u98de\u4e66\u4e91\u6587\u6863  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[25],"class_list":["post-750","post","type-post","status-publish","format-standard","hentry","category-javaweblist","tag-java"],"_links":{"self":[{"href":"http:\/\/www.cmd137blog.top\/index.php?rest_route=\/wp\/v2\/posts\/750","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.cmd137blog.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.cmd137blog.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.cmd137blog.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.cmd137blog.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=750"}],"version-history":[{"count":10,"href":"http:\/\/www.cmd137blog.top\/index.php?rest_route=\/wp\/v2\/posts\/750\/revisions"}],"predecessor-version":[{"id":771,"href":"http:\/\/www.cmd137blog.top\/index.php?rest_route=\/wp\/v2\/posts\/750\/revisions\/771"}],"wp:attachment":[{"href":"http:\/\/www.cmd137blog.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cmd137blog.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=750"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cmd137blog.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}