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);
}