mybatis-plus学习

mybatis介绍

谈谈我的个人理解，就是mybatis的升级版，简化了xml的编写，并且提供了一些内置的api，能够提高我们的开发效率，降低我们的工作量

使用方式

这里介绍maven引入，gradle引入方式请自行百度

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.5.1</version>
</dependency>

Demo项目基于SpringBoot，所以下面会贴出实体类以及Mapper类
实体类User

package com.study.demo.entity;

import lombok.Data;

@Data
public class User {
    private Long id;
    private String name;
    private Integer age;
    private String email;
}

Mapper类

package com.study.demo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.study.demo.entity.User;

public interface UserMapper extends BaseMapper<User> {
}

application.yml

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/mybatis-plus
    username: root
    password: a1374268

测试类

package com.study.demo.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.study.demo.entity.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@SpringBootTest
public class MapperTest {
    @Autowired
    private UserMapper userMapper;

    @Test
    public void select() {
        List<User> users = userMapper.selectList(null);
        users.forEach(System.out::println);
    }

    @Test
    public void selectById() {
        User user = userMapper.selectById(1L);
        System.out.println(user);
    }

    @Test
    public void selectByBatchIds() {
        List<Long> ids = Arrays.asList(1L, 2L);
        List<User> users = userMapper.selectBatchIds(ids);
        users.forEach(System.out::println);
    }

    @Test
    public void selectByMap() {
        Map<String, Object> selectedMap = new HashMap<>();
        // 这里的Map的key值对应的是数据库中的列名，不是实体类的字段名
        // value对应的是数据库中的实际的值
        selectedMap.put("name", "Jone");
        List<User> users = userMapper.selectByMap(selectedMap);
        users.forEach(System.out::println);
    }

    @Test
    public void selectWrapper1() {
        // 查询名字中包含字母J的，并且年龄小于20岁的用户
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        queryWrapper.like("name","J").lt("age",20);
        List<User> users = userMapper.selectList(queryWrapper);
        users.forEach(System.out::println);
    }

    @Test
    public void selectWrapper2() {
        // 查询邮箱中包含@符号的，并且按照年龄降序排列
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        queryWrapper.like("email","@").orderByDesc("age");
        List<User> users = userMapper.selectList(queryWrapper);
        users.forEach(System.out::println);
    }
}

未完待续