JAVA JPA检查日期介于两个日期之间

import javax.persistence.EntityManager;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;
import java.util.Date;
import java.util.List;

public class DateRangeExample {
    public List<Entity> getEntitiesBetweenDates(Date startDate, Date endDate) {
        EntityManager entityManager = // 获取EntityManager实例
        
        CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
        CriteriaQuery<Entity> criteriaQuery = criteriaBuilder.createQuery(Entity.class);
        Root<Entity> root = criteriaQuery.from(Entity.class);
        
        Predicate datePredicate = criteriaBuilder.between(root.get("date"), startDate, endDate);
        criteriaQuery.where(datePredicate);
        
        return entityManager.createQuery(criteriaQuery).getResultList();
    }
}

import javax.persistence.EntityManager;
import javax.persistence.Query;
import java.util.Date;
import java.util.List;

public class DateRangeExample {
    public List<Entity> getEntitiesBetweenDates(Date startDate, Date endDate) {
        EntityManager entityManager = // 获取EntityManager实例
        
        String jpql = "SELECT e FROM Entity e WHERE e.date BETWEEN :startDate AND :endDate";
        Query query = entityManager.createQuery(jpql);
        query.setParameter("startDate", startDate);
        query.setParameter("endDate", endDate);
        
        return query.getResultList();
    }
}