상품 조회 로직 구현하기

 

ProductController

    @Operation(summary = "상품 조회", description = "상품 조회입니다")
    @GetMapping("/{id}")
    public @ResponseBody ApiResponse<ProductSelectResponseDto> selectProduct(@PathVariable(name = "id") long id) throws Exception{
        return ApiResponse.OK(productService.selectProduct(id));
    }

 

ProductService

// 상품 조회
    public ProductSelectResponseDto selectProduct(Long id) {

        Product product = productRepository.findById(id)
                .orElseThrow( ()-> new CustomException(PRODUCT_NOT_FOUND));

        List<ProductSelectResponseDto.productOptionSelectResponseDto> optionDtoList = new ArrayList<>();

        // Option Entity List 를 Option Dto List로 바꾸는 과정 (꺼내는 거)
        for(ProductOption productOption : product.getProductOptionList()){
            // Entity List → Entity

            // Option 하나에 연결된 Option detail Entity List를 가져와 String 타입의 List detail에 넣어줌
            // 결국은 이 과정이 optionDto의 optionDetails 자리에 넣기 위함.
            List<String> detail = new ArrayList<>();
            for(ProductOptionDetail d : productOption.getProductOptionDetailList()){
                detail.add(d.getOptionContent());
            }

            ProductSelectResponseDto.productOptionSelectResponseDto optionDto = new ProductSelectResponseDto.productOptionSelectResponseDto(productOption.getOptionEx(), detail);
            // 위의 optionDtoList는 여러 개의 optionDto를 넣기 위해 만듦
            optionDtoList.add(optionDto);
        }

        return new ProductSelectResponseDto(product.getProductNo(), product.getProductCategory().getProductCategoryNo(), product.getProductName(), product.getProductContent(),
                product.getPrice(), product.getProductQuantity(), optionDtoList);
    }

 

ProductSelectResponseDto

package com.example.bluesyroom.dto.product;

import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;

import java.util.List;

@AllArgsConstructor
@NoArgsConstructor
@Getter
public class ProductSelectResponseDto {
    // ★★★★★★★★★★★★★★★★★★★
    // optionEx를 List로 바꿔서 innetClass 변경 하고 ~~~~

    private long productNo;
    private Long productCategoryNo;
    private String productName;
    private String productContent;
    private int price;
    private int productQuantity;
    private List<productOptionSelectResponseDto> optionDtoList;

    @NoArgsConstructor
    @AllArgsConstructor
    @Getter
    public static class productOptionSelectResponseDto {
        private String optionEx;
        private List<String> optionDetails;
    }

}

 

Product

package com.example.bluesyroom.entity;

import java.util.*;
import jakarta.persistence.*;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import com.example.bluesyroom.entity.ProductImage;

@Entity
@NoArgsConstructor
@Getter
@Setter         // 상품
@Table(name = "PRODUCT")
public class Product {
    @Id // 기본키
    @GeneratedValue(strategy = GenerationType.IDENTITY) // auto_increament
    @Column(name = "PRODUCT_NO", nullable = false)
    private long productNo;

    // DB 컬럼은 _ 사용
    @Column(name = "PRODUCT_NAME", nullable = false)
    private String productName;

    @Column(name = "PRODUCT_CONTENT", nullable = false)
    private String productContent;

    @Column(name = "PRICE", nullable = false)
    private int price;

    @Column(name = "PRODUCT_QUANTITY", nullable = false)
    private int productQuantity;

    // 테이블 생성과 조인은 이후에 따로 진행할 수 있음

    @OneToOne
    @JoinColumn(name = "PRODUCT_CATEGORY_NO")
    private ProductCategory productCategory;

    @OneToMany(mappedBy = "product")
    private List<ProductImage> productImageList = new ArrayList<ProductImage>();

	// ★ ★
    @OneToMany(mappedBy = "product")
    private List<ProductOption> productOptionList = new ArrayList<>();

    public Product(String productName, String productContent, int price, int productQuantity, ProductCategory productCategory) {
        this.productName = productName;
        this.productContent = productContent;
        this.price = price;
        this.productQuantity = productQuantity;
        this.productCategory = productCategory;
    }
}

 

ProductOption

package com.example.bluesyroom.entity;

import jakarta.persistence.*;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;

import java.util.ArrayList;
import java.util.List;

@Entity
@NoArgsConstructor
@Getter
@Setter         // 상품 옵션
@Table(name = "PRODUCT_OPTION")
public class ProductOption {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "OPTION_NO", nullable = false)
    private long optionNo;

    @Column(name = "OPTION_EX", nullable = false)
    private String optionEx;

    @ManyToOne
    @JoinColumn(name = "PRODUCT_NO")
    private Product product;
    
	// ★ ★
    @OneToMany(mappedBy = "productOption")
    private List<ProductOptionDetail> productOptionDetailList = new ArrayList<>();

    public ProductOption(String optionEx) {
        this.optionEx = optionEx;
    }
}

 

ProductOptionDetail

package com.example.bluesyroom.entity;

import jakarta.persistence.*;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;

@Entity
@NoArgsConstructor
@Getter
@Setter         // 상품 옵션 상세
@Table(name = "PRODUCT_OPTION_DETAIL")
public class ProductOptionDetail {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "OPTION_DETAIL_NO", nullable = false)
    private long optionDetailNo;

    @Column(name = "OPTION_CONTENT", nullable = false)
    private String optionContent;

    @ManyToOne
    @JoinColumn(name = "OPTION_NO")
    private ProductOption productOption;

    public ProductOptionDetail(String optionContent, ProductOption productOption) {
        this.optionContent = optionContent;
        this.productOption = productOption;
    }
}