4일차 과제 - API 만들기 2

 

인프런 지식공유자 최태현 님의 자바 스프링부트 서버개발 올인원 강의 커리큘럼에 포함된 과제입니다. 

https://inf.run/Hywa

자바와 스프링 부트로 생애 최초 서버 만들기, 누구나 쉽게 개발부터 배포까지! [서버 개발 올인

 

 

문제 1

DB

create table fruit(
    id bigint auto_increment,
    name varchar(20),
    warehousingDate date,
    price bigint,
    is_sold boolean default false,
    primary key (id)
);

 

Controller

@RestController
@RequestMapping("/api/v1/fruit")
public class FruitController {
    private final JdbcTemplate jdbcTemplate;

    public FruitController(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    @PostMapping("")
    public void saveFruit(@RequestBody FruitCreateRequest request) {
        String sql = "insert into fruit(name, warehousingDate,price)values(?,?,?)";
        jdbcTemplate.update(sql,request.getName(),request.getWarehousingDate(),request.getPrice());

    }
}

 

DTO

public class FruitCreateRequest {
    private String name;
    private LocalDate warehousingDate;
    private long price;

    public String getName() {
        return name;
    }

    public LocalDate getWarehousingDate() {
        return warehousingDate;
    }

    public long getPrice() {
        return price;
    }
}

 

 

 

문제 2

 @PutMapping("")
  public void updateFruit(@RequestBody FruitUpdateRequest request){
    String sql = "SELECT * FROM fruit WHERE id = ?";
    boolean isFruitNotExist
        = jdbcTemplate.query(sql, (rs, rowNum) -> 0, request.getId()).isEmpty();

    if(isFruitNotExist){
      throw new IllegalArgumentException();
    }

    String updateSql = "UPDATE fruit SET is_sold = ? WHERE id = ?";
    jdbcTemplate.update(updateSql, true, request.getId());
  }

package com.group.libraryapp.dto.fruit.request;

public class FruitUpdateRequest {
  long id;

  public long getId() {
    return id;
  }
}

 

 

 

문제 3

Controller

 @GetMapping("/stat")
  public FruitPriceResponse getFruitSellPrice(@RequestParam String name) {
    String sql =  "SELECT "
        + "SUM(CASE WHEN is_sold = true THEN price ELSE 0 END) AS salesAmount, \n"
        + "SUM(CASE WHEN is_sold = false THEN price ELSE 0 END) AS notSalesAmount \n"
        + "FROM fruit \n"
        + "WHERE name = ?";


    return jdbcTemplate.queryForObject(sql, (rs, rowNum) -> {
      long salesAmount = rs.getLong("salesAmount");
      long notSalesAmount = rs.getLong("notSalesAmount");
      return new FruitPriceResponse(salesAmount, notSalesAmount);
    }, name);

  }

 

DTO

public class FruitPriceResponse {

  private final long salesAmount;
  private final long notSalesAmount;

  public FruitPriceResponse(long salesAmount, long notSalesAmount) {
    this.salesAmount = salesAmount;
    this.notSalesAmount = notSalesAmount;
  }

  public long getSalesAmount() {
    return salesAmount;
  }

  public long getNotSalesAmount() {
    return notSalesAmount;
  }

}