W3Cschool
恭喜您成為首批注冊用戶
獲得88經(jīng)驗值獎勵
表person對應(yīng)的model類:
表phone對應(yīng)的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; @OneToMany(cascade = ALL) private Set<Phone> phones = new HashSet<>();
// getter and setter
}
數(shù)據(jù)庫訪問PhoneRepository類:@Entity @Table(name = "phone") public class Phone { @Id @GeneratedValue private Long id; private String number; private String brand; @ManyToOne private Person person;
// getter and setter
}
public interface PhoneRepository extends JpaRepository<Phone, Long>, JpaSpecificationExecutor<Phone> {
}
查詢姓名為"Jack",用的手機為"HuaWei"的人。public List<Phone> findAll(SearchRequest request) { Specification<Phone> specification = new Specifications<Phone>() .eq(StringUtils.isNotBlank(request.getBrand()), "brand", "HuaWei") .eq(StringUtils.isNotBlank(request.getPersonName()), "person.name", "Jack") .build(); return phoneRepository.findAll(specification); }
Copyright©2021 w3cschool編程獅|閩ICP備15016281號-3|閩公網(wǎng)安備35020302033924號
違法和不良信息舉報電話:173-0602-2364|舉報郵箱:jubao@eeedong.com
掃描二維碼
下載編程獅App
編程獅公眾號
聯(lián)系方式:
更多建議: