상품조회하기

상품 화면 리스트 보여주기
1. DTO 작성 -> 
2. 쿼리문 작성 -> 
3. mapper/Goods.Mapper.xml 생성 -> 
4. GoodsMapper.java 인터페이스 생성(@Mapper -> 
5. GoodsService.java생성(@Service, @Transactional) -> 
6. GoodsController 생성(@Controller) -> 
7. GoodsMapper.xml(resultMap 작성 - <type="DTO명" id="">
      (result --PK값을 id column으로-- : column="db명", property="dto명"))
8. GoodsMapper.java 추상메서드 생성
9. select문 id에 GoodsMapper.java의 추상메서드 명 입력 후 쿼리 입력
10. GoodsService.java DI 의존성 주입 
11. GoodsController DI 의존성 주입, @GetMapping return("html 화면" 반환)
11-1. GoodsController에 model.addAttribute 메서드 실행
12. return = " 파일경로에 맞는 (html(goodsList.html)" 화면 생성 후 - goodsList 표생성

 

package ksmart42.mybatis.controller;

import java.util.List;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;

import ksmart42.mybatis.dto.Goods;
import ksmart42.mybatis.service.GoodsService;

@Controller
@RequestMapping("/goods")
public class GoodsController {
	
	private static final Logger log = LoggerFactory.getLogger(GoodsController.class);

	private GoodsService goodsService;
	
	public GoodsController(GoodsService goodsService) {
		this.goodsService=goodsService;
	}
	
	@GetMapping("/goodsList")
	public String getGoodsList(Model model) {
		List<Goods> goodsList = goodsService.getGoodsList();
		log.info("상품목록조회 goodsList:{}",goodsList);
		return "redirect:/";
		//return "merchandise/goodsList";
	}
}