{"id":8474,"date":"2022-11-12T22:24:41","date_gmt":"2022-11-12T14:24:41","guid":{"rendered":"http:\/\/123.57.164.21\/?p=8474"},"modified":"2022-11-12T22:26:22","modified_gmt":"2022-11-12T14:26:22","slug":"springboot-mybatis-plus","status":"publish","type":"post","link":"https:\/\/92it.top\/?p=8474","title":{"rendered":"SpringBoot MyBatis-Plus"},"content":{"rendered":"\n<p><strong>\u4e00\u3001\u4e86\u89e3mybatisplus<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/link.zhihu.com\/?target=https%3A\/\/github.com\/baomidou\/mybatis-plus\" target=\"_blank\">MyBatis-Plus <\/a>\uff08\u7b80\u79f0 MP\uff09\u662f\u4e00\u4e2a <a rel=\"noreferrer noopener\" href=\"https:\/\/link.zhihu.com\/?target=https%3A\/\/www.mybatis.org\/mybatis-3\/\" target=\"_blank\">MyBatis <\/a>\u7684\u589e\u5f3a\u5de5\u5177\uff0c\u5728 MyBatis \u7684\u57fa\u7840\u4e0a\u53ea\u505a\u589e\u5f3a\u4e0d\u505a\u6539\u53d8\uff0c\u4e3a\u7b80\u5316\u5f00\u53d1\u3001\u63d0\u9ad8\u6548\u7387\u800c\u751f\u3002<\/p>\n\n\n\n<p>\u613f\u666f\uff1a\u6210\u4e3a MyBatis \u6700\u597d\u7684\u642d\u6863\uff0c\u5c31\u50cf \u9b42\u6597\u7f57 \u4e2d\u7684 1P\u30012P\uff0c\u57fa\u53cb\u642d\u914d\uff0c\u6548\u7387\u7ffb\u500d\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-180-1024x361.png\" alt=\"\" class=\"wp-image-8476\" width=\"476\" height=\"168\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-180-1024x361.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-180-300x106.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-180-768x270.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-180-830x292.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-180-230x81.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-180-350x123.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-180-480x169.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-180.png 1278w\" sizes=\"(max-width: 476px) 100vw, 476px\" \/><\/figure><\/div>\n\n\n\n<p><strong>\u4e8c\u3001\u652f\u6301\u6570\u636e\u5e93<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u4efb\u4f55\u80fd\u4f7f\u7528 MyBatis \u8fdb\u884c CRUD, \u5e76\u4e14\u652f\u6301\u6807\u51c6 SQL \u7684\u6570\u636e\u5e93\u3002<\/p>\n\n\n\n<ul><li>MySQL\uff0cOracle\uff0cDB2\uff0cH2\uff0cHSQL\uff0cSQLite\uff0cPostgreSQL\uff0cSQLServer\uff0cPhoenix\uff0cGauss \uff0cClickHouse\uff0cSybase\uff0cOceanBase\uff0cFirebird\uff0cCubrid\uff0cGoldilocks\uff0ccsiidb<\/li><li>\u8fbe\u68a6\u6570\u636e\u5e93\uff0c<a rel=\"noreferrer noopener\" href=\"https:\/\/www.zhihu.com\/search?q=%E8%99%9A%E8%B0%B7%E6%95%B0%E6%8D%AE%E5%BA%93&amp;search_source=Entity&amp;hybrid_search_source=Entity&amp;hybrid_search_extra=%7B%22sourceType%22%3A%22answer%22%2C%22sourceId%22%3A2744432305%7D\" target=\"_blank\">\u865a\u8c37\u6570\u636e\u5e93<\/a><\/li><\/ul>\n\n\n\n<p><strong>\u4e09\u3001\u6846\u67b6\u7ed3\u6784<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-179-1024x662.png\" alt=\"\" class=\"wp-image-8475\" width=\"487\" height=\"315\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-179-1024x662.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-179-300x194.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-179-768x497.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-179-830x537.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-179-230x149.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-179-350x226.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-179-480x310.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-179.png 1324w\" sizes=\"(max-width: 487px) 100vw, 487px\" \/><\/figure><\/div>\n\n\n\n<p><strong>\u56db\u3001springboot\u6574\u5408MybatisPlus\u5feb\u901f\u5165\u95e8<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p><strong>1.\u624b\u52a8\u6dfb\u52a0MyBatisPlus\u4f9d\u8d56<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;dependency>\n    &lt;groupId>com.baomidou&lt;\/groupId>\n    &lt;artifactId>mybatis-plus-boot-starter\n\n&lt;\/artifactId>\n    &lt;version>3.4.1&lt;\/version>\n&lt;\/dependency>\n&lt;dependency>\n    &lt;groupId>com.alibaba&lt;\/groupId>\n    &lt;artifactId>druid&lt;\/artifactId>\n    &lt;version>1.1.16&lt;\/version>\n&lt;\/dependency>\n&lt;!--mysql-->\n&lt;dependency>\n    &lt;groupId>mysql&lt;\/groupId>\n    &lt;artifactId>mysql-connector-java&lt;\/artifactId>\n    &lt;scope>runtime&lt;\/scope>\n&lt;\/dependency><\/pre>\n\n\n\n<p><strong>2.\u5236\u4f5c\u5b9e\u4f53\u7c7b\u4e0e\u8868\u7ed3\u6784<\/strong>\uff08\u7c7b\u540d\u4e0e\u8868\u540d\u5bf9\u5e94\uff0c\u5c5e\u6027\u540d\u4e0e\u5b57\u6bb5\u540d\u5bf9\u5e94\uff09<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">create database if not exists mybatisplus_db character set utf8;\nuse mybatisplus_db;\nCREATE TABLE user (\n            id bigint(20) primary key auto_increment,\n            name varchar(32) not null,\n            password  varchar(32) not null,\n            age int(3) not null ,\n            tel varchar(32) not null\n);\ninsert into user values(null,'tom','123456',12,'12345678910');\ninsert into user values(null,'jack','123456',8,'12345678910');\ninsert into user values(null,'jerry','123456',15,'12345678910');\ninsert into user values(null,'tom','123456',9,'12345678910');\ninsert into user values(null,'snake','123456',28,'12345678910');\ninsert into user values(null,'\u5f20\u76ca\u8fbe','123456',22,'12345678910');\ninsert into user values(null,'\u5f20\u5927\u70ae','123456',16,'12345678910');\n\npublic class User {\n    private Long id;\n    private String name;\n    private String password;\n    private Integer age;\n    private String tel;\n    \/\/\u81ea\u884c\u6dfb\u52a0getter\u3001setter\u3001toString()\u7b49\u65b9\u6cd5\n}<\/pre>\n\n\n\n<p><strong>3.\u8bbe\u7f6eJdbc\u53c2\u6570\uff08application.yml\uff09<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">spring:\n  datasource:\n    type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql:\/\/localhost:3306\/mybatisplus_db?serverTimezone=UTC\n    username: root\n    password: 1234\n<\/pre>\n\n\n\n<p><strong>4.\u5b9a\u4e49\u6570\u636e\u63a5\u53e3\uff0c\u7ee7\u627fBaseMapper<\/strong><\/p>\n\n\n\n<p>\u4f7f\u7528\u4ee3\u7801\u751f\u6210\u5668\u751f\u6210\u7684 mapper \u63a5\u53e3\u4e2d\uff0c\u5176\u7ee7\u627f\u4e86 BaseMapper \u63a5\u53e3\u3002\u800c BaseMapper \u63a5\u53e3\u4e2d\u5c01\u88c5\u4e86\u4e00\u7cfb\u5217 CRUD \u5e38\u7528\u64cd\u4f5c\uff0c\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528\uff0c\u800c\u4e0d\u7528\u81ea\u5b9a\u4e49 xml \u4e0e sql \u8bed\u53e5\u8fdb\u884c CRUD \u64cd\u4f5c\uff08\u5f53\u7136\u6839\u636e\u5b9e\u9645\u5f00\u53d1\u9700\u8981\uff0c\u81ea\u5b9a\u4e49 sql \u8fd8\u662f\u6709\u5fc5\u8981\u7684\uff09\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-197-1024x363.png\" alt=\"\" class=\"wp-image-8499\" width=\"562\" height=\"198\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-197-1024x363.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-197-300x106.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-197-768x272.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-197-1536x544.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-197-830x294.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-197-230x81.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-197-350x124.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-197-480x170.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-197.png 1976w\" sizes=\"(max-width: 562px) 100vw, 562px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-198-1024x814.png\" alt=\"\" class=\"wp-image-8500\" width=\"566\" height=\"449\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-198-1024x814.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-198-300x238.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-198-768x610.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-198-830x659.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-198-230x183.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-198-350x278.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-198-480x381.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-198.png 1032w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/><\/figure><\/div>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">package com.itheima.dao;\n\u200b\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.itheima.domain.User;\nimport org.apache.ibatis.annotations.Mapper;\n\u200b\n@Mapper\npublic interface UserDao extends BaseMapper&lt;User> {\n}\n\u200b<\/pre>\n\n\n\n<p><strong>5.\u6d4b\u8bd5\u7c7b\u4e2d\u6ce8\u5165dao\u63a5\u53e3\uff0c\u6d4b\u8bd5\u529f\u80fd<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\u4f5c\u8005\uff1a\u9ed1\u9a6c\u7a0b\u5e8f\u5458Java\n\u94fe\u63a5\uff1ahttps:\/\/www.zhihu.com\/question\/314745062\/answer\/2744432305\n\u6765\u6e90\uff1a\u77e5\u4e4e\n\u8457\u4f5c\u6743\u5f52\u4f5c\u8005\u6240\u6709\u3002\u5546\u4e1a\u8f6c\u8f7d\u8bf7\u8054\u7cfb\u4f5c\u8005\u83b7\u5f97\u6388\u6743\uff0c\u975e\u5546\u4e1a\u8f6c\u8f7d\u8bf7\u6ce8\u660e\u51fa\u5904\u3002\n\npackage com.itheima;\n\u200b\nimport com.itheima.dao.UserDao;\nimport com.itheima.domain.User;\nimport org.junit.jupiter.api.Test;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.boot.test.context.SpringBootTest;\n\u200b\nimport java.util.List;\n\u200b\n@SpringBootTest\npublic class Mybatisplus01QuickstartApplicationTests {\n\u200b\n    @Autowired\n    private UserDao userDao;\n\u200b\n    @Test\n    void testGetAll() {\n        List&lt;User> userList = userDao.selectList(null);\n        System.out.println(userList);\n    }\n}<\/pre>\n\n\n\n<p><strong>6.\u6267\u884c\u7ed3\u679c<\/strong><\/p>\n\n\n\n<p>\u901a\u8fc7\u4ee5\u4e0a\u7b80\u5355\u64cd\u4f5c\uff0c\u5c31\u80fd\u5bf9 \u8868\u8fdb\u884c CRUD \u64cd\u4f5c\uff0c\u4e0d\u9700\u8981\u53bb\u7f16\u5199 xml \u6587\u4ef6\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-181-1024x289.png\" alt=\"\" class=\"wp-image-8477\" width=\"650\" height=\"183\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-181-1024x289.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-181-300x85.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-181-768x216.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-181-830x234.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-181-230x65.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-181-350x99.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-181-480x135.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-181.png 1320w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/figure><\/div>\n\n\n\n<p><strong>\u4e94\u3001\u4f18\u70b9<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<ul><li>\uff081\uff09\u65e0\u4fb5\u5165\uff1a\u53ea\u505a\u589e\u5f3a\u4e0d\u505a\u6539\u53d8\uff0c\u5f15\u5165\u5b83\u4e0d\u4f1a\u5bf9\u73b0\u6709\u5de5\u7a0b\u4ea7\u751f\u5f71\u54cd\uff0c\u5982\u4e1d\u822c\u987a\u6ed1\u3002<\/li><li>\uff082\uff09\u635f\u8017\u5c0f\uff1a\u542f\u52a8\u5373\u4f1a\u81ea\u52a8\u6ce8\u5165\u57fa\u672c CURD\uff0c\u6027\u80fd\u57fa\u672c\u65e0\u635f\u8017\uff0c\u76f4\u63a5\u9762\u5411\u5bf9\u8c61\u64cd\u4f5c\u3002<\/li><li>\uff083\uff09\u5f3a\u5927\u7684 CRUD \u64cd\u4f5c\uff1a\u5185\u7f6e\u901a\u7528 Mapper\u3001\u901a\u7528 Service\uff0c\u4ec5\u4ec5\u901a\u8fc7\u5c11\u91cf\u914d\u7f6e\u5373\u53ef\u5b9e\u73b0\u5355\u8868\u5927\u90e8\u5206 CRUD \u64cd\u4f5c\uff0c\u66f4\u6709\u5f3a\u5927\u7684\u6761\u4ef6\u6784\u9020\u5668\uff0c\u6ee1\u8db3\u5404\u7c7b\u4f7f\u7528\u9700\u6c42\u3002<\/li><li>\uff084\uff09\u652f\u6301 Lambda \u5f62\u5f0f\u8c03\u7528\uff1a\u901a\u8fc7 Lambda \u8868\u8fbe\u5f0f\uff0c\u65b9\u4fbf\u7684\u7f16\u5199\u5404\u7c7b\u67e5\u8be2\u6761\u4ef6\uff0c\u65e0\u9700\u518d\u62c5\u5fc3\u5b57\u6bb5\u5199\u9519\u3002<\/li><li>\uff085\uff09\u652f\u6301\u4e3b\u952e\u81ea\u52a8\u751f\u6210\uff1a\u652f\u6301\u591a\u8fbe 4 \u79cd\u4e3b\u952e\u7b56\u7565\uff08\u5185\u542b\u5206\u5e03\u5f0f\u552f\u4e00 ID \u751f\u6210\u5668 &#8211; Sequence\uff09\uff0c\u53ef\u81ea\u7531\u914d\u7f6e\uff0c\u5b8c\u7f8e\u89e3\u51b3\u4e3b\u952e\u95ee\u9898\u3002<\/li><li>\uff086\uff09\u652f\u6301 ActiveRecord \u6a21\u5f0f\uff1a\u652f\u6301 ActiveRecord \u5f62\u5f0f\u8c03\u7528\uff0c\u5b9e\u4f53\u7c7b\u53ea\u9700\u7ee7\u627f Model \u7c7b\u5373\u53ef\u8fdb\u884c\u5f3a\u5927\u7684 CRUD \u64cd\u4f5c\u3002<\/li><li>\uff087\uff09\u652f\u6301\u81ea\u5b9a\u4e49\u5168\u5c40\u901a\u7528\u64cd\u4f5c\uff1a\u652f\u6301\u5168\u5c40\u901a\u7528\u65b9\u6cd5\u6ce8\u5165\uff08 Write once, use anywhere \uff09\u3002<\/li><li>\uff088\uff09\u5185\u7f6e\u4ee3\u7801\u751f\u6210\u5668\uff1a\u91c7\u7528\u4ee3\u7801\u6216\u8005 Maven \u63d2\u4ef6\u53ef\u5feb\u901f\u751f\u6210 Mapper \u3001 Model \u3001 Service \u3001 Controller \u5c42\u4ee3\u7801\uff0c\u652f\u6301\u6a21\u677f\u5f15\u64ce\uff0c\u66f4\u6709\u8d85\u591a\u81ea\u5b9a\u4e49\u914d\u7f6e\u7b49\u60a8\u6765\u4f7f\u7528\u3002<\/li><li>\uff089\uff09\u5185\u7f6e\u5206\u9875\u63d2\u4ef6\uff1a\u57fa\u4e8e MyBatis \u7269\u7406\u5206\u9875\uff0c\u5f00\u53d1\u8005\u65e0\u9700\u5173\u5fc3\u5177\u4f53\u64cd\u4f5c\uff0c\u914d\u7f6e\u597d\u63d2\u4ef6\u4e4b\u540e\uff0c\u5199\u5206\u9875\u7b49\u540c\u4e8e\u666e\u901a List \u67e5\u8be2\u3002<\/li><li>\uff0810\uff09\u5206\u9875\u63d2\u4ef6\u652f\u6301\u591a\u79cd\u6570\u636e\u5e93\uff1a\u652f\u6301 MySQL\u3001MariaDB\u3001Oracle\u3001DB2\u3001H2\u3001HSQL\u3001SQLite\u3001Postgre\u3001SQLServer \u7b49\u591a\u79cd\u6570\u636e\u5e93\u3002<\/li><li>\uff0811\uff09\u5185\u7f6e\u6027\u80fd\u5206\u6790\u63d2\u4ef6\uff1a\u53ef\u8f93\u51fa SQL \u8bed\u53e5\u4ee5\u53ca\u5176\u6267\u884c\u65f6\u95f4\uff0c\u5efa\u8bae\u5f00\u53d1\u6d4b\u8bd5\u65f6\u542f\u7528\u8be5\u529f\u80fd\uff0c\u80fd\u5feb\u901f\u63ea\u51fa\u6162\u67e5\u8be2\u3002<\/li><li>\uff0812\uff09\u5185\u7f6e\u5168\u5c40\u62e6\u622a\u63d2\u4ef6\uff1a\u63d0\u4f9b\u5168\u8868 delete \u3001 update \u64cd\u4f5c\u667a\u80fd\u5206\u6790\u963b\u65ad\uff0c\u4e5f\u53ef\u81ea\u5b9a\u4e49\u62e6\u622a\u89c4\u5219\uff0c\u9884\u9632\u8bef\u64cd\u4f5c\u3002<\/li><\/ul>\n\n\n\n<p><strong>\u516d.Mybatis-Plus \u5e38\u7528\u64cd\u4f5c<\/strong><\/p>\n\n\n\n<p><strong>6.1 \u914d\u7f6e\u65e5\u5fd7<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<pre class=\"wp-block-preformatted\">\u3010\u53c2\u8003\u5730\u5740\uff08\u4e24\u79cd\u65b9\u5f0f\u914d\u7f6e\u65e5\u5fd7\uff09\u3011     \n https:\/\/blog.csdn.net\/dfBeautifulLive\/article\/details\/100700365 <\/pre>\n\n\n\n<p>\u60f3\u8981\u67e5\u770b\u6267\u884c\u7684 sql \u8bed\u53e5\uff0c\u53ef\u4ee5\u5728 yml \u6587\u4ef6\u4e2d\u6dfb\u52a0\u914d\u7f6e\u4fe1\u606f\uff0c\u5982\u4e0b\u3002 <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mybatis-plus:\n  configuration:\n    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl<\/pre>\n\n\n\n<p>\u5982\u4e0b\u56fe\u6240\u793a\uff1a\u6267\u884c\u65f6\u4f1a\u6253\u5370\u51fa sql \u8bed\u53e5\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-182-1024x574.png\" alt=\"\" class=\"wp-image-8482\" width=\"609\" height=\"340\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-182-1024x574.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-182-300x168.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-182-1536x861.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-182-830x465.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-182-230x129.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-182-350x196.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-182-480x269.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-182.png 2048w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/figure><\/div>\n\n\n\n<p><strong>6.2 \u4ee3\u7801\u751f\u6210\u5668<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>AutoGenerator \u662f MyBatis-Plus \u7684\u4ee3\u7801\u751f\u6210\u5668\uff0c\u901a\u8fc7 AutoGenerator \u53ef\u4ee5\u5feb\u901f\u751f\u6210 Entity\u3001Mapper\u3001Mapper XML\u3001Service\u3001Controller \u7b49\u5404\u4e2a\u6a21\u5757\u7684\u4ee3\u7801\uff0c\u6781\u5927\u7684\u63d0\u5347\u4e86\u5f00\u53d1\u6548\u7387\u3002<\/p>\n\n\n\n<p>\u4e0e mybatis \u4e2d\u7684 mybatis-generator-core \u7c7b\u4f3c\u3002<\/p>\n\n\n\n<p>\u6dfb\u52a0\u4f9d\u8d56<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;dependency>\n    &lt;groupId>com.baomidou&lt;\/groupId>\n    &lt;artifactId>mybatis-plus-generator&lt;\/artifactId>\n    &lt;version>3.3.1.tmp&lt;\/version>\n&lt;\/dependency>\n&lt;!-- \u6dfb\u52a0 \u6a21\u677f\u5f15\u64ce \u4f9d\u8d56 -->\n&lt;dependency>\n    &lt;groupId>org.apache.velocity&lt;\/groupId>\n    &lt;artifactId>velocity-engine-core&lt;\/artifactId>\n    &lt;version>2.2&lt;\/version>\n&lt;\/dependency><\/pre>\n\n\n\n<p>\u4ee3\u7801\u5206\u6790<\/p>\n\n\n\n<p>Step1\uff1a\u521b\u5efa\u4e00\u4e2a \u4ee3\u7801\u751f\u6210\u5668\u3002\u7528\u4e8e\u751f\u6210\u4ee3\u7801\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ Step1\uff1a\u4ee3\u7801\u751f\u6210\u5668\nAutoGenerator mpg = new AutoGenerator();<\/pre>\n\n\n\n<p>Step2\uff1a\u914d\u7f6e\u5168\u5c40\u4fe1\u606f\u3002\u6307\u5b9a\u4ee3\u7801\u8f93\u51fa\u8def\u5f84\uff0c\u4ee5\u53ca\u5305\u540d\u3001\u4f5c\u8005\u7b49\u4fe1\u606f\u3002\u6b64\u5904\u6309\u9700\u6dfb\u52a0\uff0cprojectPath \u9700\u8981\u4fee\u6539\uff0csetAuthor \u9700\u8981\u4fee\u6539\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ Step2\uff1a\u5168\u5c40\u914d\u7f6e\nGlobalConfig gc = new GlobalConfig();\n\/\/ \u586b\u5199\u4ee3\u7801\u751f\u6210\u7684\u76ee\u5f55(\u9700\u8981\u4fee\u6539)\nString projectPath = \"E:\\\\myProject\\\\test\\\\test_mybatis_plus\";\n\/\/ \u62fc\u63a5\u51fa\u4ee3\u7801\u6700\u7ec8\u8f93\u51fa\u7684\u76ee\u5f55\ngc.setOutputDir(projectPath + \"\/src\/main\/java\");\n\/\/ \u914d\u7f6e\u5f00\u53d1\u8005\u4fe1\u606f\uff08\u53ef\u9009\uff09\uff08\u9700\u8981\u4fee\u6539\uff09\ngc.setAuthor(\"lyh\");\n\/\/ \u914d\u7f6e\u662f\u5426\u6253\u5f00\u76ee\u5f55\uff0cfalse \u4e3a\u4e0d\u6253\u5f00\uff08\u53ef\u9009\uff09\ngc.setOpen(false);\n\/\/ \u5b9e\u4f53\u5c5e\u6027 Swagger2 \u6ce8\u89e3\uff0c\u6dfb\u52a0 Swagger \u4f9d\u8d56\uff0c\u5f00\u542f Swagger2 \u6a21\u5f0f\uff08\u53ef\u9009\uff09\n\/\/gc.setSwagger2(true);\n\/\/ \u91cd\u65b0\u751f\u6210\u6587\u4ef6\u65f6\u662f\u5426\u8986\u76d6\uff0cfalse \u8868\u793a\u4e0d\u8986\u76d6\uff08\u53ef\u9009\uff09\ngc.setFileOverride(false);\n\/\/ \u914d\u7f6e\u4e3b\u952e\u751f\u6210\u7b56\u7565\uff0c\u6b64\u5904\u4e3a ASSIGN_ID\uff08\u53ef\u9009\uff09\ngc.setIdType(IdType.ASSIGN_ID);\n\/\/ \u914d\u7f6e\u65e5\u671f\u7c7b\u578b\uff0c\u6b64\u5904\u4e3a ONLY_DATE\uff08\u53ef\u9009\uff09\ngc.setDateType(DateType.ONLY_DATE);\n\/\/ \u9ed8\u8ba4\u751f\u6210\u7684 service \u4f1a\u6709 I \u524d\u7f00\ngc.setServiceName(\"%sService\");\nmpg.setGlobalConfig(gc);<\/pre>\n\n\n\n<p>Step3\uff1a\u914d\u7f6e\u6570\u636e\u6e90\u4fe1\u606f\u3002\u7528\u4e8e\u6307\u5b9a \u9700\u8981\u751f\u6210\u4ee3\u7801\u7684 \u6570\u636e\u4ed3\u5e93\u3001\u6570\u636e\u8868\u3002setUrl\u3001setDriverName\u3001setUsername\u3001setPassword \u5747\u9700\u4fee\u6539\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ Step3\uff1a\u6570\u636e\u6e90\u914d\u7f6e\uff08\u9700\u8981\u4fee\u6539\uff09\nDataSourceConfig dsc = new DataSourceConfig();\n\/\/ \u914d\u7f6e\u6570\u636e\u5e93 url \u5730\u5740\ndsc.setUrl(\"jdbc:mysql:\/\/localhost:3306\/testMyBatisPlus?useUnicode=true&amp;characterEncoding=utf8\");\n\/\/ dsc.setSchemaName(\"testMyBatisPlus\"); \/\/ \u53ef\u4ee5\u76f4\u63a5\u5728 url \u4e2d\u6307\u5b9a\u6570\u636e\u5e93\u540d\n\/\/ \u914d\u7f6e\u6570\u636e\u5e93\u9a71\u52a8\ndsc.setDriverName(\"com.mysql.cj.jdbc.Driver\");\n\/\/ \u914d\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\u7528\u6237\u540d\ndsc.setUsername(\"root\");\n\/\/ \u914d\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\u5bc6\u7801\ndsc.setPassword(\"123456\");\nmpg.setDataSource(dsc);<\/pre>\n\n\n\n<p>Step4\uff1a\u914d\u7f6e\u5305\u4fe1\u606f\u3002setParent\u3001setModuleName \u5747\u9700\u4fee\u6539\u3002\u5176\u4f59\u6309\u9700\u6c42\u4fee\u6539.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ Step:4\uff1a\u5305\u914d\u7f6e\nPackageConfig pc = new PackageConfig();\n\/\/ \u914d\u7f6e\u7236\u5305\u540d\uff08\u9700\u8981\u4fee\u6539\uff09\npc.setParent(\"com.lyh.test\");\n\/\/ \u914d\u7f6e\u6a21\u5757\u540d\uff08\u9700\u8981\u4fee\u6539\uff09\npc.setModuleName(\"test_mybatis_plus\");\n\/\/ \u914d\u7f6e entity \u5305\u540d\npc.setEntity(\"entity\");\n\/\/ \u914d\u7f6e mapper \u5305\u540d\npc.setMapper(\"mapper\");\n\/\/ \u914d\u7f6e service \u5305\u540d\npc.setService(\"service\");\n\/\/ \u914d\u7f6e controller \u5305\u540d\npc.setController(\"controller\");\nmpg.setPackageInfo(pc);<\/pre>\n\n\n\n<p>Step5\uff1a\u914d\u7f6e\u6570\u636e\u8868\u6620\u5c04\u4fe1\u606f\u3002setInclude \u9700\u8981\u4fee\u6539\uff0c\u5176\u4f59\u6309\u5b9e\u9645\u5f00\u53d1\u4fee\u6539\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ Step5\uff1a\u7b56\u7565\u914d\u7f6e\uff08\u6570\u636e\u5e93\u8868\u914d\u7f6e\uff09\nStrategyConfig strategy = new StrategyConfig();\n\/\/ \u6307\u5b9a\u8868\u540d\uff08\u53ef\u4ee5\u540c\u65f6\u64cd\u4f5c\u591a\u4e2a\u8868\uff0c\u4f7f\u7528 , \u9694\u5f00\uff09\uff08\u9700\u8981\u4fee\u6539\uff09\nstrategy.setInclude(\"test_mybatis_plus_user\");\n\/\/ \u914d\u7f6e\u6570\u636e\u8868\u4e0e\u5b9e\u4f53\u7c7b\u540d\u4e4b\u95f4\u6620\u5c04\u7684\u7b56\u7565\nstrategy.setNaming(NamingStrategy.underline_to_camel);\n\/\/ \u914d\u7f6e\u6570\u636e\u8868\u7684\u5b57\u6bb5\u4e0e\u5b9e\u4f53\u7c7b\u7684\u5c5e\u6027\u540d\u4e4b\u95f4\u6620\u5c04\u7684\u7b56\u7565\nstrategy.setColumnNaming(NamingStrategy.underline_to_camel);\n\/\/ \u914d\u7f6e lombok \u6a21\u5f0f\nstrategy.setEntityLombokModel(true);\n\/\/ \u914d\u7f6e rest \u98ce\u683c\u7684\u63a7\u5236\u5668\uff08@RestController\uff09\nstrategy.setRestControllerStyle(true);\n\/\/ \u914d\u7f6e\u9a7c\u5cf0\u8f6c\u8fde\u5b57\u7b26\nstrategy.setControllerMappingHyphenStyle(true);\n\/\/ \u914d\u7f6e\u8868\u524d\u7f00\uff0c\u751f\u6210\u5b9e\u4f53\u65f6\u53bb\u9664\u8868\u524d\u7f00\n\/\/ \u6b64\u5904\u7684\u8868\u540d\u4e3a test_mybatis_plus_user\uff0c\u6a21\u5757\u540d\u4e3a test_mybatis_plus\uff0c\u53bb\u9664\u524d\u7f00\u540e\u5269\u4e0b\u4e3a user\u3002\nstrategy.setTablePrefix(pc.getModuleName() + \"_\");\nmpg.setStrategy(strategy);<\/pre>\n\n\n\n<p>Step6\uff1a\u6267\u884c\u4ee3\u7801\u751f\u6210\u64cd\u4f5c\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ Step6\uff1a\u6267\u884c\u4ee3\u7801\u751f\u6210\u64cd\u4f5c\nmpg.execute();<\/pre>\n\n\n\n<p>\u5b8c\u6574\u914d\u7f6e\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">package com.lyh.test.test_mybatis_plus;\n\nimport com.baomidou.mybatisplus.annotation.IdType;\nimport com.baomidou.mybatisplus.generator.AutoGenerator;\nimport com.baomidou.mybatisplus.generator.config.DataSourceConfig;\nimport com.baomidou.mybatisplus.generator.config.GlobalConfig;\nimport com.baomidou.mybatisplus.generator.config.PackageConfig;\nimport com.baomidou.mybatisplus.generator.config.StrategyConfig;\nimport com.baomidou.mybatisplus.generator.config.rules.DateType;\nimport com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;\nimport org.junit.jupiter.api.Test;\n\npublic class TestAutoGenerate {\n    @Test\n    public void autoGenerate() {\n        \/\/ Step1\uff1a\u4ee3\u7801\u751f\u6210\u5668\n        AutoGenerator mpg = new AutoGenerator();\n\n        \/\/ Step2\uff1a\u5168\u5c40\u914d\u7f6e\n        GlobalConfig gc = new GlobalConfig();\n        \/\/ \u586b\u5199\u4ee3\u7801\u751f\u6210\u7684\u76ee\u5f55(\u9700\u8981\u4fee\u6539)\n        String projectPath = \"E:\\\\myProject\\\\test\\\\test_mybatis_plus\";\n        \/\/ \u62fc\u63a5\u51fa\u4ee3\u7801\u6700\u7ec8\u8f93\u51fa\u7684\u76ee\u5f55\n        gc.setOutputDir(projectPath + \"\/src\/main\/java\");\n        \/\/ \u914d\u7f6e\u5f00\u53d1\u8005\u4fe1\u606f\uff08\u53ef\u9009\uff09\uff08\u9700\u8981\u4fee\u6539\uff09\n        gc.setAuthor(\"lyh\");\n        \/\/ \u914d\u7f6e\u662f\u5426\u6253\u5f00\u76ee\u5f55\uff0cfalse \u4e3a\u4e0d\u6253\u5f00\uff08\u53ef\u9009\uff09\n        gc.setOpen(false);\n        \/\/ \u5b9e\u4f53\u5c5e\u6027 Swagger2 \u6ce8\u89e3\uff0c\u6dfb\u52a0 Swagger \u4f9d\u8d56\uff0c\u5f00\u542f Swagger2 \u6a21\u5f0f\uff08\u53ef\u9009\uff09\n        \/\/gc.setSwagger2(true);\n        \/\/ \u91cd\u65b0\u751f\u6210\u6587\u4ef6\u65f6\u662f\u5426\u8986\u76d6\uff0cfalse \u8868\u793a\u4e0d\u8986\u76d6\uff08\u53ef\u9009\uff09\n        gc.setFileOverride(false);\n        \/\/ \u914d\u7f6e\u4e3b\u952e\u751f\u6210\u7b56\u7565\uff0c\u6b64\u5904\u4e3a ASSIGN_ID\uff08\u53ef\u9009\uff09\n        gc.setIdType(IdType.ASSIGN_ID);\n        \/\/ \u914d\u7f6e\u65e5\u671f\u7c7b\u578b\uff0c\u6b64\u5904\u4e3a ONLY_DATE\uff08\u53ef\u9009\uff09\n        gc.setDateType(DateType.ONLY_DATE);\n        \/\/ \u9ed8\u8ba4\u751f\u6210\u7684 service \u4f1a\u6709 I \u524d\u7f00\n        gc.setServiceName(\"%sService\");\n        mpg.setGlobalConfig(gc);\n\n        \/\/ Step3\uff1a\u6570\u636e\u6e90\u914d\u7f6e\uff08\u9700\u8981\u4fee\u6539\uff09\n        DataSourceConfig dsc = new DataSourceConfig();\n        \/\/ \u914d\u7f6e\u6570\u636e\u5e93 url \u5730\u5740\n        dsc.setUrl(\"jdbc:mysql:\/\/localhost:3306\/testMyBatisPlus?useUnicode=true&amp;characterEncoding=utf8\");\n        \/\/ dsc.setSchemaName(\"testMyBatisPlus\"); \/\/ \u53ef\u4ee5\u76f4\u63a5\u5728 url \u4e2d\u6307\u5b9a\u6570\u636e\u5e93\u540d\n        \/\/ \u914d\u7f6e\u6570\u636e\u5e93\u9a71\u52a8\n        dsc.setDriverName(\"com.mysql.cj.jdbc.Driver\");\n        \/\/ \u914d\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\u7528\u6237\u540d\n        dsc.setUsername(\"root\");\n        \/\/ \u914d\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\u5bc6\u7801\n        dsc.setPassword(\"123456\");\n        mpg.setDataSource(dsc);\n\n        \/\/ Step:4\uff1a\u5305\u914d\u7f6e\n        PackageConfig pc = new PackageConfig();\n        \/\/ \u914d\u7f6e\u7236\u5305\u540d\uff08\u9700\u8981\u4fee\u6539\uff09\n        pc.setParent(\"com.lyh.test\");\n        \/\/ \u914d\u7f6e\u6a21\u5757\u540d\uff08\u9700\u8981\u4fee\u6539\uff09\n        pc.setModuleName(\"test_mybatis_plus\");\n        \/\/ \u914d\u7f6e entity \u5305\u540d\n        pc.setEntity(\"entity\");\n        \/\/ \u914d\u7f6e mapper \u5305\u540d\n        pc.setMapper(\"mapper\");\n        \/\/ \u914d\u7f6e service \u5305\u540d\n        pc.setService(\"service\");\n        \/\/ \u914d\u7f6e controller \u5305\u540d\n        pc.setController(\"controller\");\n        mpg.setPackageInfo(pc);\n\n        \/\/ Step5\uff1a\u7b56\u7565\u914d\u7f6e\uff08\u6570\u636e\u5e93\u8868\u914d\u7f6e\uff09\n        StrategyConfig strategy = new StrategyConfig();\n        \/\/ \u6307\u5b9a\u8868\u540d\uff08\u53ef\u4ee5\u540c\u65f6\u64cd\u4f5c\u591a\u4e2a\u8868\uff0c\u4f7f\u7528 , \u9694\u5f00\uff09\uff08\u9700\u8981\u4fee\u6539\uff09\n        strategy.setInclude(\"test_mybatis_plus_user\");\n        \/\/ \u914d\u7f6e\u6570\u636e\u8868\u4e0e\u5b9e\u4f53\u7c7b\u540d\u4e4b\u95f4\u6620\u5c04\u7684\u7b56\u7565\n        strategy.setNaming(NamingStrategy.underline_to_camel);\n        \/\/ \u914d\u7f6e\u6570\u636e\u8868\u7684\u5b57\u6bb5\u4e0e\u5b9e\u4f53\u7c7b\u7684\u5c5e\u6027\u540d\u4e4b\u95f4\u6620\u5c04\u7684\u7b56\u7565\n        strategy.setColumnNaming(NamingStrategy.underline_to_camel);\n        \/\/ \u914d\u7f6e lombok \u6a21\u5f0f\n        strategy.setEntityLombokModel(true);\n        \/\/ \u914d\u7f6e rest \u98ce\u683c\u7684\u63a7\u5236\u5668\uff08@RestController\uff09\n        strategy.setRestControllerStyle(true);\n        \/\/ \u914d\u7f6e\u9a7c\u5cf0\u8f6c\u8fde\u5b57\u7b26\n        strategy.setControllerMappingHyphenStyle(true);\n        \/\/ \u914d\u7f6e\u8868\u524d\u7f00\uff0c\u751f\u6210\u5b9e\u4f53\u65f6\u53bb\u9664\u8868\u524d\u7f00\n        \/\/ \u6b64\u5904\u7684\u8868\u540d\u4e3a test_mybatis_plus_user\uff0c\u6a21\u5757\u540d\u4e3a test_mybatis_plus\uff0c\u53bb\u9664\u524d\u7f00\u540e\u5269\u4e0b\u4e3a user\u3002\n        strategy.setTablePrefix(pc.getModuleName() + \"_\");\n        mpg.setStrategy(strategy);\n\n        \/\/ Step6\uff1a\u6267\u884c\u4ee3\u7801\u751f\u6210\u64cd\u4f5c\n        mpg.execute();\n    }\n}<\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-183-1024x507.png\" alt=\"\" class=\"wp-image-8483\" width=\"540\" height=\"266\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-183-1024x507.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-183-300x148.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-183-768x380.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-183-1536x760.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-183-2048x1013.png 2048w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-183-830x411.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-183-230x114.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-183-350x173.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-183-480x237.png 480w\" sizes=\"(max-width: 540px) 100vw, 540px\" \/><\/figure><\/div>\n\n\n\n<p><strong>6.3 \u5206\u9875\u63d2\u4ef6\u7684\u4f7f\u7528<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u4e0e mybatis \u7684\u63d2\u4ef6 pagehelper \u7528\u6cd5\u7c7b\u4f3c\u3002\u901a\u8fc7\u7b80\u5355\u7684\u914d\u7f6e\u5373\u53ef\u4f7f\u7528\u3002<\/p>\n\n\n\n<p>Step1\uff1a\u914d\u7f6e\u5206\u9875\u63d2\u4ef6\u3002\u7f16\u5199\u4e00\u4e2a \u914d\u7f6e\u7c7b\uff0c\u5185\u90e8\u4f7f\u7528 @Bean \u6ce8\u89e3\u5c06 PaginationInterceptor \u4ea4\u7ed9 Spring \u5bb9\u5668\u7ba1\u7406\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">package com.lyh.test.test_mybatis_plus.config;\n\nimport com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;\nimport org.mybatis.spring.annotation.MapperScan;\nimport org.springframework.context.annotation.Bean;\nimport org.springframework.context.annotation.Configuration;\n\n\/**\n * \u81ea\u5b9a\u4e49\u4e00\u4e2a\u914d\u7f6e\u7c7b\uff0cmapper \u626b\u63cf\u4e5f\u53ef\u5728\u6b64\u5199\u4e0a\n *\/\n@Configuration\n@MapperScan(\"com.lyh.test.test_mybatis_plus.mapper\")\npublic class Myconfig {\n    \/**\n     * \u5206\u9875\u63d2\u4ef6\n     * @return \u5206\u9875\u63d2\u4ef6\u7684\u5b9e\u4f8b\n     *\/\n    @Bean\n    public PaginationInterceptor paginationInterceptor() {\n        return new PaginationInterceptor();\n    }\n}<\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-184-1024x457.png\" alt=\"\" class=\"wp-image-8485\" width=\"602\" height=\"268\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-184-1024x457.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-184-300x134.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-184-768x343.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-184-1536x686.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-184-2048x914.png 2048w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-184-830x370.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-184-230x103.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-184-350x156.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-184-480x214.png 480w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/figure><\/div>\n\n\n\n<p>Step2\uff1a\u7f16\u5199\u5206\u9875\u4ee3\u7801\u3002\u76f4\u63a5 new \u4e00\u4e2a Page \u5bf9\u8c61\uff0c\u5bf9\u8c61\u9700\u8981\u4f20\u9012\u4e24\u4e2a\u53c2\u6570\uff08\u5f53\u524d\u9875\uff0c\u6bcf\u9875\u663e\u793a\u7684\u6761\u6570\uff09\u3002\u8c03\u7528 mybatis-plus \u63d0\u4f9b\u7684\u5206\u9875\u67e5\u8be2\u65b9\u6cd5\uff0c\u5176\u4f1a\u5c06 \u5206\u9875\u67e5\u8be2\u7684\u6570\u636e\u5c01\u88c5\u5230 Page \u5bf9\u8c61\u4e2d\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">@Test\npublic void testPage() {\n    \/\/ Step1\uff1a\u521b\u5efa\u4e00\u4e2a Page \u5bf9\u8c61\n    Page&lt;User> page = new Page&lt;>();\n    \/\/ Page&lt;User> page = new Page&lt;>(2, 5);\n    \/\/ Step2\uff1a\u8c03\u7528 mybatis-plus \u63d0\u4f9b\u7684\u5206\u9875\u67e5\u8be2\u65b9\u6cd5\n    userService.page(page, null);\n    \/\/ Step3\uff1a\u83b7\u53d6\u5206\u9875\u6570\u636e\n    System.out.println(page.getCurrent()); \/\/ \u83b7\u53d6\u5f53\u524d\u9875\n    System.out.println(page.getTotal()); \/\/ \u83b7\u53d6\u603b\u8bb0\u5f55\u6570\n    System.out.println(page.getSize()); \/\/ \u83b7\u53d6\u6bcf\u9875\u7684\u6761\u6570\n    System.out.println(page.getRecords()); \/\/ \u83b7\u53d6\u6bcf\u9875\u6570\u636e\u7684\u96c6\u5408\n    System.out.println(page.getPages()); \/\/ \u83b7\u53d6\u603b\u9875\u6570\n    System.out.println(page.hasNext()); \/\/ \u662f\u5426\u5b58\u5728\u4e0b\u4e00\u9875\n    System.out.println(page.hasPrevious()); \/\/ \u662f\u5426\u5b58\u5728\u4e0a\u4e00\u9875\n}<\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-185-1024x602.png\" alt=\"\" class=\"wp-image-8486\" width=\"531\" height=\"311\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-185-1024x602.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-185-300x176.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-185-768x451.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-185-1536x903.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-185-830x488.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-185-230x135.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-185-350x206.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-185-480x282.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-185.png 1960w\" sizes=\"(max-width: 531px) 100vw, 531px\" \/><\/figure><\/div>\n\n\n\n<p><strong>6.4 \u81ea\u52a8\u586b\u5145\u6570\u636e\u529f\u80fd<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u6dfb\u52a0\u3001\u4fee\u6539\u6570\u636e\u65f6\uff0c\u6bcf\u6b21\u90fd\u4f1a\u4f7f\u7528\u76f8\u540c\u7684\u65b9\u5f0f\u8fdb\u884c\u586b\u5145\u3002\u6bd4\u5982 \u6570\u636e\u7684\u521b\u5efa\u65f6\u95f4\u3001\u4fee\u6539\u65f6\u95f4\u7b49\u3002<\/p>\n\n\n\n<p>Mybatis-plus \u652f\u6301\u81ea\u52a8\u586b\u5145\u8fd9\u4e9b\u5b57\u6bb5\u7684\u6570\u636e\u3002\u7ed9\u4e4b\u524d\u7684\u6570\u636e\u8868\u65b0\u589e\u4e24\u4e2a\u5b57\u6bb5\uff1a\u521b\u5efa\u65f6\u95f4\u3001\u4fee\u6539\u65f6\u95f4\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE TABLE test_mybatis_plus_user\n(\n    id BIGINT NOT NULL COMMENT '\u4e3b\u952eID',\n    name VARCHAR(30) NULL DEFAULT NULL COMMENT '\u59d3\u540d',\n    age INT(11) NULL DEFAULT NULL COMMENT '\u5e74\u9f84',\n    email VARCHAR(50) NULL DEFAULT NULL COMMENT '\u90ae\u7bb1',\n    create_time timestamp NULL DEFAULT NULL COMMENT '\u521b\u5efa\u65f6\u95f4',\n    update_time timestamp NULL DEFAULT NULL COMMENT '\u6700\u540e\u4fee\u6539\u65f6\u95f4', \n    PRIMARY KEY (id)\n);<\/pre>\n\n\n\n<p>\u5e76\u4f7f\u7528 \u4ee3\u7801\u751f\u6210\u5668\u751f\u6210\u4ee3\u7801\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-186-1024x412.png\" alt=\"\" class=\"wp-image-8487\" width=\"566\" height=\"227\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-186-1024x412.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-186-300x121.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-186-768x309.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-186-1536x617.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-186-830x334.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-186-230x92.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-186-350x141.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-186-480x193.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-186.png 1990w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/><\/figure><\/div>\n\n\n\n<p>\u672a\u4f7f\u7528\u81ea\u52a8\u586b\u5145\u65f6\uff0c\u6bcf\u6b21\u6dfb\u52a0\u3001\u4fee\u6539\u6570\u636e\u90fd\u53ef\u4ee5\u624b\u52a8\u5bf9\u5176\u8fdb\u884c\u6dfb\u52a0\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">@SpringBootTest\nclass TestMybatisPlusApplicationTests {\n\n    @Autowired\n    private UserService userService;\n\n    @Test\n    public void testUpdate() {\n        User user = new User();\n        user.setName(\"tom\").setAge(20).setEmail(\"tom@163.com\");\n        \/\/ \u624b\u52a8\u6dfb\u52a0\u6570\u636e\n        user.setCreateTime(new Date()).setUpdateTime(new Date());\n        if (userService.save(user)) {\n            userService.list().forEach(System.out::println);\n        } else {\n            System.out.println(\"\u6dfb\u52a0\u6570\u636e\u5931\u8d25\");\n        }\n    }\n}<\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-187-1024x560.png\" alt=\"\" class=\"wp-image-8488\" width=\"579\" height=\"316\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-187-1024x560.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-187-300x164.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-187-768x420.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-187-1536x840.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-187-2048x1120.png 2048w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-187-830x454.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-187-230x126.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-187-350x191.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-187-480x262.png 480w\" sizes=\"(max-width: 579px) 100vw, 579px\" \/><\/figure><\/div>\n\n\n\n<p>\u4f7f\u7528\u81ea\u52a8\u586b\u5145\u529f\u80fd\u3002<\/p>\n\n\n\n<p>Step1\uff1a\u4f7f\u7528 @TableField \u6ce8\u89e3\uff0c\u6807\u6ce8\u9700\u8981\u8fdb\u884c\u586b\u5145\u7684\u5b57\u6bb5\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/**\n * \u521b\u5efa\u65f6\u95f4\n *\/\n@TableField(fill = FieldFill.INSERT)\nprivate Date createTime;\n\n\/**\n * \u6700\u540e\u4fee\u6539\u65f6\u95f4\n *\/\n@TableField(fill = FieldFill.INSERT_UPDATE)\nprivate Date updateTime;<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"320\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-188-1024x320.png\" alt=\"\" class=\"wp-image-8489\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-188-1024x320.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-188-300x94.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-188-768x240.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-188-1536x481.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-188-830x260.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-188-230x72.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-188-350x110.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-188-480x150.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-188.png 2020w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Step2\uff1a\u81ea\u5b9a\u4e49\u4e00\u4e2a\u7c7b\uff0c\u5b9e\u73b0 MetaObjectHandler \u63a5\u53e3\uff0c\u5e76\u91cd\u5199\u65b9\u6cd5\u3002\u6dfb\u52a0 @Component \u6ce8\u89e3\uff0c\u4ea4\u7ed9 Spring \u53bb\u7ba1\u7406\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">package com.lyh.test.test_mybatis_plus.handler;\n\nimport com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;\nimport org.apache.ibatis.reflection.MetaObject;\nimport org.springframework.stereotype.Component;\n\nimport java.util.Date;\n\n@Component\npublic class MyMetaObjectHandler implements MetaObjectHandler {\n    @Override\n    public void insertFill(MetaObject metaObject) {\n        this.strictInsertFill(metaObject, \"createTime\", Date.class, new Date());\n        this.strictInsertFill(metaObject, \"updateTime\", Date.class, new Date());\n    }\n\n    @Override\n    public void updateFill(MetaObject metaObject) {\n        this.strictUpdateFill(metaObject, \"updateTime\", Date.class, new Date());\n    }\n}<\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-189-1024x310.png\" alt=\"\" class=\"wp-image-8490\" width=\"614\" height=\"186\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-189-1024x310.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-189-300x91.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-189-768x233.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-189-1536x465.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-189-2048x620.png 2048w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-189-830x251.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-189-230x70.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-189-350x106.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-189-480x145.png 480w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/figure><\/div>\n\n\n\n<p>Step3\uff1a\u7b80\u5355\u6d4b\u8bd5\u4e00\u4e0b\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">@Test\npublic void testAutoFill() {\n    User user = new User();\n    user.setName(\"tom\").setAge(20).setEmail(\"tom@163.com\");\n    if (userService.save(user)) {\n        userService.list().forEach(System.out::println);\n    } else {\n        System.out.println(\"\u6dfb\u52a0\u6570\u636e\u5931\u8d25\");\n    }\n}<\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-190-1024x530.png\" alt=\"\" class=\"wp-image-8491\" width=\"560\" height=\"289\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-190-1024x530.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-190-300x155.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-190-768x398.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-190-1536x796.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-190-2048x1061.png 2048w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-190-830x430.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-190-230x119.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-190-350x181.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-190-480x249.png 480w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/figure><\/div>\n\n\n\n<p><strong>6.5 \u903b\u8f91\u5220\u9664<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u5220\u9664\u6570\u636e\uff0c\u53ef\u4ee5\u901a\u8fc7\u7269\u7406\u5220\u9664\uff0c\u4e5f\u53ef\u4ee5\u901a\u8fc7\u903b\u8f91\u5220\u9664\u3002<\/p>\n\n\n\n<p>\u7269\u7406\u5220\u9664\u6307\u7684\u662f\u76f4\u63a5\u5c06\u6570\u636e\u4ece\u6570\u636e\u5e93\u4e2d\u5220\u9664\uff0c\u4e0d\u4fdd\u7559\u3002<\/p>\n\n\n\n<p>\u903b\u8f91\u5220\u9664\u6307\u7684\u662f\u4fee\u6539\u6570\u636e\u7684\u67d0\u4e2a\u5b57\u6bb5\uff0c\u4f7f\u5176\u8868\u793a\u4e3a\u5df2\u5220\u9664\u72b6\u6001\uff0c\u800c\u975e\u5220\u9664\u6570\u636e\uff0c\u4fdd\u7559\u8be5\u6570\u636e\u5728\u6570\u636e\u5e93\u4e2d\uff0c\u4f46\u662f\u67e5\u8be2\u65f6\u4e0d\u663e\u793a\u8be5\u6570\u636e\uff08\u67e5\u8be2\u65f6\u8fc7\u6ee4\u6389\u8be5\u6570\u636e\uff09\u3002<\/p>\n\n\n\n<p>\u7ed9\u6570\u636e\u8868\u589e\u52a0\u4e00\u4e2a\u5b57\u6bb5\uff1adelete_flag\uff0c\u7528\u4e8e\u8868\u793a\u8be5\u6570\u636e\u662f\u5426\u88ab\u903b\u8f91\u5220\u9664\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE TABLE test_mybatis_plus_user\n(\n    id BIGINT NOT NULL COMMENT '\u4e3b\u952eID',\n    name VARCHAR(30) NULL DEFAULT NULL COMMENT '\u59d3\u540d',\n    age INT(11) NULL DEFAULT NULL COMMENT '\u5e74\u9f84',\n    email VARCHAR(50) NULL DEFAULT NULL COMMENT '\u90ae\u7bb1',\n    create_time timestamp NULL DEFAULT NULL COMMENT '\u521b\u5efa\u65f6\u95f4',\n    update_time timestamp NULL DEFAULT NULL COMMENT '\u6700\u540e\u4fee\u6539\u65f6\u95f4', \n    delete_flag tinyint(1) NULL DEFAULT NULL COMMENT '\u903b\u8f91\u5220\u9664\uff080 \u672a\u5220\u9664\u30011 \u5220\u9664\uff09',\n    PRIMARY KEY (id)\n);<\/pre>\n\n\n\n<p>\u4f7f\u7528\u903b\u8f91\u5220\u9664\u3002\u53ef\u4ee5\u5b9a\u4e49\u4e00\u4e2a\u81ea\u52a8\u586b\u5145\u89c4\u5219\uff0c\u521d\u59cb\u503c\u4e3a 0\u30020 \u8868\u793a\u672a\u5220\u9664\uff0c 1 \u8868\u793a\u5220\u9664\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/**\n * \u903b\u8f91\u5220\u9664\uff080 \u672a\u5220\u9664\u30011 \u5220\u9664\uff09\n *\/\n@TableLogic(value = \"0\", delval = \"1\")\n@TableField(fill = FieldFill.INSERT)\nprivate Integer deleteFlag;\n\n\n@Override\npublic void insertFill(MetaObject metaObject) {\n    this.strictInsertFill(metaObject, \"deleteFlag\", Integer.class, 0);\n}<\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-191-1024x377.png\" alt=\"\" class=\"wp-image-8492\" width=\"608\" height=\"224\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-191-1024x377.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-191-300x110.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-191-768x283.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-191-1536x565.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-191-2048x754.png 2048w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-191-830x305.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-191-230x85.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-191-350x129.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-191-480x177.png 480w\" sizes=\"(max-width: 608px) 100vw, 608px\" \/><\/figure><\/div>\n\n\n\n<p>\u7b80\u5355\u6d4b\u8bd5\uff1a\u4f7f\u7528 mybatis-plus \u5c01\u88c5\u597d\u7684\u65b9\u6cd5\u65f6\uff0c\u4f1a\u81ea\u52a8\u6dfb\u52a0\u903b\u8f91\u5220\u9664\u7684\u529f\u80fd\u3002\u82e5\u662f\u81ea\u5b9a\u4e49\u7684 sql \u8bed\u53e5\uff0c\u9700\u8981\u624b\u52a8\u6dfb\u52a0\u903b\u8f91\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">@Test\npublic void testDelete() {\n    if (userService.removeById(1258924257048547329L)) {\n        System.out.println(\"\u5220\u9664\u6570\u636e\u6210\u529f\");\n        userService.list().forEach(System.out::println);\n    } else {\n        System.out.println(\"\u5220\u9664\u6570\u636e\u5931\u8d25\");\n    }\n}<\/pre>\n\n\n\n<p>\u73b0\u6709\u6570\u636e<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-192-1024x166.png\" alt=\"\" class=\"wp-image-8493\" width=\"549\" height=\"89\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-192-1024x166.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-192-300x48.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-192-768x124.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-192-1536x248.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-192-830x134.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-192-230x37.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-192-350x57.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-192-480x78.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-192.png 1658w\" sizes=\"(max-width: 549px) 100vw, 549px\" \/><\/figure><\/div>\n\n\n\n<p>\u6267\u884c testDelete \u8fdb\u884c\u903b\u8f91\u5220\u9664\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-193-1024x501.png\" alt=\"\" class=\"wp-image-8494\" width=\"564\" height=\"275\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-193-1024x501.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-193-300x147.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-193-768x376.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-193-1536x751.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-193-2048x1002.png 2048w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-193-830x406.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-193-230x112.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-193-350x171.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-193-480x235.png 480w\" sizes=\"(max-width: 564px) 100vw, 564px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-194-1024x231.png\" alt=\"\" class=\"wp-image-8495\" width=\"570\" height=\"128\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-194-1024x231.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-194-300x68.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-194-768x173.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-194-1536x346.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-194-830x187.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-194-230x52.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-194-350x79.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-194-480x108.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-194.png 1678w\" sizes=\"(max-width: 570px) 100vw, 570px\" \/><\/figure><\/div>\n\n\n\n<p>\u82e5\u53bb\u9664 TableLogic \u6ce8\u89e3\uff0c\u518d\u6267\u884c testDelete \u65f6\u8fdb\u884c\u7269\u7406\u5220\u9664\uff0c\u76f4\u63a5\u5220\u9664\u8fd9\u6761\u6570\u636e\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-195-1024x535.png\" alt=\"\" class=\"wp-image-8496\" width=\"588\" height=\"306\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-195-1024x535.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-195-300x157.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-195-768x401.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-195-1536x803.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-195-2048x1070.png 2048w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-195-830x434.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-195-230x120.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-195-350x183.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-195-480x251.png 480w\" sizes=\"(max-width: 588px) 100vw, 588px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-196-1024x192.png\" alt=\"\" class=\"wp-image-8497\" width=\"592\" height=\"110\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-196-1024x192.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-196-300x56.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-196-768x144.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-196-1536x288.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-196-830x156.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-196-230x43.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-196-350x66.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-196-480x90.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/11\/\u56fe\u7247-196.png 1708w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001\u4e86\u89e3mybatisplus MyBatis-Plus \uff08\u7b80\u79f0 MP\uff09\u662f\u4e00\u4e2a MyBatis \u7684\u589e\u5f3a\u5de5\u5177\uff0c\u5728 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,27],"tags":[],"_links":{"self":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/8474"}],"collection":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8474"}],"version-history":[{"count":7,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/8474\/revisions"}],"predecessor-version":[{"id":8502,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/8474\/revisions\/8502"}],"wp:attachment":[{"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8474"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}