What are some examples of Hibernate criteria queries?

Can you give me some examples of Hibernate criteria queries?

Sure! Hibernate criteria queries allow you to create queries using a programmatic approach. For example, to find all users with a specific age, you can use the following code:

CriteriaBuilder criteriaBuilder = session.getCriteriaBuilder();
CriteriaQuery<User> criteriaQuery = criteriaBuilder.createQuery(User.class);
Root<User> root = criteriaQuery.from(User.class);
criteriaQuery.select(root).where(criteriaBuilder.equal(root.get("age"), 25));
List<User> users = session.createQuery(criteriaQuery).getResultList();

What if I want to add multiple conditions?

You can easily add multiple conditions using the CriteriaBuilder methods. For instance, if you want to find users who are 25 years old and live in 'New York', you can do this:

criteriaQuery.select(root).where(
    criteriaBuilder.and(
        criteriaBuilder.equal(root.get("age"), 25),
        criteriaBuilder.equal(root.get("city"), "New York")
    )
);

Can I sort the results as well?

Absolutely! You can sort the results using the orderBy method. Here's how you can sort users by their last name:

criteriaQuery.select(root).orderBy(criteriaBuilder.asc(root.get("lastName")));

Are there any performance considerations I should be aware of?

Yes, when using criteria queries, be mindful of the number of joins and the size of the result set, as they can impact performance. Always test and optimize your queries.