mysql查询In顺序和返回结果顺序不一致解决方案

?

1

//参数封装<br>String idStr = StrUtil.join(",", ids);//手动指定排序规则,按照传入顺序返回,并收集数据到返回集合List<UserDTO> userDTOS = userService.query()<br>.in("id", ids)<br>.last("ORDER BY FIELD(id," + idStr + ")")<br>.list()<br>.stream() <br>.map(user -> BeanUtil.copyProperties(user, UserDTO.class)) <br>.collect(Collectors.toList());