mybatisplus方法测试

import com.baizhi.Application;
import com.baizhi.entity.User;
import com.baizhi.service.IUserService;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import org.junit.runner.RunWith;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
 
import java.util.*;
 
@RunWith(SpringRunner.class)
@SpringBootTest(classes = Application.class)
public class TestMP {
 
    @Autowired
    private IUserService userService;
 
    @Test
    //通过id查找和添加
    public void myTest1(){
 
        /*User user = userService.selectById("1");
        System.out.println(user);*/
 
        //如果不指定id  MP会自动给你生成一个去掉-符号的UUID
        User user = new User();
        user.setId(UUID.randomUUID().toString());
        user.setUsername("狗剩");
        user.setPassword("123456");
        boolean b = userService.insert(user);
 
    }
 
    //根据用户名查找
    @Test
    public void selectByName(){
 
        EntityWrapper<User> wrapper = new EntityWrapper<>();
        wrapper.eq("username","xiaohei");
 
        List<User> users = userService.selectList(wrapper);
        for (User user : users) {
            System.out.println(user);
        }
 
    }
 
    //查询所有用户、条件查询
    @Test
    public void selectAll(){
 
        //根据id查
        /*List<User> users = userService.selectList(null);
        for (User user : users) {
            System.out.println(user);
        }*/
 
        //条件查询
        Map<String,Object> map = new HashMap<>();
        map.put("username","狗剩");
        List<User> list = userService.selectByMap(map);
        for (User user : list) {
            System.out.println(user);
        }
 
    }
 
    //分页查询，第1页，每页3条
    @Test
    public void selectByPage(){
        //current是当前页   size是每页显示的条数
        Page<User> page = new Page<>(current,size);
        Page<User> userPage = userService.selectPage(page);
        List<User> users = userPage.getRecords();
 
        for (User user : users) {
            System.out.println(user);
        }
 
 
    }
 
    //模糊查询
    @Test
    public void selectLike(){
 
        EntityWrapper<User> wrapper = new EntityWrapper<>();
        wrapper.like("username","value");
 
        List<User> users = userService.selectList(wrapper);
        for (User user : users) {
            System.out.println(user);
        }
 
    }
 
    //批量插入
    @Test
    public void addAllColum(){
 
        List<User> list = new ArrayList<User>();
        list.add(new User("45","fdsf","123456"));
        list.add(new User("789","环境","123456"));
 
        boolean b = userService.insertBatch(list);
 
    }

//删除

   @Test
    public void delete(){
 
        /*Map<String,Object> map = new HashMap<>();
        map.put("username","环境");
        userService.deleteByMap(map);*/
 
        EntityWrapper<User> wrapper = new EntityWrapper<>();
        wrapper.eq("username","fdsf");
 
        userService.delete(wrapper);
 
    }

//修改

@Test
    public void update(){
 
        User user = userService.selectById("2");
        user.setUsername("小胖墩");
        userService.updateById(user);
 
    }

//查询总记录数

  @Test
    public void selectCount(){
 
        int count = userService.selectCount(null);
        System.out.println(count);
 
    }

根据条件查询

//根据条件查询
        RowBounds rowBounds = new RowBounds((page - 1) * rows, rows);
        EntityWrapper<Chapter> wrapper = new EntityWrapper<>();
        wrapper.eq("album_id", albumId);
        List<Chapter> chapter = chapterDao.selectPage(rowBounds, wrapper);