2023年7月20日发(作者:)
JPA中⾼级查询怎样实现join⼦查询如SQL:select assets_entity.* from assets_entity
left join ( select inventory__entity_id from inventory_recording where inventory_ory_task_id = ?) as irr
on assets_ = _entity_id
where _entity_id is null;下⾯是我写到⼀半的,可是不知道怎么放⼦查询private void listsss(){ Specification specification = new Specification() { @Override public Predicate toPredicate(Root root, CriteriaQuery> criteriaQuery, CriteriaBuilder criteriaBuilder) { //Path assetsNumberPath = ("assetsNumber"); // 完成⼦查询 Subquery subQuery = ry(); Root IRFrom = (); (("assetsEntity")).where((("inventoryTask"), 1L)); // left join List predicates = new ArrayList<>(); Predicate[] array = new Predicate[()]; (y(array)); return null; }
发布者:admin,转转请注明出处:http://www.yc00.com/news/1689827028a289041.html
评论列表(0条)