\u6d4b\u8bd5<\/li>\n<\/ul>\n1\u3001\u51c6\u5907\u5de5\u4f5c<\/h3>\n
1\u3001\u6570\u636e\u5e93sql\u521b\u5efa<\/p>\n
DROP TABLE IF EXISTS user;\n\nCREATE TABLE user\n(\n id BIGINT(20) 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 PRIMARY KEY (id)\n);\n\nINSERT INTO user (id, name, age, email) VALUES\n(1, 'Jone', 18, 'test1@baomidou.com'),\n(2, 'Jack', 20, 'test2@baomidou.com'),\n(3, 'Tom', 28, 'test3@baomidou.com'),\n(4, 'Sandy', 21, 'test4@baomidou.com'),\n(5, 'Billie', 24, 'test5@baomidou.com');\n<\/code><\/pre>\n2\u3001\u5b9e\u4f53\u7c7b\u521b\u5efa<\/p>\n
package com.atguigu.pojo;\n\nimport lombok.Data;\n\n@Data\npublic class User {\n private Integer id;\n private String name;\n private Integer age;\n private String email;\n}\n<\/code><\/pre>\n2\u3001\u5bfc\u5165mybatisplus\u3001\u548cspringboot\u4f9d\u8d56<\/h3>\n<?xml version="1.0" encoding="UTF-8"?>\n<project xmlns="http:\/\/maven.apache.org\/POM\/4.0.0"\n xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance"\n xsi:schemaLocation="http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd">\n <modelVersion>4.0.0<\/modelVersion>\n\n <groupId>com.atguigu<\/groupId>\n <artifactId>mybatis-plus-base-quick-01<\/artifactId>\n <version>1.0-SNAPSHOT<\/version>\n\n <parent>\n <groupId>org.springframework.boot<\/groupId>\n <artifactId>spring-boot-starter-parent<\/artifactId>\n <version>3.0.5<\/version>\n <\/parent>\n\n <properties>\n <maven.compiler.source>17<\/maven.compiler.source>\n <maven.compiler.target>17<\/maven.compiler.target>\n <project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>\n <\/properties>\n\n <dependencies>\n <dependency>\n <groupId>org.springframework.boot<\/groupId>\n <artifactId>spring-boot-starter<\/artifactId>\n <\/dependency>\n\n <!-- \u6d4b\u8bd5\u73af\u5883 -->\n <dependency>\n <groupId>org.springframework.boot<\/groupId>\n <artifactId>spring-boot-starter-test<\/artifactId>\n <\/dependency>\n\n <!-- mybatis-plus -->\n <dependency>\n <groupId>com.baomidou<\/groupId>\n <artifactId>mybatis-plus-boot-starter<\/artifactId>\n <version>3.5.3.1<\/version>\n <\/dependency>\n\n <!-- \u6570\u636e\u5e93\u76f8\u5173\u914d\u7f6e\u542f\u52a8\u5668 -->\n <dependency>\n <groupId>org.springframework.boot<\/groupId>\n <artifactId>spring-boot-starter-jdbc<\/artifactId>\n <\/dependency>\n\n <!-- druid\u542f\u52a8\u5668\u7684\u4f9d\u8d56 -->\n <dependency>\n <groupId>com.alibaba<\/groupId>\n <artifactId>druid<\/artifactId>\n <version>1.2.20<\/version>\n <\/dependency>\n\n <!-- \u9a71\u52a8\u7c7b-->\n <dependency>\n <groupId>mysql<\/groupId>\n <artifactId>mysql-connector-java<\/artifactId>\n <version>8.0.28<\/version>\n <\/dependency>\n\n <dependency>\n <groupId>org.projectlombok<\/groupId>\n <artifactId>lombok<\/artifactId>\n <version>1.18.28<\/version>\n <\/dependency>\n\n <\/dependencies>\n\n <!-- SpringBoot\u5e94\u7528\u6253\u5305\u63d2\u4ef6-->\n <build>\n <plugins>\n <plugin>\n <groupId>org.springframework.boot<\/groupId>\n <artifactId>spring-boot-maven-plugin<\/artifactId>\n <\/plugin>\n <\/plugins>\n <\/build>\n\n<\/project><\/code><\/pre>\n3\u3001\u7f16\u5199\u914d\u7f6e\u6587\u4ef6<\/h3>\n
1\u3001application.yaml<\/p>\n
# \u8fde\u63a5\u6c60\u914d\u7f6e\nspring:\n datasource:\n type: com.alibaba.druid.pool.DruidDataSource\n\n url: jdbc:mysql:\/\/\/manager\n username: root\n password: root\n driver-class-name: com.mysql.cj.jdbc.Driver\n<\/code><\/pre>\n4\u3001\u542f\u52a8\u7c7b<\/h3>\n
1\u3001MainApplication.java<\/p>\n
package com.atguigu;\n\nimport org.mybatis.spring.annotation.MapperScan;\nimport org.springframework.boot.SpringApplication;\nimport org.springframework.boot.autoconfigure.SpringBootApplication;\n\n@SpringBootApplication\n@MapperScan("com.atguigu.mapper") \/\/\u5305\u626b\u63cf\npublic class MainApplication {\n public static void main(String[] args) {\n SpringApplication.run(MainApplication.class, args);\n }\n}\n<\/code><\/pre>\n5\u3001\u7f16\u5199\u529f\u80fd\u4ee3\u7801<\/h3>\n
1\u3001\u7f16\u5199UserMapper<\/p>\n
2\u3001\u8fd9\u4e2a\u53ea\u8981\u7ee7\u627fBaseMapper\\\u3002\u6cdb\u578b\u5199\u5b9e\u4f53\u7c7b\u5c31\u884c\u3002\u91cc\u9762\u4f1a\u6709\u5199\u597d\u7684crud\u65b9\u6cd5<\/p>\n3\u3001\u800c\u4e14\u4e0d\u9700\u8981\u5199UserMapper.xml\u6587\u4ef6<\/p>\n
package com.atguigu.mapper;\n\nimport com.atguigu.pojo.User;\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\n\npublic interface UserMapper extends BaseMapper<User> {\n\n}\n<\/code><\/pre>\n6\u3001\u7f16\u5199\u6d4b\u8bd5\u4ee3\u7801<\/h3>\npackage com.atguigu;\n\nimport com.atguigu.mapper.UserMapper;\nimport com.atguigu.pojo.User;\nimport org.junit.jupiter.api.Test;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.boot.test.context.SpringBootTest;\n\nimport java.util.List;\n\n@SpringBootTest\npublic class SpringBootMybatisPlusTest {\n @Autowired\n private UserMapper userMapper;\n\n @Test\n public void testSelect() {\n System.out.println(("----- selectAll method test ------"));\n List<User> userList = userMapper.selectList(null);\n userList.forEach(System.out::println);\n }\n}\n<\/code><\/pre>\n7\u3001\u5c0f\u7ed3<\/h3>\n
1\u3001\u4ece\u4ee5\u4e0a\u6b65\u9aa4\u4e2d\uff0c\u6211\u4eec\u53ef\u4ee5\u770b\u5230\u96c6\u6210MyBatis-Plus\u975e\u5e38\u7684\u7b80\u5355\uff0c\u53ea\u9700\u8981\u5f15\u5165 starter \u5de5\u7a0b\uff0c\u5e76\u914d\u7f6e mapper \u626b\u63cf\u8def\u5f84\u5373\u53ef\u3002<\/p>\n
2\u3001\u800c\u4e14\u4e0d\u9700\u8981\u5199XML\u6587\u4ef6<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4e00\u3001MybatisPlus\u5feb\u901f\u5165\u95e8 1\u3001\u4ecb\u7ecd 1\u3001\u8fd9\u91cc\u4f7f\u7528\u7684\u7248\u672c\u4e3a3.5.3.1 2\u3001\u5b98\u65b9\u6587\u6863 MyBatis […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-5814","post","type-post","status-publish","format-standard","hentry","category-mybatisplus"],"_links":{"self":[{"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/posts\/5814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/comments?post=5814"}],"version-history":[{"count":1,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/posts\/5814\/revisions"}],"predecessor-version":[{"id":5815,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/posts\/5814\/revisions\/5815"}],"wp:attachment":[{"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/media?parent=5814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/categories?post=5814"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zyg.luchers.cn\/index.php\/wp-json\/wp\/v2\/tags?post=5814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}