MyBatis-Plus(二.基础的CRUD)

Mybatis-Plus早就给我们自定义写好了许多自定义的CRUD方法, 这里只简述常用的几种

基础查询

@SpringBootTest
public class UserTest{

    @Autowired
    UserMapper userMapper;

    @Test
    // selectById: 按id查
    public void testGetById(){
        User user = userMapper.selectById(1);
        System.out.println(user);
    }

    @Test
    // selectList: 查全部
    public void testGetAll(){
        List<User> users = userMapper.selectList(null);
        System.out.println(users);
    }

    @Test
    // insert: 增
    public void testInsert(){
        User user = new User(0, "jian", "23i1y", "zayg@qq.com", 1);
        userMapper.insert(user);
    }

    // updateById: 根据id改
    @Test void testUpdate(){
        User user = new User(10, "jian", "修改", "zayg@qq.com", 1);
        userMapper.updateById(user);
    }

    // deleteById: 删
    @Test void testDelete(){
        userMapper.deleteById(10);
    }
}

Map条件查询

把Map的key当成字段, value当成值,作为查询条件

@SpringBootTest
public class UserMapTest{

    @Autowired
    UserMapper userMapper;

    // 按map中的条件查,key=字段, value=值
    @Test
    public void testGet(){
        Map<String, Object> map = new HashMap<>();
        map.put("id", 10);
        map.put("username", "jian");
        List<User> users = userMapper.selectByMap(map);
        users.forEach(System.out::println);
    }

    // 按map删
    @Test
    public void testDel(){
        Map<String, Object> map = new HashMap<>();
        map.put("id", 10);
        map.put("username", "j");
        int deleteNum = userMapper.deleteByMap(map);
        System.out.println(deleteNum);
    }
}

所有的方法都能在BaseMapper的源码中找到, 一定不要害怕看源码, MyBatis-Plus的源码注释是全中文的,很适合作为新手的第一篇源码教程

对了,源码要下载下来,才能看到注释, 所以一定要点右上方的下载