CriteriaQuery cq = new CriteriaQuery(QdFormFieldEntity.class, dataGrid); cq.createAlias("table", "table"); cq.eq("table.tableName", tPBusiness.getTableName()); //查询条件组装器 try{ //自定义追加查询条件 }catch (Exception e) { throw new BusinessException(e.getMessage()); } cq.add(); DetachedCriteria query = DetachedCriteria.forClass(TPBusinessDEntity.class); query.add(Restrictions.eq("businessId", tPBusinessD.getBusinessId())); query.setProjection(Projections.property("fieldId")); cq.add(Property.forName("id").notIn(query)); this.systemService.getDataGridReturn(cq, true); query.add(Property.forName("admissionId").eqProperty(Property.forName("id"))); query.setProjection(Projections.property("admissionId")); cq.add(Subqueries.exists(query));
CriteriaQuery查询not in 语句写法
本文由 admin 创作,采用 知识共享署名4.0
国际许可协议进行许可
本站文章除注明转载/出处外,均为本站原创或翻译,转载前请务必署名
最后编辑时间为:2022-08-09 21:13:03