如何动态创建CriteriaQuery

Question

我想创建与这个查询等价的CriteriaQuery : select u from User u where u.name = "John“and u.surname = "Black”and u.middlename = "Small"；但是我对"where“谓词有问题。谢谢

Answer 1

您可以使用：

CriteriaBuilder builder = entityManager.getCriteriaBuilder();
CriteriaQuery c = ...;
Root root = ...;

Predications name = builder.equal(root.get("name"), name);
Predications surname = ...;
Predications middlename = ...;

c.where(name, surname, middlename);