如何在Java中查询对象集合(Criteria/SQL-like)？

List<Person> people = Arrays.asList(
    new Person("Alice", "A123"),
    new Person("Bob", "B456"),
    new Person("Carol", "C789")
);

List<String> namesStartingWithA = people.stream()
    .filter(p -> p.getName().startsWith("A"))
    .map(p -> p.getName())
    .sorted()
    .collect(toList());

System.out.println(namesStartingWithA); // 输出 [Alice, Carol]

List<Person> people = ...;

Predicate<Person> startsWithA = p -> p.getName().startsWith("A");

List<String> namesStartingWithA = people.stream()
    .filter(startsWithA)
    .map(p -> p.getName())
    .sorted()
    .collect(toList());

List<Person> people = ...;
Query q = entityManager.createQuery("FROM People p WHERE p.name.startswith('A')");
List<String> namesStartingWithA = q.getResultList();

CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
CriteriaQuery<String> cq = criteriaBuilder.createQuery(String.class);
Root<Person> root = cq.from(Person.class);
criterion = criteriaBuilder.equal(root.get("name").as(String.class), "Alice");

Predicate predicate = criterion.getRestriction();
List namesStartingWithA = entityManager.createQuery(cq.select(root.get("name")).where(predicate)).getResultList();