带有枚举对象列表的Restrictions.in休眠计数

public enum OrderStatus {
    PENDING, PAID, SHIPPED, DELIVERED;
}

@Entity
public class Order {
    @Id
    private Long id;
    private OrderStatus status;
    // getters and setters
}

Criteria criteria = session.createCriteria(Order.class);
criteria.add(Restrictions.in("status", Arrays.asList(OrderStatus.PENDING, OrderStatus.SHIPPED)));
Long count = (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
System.out.println("休眠订单数量: " + count);

// 添加索引
@Entity
@Table(name = "orders", indexes = @Index(columnList = "status"))
public class Order {
    // ...
}

// 分页查询
Criteria criteria = session.createCriteria(Order.class);
criteria.add(Restrictions.in("status", Arrays.asList(OrderStatus.PENDING, OrderStatus.SHIPPED)));
criteria.setFirstResult(0); // 设置起始位置
criteria.setMaxResults(100); // 设置每页大小
List<Order> orders = criteria.list();