简介
MyBatis-Plus(简称 MP)是一个 MyBatis 的增强工具,在 MyBatis 的基础上只做增强不做改变,为简化开发、提高效率而生。MyBatis和JAP各自有自己的优点。MyBatis需要自己写sql,灵活性更强,也方便我们优化,提供动态sql的特性。Spring Data JPA更加面向对象,提供根据方法名自动创建sql的功能。MyBatis-Plus 就是对 Mybatis面向对象方面的一个增强,提供了简单sql的默认实现。
快速搭建测试项目
使用springboot来集成mp作为练习。
pom
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.3.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.mybaties-plus</groupId>
<artifactId>demo</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>demo</name>
<description>Demo project for mybaties-plus demo</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/com.baomidou/mybatis-plus -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.1.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
启动类
增加扫描的mapper注解
@SpringBootApplication
@MapperScan("com.mybatiesplus.demo.dao")
public class DemoApplication {
public static void main(String[] args) {
SpringApplication.run(DemoApplication.class, args);
}
}
实体类
@Data
@TableName("mpdemo")
public class User {
private Long id;
private String name;
private Integer age;
private String email;
private Long managerId;
private LocalDateTime createTime;
}
Mapper
public interface UserMapper extends BaseMapper<User> {
}
表结构
CREATE TABLE `mpdemo` (
`id` bigint(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(11) DEFAULT NULL COMMENT '姓名',
`age` tinyint(3) unsigned DEFAULT NULL COMMENT '年龄',
`email` varchar(11) DEFAULT NULL COMMENT '邮箱',
`manager_id` bigint(20) unsigned DEFAULT NULL COMMENT '领导id',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1149584829487587331 DEFAULT CHARSET=utf8mb4;
初始化数据
INSERT INTO `mpdemo` (`id`, `name`, `age`, `email`, `manager_id`, `create_time`)
VALUES
(1, '大Boss', 35, 'boss@qq.com', NULL, '2019-07-10 12:14:45'),
(2, '王天风', 25, 'wtf@qq.com', 1, '2019-07-11 12:14:45'),
(3, '李艺伟', 28, 'lyw@qq.com', 1, '2019-07-11 09:09:08'),
(4, '张雨绮', 24, 'yq@qq.com', 1, '2019-07-12 07:00:00'),
(5, '刘宏宇', 32, 'lhy@qq.com', 1, '2019-07-10 11:11:11');
CRUD操作
Create
mp默认是支持实体和表名、字段名驼峰和下滑线转化。默认通过雪花算法自动生产id。
@Test
public void insert() {
User user = new User();
user.setName("刘明强");
user.setAge(19);
user.setManagerId(2L);
user.setCreateTime(LocalDateTime.now());
int insert = userMapper.insert(user)