我用了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;
}