Mybatis-plus中的通用CRUD方法测试使用

最新推荐文章于 2022-07-21 10:06:12 发布

原创最新推荐文章于 2022-07-21 10:06:12 发布 · 886 阅读

1 ·

CC 4.0 BY-SA版权

JavaWeb 专栏收录该内容

38 篇文章

订阅专栏

本文详细介绍了Mybatis-plus库中的通用创建、读取、更新和删除（CRUD）方法，并通过实例展示了如何在实际项目中进行测试和应用，帮助开发者提升数据库操作的效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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(String content){
 
        EntityWrapper<User> wrapper = new EntityWrapper<>();
        wrapper.like("username",content);
 
        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);
 
    }
 
 
}