请帮助我找到一种方法,使父母@实体在双向的父母-孩子关系,而不是它的子实体。谢谢!父实体(w/o -一些不重要的字段):
@Data
@Entity
@Table(name = "COMPANIES")
@NoArgsConstructor
@AllArgsConstructor
@Lazy
@Builder
public class Company {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY, generator = "increment")
@Column(nullable = false, name = "ID", updatable = false) //updatable
private int id;
@Column(nullable = false, length = 100, name = "NAME", unique = true)
private String name;
@OneToMany(mappedBy = "company", cascade = CascadeType.ALL, fetch = FetchType.LAZY, orphanRemoval = true)
@JsonManagedReference
private List<Coupon> coupons = new ArrayList<>();儿童实体:
@Entity
@Table(name = "COUPONS", indexes = @Index(name = "TitleIndex", columnList = "COMPANY_ID, TITLE", unique = true))
@AllArgsConstructor
@NoArgsConstructor
@Lazy
@Builder
public class Coupon {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY, generator = "increment")
@Column(nullable = false, name = "ID", updatable = false)
private int id;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "COMPANY_ID", nullable = false)
@JsonBackReference
private Company company;
@Column(nullable = false, length = 100, name = "TITLE")
private String title;
@OneToMany(mappedBy = "coupon", cascade = CascadeType.ALL, fetch = FetchType.LAZY, orphanRemoval = true)
@JsonManagedReference
private List<Purchase> purchase = new ArrayList<>();我已经尝试用@OneToMany注释在父实体上使用这些注释:
依赖性清单:
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.4.5</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.jb</groupId>
<artifactId>coupons3web</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>coupons3web</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>11</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-rest</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-hateoas</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-security</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.mariadb.jdbc</groupId>
<artifactId>mariadb-java-client</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.security</groupId>
<artifactId>spring-security-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<excludes>
<exclude>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</exclude>
</excludes>
</configuration>
</plugin>
</plugins>
</build>如果我试图得到一个公司(父实体),它有优惠券(子实体):
{"id":2,"name":"Facebook","email":"k3","password":"$2a$10$WHBxW62w07mNcT8UcaiPw.MmAB/TjbIjcTM2fcmIiCjri5ac59ba.","coupons":[{"id":1,"title":"Travel","description":"RK49NZi3L7","startDate":"2021-05-27","endDate":"2021-06-17","amount":3400,"price":163.55,"image":"qq3eUAJx0CnxnOtkv2HB","purchase":[{"id":{"couponID":1,"customerID":2}},{"id":{"couponID":1,"customerID":5}},{"id":{"couponID":1,"customerID":6}},{"id":{"couponID":1,"customerID":12}},{"id":{"couponID":1,"customerID":16}},{"id":{"couponID":1,"customerID":19}}]}]}发布于 2021-05-16 18:56:08
据我所知,答案是不能。Hibernate按实体映射,所以您总是拥有整个子对象。
来发出查询。
-If (您想知道当前在apllication.properties中内部触发的查询是什么?)
spring.jpa.show-sql=true希望这个答案能对你有所帮助。
发布于 2021-05-20 08:24:14
不知道你到底想要禁用什么,但我想你看到的是获取优惠券的额外选择?在这种情况下,您应该在EAGER上使用@OneToMany,或者使用实体图来指定应该获取优惠券集合。
https://stackoverflow.com/questions/67558985
复制相似问题