{"id":68336,"date":"2026-01-30T01:41:37","date_gmt":"2026-01-29T17:41:37","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/68336.html"},"modified":"2026-01-30T01:41:37","modified_gmt":"2026-01-29T17:41:37","slug":"mybatis-plus%e5%bf%ab%e9%80%9f%e5%85%a5%e9%97%a8","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/68336.html","title":{"rendered":"Mybatis Plus\u5feb\u901f\u5165\u95e8"},"content":{"rendered":"<h4 id=\"e05dce83\">\u7b80\u4ecb<\/h4>\n<p id=\"u0c8ad53d\">\u5b98\u7f51&#xff1a;https:\/\/baomidou.com\/<\/p>\n<p id=\"ucba015b2\">MyBatis-Plus \u662f\u4e00\u4e2a MyBatis \u7684\u589e\u5f3a\u5de5\u5177&#xff0c;\u5728 MyBatis \u7684\u57fa\u7840\u4e0a\u53ea\u505a\u589e\u5f3a\u4e0d\u505a\u6539\u53d8&#xff0c;\u4e3a\u7b80\u5316\u5f00\u53d1\u3001\u63d0\u9ad8\u6548\u7387\u800c\u751f\u3002<\/p>\n<p id=\"u343941c6\">\u613f\u666f<\/p>\n<p id=\"u733a8db3\">\u6211\u4eec\u7684\u613f\u666f\u662f\u6210\u4e3a MyBatis \u6700\u597d\u7684\u642d\u6863&#xff0c;\u5c31\u50cf \u9b42\u6597\u7f57 \u4e2d\u7684 1P\u30012P&#xff0c;\u57fa\u53cb\u642d\u914d&#xff0c;\u6548\u7387\u7ffb\u500d\u3002<\/p>\n<p id=\"u4aaecc0c\">&#xff08;\u7b80\u79f0 MP&#xff09;\u662f\u4e00\u4e2aMybatis \u7684\u589e\u5f3a\u5de5\u5177&#xff0c;\u5728 MyBatis \u7684\u57fa\u7840\u4e0a\u53ea\u505a\u589e\u5f3a\u4e0d\u505a\u6539\u53d8&#xff0c;\u5b8c\u5168\u53bbSQL\u5316&#xff0c;\u5c01\u88c5\u597d\u4e86\u5927\u91cf\u7684CURD\u64cd\u4f5c\u3002 \u751a\u81f3\u628aCRUD\u64cd\u4f5c\u5c01\u88c5\u5230\u4e86Service\u5c42&#xff0c;\u53ef\u4ee5\u76f4\u63a5\u5728controller\u8c03\u7528\u73b0\u6210\u7684CRUD\u670d\u52a1\u5c42&#xff0c;\u6781\u5ea6\u8212\u9002\u7701\u5fc3\u3002<\/p>\n<p id=\"uf407593e\">\u5c40\u9650&#xff1a;\u53ea\u652f\u6301\u7b80\u5355\u7684CRUD \u64cd\u4f5c\u3002\u4e0d\u652f\u6301\u591a\u8868\u64cd\u4f5c&#xff08;join ,union,\u5b50\u67e5\u8be2&#xff09; \u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"559\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174130-697b9bca7e85b.png\" width=\"1464\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1435\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174130-697b9bcaca051.png\" width=\"1578\" \/><\/p>\n<\/p>\n<h4 id=\"c1b18ad6\">\u5feb\u901f\u4e0a\u624b<\/h4>\n<h4>1.\u5efa\u8868 <img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"752\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174131-697b9bcbb8871.png\" width=\"850\" \/><\/h4>\n<\/p>\n<p>DROP TABLE IF EXISTS &#096;user&#096;;<\/p>\n<p>CREATE TABLE &#096;user&#096;<br \/>\n(<br \/>\n    id BIGINT NOT NULL COMMENT &#039;\u4e3b\u952eID&#039;,<br \/>\n    name VARCHAR(30) NULL DEFAULT NULL COMMENT &#039;\u59d3\u540d&#039;,<br \/>\n    age INT NULL DEFAULT NULL COMMENT &#039;\u5e74\u9f84&#039;,<br \/>\n    email VARCHAR(50) NULL DEFAULT NULL COMMENT &#039;\u90ae\u7bb1&#039;,<br \/>\n    PRIMARY KEY (id)<br \/>\n);<\/p>\n<p>select * from user;<\/p>\n<p>INSERT INTO &#096;user&#096; (id, name, age, email) VALUES<br \/>\n(1, &#039;Jone&#039;, 18, &#039;test1&#064;baomidou.com&#039;),<br \/>\n(2, &#039;Jack&#039;, 20, &#039;test2&#064;baomidou.com&#039;),<br \/>\n(3, &#039;Tom&#039;, 28, &#039;test3&#064;baomidou.com&#039;),<br \/>\n(4, &#039;Sandy&#039;, 21, &#039;test4&#064;baomidou.com&#039;),<br \/>\n(5, &#039;Billie&#039;, 24, &#039;test5&#064;baomidou.com&#039;); <\/p>\n<li id=\"ueed0c790\">\u9879\u76ee\u4f9d\u8d56<\/li>\n<p>&lt;?xml version&#061;&#034;1.0&#034; encoding&#061;&#034;UTF-8&#034;?&gt;<br \/>\n&lt;project xmlns&#061;&#034;http:\/\/maven.apache.org\/POM\/4.0.0&#034; xmlns:xsi&#061;&#034;http:\/\/www.w3.org\/2001\/XMLSchema-instance&#034;<br \/>\n         xsi:schemaLocation&#061;&#034;http:\/\/maven.apache.org\/POM\/4.0.0 https:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd&#034;&gt;<br \/>\n    &lt;modelVersion&gt;4.0.0&lt;\/modelVersion&gt;<br \/>\n    &lt;!&#8211;&lt;parent&gt;<br \/>\n        &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;<br \/>\n        &lt;artifactId&gt;spring-boot-starter-parent&lt;\/artifactId&gt;<br \/>\n        &lt;version&gt;3.5.9&lt;\/version&gt;<br \/>\n        &lt;relativePath\/&gt; &amp;lt;!&amp;ndash; lookup parent from repository &amp;ndash;&amp;gt;<br \/>\n    &lt;\/parent&gt;&#8211;&gt;<br \/>\n    &lt;groupId&gt;com.bigdata&lt;\/groupId&gt;<br \/>\n    &lt;artifactId&gt;demo1&lt;\/artifactId&gt;<br \/>\n    &lt;version&gt;0.0.1-SNAPSHOT&lt;\/version&gt;<br \/>\n    &lt;name&gt;demo1&lt;\/name&gt;<br \/>\n    &lt;description&gt;demo1&lt;\/description&gt;<br \/>\n    &lt;properties&gt;<br \/>\n        &lt;java.version&gt;1.8&lt;\/java.version&gt;<br \/>\n        &lt;spring-cloud-alibaba.version&gt;2.2.2.RELEASE&lt;\/spring-cloud-alibaba.version&gt;<br \/>\n        &lt;spring-cloud.version&gt;Hoxton.SR8&lt;\/spring-cloud.version&gt;<br \/>\n        &lt;mybatis-plus.version&gt;3.5.5&lt;\/mybatis-plus.version&gt;<br \/>\n        &lt;velocity.version&gt;2.0&lt;\/velocity.version&gt;<br \/>\n        &lt;swagger.version&gt;2.9.2&lt;\/swagger.version&gt;<br \/>\n        &lt;swagger-bootstrap-ui.version&gt;1.9.2&lt;\/swagger-bootstrap-ui.version&gt;<br \/>\n        &lt;commons-lang3.version&gt;3.9&lt;\/commons-lang3.version&gt;<br \/>\n        &lt;commons-fileupload.version&gt;1.3.1&lt;\/commons-fileupload.version&gt;<br \/>\n        &lt;commons-io.version&gt;2.6&lt;\/commons-io.version&gt;<br \/>\n        &lt;fastjson.version&gt;1.2.28&lt;\/fastjson.version&gt;<br \/>\n        &lt;gson.version&gt;2.8.6&lt;\/gson.version&gt;<br \/>\n        &lt;json.version&gt;20170516&lt;\/json.version&gt;<br \/>\n        &lt;jodatime.version&gt;2.10.1&lt;\/jodatime.version&gt;<br \/>\n        &lt;jwt.version&gt;0.7.0&lt;\/jwt.version&gt;<br \/>\n        &lt;httpclient.version&gt;4.5.1&lt;\/httpclient.version&gt;<br \/>\n    &lt;\/properties&gt;<\/p>\n<p>    &lt;parent&gt;<br \/>\n        &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;<br \/>\n        &lt;artifactId&gt;spring-boot-starter-parent&lt;\/artifactId&gt;<br \/>\n        &lt;version&gt;2.3.4.RELEASE&lt;\/version&gt;<br \/>\n        &lt;relativePath\/&gt; &lt;!&#8211; lookup parent from repository &#8211;&gt;<br \/>\n    &lt;\/parent&gt;<\/p>\n<p>    &lt;dependencies&gt;<br \/>\n        &lt;dependency&gt;<br \/>\n            &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;<br \/>\n            &lt;artifactId&gt;spring-boot-starter-web&lt;\/artifactId&gt;<br \/>\n        &lt;\/dependency&gt;<br \/>\n        &lt;dependency&gt;<br \/>\n            &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;<br \/>\n            &lt;artifactId&gt;spring-boot-starter-test&lt;\/artifactId&gt;<br \/>\n        &lt;\/dependency&gt;<br \/>\n        &lt;!&#8211;mybatis-plus&#8211;&gt;<br \/>\n        &lt;dependency&gt;<br \/>\n            &lt;groupId&gt;com.baomidou&lt;\/groupId&gt;<br \/>\n            &lt;artifactId&gt;mybatis-plus-boot-starter&lt;\/artifactId&gt;<br \/>\n            &lt;version&gt;${mybatis-plus.version}&lt;\/version&gt;<br \/>\n        &lt;\/dependency&gt;<br \/>\n        &lt;!&#8211;mybatis-plus \u4ee3\u7801\u751f\u6210\u5668&#8211;&gt;<br \/>\n        &lt;dependency&gt;<br \/>\n            &lt;groupId&gt;com.baomidou&lt;\/groupId&gt;<br \/>\n            &lt;artifactId&gt;mybatis-plus-generator&lt;\/artifactId&gt;<br \/>\n            &lt;version&gt;${mybatis-plus.version}&lt;\/version&gt;<br \/>\n        &lt;\/dependency&gt;<br \/>\n        &lt;!&#8211; Mybatis Plus \u4ee3\u7801\u751f\u6210\u5668\u6a21\u677f\u5f15\u64ce,  &#8211;&gt;<br \/>\n        &lt;dependency&gt;<br \/>\n            &lt;groupId&gt;org.apache.velocity&lt;\/groupId&gt;<br \/>\n            &lt;artifactId&gt;velocity-engine-core&lt;\/artifactId&gt;<br \/>\n            &lt;version&gt;${velocity.version}&lt;\/version&gt;<br \/>\n        &lt;\/dependency&gt;<\/p>\n<p>        &lt;dependency&gt;<br \/>\n            &lt;groupId&gt;org.projectlombok&lt;\/groupId&gt;<br \/>\n            &lt;artifactId&gt;lombok&lt;\/artifactId&gt;<br \/>\n        &lt;\/dependency&gt;<\/p>\n<p>        &lt;dependency&gt;<br \/>\n            &lt;groupId&gt;mysql&lt;\/groupId&gt;<br \/>\n            &lt;artifactId&gt;mysql-connector-java&lt;\/artifactId&gt;<br \/>\n        &lt;\/dependency&gt;<\/p>\n<p>        &lt;dependency&gt;<br \/>\n            &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;<br \/>\n            &lt;artifactId&gt;spring-boot-starter-freemarker&lt;\/artifactId&gt;<br \/>\n        &lt;\/dependency&gt;<\/p>\n<p>       &lt;!&#8211; Spring Data Commons \u505a\u5206\u9875\u6709\u7528&#8211;&gt;<br \/>\n        &lt;dependency&gt;<br \/>\n            &lt;groupId&gt;org.springframework.data&lt;\/groupId&gt;<br \/>\n            &lt;artifactId&gt;spring-data-commons&lt;\/artifactId&gt;<br \/>\n        &lt;\/dependency&gt;<\/p>\n<p>    &lt;\/dependencies&gt;<\/p>\n<p>&lt;\/project&gt;<\/p>\n<li id=\"u2af8b07e\">application.yml<\/li>\n<p>server:<br \/>\n  port: 8081<\/p>\n<p>spring:<br \/>\n  profiles:<br \/>\n    active: dev<br \/>\n  application:<br \/>\n    name: mybatisplus-test<br \/>\n  datasource:<br \/>\n    driver-class-name: com.mysql.cj.jdbc.Driver<br \/>\n    url: jdbc:mysql:\/\/127.0.0.1:3306\/test?serverTimezone&#061;GMT%2B8&amp;characterEncoding&#061;utf-8<br \/>\n    username: root<br \/>\n    password: 123456<\/p>\n<p># \u6253\u5370SQL<br \/>\nmybatis-plus:<br \/>\n  configuration:<br \/>\n    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl <\/p>\n<p id=\"u25f00691\">\u6216\u8005\u5982\u4e0b\u6240\u793a&#xff1a;<\/p>\n<p>spring.application.name&#061;demo1<br \/>\nserver.port&#061;8081<br \/>\nspring.datasource.driver-class-name&#061;com.mysql.cj.jdbc.Driver<br \/>\nspring.datasource.url&#061;jdbc:mysql:\/\/127.0.0.1:3306\/mybatis?serverTimezone&#061;GMT%2B8&amp;characterEncoding&#061;utf-8<br \/>\nspring.datasource.username&#061;root<br \/>\nspring.datasource.password&#061;root<br \/>\nmybatis-plus.configuration.log-impl&#061;org.apache.ibatis.logging.stdout.StdOutImpl <\/p>\n<h4 id=\"8b8ca150\">\u4ee3\u7801\u751f\u6210\u5668<\/h4>\n<p id=\"ue60074b6\">\u867d\u7136mybatis-plus\u5df2\u7ecf\u8282\u7701\u4e86sql\u7f16\u5199\u7684\u5927\u90e8\u5206\u5de5\u4f5c&#xff0c;\u4f46\u662f\u5f53\u9762\u5bf9\u51e0\u5341\u4e0a\u767e\u4e2a\u8868\u7684\u6a21\u5757\u5904\u7406\u65f6&#xff0c;\u4ecd\u7136\u53c8\u5927\u91cf\u7684\u7c7b\u6a21\u5757\u8981\u7f16\u5199&#xff0c;\u5176\u4e2d\u6700\u5927\u7684\u5de5\u4f5c\u91cf\u5c31\u662f\u5b9e\u4f53\u7c7b\u7684\u7f16\u5199&#xff0c;\u5982\u679c\u624b\u5de5\u7f16\u5199\u8fd8\u5f88\u5bb9\u6613\u51fa\u9519\u3002<\/p>\n<p id=\"ud97aaa4e\">\u6240\u4ee5mybatis-plus\u8fd8\u63a8\u51fa\u4e86\u4ee3\u7801\u751f\u6210\u5de5\u5177\u3002<\/p>\n<p id=\"uf67f14ea\">\u5728pom.xml\u4e2d\u589e\u52a0\u4ee3\u7801\u751f\u6210\u5de5\u5177\u3002<\/p>\n<p id=\"u31c28be9\">\u589e\u52a0\u4e00\u4e2a\u4ee3\u7801\u751f\u6210\u7684\u5de5\u5177\u7c7b<\/p>\n<p>CREATE TABLE &#096;student&#096;  (<br \/>\n  &#096;id&#096; int(0) NOT NULL AUTO_INCREMENT COMMENT &#039;ID&#039;,<br \/>\n  &#096;name&#096; varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT &#039;\u59d3\u540d&#039;,<br \/>\n  &#096;age&#096; int(0) NULL DEFAULT NULL COMMENT &#039;\u5e74\u9f84&#039;,<br \/>\n  PRIMARY KEY (&#096;id&#096;) USING BTREE<br \/>\n) ENGINE &#061; InnoDB AUTO_INCREMENT &#061; 1 CHARACTER SET &#061; utf8mb4 COLLATE &#061; utf8mb4_0900_ai_ci ROW_FORMAT &#061; Dynamic;<br \/>\nSET FOREIGN_KEY_CHECKS &#061; 1;<\/p>\n<p>select * from student;<\/p>\n<p>INSERT INTO &#096;student&#096; (id, name, age) VALUES<br \/>\n(1, &#039;\u5f20\u4e09&#039;, 18),<br \/>\n(2, &#039;\u674e\u56db&#039;, 20); <\/p>\n<h4 id=\"VIgfn\">EasyCode \u81ea\u52a8\u4ee3\u7801\u751f\u6210:<\/h4>\n<p id=\"u6313fff1\">\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"999\" id=\"u022c5412\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174132-697b9bcc003e4.png\" width=\"1476\" \/><\/p>\n<p id=\"u3da6ee06\">idea \u8fde\u63a5\u6570\u636e\u5e93&#xff1a;<\/p>\n<p id=\"u18225c38\">\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"999\" id=\"u13632b29\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174132-697b9bcc8210f.png\" width=\"1558\" \/><\/p>\n<p id=\"ue7dae159\">\u7b2c\u4e00\u6b21\u9700\u8981\u4e0b\u8f7d\u9a71\u52a8&#xff1a;<\/p>\n<p id=\"u6016331e\">\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"1385\" id=\"uf269b0b9\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174133-697b9bcd447b7.png\" width=\"1602\" \/><\/p>\n<p id=\"ua9f3808b\">\u70b9\u51fb\u9700\u8981\u751f\u6210\u4ee3\u7801\u7684\u8868&#xff1a;<\/p>\n<p id=\"uc123c716\">\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"920\" id=\"ua309c410\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174134-697b9bce4b5b7.png\" width=\"1600\" \/><\/p>\n<p id=\"ub03062c9\">\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"612\" id=\"ue8dc9dc1\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174134-697b9bcee6e67.png\" width=\"1598\" \/><\/p>\n<p id=\"ucdc0afee\">\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"871\" id=\"u1b1db8c2\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174135-697b9bcf5d81e.png\" width=\"1050\" \/><\/p>\n<p id=\"u9228b358\">\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"519\" id=\"u5055628e\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174135-697b9bcfba7b9.png\" width=\"723\" \/><\/p>\n<p id=\"u967852d3\">\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"548\" id=\"ub1d1b74b\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174135-697b9bcfd75c9.png\" width=\"1882\" \/><\/p>\n<p id=\"u3965b0e3\">\u5982\u679c\u9700\u8981\u751f\u6210\u7b26\u5408\u81ea\u5df1\u9884\u671f\u7684\u4ee3\u7801&#xff0c;\u9700\u8981\u81ea\u5df1\u8bbe\u7f6e\u6a21\u7248\u3002<\/p>\n<p id=\"ueab755e3\">\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"997\" id=\"ua012ea9c\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174136-697b9bd043448.png\" width=\"1590\" \/><\/p>\n<p id=\"u8eac683f\">\n<p id=\"u4b9ec8f7\">\n<p>\u63a5\u7740\u53ef\u4ee5\u62ff teacher \u8868\u7ec3\u7ec3\u624b&#xff1a;<\/p>\n<p>CREATE TABLE &#096;teacher&#096;  (<br \/>\n  &#096;id&#096; int(0) NOT NULL AUTO_INCREMENT COMMENT &#039;ID&#039;,<br \/>\n  &#096;name&#096; varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT &#039;\u59d3\u540d&#039;,<br \/>\n  &#096;age&#096; int(0) NULL DEFAULT NULL COMMENT &#039;\u5e74\u9f84&#039;,<br \/>\n  PRIMARY KEY (&#096;id&#096;) USING BTREE<br \/>\n) ENGINE &#061; InnoDB AUTO_INCREMENT &#061; 1 CHARACTER SET &#061; utf8mb4 COLLATE &#061; utf8mb4_0900_ai_ci ROW_FORMAT &#061; Dynamic;<br \/>\nSET FOREIGN_KEY_CHECKS &#061; 1;<\/p>\n<p>select * from teacher;<\/p>\n<p>INSERT INTO &#096;teacher&#096; (id, name, age) VALUES<br \/>\n(1, &#039;\u5f20\u4e09&#039;, 18),<br \/>\n(2, &#039;\u674e\u56db&#039;, 20); <\/p>\n<h4 id=\"0943d61b\">\u6761\u4ef6\u67e5\u8be2<\/h4>\n<p id=\"ua6293753\">https:\/\/baomidou.com\/guides\/wrapper\/<\/p>\n<p id=\"u28d05de1\">\u666e\u901a Wrapper (QueryWrapper)&#xff1a;<\/p>\n<p>QueryWrapper&lt;User&gt; queryWrapper &#061; new QueryWrapper&lt;&gt;();<br \/>\nqueryWrapper.eq(&#034;name&#034;, &#034;\u8001\u738b&#034;); <\/p>\n<p id=\"u369dd2c2\">Lambda Wrapper (LambdaQueryWrapper)&#xff1a;<\/p>\n<p>LambdaQueryWrapper&lt;User&gt; lambdaQueryWrapper &#061; new LambdaQueryWrapper&lt;&gt;();<br \/>\nlambdaQueryWrapper.eq(User::getName, &#034;\u8001\u738b&#034;); <\/p>\n<p id=\"uee25d47a\">\u751f\u6210\u7684 SQL<\/p>\n<p>&#8212; \u666e\u901a Wrapper \u548c Lambda Wrapper \u751f\u6210\u7684 SQL \u76f8\u540c<br \/>\nSELECT * FROM user WHERE name &#061; &#039;\u8001\u738b&#039; <\/p>\n<p id=\"u03a34bdd\">\u6d4b\u8bd5&#xff1a;\u67e5\u8be2\u59d3\u540d\u662f \u5f20\u5f00\u5934&#xff0c;\u5e74\u9f84\u572810\u523020\u4e4b\u95f4\u7684\u5b66\u751f\u4fe1\u606f<\/p>\n<p>import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;<br \/>\nimport com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;<br \/>\nimport com.bigdata.ApplicationDemo;<br \/>\nimport com.bigdata.mapper.UserMapper;<br \/>\nimport com.bigdata.pojo.User;<\/p>\n<p>import org.junit.jupiter.api.Test;<br \/>\nimport org.springframework.beans.factory.annotation.Autowired;<br \/>\nimport org.springframework.boot.test.context.SpringBootTest;<\/p>\n<p>import java.util.List;<\/p>\n<p>&#064;SpringBootTest(classes &#061; ApplicationDemo.class)<br \/>\npublic class ApplicationTests {<\/p>\n<p>    &#064;Autowired<br \/>\n    UserMapper userMapper;<\/p>\n<p>    &#064;Test<br \/>\n    public void test1(){<br \/>\n        List&lt;User&gt; users &#061; userMapper.selectList(null);<br \/>\n        for (User user : users) {<br \/>\n            System.out.println(user);<br \/>\n        }<br \/>\n    }<\/p>\n<p>    &#064;Test<br \/>\n    public void test2(){<\/p>\n<p>       \/* QueryWrapper&lt;User&gt; queryWrapper &#061; new QueryWrapper&lt;&gt;();<br \/>\n        queryWrapper.eq(&#034;name&#034;,&#034;\u8001\u738b&#034;);*\/<\/p>\n<p>        LambdaQueryWrapper&lt;User&gt; queryWrapper &#061; new LambdaQueryWrapper&lt;&gt;();<br \/>\n        \/\/queryWrapper.eq(User::getName,&#034;\u8001\u738b&#034;);<br \/>\n        queryWrapper.lt(User::getAge,28);<br \/>\n        queryWrapper.gt(User::getAge,18);<\/p>\n<p>        List&lt;User&gt; users &#061; userMapper.selectList(queryWrapper);<br \/>\n        for (User user : users) {<br \/>\n            System.out.println(user);<br \/>\n        }<br \/>\n    }<\/p>\n<p>}<\/p>\n<h4 id=\"f47a0bfa\">\u5206\u9875\u67e5\u8be2<\/h4>\n<p id=\"u58f242f5\">https:\/\/baomidou.com\/guides\/data-interface\/#page<\/p>\n<p>\u00a0\u72c2\u8de8<\/p>\n<p>package com.demo.config;<\/p>\n<p>import com.baomidou.mybatisplus.annotation.DbType;<br \/>\nimport com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;<br \/>\nimport com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;<br \/>\nimport org.springframework.context.annotation.Bean;<br \/>\nimport org.springframework.context.annotation.Configuration;<\/p>\n<p>&#064;Configuration<br \/>\npublic class MybatisPlusConfig {<br \/>\n    \/**<br \/>\n     * \u65b0\u589e\u5206\u9875\u62e6\u622a\u5668&#xff0c;\u5e76\u8bbe\u7f6e\u6570\u636e\u5e93\u7c7b\u578b\u4e3amysql<br \/>\n     *\/<br \/>\n    &#064;Bean<br \/>\n    public MybatisPlusInterceptor mybatisPlusInterceptor() {<br \/>\n        MybatisPlusInterceptor interceptor &#061; new MybatisPlusInterceptor();<br \/>\n        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));<br \/>\n        return interceptor;<br \/>\n    }<br \/>\n}<\/p>\n<p>&#064;Test<br \/>\npublic void testPage(){<br \/>\n    IPage&lt;Student&gt; page &#061; new Page&lt;&gt;(1,10);<br \/>\n    IPage&lt;Student&gt; studentIPage &#061; studentService.page(page);<br \/>\n    List&lt;Student&gt; records &#061; studentIPage.getRecords();<br \/>\n    \/\/ \u6570\u636e\u5e93\u4e2d\u603b\u7684\u5b66\u751f\u7684\u6570\u91cf<br \/>\n    long total &#061; studentIPage.getTotal();<br \/>\n    System.out.println(total);<br \/>\n    \/\/ \u603b\u5171\u7684\u9875\u6570<br \/>\n    long pages &#061; studentIPage.getPages();<br \/>\n    System.out.println(pages);<br \/>\n    \/\/ \u6bcf\u9875\u5c55\u793a\u591a\u5c11\u6761\u6570\u636e<br \/>\n    long size &#061; studentIPage.getSize();<br \/>\n    System.out.println(size);<\/p>\n<p>    \/\/ \u5faa\u73af\u6253\u5370\u5f53\u524d\u9875\u7684\u6570\u636e<br \/>\n    for (Student student : records) {<br \/>\n        System.out.println(student);<br \/>\n    }<br \/>\n} <\/p>\n<p id=\"u43de0cc0\">\u6ce8\u610f\u5bfc\u5165\u7684 Page \u7684\u5305\u4e3a&#xff1a;<\/p>\n<p>import com.baomidou.mybatisplus.core.metadata.IPage;<br \/>\nimport com.baomidou.mybatisplus.extension.plugins.pagination.Page; <\/p>\n<\/p>\n<p id=\"u8c234a6f\">\n<p id=\"u7fd1c77d\">\n","protected":false},"excerpt":{"rendered":"<p>\u7b80\u4ecb<br \/>\n\u5b98\u7f51&#xff1a;https:\/\/baomidou.com\/<br \/>\nMyBatis-Plus \u662f\u4e00\u4e2a MyBatis \u7684\u589e\u5f3a\u5de5\u5177&#xff0c;\u5728 MyBatis \u7684\u57fa\u7840\u4e0a\u53ea\u505a\u589e\u5f3a\u4e0d\u505a\u6539\u53d8&#xff0c;\u4e3a\u7b80\u5316\u5f00\u53d1\u3001\u63d0\u9ad8\u6548\u7387\u800c\u751f\u3002<br \/>\n\u613f\u666f<br \/>\n\u6211\u4eec\u7684\u613f\u666f\u662f\u6210\u4e3a MyBatis \u6700\u597d\u7684\u642d\u6863&#xff0c;\u5c31\u50cf \u9b42\u6597\u7f57 \u4e2d\u7684 1P\u30012P&#xff0c;\u57fa\u53cb\u642d\u914d&#xff0c;\u6548\u7387\u7ffb\u500d\u3002<br \/>\n&#xff08;\u7b80\u79f0 MP&#xff09;\u662f\u4e00\u4e2aMybatis \u7684\u589e\u5f3a\u5de5\u5177&amp;#xff0c<\/p>\n","protected":false},"author":2,"featured_media":68324,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[99,190],"topic":[],"class_list":["post-68336","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-java","tag-190"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Mybatis Plus\u5feb\u901f\u5165\u95e8 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/68336.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mybatis Plus\u5feb\u901f\u5165\u95e8 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u7b80\u4ecb \u5b98\u7f51&#xff1a;https:\/\/baomidou.com\/ MyBatis-Plus \u662f\u4e00\u4e2a MyBatis \u7684\u589e\u5f3a\u5de5\u5177&#xff0c;\u5728 MyBatis \u7684\u57fa\u7840\u4e0a\u53ea\u505a\u589e\u5f3a\u4e0d\u505a\u6539\u53d8&#xff0c;\u4e3a\u7b80\u5316\u5f00\u53d1\u3001\u63d0\u9ad8\u6548\u7387\u800c\u751f\u3002 \u613f\u666f \u6211\u4eec\u7684\u613f\u666f\u662f\u6210\u4e3a MyBatis \u6700\u597d\u7684\u642d\u6863&#xff0c;\u5c31\u50cf \u9b42\u6597\u7f57 \u4e2d\u7684 1P\u30012P&#xff0c;\u57fa\u53cb\u642d\u914d&#xff0c;\u6548\u7387\u7ffb\u500d\u3002 &#xff08;\u7b80\u79f0 MP&#xff09;\u662f\u4e00\u4e2aMybatis \u7684\u589e\u5f3a\u5de5\u5177&amp;#xff0c\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/68336.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-29T17:41:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174130-697b9bca7e85b.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/68336.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/68336.html\",\"name\":\"Mybatis Plus\u5feb\u901f\u5165\u95e8 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-01-29T17:41:37+00:00\",\"dateModified\":\"2026-01-29T17:41:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/68336.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/68336.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/68336.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mybatis Plus\u5feb\u901f\u5165\u95e8\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mybatis Plus\u5feb\u901f\u5165\u95e8 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/68336.html","og_locale":"zh_CN","og_type":"article","og_title":"Mybatis Plus\u5feb\u901f\u5165\u95e8 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u7b80\u4ecb \u5b98\u7f51&#xff1a;https:\/\/baomidou.com\/ MyBatis-Plus \u662f\u4e00\u4e2a MyBatis \u7684\u589e\u5f3a\u5de5\u5177&#xff0c;\u5728 MyBatis \u7684\u57fa\u7840\u4e0a\u53ea\u505a\u589e\u5f3a\u4e0d\u505a\u6539\u53d8&#xff0c;\u4e3a\u7b80\u5316\u5f00\u53d1\u3001\u63d0\u9ad8\u6548\u7387\u800c\u751f\u3002 \u613f\u666f \u6211\u4eec\u7684\u613f\u666f\u662f\u6210\u4e3a MyBatis \u6700\u597d\u7684\u642d\u6863&#xff0c;\u5c31\u50cf \u9b42\u6597\u7f57 \u4e2d\u7684 1P\u30012P&#xff0c;\u57fa\u53cb\u642d\u914d&#xff0c;\u6548\u7387\u7ffb\u500d\u3002 &#xff08;\u7b80\u79f0 MP&#xff09;\u662f\u4e00\u4e2aMybatis \u7684\u589e\u5f3a\u5de5\u5177&amp;#xff0c","og_url":"https:\/\/www.wsisp.com\/helps\/68336.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-01-29T17:41:37+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129174130-697b9bca7e85b.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"6 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/68336.html","url":"https:\/\/www.wsisp.com\/helps\/68336.html","name":"Mybatis Plus\u5feb\u901f\u5165\u95e8 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-01-29T17:41:37+00:00","dateModified":"2026-01-29T17:41:37+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/68336.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/68336.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/68336.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"Mybatis Plus\u5feb\u901f\u5165\u95e8"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/68336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=68336"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/68336\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/68324"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=68336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=68336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=68336"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=68336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}