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

@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);
}
}
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);
}
}