Spring

List<OrderInfo> findAllByMember_MemberIdOrderByOrderDateDesc(Long memberId);

MDanderson 2023. 4. 26. 07:09

@Entity
@Data
@ToString(exclude = "member")
@NoArgsConstructor
public class OrderInfo {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long orderId;
    // 오더 아이디 (pk)

    @Column(length = 16, nullable = false)
    private String orderNo;
    // 주문번호

    @CreationTimestamp
    private Date orderDate;
    // 주문날짜

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "member_id")
    private Member member;
    // 주문자

    @OneToMany(mappedBy = "orderInfo", fetch = FetchType.LAZY, cascade = CascadeType.ALL)
    private List<OrderItem> orderItemList = new ArrayList<>();
    // 오더아이템 연결

    @Column(length = 8, nullable = false)
    private Long orderTotalCount;
    // 주문 하나당 주문상품 몇 종인지

    @OneToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "payment_id")
    private Payment payment;
    // 결제 연결

    @OneToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "address_id")
    private Delivery delivery;
    // 배송 연결

    @Column(nullable = false)
    private String selectedDeliveryReq;
    // 배송요청사항

}

public class Member {

    @Id
    @Column(length = 16)
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long memberId;

    @Column(length = 16,unique = true, nullable = false)
    private String userId;

    public Member(String userId) {
        this.userId = userId;
    }

    @OneToMany(mappedBy = "member", fetch = FetchType.LAZY, cascade = CascadeType.ALL)
    private Set<Authentication> authentications = new HashSet<>();

 

 

findAllByMember_MemberIdOrderByOrderDateDesc(Long memberId);

 

OrderInfo들을 모두다 찾는데  OrderInfo엔티티의 Member객체의 memberId칼럼으로 조회하라는말

findAllByMemberMemberId 이거랑 같음

 

'Spring' 카테고리의 다른 글

@jsonIgnore의 문제점  (0) 2023.04.27
@Lob과 columnDefinition = "TEXT"  (0) 2023.04.26
@OneToMany(mappedBy =  (0) 2023.04.26
단방향 조인 mappedBy= 없이  (0) 2023.04.26
CascadeType.DETACH  (0) 2023.04.26