hibernate - Hibernate 5，具有 2 个限制的 where 子句的条件查询

Question

对于员工表

public class Employee {
    
    private Long id;
    
    private int deptId;
    
    private String name;
    
    private LocalDateTime joiningDate;
    
    private LocalDateTime seperatedDate;

}

我想建立一个具有以下两个条件的标准

criteriaQuery.where((EmployeeRoot.get("deptId").in(request.getDeptIdList())));
criteriaBuilder.greaterThanOrEqualTo(EmployeeRoot.get("joiningDate"), startDate)); 

但它只需要最新的谓词。我怎样才能将两者结合起来像 [Where {condition1} + AND {condition2}] ？

标签： hibernatespring-data-jpacriteriahibernate-criteriapredicatebuilder

Answer 1

你应该这样做：

CriteriaBuilder builder = entityManager.getCriteriaBuilder();
CriteriaQuery<Employee> criteria = builder.createQuery(Employee.class);
Root<Employee> root = criteria.from(Employee.class);
criteria
  .select(...)
  .where(
      builder.and(
         root.get("deptId").in(request.getDeptIdList()),
         builder.greaterThanOrEqualTo(root.get("joiningDate"), startDate))
      )
  );
entityManager.createQuery(criteria).getResultList();