JPA EntityManager 查询写法记录

获取EntityManager

  @PersistenceContext
    private EntityManager entityManager;

子查询

@Transactional
class Demo{

	public void method(){
 		CriteriaBuilder cb = entityManager.getCriteriaBuilder();
        //结果集
        CriteriaQuery<A> query = cb.createQuery(A.class);
        //目标库
        Root<A> root = query.from(A.class);


        Subquery<Long> subQuery = query.subquery(Long.class);
        Root<TemplateDO> subRoot = subQuery.from(A.class);
        subQuery.select(subRoot.get("id"))
                .where(setPredicate(cb, subRoot, subQuery, request));
        query.select(root).where(cb.in(root.get("id")).value(subQuery));

		query.orderBy(cb.desc(root.get("createTime")))
                .where(setPredicate(cb, root, query, request));
 }
}

普通分页查询

class Demo{
	public void method(){
		query.orderBy(cb.desc(root.get("createTime")))
                .where(setPredicate(cb, root, query, request));

        TypedQuery<TemplateDO> typedQuery = entityManager.createQuery(query);
        typedQuery.setFirstResult((request.getPageIndex() - 1) * request.getPageSize()); // 设置分页limit a,b 的a
        typedQuery.setMaxResults(request.getPageSize());  // 设置分页limit a,b 的b
        PageResult.page((int) totalCount
                , request.getPageSize()
                , request.getPageIndex()
                , typedQuery.getResultStream()
				.......//resultSet 结果处理
				);
	}
}