@Test
void testQueryWrapper() {
    // 查询条件
    QueryWrapper<User> wrapper = new QueryWrapper<User>()
            .select("id", "username", "info", "balance")
            .like("username", "o")
            .ge("balance", 1000);
    // 查询
    List<User> users = userMapper.selectList(wrapper);
    users.forEach(System.out::println);
}

@Test
void testUpdateQueryWrapper(){
    // 更新数据
    User user = new User();
    user.setBalance(2000);
    // 查询条件
    QueryWrapper<User> wrapper = new QueryWrapper<User>().eq("username", "jack");
    // 更新
    userMapper.update(user,wrapper);
}

@Test
void testUpdateWrapper(){
    List<Long> ids = List.of(1L, 2L,  4L);
    UpdateWrapper<User> wrapper = new UpdateWrapper<User>()
            .setSql("balance=balance-200")
            .in("id", ids);
    userMapper.update(null,wrapper);
}

@Test
void testLambdaQueryWrapper() {
    // 查询条件
    LambdaQueryWrapper<User> wrapper = new LambdaQueryWrapper<User>()
            .select(User::getId, User::getUsername, User::getInfo, User::getBalance)
            .like(User::getUsername, "o")
            .ge(User::getBalance, 1000);
    // 查询
    List<User> users = userMapper.selectList(wrapper);
    users.forEach(System.out::println);
}

@Test
    void testSave(){
        User user = new User();
        //user.setId();
        user.setUsername("LiLei");
        user.setPassword("1231");
        user.setPhone("186889900112");
        user.setBalance(2001);
        user.setInfo("{\"age\": 24, \"intro\": \"英文老师\", \"gender\": \"female\"}");
        user.setCreateTime(LocalDateTime.now());
        user.setUpdateTime(LocalDateTime.now());
  
        userService.save(user);
    }

// 根据id查多条数据
@Test
    void testQuery(){
        List<User> users = userService.listByIds(List.of(1L, 2L, 3L, 4L));
        users.forEach(System.out::println);
    }

    private final IUserService userService;

    @ApiOperation("新增用户")
    @PostMapping
    public void saveUser(@RequestBody UserFormDTO userDTO){
        User user = BeanUtil.copyProperties(userDTO, User.class);
        userService.save(user);
    }
    @ApiOperation("删除用户")
    @DeleteMapping("/{id}")
    public void DeleteUserById(@ApiParam("用户id") @PathVariable("id") Long id){
        userService.removeById(id);
    }
    @ApiOperation("id查询用户")
    @GetMapping("/{id}")
    public UserVO findUserById(@ApiParam("用户id") @PathVariable("id") Long id){
        User user = userService.getById(id);
        return BeanUtil.copyProperties(user, UserVO.class);
    }
    @ApiOperation("id批量查询")
    @GetMapping
    public List<UserVO> findUsersByIds(@ApiParam("用户id列表") @RequestParam("ids") List<Long> ids){
        List<User> users = userService.listByIds(ids);

        return  BeanUtil.copyToList(users, UserVO.class);
    }

、    // controller
    @ApiOperation("根据复杂条件查询用户")
    @PutMapping("/list")
    public List<UserVO> queryUsers(UserQuery query){
        List<User> users = userService.queryUsres(query.getName(), query.getStatus(), query.getMinBalance(), query.getMaxBalance());
        return BeanUtil.copyToList(users, UserVO.class);
    }   

    //service
    @Override
    public List<User> queryUsres(String name, Integer status, Integer minBalance, Integer maxBalance) {
        return lambdaQuery()
                .like(name != null, User::getUsername, name)
                .eq(status != null, User::getStatus, status)
                .gt(minBalance != null, User::getBalance, minBalance)
                .lt(maxBalance != null, User::getBalance, maxBalance)
                .list();
    }

spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/mp?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: MySQL123