休眠条件联接查询 [英] Hibernate Criteria join query

问题描述

如何从以下SQL创建休眠条件查询？

How do I create a Hibernate criteria query from the following sql?

String hql = select e.employeeId，m.meetingId， e。来自员工的名字e加入e。会议m;

有人可以提供相应的条件查询吗？

Can anyone please provide the corresponding criteria query?

推荐答案

条件查询为：

Criteria c = session.createCriteria(Employee.class, "e");
c.createAlias("e.meetings", "m"); // inner join by default
c.setProjection( Projections.distinct( Projections.projectionList()
            .add( Projections.property("e.employeeId"), "employeeId")
            .add( Projections.property("m.meetingId"), "meetingId")
            .add( Projections.property("e.firstname"), "firstname")));

这篇关于休眠条件联接查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！