JPA中高级查询怎样实现join子查询

JPA中高级查询怎样实现join子查询

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条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信