首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >如何禁用双向@OneToMany @ManyToOne关系中的获取。弹簧数据

问如何禁用双向@OneToMany @ManyToOne关系中的获取。弹簧数据
EN

Stack Overflow用户
提问于 2021-05-16 16:16:14
回答 2查看 1.1K关注 0票数 0

请帮助我找到一种方法,使父母@实体在双向的父母-孩子关系,而不是它的子实体。谢谢!父实体(w/o -一些不重要的字段):

代码语言:javascript
复制
@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<>();

儿童实体:

代码语言:javascript
复制
@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注释在父实体上使用这些注释:

  • @JsonIgnoreProperties("coupons")
  • @Fetch(value = FetchMode.SELECT)
  • @OnDelete(action = OnDeleteAction.CASCADE)

依赖性清单:

代码语言:javascript
复制
<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>

如果我试图得到一个公司(父实体),它有优惠券(子实体):

代码语言:javascript
复制
{"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}}]}]}
EN

回答 2

Stack Overflow用户

发布于 2021-05-16 18:56:08

据我所知,答案是不能。Hibernate按实体映射,所以您总是拥有整个子对象。

  • --我不知道您想要做什么--但是我认为您应该将整个子列表对象(可能是stream.map()函数)修改成一个列表childId,因为您希望
  • 只对构建的方法中的父查询而不是Hibernate进行查询,因为在内部,它们根据您的映射(独立于和渴望加载)

来发出查询。

-If (您想知道当前在apllication.properties中内部触发的查询是什么?)

代码语言:javascript
复制
spring.jpa.show-sql=true

希望这个答案能对你有所帮助。

票数 0
EN

Stack Overflow用户

发布于 2021-05-20 08:24:14

不知道你到底想要禁用什么,但我想你看到的是获取优惠券的额外选择?在这种情况下,您应该在EAGER上使用@OneToMany,或者使用实体图来指定应该获取优惠券集合。

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/67558985

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档