mq的条件查询、分页查询以及简单增删改查等等

package com.itheima;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.itheima.dao.UserDao;
import com.itheima.domain.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest
class MybatisPlus01ApplicationTests {


    @Autowired
    private UserDao userDao;

    /**
     * 查询数据库所有数据
     */
    @Test
    void contextLoads() {
        List<User> users = userDao.selectList(null);
        System.out.println(users);
    }

    /**
     * 插入
     */
    @Test
    public void testAdd() {
        User user = new User();
        user.setName("zhangsan");
        user.setAge(18);
        user.setPassword("123");
        user.setTel("888888888");
        userDao.insert(user);
    }

    /**
     * 修改
     */
    @Test
    public void updateTest() {
        User user = new User();
        user.setName("黑马程序员hahaha");
        user.setAge(18);
        user.setPassword("123");
        user.setTel("888888888");
        user.setId(1541963246997696513l);
        userDao.insert(user);
    }

    /**
     * 删除
     */

    @Test
    void deleteTest() {
        int i = userDao.deleteById("1541963246997696513l");
        System.out.println(i);
    }

    /**
     * 查询
     */
    @Test
    void selectId() {
        User user = userDao.selectById("1541963246997696513l");
        System.out.println(user);
    }

    /**
     * 分页
     */
    @Test
    void page() {
        Page<User> page = new Page<>(2, 2);
        userDao.selectPage(page, null);
        System.out.println("当前页码：" + page.getCurrent());
        System.out.println("总记录数：" + page.getTotal());
        System.out.println("每条页数：" + page.getSize());
        System.out.println("查询的数据：" + page.getRecords());

    }
    /**
     * 条件查询
     */
    @Test
    void selectIds(){
        //根据条件查询:年龄小于四十
        QueryWrapper<User> qw = new QueryWrapper<>();
        qw.lt("age",40);
        List<User> users1 = userDao.selectList(qw);
        System.out.println(users1);
        //lambda按条件查询
        QueryWrapper<User> qw2 = new QueryWrapper<>();
        qw2.lambda().lt(User::getAge,40);
        List<User> users2 = userDao.selectList(qw2);
        System.out.println(users2);

        //定义条件器
       // QueryWrapper<Object> qw = new QueryWrapper<>();
        LambdaQueryWrapper<User> lw = new LambdaQueryWrapper<>();
        lw.like(User::getName,"J");
        List<User> users = userDao.selectList(lw);
        System.out.println(users);

        //组合条件
        //1并且关系
        LambdaQueryWrapper<User> lm = new LambdaQueryWrapper<>();
        lm.lt(User::getAge,10).gt(User::getAge,20);
        List<User> users3 = userDao.selectList(lm);
        System.out.println(users3);

        //或者关系
        LambdaQueryWrapper<User> lm2 = new LambdaQueryWrapper<>();
        lm2.lt(User::getAge,20).gt(User::getAge,30);
        List<User> users4 = userDao.selectList(lm2);
        System.out.println(users4);
    }
}