제가 수강하고 있는 최태현님 강의 출처입니다!

https://inf.run/XKQg

오늘 과제 소감

이게 왜 돌아가..? 를 절실히 경험중인 오늘이다. 솔직히 그냥 뭐가 뭔지 아무것도 모르고 있어서.. 그냥 한번 해보자는 마음으로 강의가 뚫릴듯이 다시보고 아무것도 모르지만 비슷하게 따라해봤다. 이렇게 하는게 맞는건지.. 처음에 시도했을땐 제대로 전환이 안돼서 그냥 포기했었는데, 과제마감 한 시간 전에 조금만 더 해보고 싶다는 생각이 생겼다.
알고보니 실행이 안되었던게, FruitMemoryRepository랑 FruitMysqlRepository에 "implements FruitRepository" 이걸 빼먹어서 그랬더라.. 더 시도해보길 잘한거 같다ㅜㅜㅜㅜㅜ
-> 내가 모르는거 인터페이스,오버라이드,의존성..

문제1

FruitController.java

package com.group.libraryapp.controller.fourthAssignment;

import com.group.libraryapp.dto.fourth.request.SaveFruitRequest;
import com.group.libraryapp.dto.fourth.response.FruitFinalResponse;
import com.group.libraryapp.service.fruit.FruitService;
import org.springframework.web.bind.annotation.*;

@RestController
public class FruitController {

    //추가
    private final FruitService fruitService ;

    //추가
    public FruitController(FruitService fruitService){


        this.fruitService = fruitService;
    }




    @PostMapping("/api/v1/fruit")
    public void saveFruitInfo(@RequestBody SaveFruitRequest request) {
       fruitService.saveFruitInfo(request);


    }

    @PutMapping("/api/v1/fruit")
    public void updateFruit(@RequestBody SaveFruitRequest request){
       fruitService.updateFruit(request);
    }

    @GetMapping("/api/v1/fruit/stat")
    public FruitFinalResponse getFruits(@RequestParam String name) {
        return fruitService.getFruit(name);

    }


}

FruitService.java

package com.group.libraryapp.service.fruit;

import com.group.libraryapp.dto.fourth.request.SaveFruitRequest;
import com.group.libraryapp.dto.fourth.response.FruitFinalResponse;
import com.group.libraryapp.dto.fourth.response.FruitResponse;
import com.group.libraryapp.repository.fruit.FruitMysqlRepository;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class FruitService {

    private final FruitMysqlRepository fruitRepository;

    public FruitService(FruitMysqlRepository fruitRepository){
        this.fruitRepository = fruitRepository;

    }

    public void saveFruitInfo( SaveFruitRequest request){
        fruitRepository.saveFruit(request.getName(),request.getWarehousingDate(),request.getPrice());

    }

    public void updateFruit(SaveFruitRequest request){


        //query() 통해 나오는게 리스트인데, 뭐라도 있으면 0을 넣어줄거고 조회가 안되면 비어있을거임.
        boolean isFruitIdNotExist = fruitRepository.isFruitIdNotExist(request.getId());

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

        fruitRepository.updateFruitSellStatus(request.getId());



    }

    public FruitFinalResponse getFruit(String name){

        //가져온 데이터 결과 rs 를 우리가 원하는 userResponse형태로 바꿔줌.이거는 객체 참조값인데, 전체에서 반환하는건 결국 query로 감싸서 나오므로 리스트 타입.
        boolean isFruitNameNotExist = fruitRepository.isFruitNameNotExist(name);

        if(isFruitNameNotExist){
            throw new IllegalArgumentException();
        }else{

            List<FruitResponse> fruitList = fruitRepository.getFruit(name);
            long salesTotal=0;
            long notSalesTotal=0;
            for(int i=0;i<fruitList.size();i++){
                if(fruitList.get(i).isSell()){
                    salesTotal = salesTotal + fruitList.get(i).getSalesAmount();

                }else{
                    notSalesTotal = notSalesTotal + fruitList.get(i).getSalesAmount();

                }
            }

            return new FruitFinalResponse(salesTotal,notSalesTotal);
        }

    }
}

FruitMysqlRepository.java

package com.group.libraryapp.repository.fruit;

import com.group.libraryapp.dto.fourth.response.FruitResponse;
import com.group.libraryapp.service.fruit.FruitService;
import org.springframework.context.annotation.Primary;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import java.time.LocalDate;
import java.util.List;

@Repository
public class FruitMysqlRepository{

    private final JdbcTemplate jdbcTemplate;
    public FruitMysqlRepository(JdbcTemplate jdbcTemplate){

        this.jdbcTemplate = jdbcTemplate;
    }

    public void saveFruit( String fruitName, LocalDate warehousingDate, long price){

        String sql = "INSERT INTO fruit(name,warehousingDate,price) VALUES(?,?,?)";
        jdbcTemplate.update(sql,fruitName,warehousingDate,price);
    }

    public boolean isFruitIdNotExist(long id){
        String readSql ="SELECT * from fruit WHERE id = ?";
        return jdbcTemplate.query(readSql, (rs, rowNum) -> 0,id).isEmpty();
    }

