有一个地区district的表有id name 和pid属性,pid对于pojo里的districts的set集合,一对多的关系。
id name pid
1 广东 NULL
2 广西 NULL
3 广州 1
4 佛山 1想请教大神们,怎么用DetachedCriteria 查询得到广东和广西啊?
小弟用这个方法,可是
DetachedCriteria dc = DetachedCriteria.forClass(District.class).createAlias("districts", "e");
dc.add(Restrictions.isNull("e.id"));
List districts = districtdao.findAllByCriteria(dc);执行的sql为:
Hibernate:
/* criteria query */ select
this_.id as id4_1_,
this_.name as name4_1_,
e1_.id as id4_0_,
e1_.district as district4_0_,
e1_.name as name4_0_
from
district this_
inner join
district e1_
on this_.district=e1_.id
where
e1_.id is null得到的结果就为空了···DetachedCriteria
id name pid
1 广东 NULL
2 广西 NULL
3 广州 1
4 佛山 1想请教大神们,怎么用DetachedCriteria 查询得到广东和广西啊?
小弟用这个方法,可是
DetachedCriteria dc = DetachedCriteria.forClass(District.class).createAlias("districts", "e");
dc.add(Restrictions.isNull("e.id"));
List districts = districtdao.findAllByCriteria(dc);执行的sql为:
Hibernate:
/* criteria query */ select
this_.id as id4_1_,
this_.name as name4_1_,
e1_.id as id4_0_,
e1_.district as district4_0_,
e1_.name as name4_0_
from
district this_
inner join
district e1_
on this_.district=e1_.id
where
e1_.id is null得到的结果就为空了···DetachedCriteria
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货