프로젝트_ 커피주문 서비스 (18) 썸네일형 리스트형 Order 삭제 참조 무결성 위반 문제 해결 OrderAPIController 코드 추가 @RestController public class OrderAPIController { @Autowired private OrderService orderService; . . . //주문 삭제 @DeleteMapping("/api/orders/{id}") public ResponseEntity delete(@PathVariable Long id) { Order deleted = orderService.delete(id); return deleted != null ? ResponseEntity.status(HttpStatus.OK).build() : ResponseEntity.status(HttpStatus.BAD_REQUEST).. Order 조회, Order_Product 등록, 삭제 Order 조회 OrderService @Slf4j @Service public class OrderService { @Autowired private OrderRepository orderRepository; @Autowired private MemberRepository memberRepository; @Autowired private OrderProductRepository orderProductRepository; //전체 주문 조회 public List list() { return orderRepository.findAll(); } //회원 전화번호 별 주문 조회 public List findByPhoneNum(String PhoneNum) { return orderRepository.findB.. OrderProduct_ SELECT 테스트 Entity/OrderProduct @AllArgsConstructor @NoArgsConstructor @ToString @Getter @Entity @Table (name = "OrderProduct") public class OrderProduct { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @ManyToOne @JoinColumn(name = "order_id") private Order order; @ManyToOne @JoinColumn(name = "product_id") private Product product; @Column private int Total; } Repository/OrderProd.. OrderDate 삽입 JPA Auditing을 활용하여 Order엔티티의 orderDate에 시간값 삽입 BaseTimeEntity 수정 @MappedSuperclass // JPA Entity 클래스들이 상속받을 경우 필드도 컬럼으로 인식 @EntityListeners(AuditingEntityListener.class) //Auditing 기능 추가 @Getter //Getter 추가, 롬복 public class BaseTimeEntity { @CreatedDate //생성 시간 private LocalDateTime orderDate; } Entity/Order @AllArgsConstructor @NoArgsConstructor @ToString @Getter @Entity @Table(name = "Orders").. 시간 등록을 위한 JPA Auditing 테스트 JPA Auditing Spring Data JPA 에서 시간에 대해서 자동으로 값을 넣어주는 기능 BaseTimeEntity 생성 @MappedSuperclass // JPA Entity 클래스들이 상속받을 경우 필드도 컬럼으로 인식 @EntityListeners(AuditingEntityListener.class) //Auditing 기능 추가 @Getter //Getter 추가, 롬복 public class BaseTimeEntity { @CreatedDate //생성 시간 private LocalDateTime createdDate; @LastModifiedDate //수정 시간 private LocalDateTime modifiedDate; } TimeTestEntity 생성 @AllArgsCo.. Member_ CRUD (API Controller) Member_ 조회, 생성, 수정, 삭제 Member 엔티티 @AllArgsConstructor @NoArgsConstructor @Getter @ToString @Entity public class Member { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @Column private String userName; //로그인 ID @Column private String name; @Column private Integer age; @Column private String phoneNum; @Column private String password; public void patch(Member member) { if .. Product_ Update, Delete (API Controller) Product_ 수정 ProductAPIController @Slf4j @RestController public class ProductAPIController { @Autowired private ProductService productService; . . . . . //상품 수정 @PatchMapping("/api/products/{id}") public ResponseEntity update(@PathVariable Long id, @RequestBody ProductDto dto) { Product updated = productService.update(id, dto); return (updated != null) ? ResponseEntity.status(HttpStatus.OK).body(.. Product_ Create, Read (API Controller) 상품의 등록과 조회 초기엔 h2 db로 진행, 안정화 후 변경예정 Entity/Product @AllArgsConstructor @NoArgsConstructor @ToString @Getter @Entity public class Product { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @Column private String name; @Column private int price; @Column private String category; } DTO/ProductDto @AllArgsConstructor @NoArgsConstructor @ToString @Setter public class ProductDt.. 이전 1 2 3 다음
