SpringBoot+MyBatisPlus的基本使用

一、MyBatis-Plus简介
1、简介

        MyBatis-Plus(简称 MP)是一个 MyBatis的增强工具，在 MyBatis 的基础上只做增强不做改变，为 简化开发、提高效率而生。

二、入门案例

1、开发环境

IDE:idea 2019.2

JDK:JDK8+

构建工具:maven 3.5.4

MySQL版本:MySQL 5.7

Spring Boot:2.6.3

MyBatis-Plus:3.5.1

2、创建数据库及表

   2.1、创建表 

   

 2.2、添加数据

3、创建Spring Boot工程

3.1、使用 Spring Initializr 快速初始化一个 Spring Boot 工程

 3.2、引入依赖

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter</artifactId> 
    </dependency>
    <dependency> 
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>com.baomidou</groupId> 
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>3.5.1</version>
    </dependency>
    <dependency>
        <groupId>org.projectlombok</groupId> 
        <artifactId>lombok</artifactId> <optional>true</optional>
    </dependency>
    <dependency>
        <groupId>mysql</groupId> 
        <artifactId>mysql-connector-java</artifactId> 
        <scope>runtime</scope>
    </dependency>
</dependencies>

 3.3、idea中安装lombok插件

 4、编写代码

4.1、配置application.yml

# 配置端口号
server:
  port: 8080

# 配置数据库连接信息
spring:
  # 配置数据源信息
  datasource:
    # 配置数据源类型
    type: com.zaxxer.hikari.HikariDataSource
    # 配置连接数据库信息
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mybatis_test?characterEncoding=utf-8&useSSL=false
    username: root
    password: 961007

#mybatisPlus相关配置
mybatis-plus:
  mapper-locations: classpath:mappers/*.xml

注意:

1、驱动类driver-class-name
spring boot 2.0(内置jdbc5驱动)，驱动类使用:driver-class-name: com.mysql.jdbc.Driver

spring boot 2.1及以上(内置jdbc8驱动)，驱动类使用:driver-class-name:com.mysql.cj.jdbc.Driver

否则运行测试用例的时候会有 WARN 信息

2、连接地址url

MySQL5.7版本的url:

jdbc:mysql://localhost:3306/mybatis_plus?characterEncoding=utf-8&useSSL=false

MySQL8.0版本的url:

jdbc:mysql://localhost:3306/mybatis_plus? serverTimezone=GMT%2B8characterEncoding=utf-8&useSSL=false

4.2、启动类

 在Spring Boot启动类中添加@MapperScan注解，扫描mapper包

@SpringBootApplication
@MapperScan("demo.mapper")
public class Demo {
    public static void main(String[] args) {
        SpringApplication.run(Demo.class,args);
    }
}

 4.3、添加实体

@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName("t_user")
public class User {
    @TableId
    private Long id;
    private String userName;
    private String password;
}

 

4.4、添加mapper

        BaseMapper是MyBatis-Plus提供的模板mapper，其中包含了基本的CRUD方法，泛型为操作的实体类型

public interface userMapper extends BaseMapper<User> {
}

 4.5、测试

@RestController
@Slf4j
@Log4j2
public class TestController {

    @Autowired(required = false)
    private userMapper userMapper;

    @RequestMapping("/test")
    public List<User> test(){
        List<User> list = userMapper.selectList(null);
        return list;
    }
}

三、使用MyBatisPlus实现基本CRUD

1、BaseMapper

/**
 * 测试向数据库中插入数据
 * @return
 */
@RequestMapping("/t2")
public int insertUser(){
    int count = dao.insert(new User(null, "tom", "123"));
    return count;
}

/**
 * 测试查询全部数据库中的数据
 * @return
 */
@RequestMapping("/t3")
public List<User> t3(){
    //查询全部
    List<User> users = dao.selectList(null);
    return users;
}

/**
 * 测试根据ID查询数据
 * @return
 */
@RequestMapping("/t4")
public User t4(){
    //根据id查询
    User u = dao.selectById(1001l);
    return u;
}

/**
 * 测试根据id修改数据
 * @return
 */
@RequestMapping("/t5")
public int t5(){
    //根据id修改
    int count = dao.updateById(new User(1592405843226775554L, "mike", "321"));
    return count;
}

/**
 * 测试根据id删除数据
 * @return
 */
@RequestMapping("/t6")
public int t6(){
    int count = dao.deleteById(1001l);
    return count;
}

/**
 * 测试根据id批量删除数据
 * @return
 */
@RequestMapping("/t7")
public int t7(){
    int count = dao.deleteBatchIds(Arrays.asList(1592419001718865921L, 1592419001144246274L));
    return count;
}

2.自定义方法

2.1在UserMapper中添加自定义方法

public interface userMapper extends BaseMapper<User> {

    User login(String userName, String password);

    int addUser(User user);

    int updateUser(User user);

    int deleteUser(Long id);
}

2.2 在UserMapp.xml中匹配自定义方法，并维护sql语句

(新建resources\mappers\UserMapp.xml)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="demo.mapper.userMapper">
    <select id="login" resultType="demo.entity.User">
        select * from t_user where user_name=#{userName} and password=#{password}
    </select>
    <insert id="addUser">
        insert into t_user (id, user_name, password) values (#{id}, #{userName}, #{password})
    </insert>
    <update id="updateUser">
        update t_user set user_name=#{userName} , password=#{password} where id=#{id}
    </update>
    <delete id="deleteUser">
        delete from t_user where id=#{id}
    </delete>
</mapper>

2.3 在controller中测试

@RestController
@Slf4j
@Log4j2
public class TestController {

    @Autowired(required = false)
    private userMapper userMapper;

    @RequestMapping("/login")
    public String login(String userName, String password){
        User u = userMapper.login(userName, password);
        if(u != null){
            return "登录成功";
        } else {
            return "登录失败";
        }
    }

    @RequestMapping("/add")
    public int t8(){
        int row = userMapper.addUser(new User(1001L, "mike", "321"));
        return row;
    }

    @RequestMapping("/update")
    public int t9(){
        int row = userMapper.updateUser(new User(1001L, "tom10", "123"));
        return row;
    }

    @RequestMapping("/delete")
    public int t10(){
        int row = userMapper.deleteUser(1001L);
        return row;
    }
}