CriteriaQuery

CriteriaQuery subCq = new CriteriaQuery(TSRoleUser.class);
subCq.setProjection(Property.forName("TSUser.id"));
subCq.eq("TSRole.id", roleId);
subCq.add();
cq.add(Property.forName("id").in(subCq.getDetachedCriteria()));
cq.add();


CriteriaQuery query = new CriteriaQuery(ProductPurchaseRecordEntity.class);
query.eq("userId",userId);
query.add();
query.isNull("end");
query.setPageSize(1);
query.setCurPage(1);
query.add();
List<ProductPurchaseRecordEntity> results = systemService.getListByCriteriaQuery(query, true);