在JPA查询中应用价格过滤器

public List<Product> getProductsByPriceRange(BigDecimal minPrice, BigDecimal maxPrice) {
    EntityManager entityManager = // 获取EntityManager对象的代码，此处省略
    
    String query = "SELECT p FROM Product p WHERE p.price >= :minPrice AND p.price <= :maxPrice";
    TypedQuery<Product> typedQuery = entityManager.createQuery(query, Product.class);
    typedQuery.setParameter("minPrice", minPrice);
    typedQuery.setParameter("maxPrice", maxPrice);
    
    return typedQuery.getResultList();
}

public List<Product> getProductsByPriceRange(BigDecimal minPrice, BigDecimal maxPrice) {
    EntityManager entityManager = // 获取EntityManager对象的代码，此处省略
    
    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery<Product> criteriaQuery = criteriaBuilder.createQuery(Product.class);
    Root<Product> root = criteriaQuery.from(Product.class);
    
    criteriaQuery.select(root)
            .where(criteriaBuilder.between(root.get("price"), minPrice, maxPrice));
    
    TypedQuery<Product> typedQuery = entityManager.createQuery(criteriaQuery);
    
    return typedQuery.getResultList();
}