1. 概述
我们在学习完mybatis后发现mybatis xml配置太过于繁琐需要写基本sql,所以mybatis应运而生
•MyBatis-Plus(简称 MP)是一个 MyBatis 的增强工具,在 MyBatis 的基础上只做增强不做改变,为简化开发、提高效率而生。
版本
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus</artifactId>
<version>3.4.0</version>
</dependency>
2、快速入门
springboot整合mybatis-plus
2.1. 数据库环境准备
创建一张tb_user表
2.2 创建spring boot工程,导入依赖
<?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.3.4.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.gao</groupId>
<artifactId>mybatis-plus</artifactId>
<version>1.0-SNAPSHOT</version>
<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>
<!-- mysql 驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.26</version>
</dependency>
<!--mybatisplus起步依赖-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.0</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
2.3配置properties.yml
# datasource
spring:
datasource:
url: jdbc:mysql://localhost:3306/mp?characterEncoding=utf-8&serverTimezone=Asia/Shanghai
username: root
password: 123456
driver-class-name: com.mysql.jdbc.Driver
2.4创建实体类
package com.gao.domain;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
@TableName("tb_user")
@Data
public class User {
private Long id;
private String userName;
private String password;
private String name;
private Integer age;
private String email;
}
上面代码中 @TableName(“tb_user”) 表示映射哪张表
@Data是lombok里面的等价于上面的@Setter、@Getter、@RequiredArgsConstructor、@ToString、@EqualsAndHashCode
2.5编写mapper
package com.gao.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.gao.domain.User;
public interface UserMapper extends BaseMapper<User> {
}
2.6测试
@RunWith(SpringRunner.class)
@SpringBootTest(classes = MybatisPlusTestApplication.class)
public class MPTest {
@Autowired
UserMapper userMapper;
@Test
public void testById(){
User user = userMapper.selectById(1L);
System.out.println(user);
}
}
最后发现id为1的用户信息打印在控制台上
思考
为什么mybatis不用写sql语句可以直接查询?
因为它继承了BaseMapper.class 在它里面已经定义了查询方法
3、CRUD
3.1增加
@Test
public void testAdd(){
User user=new User();
user.setUserName("小黑黑");
user.setPassword("123");
user.setAge(18);
user.setName("小黑黑");
user.setEmail("666@qq.com");
int i = userMapper.