【Java】MyBatis-Plus详细教程

0、初始化数据

DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `age` int DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `sys_user` (`id`, `nickname`, `age`, `email`) VALUES (1, '张三', 26, NULL);
INSERT INTO `sys_user` (`id`, `nickname`, `age`, `email`) VALUES (2, '李四', 18, NULL);
INSERT INTO `sys_user` (`id`, `nickname`, `age`, `email`) VALUES (3, '王五', 37, NULL);
INSERT INTO `sys_user` (`id`, `nickname`, `age`, `email`) VALUES (4, '赵六', 61, NULL);

1、创建工程

在pom文件添加下面配置

        <!-- 手动添加Spring Boot3的mybatis-plus依赖-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-spring-boot3-starter</artifactId>
            <version>3.5.5</version>
        </dependency>

2、工程代码

实体类

@Data
@TableName