Criteria左外连接以及去重复数据

xiaoxiao2021-02-28  145

public List<FolderVO> listFetch(Long id, int folderType) { Criteria criteria = getCriteria(FolderVO.class,"fo"); criteria.add(Restrictions.eq("fo.id", id));//id不是主键 criteria.add(Restrictions.eq("fo.folderType", folderType)); criteria.createAlias("fo.dmsVOs", "d", CriteriaSpecification.LEFT_JOIN);//左外连接 //criteria.setFetchMode("dmsVOs", FetchMode.JOIN); criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);//根据主表去重复数据 return (List<FolderVO>)criteria.list(); }

转载请注明原文地址: https://www.6miu.com/read-19715.html

最新回复(0)