MyBatis-Plus (简称 MP)是一个 MyBatis 的增强工具,在 MyBatis 的基础上只做增强不做改变,为简化开发、提高效率而生。官网:https://mp.baomidou.com/
- 创建user表,用于接下来MyBatisPlus对表进行CRUD操作
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`name` varchar(30) DEFAULT NULL COMMENT '姓名',
`age` int(11) DEFAULT NULL COMMENT '年龄',
`email` varchar(50) DEFAULT NULL COMMENT '邮箱',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*Data for the table `user` */
insert into `user`
(`id`,`name`,`age`,`email`,`create_time`,`update_time`)
values
(1,'Jone',18,'[email protected]',NULL,NULL),
(2,'Jack',20,'[email protected]',NULL,NULL),
(3,'Tom',28,'[email protected]',NULL,NULL),
(4,'Sandy',21,'[email protected]',NULL,NULL),
(5,'Billie',24,'[email protected]',NULL,NULL);
- 创建springboot项目并导入相关maven依赖
<dependencies>
<!--数据库-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.14</version>
</dependency>
<!--lombok-->
<dependency>
<groupId>org.projectlombok