如何从Hibernate搜索中获取最低和最高价格

Session session = sessionFactory.openSession();
Criteria criteria = session.createCriteria(Product.class);

ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.min("price"));
projectionList.add(Projections.max("price"));
criteria.setProjection(projectionList);

criteria.add(Restrictions.between("price", minPrice, maxPrice));

List<Object[]> results = criteria.list();
if (results != null && !results.isEmpty()) {
    Object[] result = results.get(0);
    BigDecimal minPrice = (BigDecimal) result[0];
    BigDecimal maxPrice = (BigDecimal) result[1];
    System.out.println("最低价格：" + minPrice);
    System.out.println("最高价格：" + maxPrice);
}

session.close();