spring date jpa 查询列最大值

@Resource
private EntityManagerFactory entityManagerFactory;
public Date getMaxCreatetime(){
EntityManager em = entityManagerFactory.createEntityManager();
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Date> cq = cb.createQuery(Date.class); //查询结果

//在哪个表查
Root<SysLog> root = cq.from(SysLog.class);
cq.select(cb.greatest((Path)root.get("createtime")));

//结果
TypedQuery<Date> typedQuery = em.createQuery(cq);
return typedQuery.getSingleResult();

}

文章来自:http://www.cnblogs.com/minlorry/p/4891302.html
© 2021 jiaocheng.bubufx.com  联系我们
ICP备案:鲁ICP备09046678号-3