java 一对一的关系,java – 一对一关系hibernate导致许多查询

我有一对一的关系

@Entity

@Table(name = "PERSON")

public class Person {

@Id

@GeneratedValue(strategy = GenerationType.AUTO)

@Column(name = "PERSON_ID")

private int personId;

@Column(name = "PERSON_NAME", nullable = false, length = 30)

private String personName;

@OneToOne(mappedBy = "person", cascade = CascadeType.ALL)

private DrivingLicense drivingLicense;

}

@Entity

@Table(name = "DRIVING_LICENSE")

public class DrivingLicense {

@Id

@GeneratedValue(strategy = GenerationType.AUTO)

@Column(name = "LICENSE_NUMBER")

private int licenseNumber;

@Column(name = "DATE_OF_ISSUE")

private Date dateOfIssue;

@OneToOne

@JoinColumn(name = "PERSON_ID", unique = true)

private Person person;

}

目前每个表中有3行

但是当我对下面的人进行查询时

Query query = entityManager.createQuery("from Person p");

获得结果列表后,会产生如下所示的太多查询;

Hibernate: select person0_.PERSON_ID as PERSON_ID1_1_, person0_.PERSON_NAME as PERSON_NAME2_1_ from PERSON person0_

Hibernate: select drivinglic0_.LICENSE_NUMBER as LICENSE_NUMBER1_0_1_, drivinglic0_.DATE_OF_ISSUE as DATE_OF_ISSUE2_0_1_, drivinglic0_.PERSON_ID as PERSON_ID3_0_1_, person1_.PERSON_ID as PERSON_ID1_1_0_, person1_.PERSON_NAME as PERSON_NAME2_1_0_ from DRIVING_LICENSE drivinglic0_ left outer join PERSON person1_ on drivinglic0_.PERSON_ID=person1_.PERSON_ID where drivinglic0_.PERSON_ID=?

Hibernate: select drivinglic0_.LICENSE_NUMBER as LICENSE_NUMBER1_0_1_, drivinglic0_.DATE_OF_ISSUE as DATE_OF_ISSUE2_0_1_, drivinglic0_.PERSON_ID as PERSON_ID3_0_1_, person1_.PERSON_ID as PERSON_ID1_1_0_, person1_.PERSON_NAME as PERSON_NAME2_1_0_ from DRIVING_LICENSE drivinglic0_ left outer join PERSON person1_ on drivinglic0_.PERSON_ID=person1_.PERSON_ID where drivinglic0_.PERSON_ID=?

Hibernate: select drivinglic0_.LICENSE_NUMBER as LICENSE_NUMBER1_0_1_, drivinglic0_.DATE_OF_ISSUE as DATE_OF_ISSUE2_0_1_, drivinglic0_.PERSON_ID as PERSON_ID3_0_1_, person1_.PERSON_ID as PERSON_ID1_1_0_, person1_.PERSON_NAME as PERSON_NAME2_1_0_ from DRIVING_LICENSE drivinglic0_ left outer join PERSON person1_ on drivinglic0_.PERSON_ID=person1_.PERSON_ID where drivinglic0_.PERSON_ID=?

显然对于获取3行hibernate的4个查询,如何解决这个问题？我在关系方面做错了吗？

更新

现在如果我拿着驾驶执照就像

Query query = entityManager.createQuery("from DrivingLicense dl");

更糟糕的是,7个查询被解雇了.

最佳答案 要拥有JPA供应商独立解决方案,您可以使用以下JPQL查询.

让所有拥有DrivingLicense的人

Query query = entityManager.createQuery("from Person p join fetch p.drivingLicense");

如果他们拥有DrivingLicense,则获得所有人的相关性

Query query = entityManager.createQuery("from Person p left join fetch p.drivingLicense");

或使用Criteria API

CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();

CriteriaQuery criteriaQuery = criteriaBuilder.createQuery(Person.class);

Root root = criteriaQuery.from(Person.class);

root.fetch("drivingLicense", JoinType.INNER);

criteriaQuery.select(root);

List resultList = em.createQuery(criteriaQuery).getResultList();

RESP.

CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();

CriteriaQuery criteriaQuery = criteriaBuilder.createQuery(Person.class);

Root root = criteriaQuery.from(Person.class);

root.fetch("drivingLicense", JoinType.LEFT);

criteriaQuery.select(root);

List resultList = em.createQuery(criteriaQuery).getResultList();