如何书写Jpa的动态sql

步骤

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