MP与框架学习

1. MybatisPlus学习

1.1 MP入门案例

package cn.tedu;

import cn.tedu.dao.UserMapper;
import cn.tedu.pojo.User;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
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.List;

@SpringBootTest
public class Demo2 {
    @Autowired
    private UserMapper userMapper;
    //利用MP，进行查询操作
    @Test
    //逻辑运算符  = eq; < lt ; > gt ; <= le; >=ge; != ne
    public void testSelect(){
        //1.select 查询name="小李头" 并且 性别 ="女"
        //构建条件构造器，根据对象中不为null的属性充当where条件
        QueryWrapper<User> queryWrapper = new QueryWrapper();
        queryWrapper.eq("name","小李头" ).eq("sex", "女");
        //根据条件构造器，实现数据查询
        List list = userMapper.selectList(queryWrapper);
        System.out.println(list);
        //2.select  查询age < 18岁  性别="女"
        //利用MP查询
        QueryWrapper<User> queryWrapper1 = new QueryWrapper();
        queryWrapper1.lt("age", 18).eq("sex", "女");
        List<User> users = userMapper.selectList(queryWrapper1);
        System.out.println(users);
        //3.select  查询  name包含 '小'字的数据
        //关键字： like "%xxx%"
        //以小开头： "like%"
        //以小结尾："%like"
        QueryWrapper<User> queryWrapper2 = new QueryWrapper();
        queryWrapp