우리는 GET API와 POST API를 만드는 방법을 배웠습니다. 👍 추가적인 API 들을 만들어 보며 API 개발에 익숙해져 봅시다!

<aside> 💡 4일차 문제1, 문제2, 문제3은 이어지는 문제입니다!

</aside>

1. 문제

Untitled

1. 답

create table fruit (
    id                  bigint auto_increment,
    name                varchar(30),
    warehousingDate     date,
    price               bigint,
    is_sold             boolean default false,
    primary key (id)
);
public class Ex4FruitCreateRequest {

    private String name;
    private LocalDate warehousingDate;
    private long price;

    public Ex4FruitCreateRequest(String name, LocalDate warehousingDate, long price) {
        this.name = name;
        this.warehousingDate = warehousingDate;
        this.price = price;
    }

    public String getName() {
        return name;
    }

    public LocalDate getWarehousingDate() {
        return warehousingDate;
    }

    public long getPrice() {
        return price;
    }
}
@RestController
public class Ex4FruitController {

    private final JdbcTemplate jdbcTemplate;

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

    @PostMapping("/api/v1/fruit")
    public void saveFruit(@RequestBody Ex4FruitCreateRequest ex4FruitRequest) {
        String sql = "INSERT INTO fruit (name, warehousingDate, price) VALUES (?, ?, ?)";
        jdbcTemplate.update(sql, ex4FruitRequest.getName(), ex4FruitRequest.getWarehousingDate(), ex4FruitRequest.getPrice());
    }
}

Untitled

Untitled