    public void updateFruitSellStatus(long id){

        String sql = "UPDATE fruit SET isSell = ? WHERE id = ?";
        jdbcTemplate.update(sql,true,id);


    }

    public boolean isFruitNameNotExist(String name){
        String sql = "SELECT * FROM fruit WHERE name = ?";

        return jdbcTemplate.query(sql, (rs, rowNum) -> 0,name).isEmpty();

    }

    public List<FruitResponse> getFruit(String name){
        String isSellsql = "SELECT * FROM fruit WHERE name = ?";
        return jdbcTemplate.query(isSellsql,(rs, rowNum) -> {
            long price = rs.getLong("price");
            boolean isSell = rs.getBoolean("isSell");
            return new FruitResponse(price,isSell);
        },name);
    }
}

문제2

FruitController.java

package com.group.libraryapp.controller.fourthAssignment;

import com.group.libraryapp.dto.fourth.request.SaveFruitRequest;
import com.group.libraryapp.dto.fourth.response.FruitFinalResponse;
import com.group.libraryapp.service.fruit.FruitService;
import org.springframework.web.bind.annotation.*;

@RestController
public class FruitController {

    //추가
    private final FruitService fruitService ;

    //추가
    public FruitController(FruitService fruitService){


        this.fruitService = fruitService;
    }




    @PostMapping("/api/v1/fruit")
    public void saveFruitInfo(@RequestBody SaveFruitRequest request) {
       fruitService.saveFruitInfo(request);


    }

    @PutMapping("/api/v1/fruit")
    public void updateFruit(@RequestBody SaveFruitRequest request){
       fruitService.updateFruit(request);
    }

    @GetMapping("/api/v1/fruit/stat")
    public FruitFinalResponse getFruits(@RequestParam String name) {
        return fruitService.getFruit(name);

    }


}

FruitService.java

package com.group.libraryapp.service.fruit;

import com.group.libraryapp.dto.fourth.request.SaveFruitRequest;
import com.group.libraryapp.dto.fourth.response.FruitFinalResponse;
import com.group.libraryapp.dto.fourth.response.FruitResponse;
import com.group.libraryapp.repository.fruit.FruitRepository;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class FruitService {

    private final FruitRepository fruitRepository;

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

    }

    public void saveFruitInfo( SaveFruitRequest request){
        fruitRepository.saveFruit(request.getName(),request.getWarehousingDate(),request.getPrice());

    }

    public void updateFruit(SaveFruitRequest request){


        //query() 통해 나오는게 리스트인데, 뭐라도 있으면 0을 넣어줄거고 조회가 안되면 비어있을거임.
        boolean isFruitIdNotExist = fruitRepository.isFruitIdNotExist(request.getId());

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

        fruitRepository.updateFruitSellStatus(request.getId());



    }

    public FruitFinalResponse getFruit(String name){

        //가져온 데이터 결과 rs 를 우리가 원하는 userResponse형태로 바꿔줌.이거는 객체 참조값인데, 전체에서 반환하는건 결국 query로 감싸서 나오므로 리스트 타입.
        boolean isFruitNameNotExist = fruitRepository.isFruitNameNotExist(name);

        if(isFruitNameNotExist){
            throw new IllegalArgumentException();
        }else{

            List<FruitResponse> fruitList = fruitRepository.getFruit(name);
            long salesTotal=0;
            long notSalesTotal=0;
            for(int i=0;i<fruitList.size();i++){
                if(fruitList.get(i).isSell()){
                    salesTotal = salesTotal + fruitList.get(i).getSalesAmount();

                }else{
                    notSalesTotal = notSalesTotal + fruitList.get(i).getSalesAmount();

                }
            }

            return new FruitFinalResponse(salesTotal,notSalesTotal);
        }

    }
}

FruitRepository.java

package com.group.libraryapp.repository.fruit;

import com.group.libraryapp.dto.fourth.response.FruitResponse;

import java.time.LocalDate;
import java.util.List;

public interface FruitRepository
{

    void saveFruit(String fruitName, LocalDate warehousingDate, long price);
    boolean isFruitIdNotExist(long id);
    void updateFruitSellStatus(long id);
    boolean isFruitNameNotExist(String name);
    List<FruitResponse> getFruit(String name);

}

FruitMemoryRepository.java

package com.group.libraryapp.repository.fruit;

import com.group.libraryapp.dto.fourth.response.FruitResponse;
import org.springframework.stereotype.Repository;

import java.time.LocalDate;
import java.util.ArrayList;
import java.util.List;

@Repository
public class FruitMemoryRepository implements FruitRepository {

    List<Fruit> fruits  = new ArrayList<>();
   long id = 0;

    public void saveFruit(String fruitName, LocalDate warehousingDate, long price){
        id++;
        Fruit fruit = new Fruit(fruitName,warehousingDate,price,id,false);
        fruits.add(fruit);

    }

