Join关联ManyToMany查询
表person对应的model类:
@Entity @Table(name = "person") public class Person { @Id @GeneratedValue private Long id; private Integer age; private String name; @Column(name = "nick_name") private String nickName; private String company; private Date birthday; @ManyToMany(cascade = ALL, fetch = FetchType.LAZY) private Set<Address> addresses = new HashSet<>();
// getter and setter
}
表address对应的model类:
@Entity @Table(name = "address") public class Address { @Id @GeneratedValue private Long id; private String street; private Integer number; @ManyToMany(mappedBy = "addresses") private Set<Person> owners = new HashSet<>();
// getter and setter
}
数据库访问PersonRepository类:
public interface PersonRepository extends JpaRepository<Person, Long>, JpaSpecificationExecutor<Person> {
}
查询年龄在10到35之间住在"Chengdu"的人。public List<Person> findAll(SearchRequest request) { Specification<Person> specification = new Specifications<Person>() .between("age", new Range<>(10, 35)) .eq("addresses.street", "Chengdu") .build(); return phoneRepository.findAll(specification); }