Как написать метод JPA для получения запросов сущностей с помощью двухуровневого вложенного объекта ⇐ JAVA

[Гость]

У меня есть такие сущности, как

Код: Выделить всё

@Entity
@Getter
@Setter
@ToString
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class Person implements Serializable {

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;

@Basic(optional = false)
private String name;

@Basic(optional = false)
private int credit;

}

@Entity
@Getter
@Setter
@ToString
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class Bank implements Serializable {

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;

@Basic(optional = false)
private String name;

@Basic(optional = false)
private int duration;

@Singular
@OneToMany(cascade = CascadeType.PERSIST)
private Set personCredits = new HashSet();

}

@Entity
@Getter
@Setter
@ToString
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class PersonCredit implements Serializable {

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;

@ManyToOne(optional = false)
private Person person;

@Basic(optional = false)
private int annualRate;

}

@Entity
@Getter
@Setter
@ToString
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class Billing implements Serializable {

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;

@ManyToOne(optional = false)
private Person person;

@Basic(optional = false)
private LocalDate lastPaymentDate;

@Basic(optional = false)
private long amount;
}

now I need to find all Banks who offer load for the person for a particular Bill
how do I write a JPA repository method in BankRepository?
which fetches the Bank offering the load based upon the Person
when the relationship defined is

Код: Выделить всё

Bank -> PersonCredit -> Person

a method to find all banks offering the load, find person
since it is not a direct relationship, I don't know how to do it


Источник: https://stackoverflow.com/questions/781 ... ted-entity