hibernate - Hibernate Criteria 查询没有给出完整的结果

Question

Criteria criteria = createEntityCriteria().addOrder(Order.asc("dtname"));
ProjectionList projection = Projections.projectionList();
projection.add(Projections.distinct(Projections.property("dtncode")));
projection.add(Projections.property("dtname"));
criteria.setProjection(projection);
List<VillageMaster> villageMasters = (List<VillageMaster>) 
criteria.list();

我已经编写了上面的代码，但代码没有给出确切的结果。任何人请帮我解决问题。生成的sql查询如下：

select distinct this.dtncode as y0, this.dtname11 as y1 
from village_master this
order by this.dtname11 asc

标签： hibernate

Answer 1

使用下面的代码

Criteria criteria = createEntityCriteria().addOrder(Order.asc("dtname"));    
ProjectionList projection = Projections.projectionList();
projection.add(Projections.property("dtncode"));
projection.add(Projections.property("dtname"));
criteria.setProjection(Projections.distinct(projection));
List<VillageMaster> villageMasters = (List<VillageMaster>) 
criteria.list();