JPQL order entities by passed IN IN子句

@Entity
public class User {
    @Id
    private Long id;
    private String name;
    private int age;
    // getters and setters
}

// 在Repository或DAO层中
public List<User> findUsersByAgeInOrderByAgeAsc(List<Integer> ages) {
    String jpql = "SELECT u FROM User u WHERE u.age IN :ages ORDER BY u.age ASC";
    TypedQuery<User> query = entityManager.createQuery(jpql, User.class);
    query.setParameter("ages", ages);
    return query.getResultList();
}

public List<User> findUsersByAgeInOrderByAgeAsc(List<Integer> ages, int pageNumber, int pageSize) {
    String jpql = "SELECT u FROM User u WHERE u.age IN :ages ORDER BY u.age ASC";
    TypedQuery<User> query = entityManager.createQuery(jpql, User.class);
    query.setParameter("ages", ages);
    query.setFirstResult((pageNumber - 1) * pageSize);
    query.setMaxResults(pageSize);
    return query.getResultList();
}