Hibernate 选出所有账户最后的一条记录

金闪闪金闪闪

于 2023-07-10 14:33:34 发布

阅读量195

点赞数

文章标签： hibernate windows 数据库

本文链接：https://blog.youkuaiyun.com/weixin_42189884/article/details/131638309

版权

该代码段展示了如何在Java中使用Hibernate的DetachedCriteria进行多条件查询。它创建了两个子查询dc1和dc2，分别对TaRiskProfilingDetail类进行JOIN操作，并通过创建别名和设置条件来关联数据。查询涉及旅行代理的id匹配、日期的最大值投影、特定状态筛选以及按评分排序。最后，返回满足条件的列表。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

    public List<TaRiskProfilingDetail> getRiskImpactList() {
       DetachedCriteria dc1 = DetachedCriteria.forClass(TaRiskProfilingDetail.class, "TaRS1");
       DetachedCriteria dc2 = DetachedCriteria.forClass(TaRiskProfilingDetail.class, "TaRS2");
       dc1.createAlias("travelAgent", "Ta1", JoinType.LEFT_OUTER_JOIN);
       dc2.createAlias("travelAgent", "Ta2", JoinType.LEFT_OUTER_JOIN);
       dc2.add(Restrictions.eqProperty("Ta1.id", "Ta2.id"));
       ProjectionList projections = Projections.projectionList();
       projections.add(Projections.max("TaRS2.createdDate"), "createdDate");
       dc2.setProjection(projections);
       dc1.add(Subqueries.propertyEq("TaRS1.createdDate", dc2));
       dc1.setResultTransformer(DetachedCriteria.DISTINCT_ROOT_ENTITY);
       dc1.createAlias("Ta1.licence", "licence", JoinType.LEFT_OUTER_JOIN);
       addIn(dc1, "licence.status.code", Codes.TaStatuses.GENERALLY_ACTIVE);
       dc1.addOrder(Order.desc("riScore"));
       return getList(dc1);
   };