java - hibernate :无法获取关联的列表

实体X具有实体Y的列表，而实体Y具有实体Z的实例。

X与Y之间的关系是OneToMany，而Y与Z之间的关系是ManyToOne。

我想检索X并同时检索所有关联的实体。

我写什么HQL查询，以便一次检索全部链。目前，它的hibernateTemplate.find（“ from X”）。
或我要使用什么注释？

X = ServiceProvider，Y = BusinessLocations.java，Z = State.java

我在下面注释了实体，并且整个链都保存在数据库中，但是当我尝试检索Y（BusinessLocation）的列表时，我得到了

没有。

如何将X与Y以及Y与Z联接？

以下是实体x，Y和Z。

ServiceProvider.java

@Entity
public class ServiceProvider implements Serializable{

    private Long id;
    private Set<BusinessLocation> businessLocations = new HashSet<BusinessLocation>();

    @Id
    @GeneratedValue
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }

    @OneToMany(mappedBy="serviceProvider", targetEntity=BusinessLocation.class, cascade=CascadeType.ALL, fetch=FetchType.EAGER)
    public Set<BusinessLocation> getBusinessLocations() {
        return businessLocations;
    }

    public void setBusinessLocations(Set<BusinessLocation> businessLocations) {
        this.businessLocations = businessLocations;
    }

    public boolean equals(Object obj) {
        if(!(obj instanceof ServiceProvider)) return false;
        ServiceProvider other = (ServiceProvider) obj;
        return new EqualsBuilder().append(businessLocations, other.businessLocations).isEquals();
    }
}

BusinessLocation.java

@Entity
public class BusinessLocation implements Serializable{

    private Long id;
    private String address;
    private String city;
    private State state;
    private String pincode;
    private ServiceProvider serviceProvider;

    public BusinessLocation() {
    }

    @Id
    @GeneratedValue
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }
    public String getCity() {
        return city;
    }
    public void setCity(String city) {
        this.city = city;
    }

    @ManyToOne(cascade=CascadeType.ALL)
    @JoinColumn(name="state_id")
    public State getState() {
        return state;
    }
    public void setState(State state) {
        this.state = state;
    }
    public void setPincode(String pincode) {
        this.pincode = pincode;
    }

    public String getPincode() {
        return pincode;
    }

    @ManyToOne
    @JoinColumn(name="serviceProvider_id")
    public ServiceProvider getServiceProvider() {
        return serviceProvider;
    }
    public void setServiceProvider(ServiceProvider serviceProvider) {
        this.serviceProvider = serviceProvider;
    }

    public boolean equals(Object obj) {
        if( !(obj instanceof BusinessLocation)) return false;
        BusinessLocation other = (BusinessLocation) obj;
        return new EqualsBuilder().append(address, other.address).append(city, other.city).append(state, other.state).append(pincode,

other.pincode).append(serviceProvider, other.serviceProvider).isEquals();
    }

    public int hashCode() {
        return new HashCodeBuilder().append(address).append(city).append(state).append(pincode).append(serviceProvider).toHashCode();
    }
}

State.java

@Entity
public class State implements Serializable {

    private Long id;
    private String abbreviatedName;
    private String name;
    private List<BusinessLocation> businessLocations;

    @Id
    @GeneratedValue
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    public String getAbbreviatedName() {
        return abbreviatedName;
    }
    public void setAbbreviatedName(String abbreviatedName) {
        this.abbreviatedName = abbreviatedName;
    }
    public void setName(String name) {
        this.name = name;
    }

    public String getName() {
        return name;
    }


    @OneToMany(mappedBy="state", targetEntity=BusinessLocation.class, cascade=CascadeType.ALL, fetch=FetchType.EAGER)
    public List<BusinessLocation> getBusinessLocations() {
        return businessLocations;
    }
    public void setBusinessLocations(List<BusinessLocation> businessLocations) {
        this.businessLocations = businessLocations;
    }

    public boolean equals(Object obj) {
        if(! (obj instanceof State)) return false;
        State other = (State) obj;
        return new EqualsBuilder().append(abbreviatedName, other.abbreviatedName).append(name, other.name).append(businessLocations,

other.businessLocations).isEquals();
    }

    public int hashCode() {
        return new HashCodeBuilder().append(name).append(abbreviatedName).append(businessLocations).toHashCode();
    }

}

有人可以帮我吗？

谢谢

最佳答案

关于什么：

Query q - entityManager.createQuery("Select x from ServiceProvider x inner join x.businessLocations as y and inner join y.state as z where x.id = ?1");

关于java - hibernate :无法获取关联的列表，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/3577364/