jpa左连接,表连接

mac2025-11-12  8

我用了jpa的criteriaQuery来进行表连接

public Page<BaseMov> findByNav(BaseNav all1) { PageRequest of = PageRequest.of(0, 6); Page<BaseMov> results= baseMovDao.findAll(new Specification<BaseMov>() { @Override public Predicate toPredicate(Root<BaseMov> root, CriteriaQuery<?> criteriaQuery, CriteriaBuilder criteriaBuilder) { Join join = root.join("baseNavs", JoinType.LEFT); return criteriaBuilder.equal(join.get("id"), all1.getId()); } },of); return results; }
最新回复(0)