우리는 JPA라는 개념을 배우고 유저 테이블에 JPA를 적용해 보았습니다. 몇 가지 문제를 통해 JPA를 연습해 봅시다! 🔥

1~2 문제.

1. 답

@Entity
public class Fruit {

    @Id @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(nullable = false)
    private String name;

    @Column(nullable = false)
    private LocalDate warehousingDate;

    private Long price;

    @Column(nullable = false)
    private Boolean isSold;

    public Fruit() {

    }

    public Fruit(String name, LocalDate warehousingDate, Long price) {
        this.name = name;
        this.warehousingDate = warehousingDate;
        this.price = price;
        this.isSold = false;
    }

    public Long getId() {
        return id;
    }

    public String getName() {
        return name;
    }

    public LocalDate getWarehousingDate() {
        return warehousingDate;
    }

    public Long getPrice() {
        return price;
    }

    public Boolean getSold() {
        return isSold;
    }

    public void updateIsSold(Boolean isSold) {
        this.isSold = isSold;
    }
}
@Repository
public interface FruitRepository extends JpaRepository<Fruit, Long> {

    List<Fruit> findAllByNameAndIsSold(String name, boolean isSold);
}
@Service
public class FruitService {

    private final FruitRepository fruitRepository;

    public FruitService(FruitRepository fruitRepository) {
        this.fruitRepository = fruitRepository;
    }

    public void saveFruit(Ex4FruitCreateRequest request) {
        fruitRepository.save(new Fruit(request.getName(), request.getWarehousingDate(), request.getPrice()));
    }

    public void updateFruit(Ex4FruitSoldRequest request) {
        Fruit fruit = fruitRepository.findById(request.getId()).orElseThrow(IllegalArgumentException::new);
        fruit.updateIsSold(true);
        fruitRepository.save(fruit);
    }

    public Ex4FruitSalesAmountResponse statFruit(String name) {
        long salesAmount = fruitRepository.findAllByNameAndIsSold(name,true)
                .stream().mapToLong(Fruit::getPrice).sum();
        long notSalesAmount = fruitRepository.findAllByNameAndIsSold(name,false)
                .stream().mapToLong(Fruit::getPrice).sum();

        return new Ex4FruitSalesAmountResponse(salesAmount, notSalesAmount);
    }
}

2. 답

public class FruitCountResponse {

    private long count;

    public FruitCountResponse(long count) {
        this.count = count;
    }

    public long getCount() {
        return count;
    }
}
@Repository
public interface FruitRepository extends JpaRepository<Fruit, Long> {

    long countAllByName(String name);
}
@Service
public class FruitService {

		private final FruitRepository fruitRepository;

    public FruitService(FruitRepository fruitRepository) {
        this.fruitRepository = fruitRepository;
    }

    public FruitCountResponse getFruitCount(String name) {
        return new FruitCountResponse(fruitRepository.countAllByName(name));

    }
}
@RestController
public class FruitController {

 @GetMapping("/api/v1/fruit/count")
    public FruitCountResponse getFruitCount(@RequestParam String name) {
        return fruitService.getFruitCount(name);
    }
}