    public boolean isFruitIdNotExist(long id){
        boolean result = false;
        for (Fruit fruit : fruits) {
            if(fruit.getId()==id){
                result = false;
            }else{
                result= true;
            }



        }


        return result;
    }

    public void updateFruitSellStatus(long id){


        for (Fruit fruit : fruits) {
            if(fruit.getId()==id){
                fruit.isSell = true;

            }

        }
    }

    public boolean isFruitNameNotExist(String name){
        boolean result = false;
        for (Fruit fruit : fruits) {
            if(fruit.getFruitName().equals(name)){
                result = false;
            }else{
                result= true;
            }



        }


        return result;


    }

    public List<FruitResponse> getFruit(String name){
        List<FruitResponse> test = new ArrayList<>();
        for (Fruit fruit : fruits) {
           if(fruit.getFruitName().equals(name)) {
               FruitResponse fruitResponse = new FruitResponse(fruit.getPrice(),fruit.isSell());
               test.add(fruitResponse);
           }
        }
        return test;
    }
}

FruitMysqlRepository.java

package com.group.libraryapp.repository.fruit;

import com.group.libraryapp.dto.fourth.response.FruitResponse;
import org.springframework.context.annotation.Primary;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import java.time.LocalDate;
import java.util.List;

@Repository
@Primary
public class FruitMysqlRepository implements FruitRepository{

    private final JdbcTemplate jdbcTemplate;
    public FruitMysqlRepository(JdbcTemplate jdbcTemplate){

        this.jdbcTemplate = jdbcTemplate;
    }

    public void saveFruit( String fruitName, LocalDate warehousingDate, long price){

        String sql = "INSERT INTO fruit(name,warehousingDate,price) VALUES(?,?,?)";
        jdbcTemplate.update(sql,fruitName,warehousingDate,price);
    }

    public boolean isFruitIdNotExist(long id){
        String readSql ="SELECT * from fruit WHERE id = ?";
        return jdbcTemplate.query(readSql, (rs, rowNum) -> 0,id).isEmpty();
    }

    public void updateFruitSellStatus(long id){

        String sql = "UPDATE fruit SET isSell = ? WHERE id = ?";
        jdbcTemplate.update(sql,true,id);


    }

    public boolean isFruitNameNotExist(String name){
        String sql = "SELECT * FROM fruit WHERE name = ?";

        return jdbcTemplate.query(sql, (rs, rowNum) -> 0,name).isEmpty();

    }

    public List<FruitResponse> getFruit(String name){
        String isSellsql = "SELECT * FROM fruit WHERE name = ?";
        return jdbcTemplate.query(isSellsql,(rs, rowNum) -> {
            long price = rs.getLong("price");
            boolean isSell = rs.getBoolean("isSell");
            return new FruitResponse(price,isSell);
        },name);
    }
}

Fruit.java

package com.group.libraryapp.repository.fruit;

import java.time.LocalDate;

public class Fruit {
    String fruitName;
    LocalDate warehousingDate;
    long price;
    long id;
    boolean isSell;

    public Fruit(String fruitName, LocalDate warehousingDate, long price,long id,boolean isSell) {
        this.fruitName = fruitName;
        this.warehousingDate = warehousingDate;
        this.price = price;
        this.id = id;
        this.isSell = isSell;
    }

    public String getFruitName() {
        return fruitName;
    }

    public LocalDate getWarehousingDate() {
        return warehousingDate;
    }

    public long getPrice() {
        return price;
    }

    public long getId() {
        return id;
    }

    public boolean isSell() {
        return isSell;
    }


}

실행 결과

1) @primary 어노테이션을 FruitMemoryRepository에 붙였을 때.

-> 두리안, 2023-01-01 , 10000 데이터를 저장해보겠다.

-> 200, ok 가 떴다.

-> 두리안이 제대로 들어갔는지, 데이터를 한번 가져와보겠다.

-> 방금 입력한 두리안 데이터가 ArrayList에 잘 들어갔다.

-> 참고로, mysql db에는 두리안은 없다. 고로,, 난 성공한 것이다..!

이번에는 팔린 과일을 표시해보자. 테스트를 위해 ArrayList에 파파야,1500원을 넣어보겠다. 앞에 두개의 과일을 넣어봤지만, 나는 과일 종류별로 arraylist를 만들게 해놔서 id =1이다.

파파야 15000원이 salesAmount에 집계됐다.

20000원짜리 파파야를 더 넣어봤다. 물론 수정을 안했으니, 이 20000원은 notSales에 집계되야 한다.

내 예상대로의 결과가 나왔다.

2) @primary 어노테이션을 FruitMysqlRepository에 붙였을 때.

-> 이번에는 Mysql에 샤인머스켓, 2023-01-21 , 20000 데이터를 저장해보겠다. 200 ok가 떴으니, mysql 을 확인해보자

-> 이번엔 mysql에 데이터가 저장됐다..

-> 샤인머스켓이 팔렸다고 바꿔보자. id=8이다.

-> 아까랑 다르게 isSell 이 true, 즉 1로 변경됐다(씨-익)