关于hibernate的Criterias查询

xiaochengfu1 2010-12-13 05:00:53



关于hibernate的Criterias查询，可不可以实现select distinct 列名。。。，相当于列去掉重复？

...全文

77 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

yangfeihu 2010-12-13

打赏
举报

ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.property("id"));
projectionList.add(Projections.property("name"));
c.setProjection(Projections.distinct(projectionList));
List result = c.list();

Jlins 2010-12-13

打赏
举报

类似如下的功能

DetachedCriteria avgWeight = DetachedCriteria.forClass(Cat.class)

    .setProjection( Property.forName("weight").avg() );

session.createCriteria(Cat.class)

    .add( Property.forName("weight).gt(avgWeight) )

    .list();

DetachedCriteria weights = DetachedCriteria.forClass(Cat.class)

    .setProjection( Property.forName("weight") );

session.createCriteria(Cat.class)

    .add( Subqueries.geAll("weight", weights) )

    .list();