步骤
1. 注入
@PersistenceContext
private EntityManager em;
2. 获取对象
CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
//cost去接收
CriteriaQuery<Cost> criteriaQuery = criteriaBuilder.createQuery(Cost.class);
3. 为对象赋予各个参数
- select
// 代表select *
criteriaQuery.select(root);
或
criteriaQuery.multiselect(
root.get("name"),
root.get("ty"),
root.get("qu"),
root.get("us"),
criteriaBuilder.count(root.get("na")).alias("count"),
criteriaBuilder.max(criteriaBuilder.diff(root.get("finTime"), root.get("stT