spring - 带有连接的 hibernate 公式

Question

我有一个实体订单和一个实体 order_items ( 1->n 关系)。我想要一个字段来显示相关订单项目的总和(数量)。这些是我的实体:

    @Entity(name="ORDERS")
public class Order {

    @Id
    @GeneratedValue
    @Column (name="order_id")
    private long id;

    @OneToOne
    @JoinColumn(name="customer_id")
    private Customer customer;

    @OneToMany(fetch = FetchType.LAZY, mappedBy = "order", cascade =CascadeType.ALL)
    @JsonManagedReference
    private List<OrderItem> orderItems=new ArrayList();



@Entity(name="ORDER_ITEMS")
public class OrderItem {
    @Id
    @GeneratedValue
    @Column (name="order_item_id")
    private long id;

    @Column (name="quantity")   
    private int quantity;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "order_id", nullable = false)
    @JsonBackReference
    private Order order;

我想要订单实体中的一个新字段来显示总数量( child 的数量总和)。我已尝试按顺序添加该字段，但它不起作用

@Formula("select sum(oi.quantity) from ORDER_ITEMS oi where oi.order_id= order_id)")
private int totalQuantity;

你能帮我解决它吗？

Answer 1

解决办法

    @Formula("(select sum(oi.quantity) from ORDER_ITEMS  oi where oi.order_id= order_id)")
private int totalQuantity;