1、搭建一个springboot初始化项目，添加依赖：
    Spring Web、Lombok、SpringBoot DevTools、Mysql Driver
    image.png
    image.png
    image.png

    2、引入Mybatis-Plus和阿里巴巴连接池

    1. <!--引入mybatis-plus依赖-->
    2. <dependency>
    3.     <groupId>com.baomidou</groupId>
    4.     <artifactId>mybatis-plus-boot-starter</artifactId>
    5.     <version>3.4.2</version>
    6. </dependency>
    7. <!--引入阿里巴巴连接池-->
    8. <dependency>
    9.     <groupId>com.alibaba</groupId>
    10.     <artifactId>druid</artifactId>
    11.     <version>1.1.20</version>
    12. </dependency>

    3、添加dao包，并且启动类添加启动dao包扫描注解@MapperScan
    UserDao接口

    1. //使用mybatis-plus增强接口
    2. public interface UserDao extends BaseMapper<User> {
    4. }

    MybatisPlusApplication，启动类

    2. @MapperScan("com.mybatisplus.dao")
    3. @SpringBootApplication
    4. public class MybatisPlusApplication {
    6.   public static void main(String[] args) {
    7.     SpringApplication.run(MybatisPlusApplication.class, args);
    8.   }
    10. }

    image.png

    5、添加application.properties文件配置内容

    1. #mybatis-plus最基本配置
    2. spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    3. spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    4. spring.datasource.url=jdbc:mysql://localhost:3306/mybatis_plus?characterEncoding=UTF-8
    5. spring.datasource.username=root
    6. spring.datasource.password=rootroot
    8. server.port=8778

    6、添加数据库信息

    1. SET NAMES utf8mb4;
    2. SET FOREIGN_KEY_CHECKS = 0;
    3. DROP TABLE IF EXISTS `user`;
    4. CREATE TABLE `user` (
    5.   `id` bigint NOT NULL COMMENT '主键ID',
    6.   `name` varchar(30) DEFAULT NULL COMMENT '姓名',
    7.   `age` int DEFAULT NULL COMMENT '年龄',
    8.   `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
    9.   PRIMARY KEY (`id`)
    10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    12. BEGIN;
    13. INSERT INTO `user` VALUES (1, '李白', 18, 'test1@baomidou.com');
    14. INSERT INTO `user` VALUES (2, '诸葛亮', 20, 'test2@baomidou.com');
    15. INSERT INTO `user` VALUES (3, '刘备', 28, 'test3@baomidou.com');
    16. INSERT INTO `user` VALUES (4, '蔡文姬', 21, 'test4@baomidou.com');
    17. INSERT INTO `user` VALUES (5, '甄姬', 24, 'test5@baomidou.com');
    18. INSERT INTO `user` VALUES (6, '王八', 38, '90909@qq.com');
    19. COMMIT;
    21. SET FOREIGN_KEY_CHECKS = 1;

    7、添加实体类pojo.User

    1. @Data //get/set/
    2. @AllArgsConstructor //全参构造
    3. @NoArgsConstructor  //无参构造
    4. @ToString
    5. @Accessors(chain = true)//开启链式调用
    6. public class User {
    7.   private String id;
    8.   private String name;
    9.   private Integer age;
    10.   private String email;
    11. }

    image.png

    8、编写测试类，对数据库表数据进行增加，删除 ，更新操作：

    1. @SpringBootTest
    2. class MybatisPlusApplicationTests {
    4.   @Autowired
    5.   private UserDao userDao;
    7.   @Test
    8.   void contextLoads() {
    9.     List<User> userList = userDao.selectList(null);
    10.     userList.forEach((user)->{
    11.       System.err.println("user:"+user);
    12.     });
    13.   }
    14. }

    运行测试方法，如此就拿到数据了：
    获取表数据。
    image.png