mybatisplus

  @Test
    void testQueryWrapper(){
        //select id, username, balance from user where username like ? and balance >= ?
        QueryWrapper<User> queryWrapper = new QueryWrapper<User>();
        queryWrapper.select("id","username","info","balance")
                .like("username","o")
                .ge("balance",1000);
        List<User> users = userMapper.selectList(queryWrapper);
        System.out.println(users);
    }

    @Test
    void testByQueryWrapper(){
        User user = new User();
        user.setBalance(2000);
        QueryWrapper<User> userQueryWrapper = new QueryWrapper<>();
        userQueryWrapper.eq("username","Jack");
        userMapper.update(user,userQueryWrapper);
    }

    @Test
    void testUpdateWrapper(){
        ArrayList<Long> userIds = new ArrayList<>();
        userIds.add(1L);
        userIds.add(2L);
        userIds.add(4L);

        UpdateWrapper<User> updateWrapper = new UpdateWrapper<User>();
        updateWrapper.setSql("balance = balance - 200");
        updateWrapper.in("id",userIds);

        userMapper.update(null, updateWrapper);
    }