hibernate中criteria的连接查询的问题
criteria.add(Restrictions.like("ttopic", "%" + keyWord + "%"));
criteria.add(Restrictions.like("state", Integer.parseInt(state)));
criteria.createAlias("bbsreplies", "reply",Criteria.LEFT_JOIN);
criteria.add(Restrictions.eq("reply.state", 2));
criteria.setProjection(Projections.rowCount());
List <Integer> res = criteria.list();
Integer totalCount = res.get(0);
以上代码执行后生成的sql语句为
select
count(*) as y0_
from
public.bbstopic this_
left outer join
public.bbsreply reply1_
on this_.tid=reply1_.rtid
where
this_.ttopic like ?
and this_.state like ?
and reply1_.state=?
但是我想要的语句为
select
count(*) as y0_
from
public.bbstopic this_
left outer join
public.bbsreply reply1_
on this_.tid=reply1_.rtid and reply1_.state=?
where
this_.ttopic like ?
and this_.state like ?
就是最后一个查询条件方到那个连接里面去,谁知道怎么改代码可以生成这样的语句哦