Java学习 --- mybatisplus自带的增删改查

一、mybatisplus的增删改查

 /**
     * 无条件查询所有数据
     */
    @Test
    public void selectAllUser(){
         List<User> userList = userMapper.selectList(null);
         userList.forEach(System.out::println);
     }

    /**
     * 添加用户
     */
    @Test
    public void insertUser(){
         User user = new User(null, "张三", 23, "8848@qq.com");
         int insert = userMapper.insert(user);
         System.out.println("insert=" + insert);
     }
    /**
     * 删除用户，根据id来删除
     */
    @Test
    public void deleteUser(){
        int deleteById = userMapper.deleteById(1501207660390731777L);
        System.out.println("deleteById=" + deleteById);
    }
    /**
     * 删除用户，使用map集合删除
     */
    @Test
    public void deleteUserMap(){
        HashMap<String, Object> map = new HashMap<>();
        map.put("name","张三");
        int deleteByMap = userMapper.deleteByMap(map);
        System.out.println("deleteByMap=" + deleteByMap);
    }
    /**
     * 删除用户，使用list批量删除
     */
    @Test
    public void deleteUserList(){
        List<Long> list = Arrays.asList(1L, 2L);
        int deleteBatchIds = userMapper.deleteBatchIds(list);
        System.out.println("deleteBatchIds=" + deleteBatchIds);
    }
    /**
     * 修改用户
     */
    @Test
    public void updateUser(){
        User user = new User(3L, "老王", 35, "7899@qq.com");
        int updateById = userMapper.updateById(user);
        System.out.println("updateById" + updateById);
    }
    /**
     * 根据id查询用户
     */
    @Test
    public void selectUser(){
        User user = userMapper.selectById(3L);
        System.out.println("user=" + user);
    }
    /**
     * 根据id批量查询用户
     */
    @Test
    public void selectUserList(){
        List<Long> list = Arrays.asList(3L, 4L, 5L);
        List<User> userList = userMapper.selectBatchIds(list);
        System.out.println("userList=" + userList);
    }
    /**
     * 根据map条件查询用户
     */
    @Test
    public void selectUserMap(){
        HashMap<String , Object> map = new HashMap<>();
        map.put("name","老王");
        List<User> userMap = userMapper.selectByMap(map);
        System.out.println("userMap=" + userMap);
    }