[Spring Data JPA] Exercise 🔥

📌 기본 셋팅

👉 application.yml

# server port config
server:
  port: 8001
  
# DB config
spring:
  datasource:
    driver-class-name: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@localhost:1521:xe
    username: C##GREEDY
    password: GREEDY
    
# JPA config
  jpa:
    generate-ddl: false       # create table을 할 때만 true(기본값)
    show-sql: true            # JPA가 수행하는 SQL구문을 콘솔에서 확인 가능
    database: oracle
    properties:
      hibernate:
        '[format_sql]': true  # SQL을 개행하여 보기좋게 출력

👉 pom.xml

<!-- 영속성 객체 <=> 비영속성 객체로 변환할 수 있는 ModelMapper 라이브러리 -->
		<!-- https://mvnrepository.com/artifact/org.modelmapper/modelmapper -->
		<dependency>
		    <groupId>org.modelmapper</groupId>
		    <artifactId>modelmapper</artifactId>
		    <version>3.1.1</version>
		</dependency>

👉 BeanConfiguration

@Configuration
public class BeanConfiguration {

	/* ModelMapper라이브러리 추가 후, ModelMapper객체를 사용하기 위해 Bean 등록 */
	@Bean
	public ModelMapper modelMapper() {
		
		return new ModelMapper();
	}
}

👉 PagingButtonInfo

public class PagingButtonInfo {
	
	private int currentPage;
	private int startPage;
	private int endPage;
    
    /* 기본 셋팅 */
    
}

👉 Pagenation

public class Pagenation {
	
	public static PagingButtonInfo getPagingButtonInfo(Page page) {
		
		int currentPage = page.getNumber() + 1;	 /* 인덱스 기준이므로 +1 */
		int defaultButtonCount = 10;
		int startPage;
		int endPage;
		
		startPage = (int) (Math.ceil((double) currentPage / defaultButtonCount) - 1) * defaultButtonCount + 1;
		endPage = startPage + defaultButtonCount - 1;
		
		/* 내가 가진 총 페이지 수가 4일 경우, endPage(10)보다 작으므로 endPage를 4로 변경하는 로직 */
		if(page.getTotalPages() < endPage)
			endPage = page.getTotalPages();
		
		if(page.getTotalPages() == 0 && endPage == 0)
			endPage = startPage;
		
		return new PagingButtonInfo(currentPage, startPage, endPage);
	}

}

---

👀 Template (views)

👉 main.html

	<h1 align="center">🌱 떡잎 백화점 🌱</h1>
	
	<div align="center">
	<button onclick="location.href='/product/todays'">오늘의 상품</button>
	<button onclick="location.href='/product/list'">전체 상품</button>
	<button onclick="location.href='/product/regist'">상품 등록</button>
	<button onclick="location.href='/product/modify'">상품 수정</button>
	<button onclick="location.href='/product/remove'">상품 삭제</button>
	</div>

👉 todays.html

	<h1 align="center">👏 오늘의 상품 👏</h1>

    <table align="center" border="1">
		<tr>
			<th>상품번호</th>
			<th>상품명</th>
			<th>상품 판매가</th>
			<th>등록일</th>
			<th>제조사</th>
			<th>판매여부</th>
		</tr>
		<tr th:each="product : ${ productList }">
			<td th:text="${ product.productNo }"></td>
			<td th:text="${ product.productName }"></td>
			<td th:text="${ #numbers.formatInteger(product.productPrice, 3, 'COMMA') } + 원"></td>
			<td th:text="${ product.date }"></td>
			<td th:text="${ product.supplierName }"></td>
			<td th:text="${ product.orderableStatus }"></td>
		</tr>
	</table>

👉 list.html

	<h1 align="center">🐤 All Product 🐤</h1>
	
	<div class="flex">
		<div align="left" class="searchBox">
		<form action="/product/search" method="get">
		    <input type="text" placeholder="상품명 입력 :)" name="keyword">
		    <input type="submit" value="검색">
	    </form>
	    </div>
	    
	    <div align="right" class="dateBox">
		<form action="/product/after" method="get">
		    <input type="date" name="dateAfter">
		    <input type="submit" value="이후 상품 조회">
	    </form>
		</div>
    </div>
    
    <table align="center" border="1">
		<tr>
			<th>상품번호</th>
			<th>상품명</th>
			<th>상품 판매가</th>
			<th>등록일</th>
			<th>제조사</th>
			<th>판매여부</th>
		</tr>
		<tr th:each="product : ${ productList }">
			<td th:text="${ product.productNo }"></td>
			<td th:text="${ product.productName }"></td>
			<td th:text="${ #numbers.formatInteger(product.productPrice, 3, 'COMMA') } + 원"></td>
			<td th:text="${ product.date }"></td>
			<td th:text="${ product.supplierName }"></td>
			<td th:text="${ product.orderableStatus }"></td>
		</tr>
	</table>
	
	<div align="center" id="paging" >
		
		<!-- 맨 앞으로 이동 -->
		<button th:onclick="'location.href=\'/product/list?page=' + @{${paging.startPage}} + '\''">◀◀</button>
		
		<!-- 이전 페이지로 이동 -->
		<button th:onclick="'location.href=\'/product/list?page=' + @{${paging.currentPage - 1}} + '\''"
				th:disabled="${ productList.first }">◀</button>
		
		<!-- 숫자 버튼 -->
		<th:block th:each="page : ${ #numbers.sequence(paging.startPage, paging.endPage)}">
			<button th:onclick="'location.href=\'/product/list?page=' + @{${page}} + '\''"
					th:text="${ page }"
					th:disabled="${ paging.currentPage eq page }">
			</button>
		</th:block>
		
		<!-- 다음 페이지로 이동 -->
		<button th:onclick="'location.href=\'/product/list?page=' + @{${paging.currentPage + 1}} + '\''"
				th:disabled="${ productList.last }">▶</button>
		
		<!-- 맨 끝으로 이동 -->
		<button th:onclick="'location.href=\'/product/list?page=' + @{${paging.endPage}} + '\''">▶▶</button>
	</div>
	
	
	<script>
	/* 신규 상품 등록 or 상품 삭제 후, 해당 페이지로 redirect 되기 전 alert 띄우기 */
	if(window.location.hash === '#success-regist' || window.location.hash === '#success-remove'){
	    alert('[[${message}]]'); // message 변수는 컨트롤러에서 전달한 Flash Attribute
	}
	</script>

👉 search.html

	<h1 align="center" th:text="'🐤 Products searched with ' + ${ keyword } + ' 🐤'"></h1>
	
	<div class="flex">
		<div align="left" class="searchBox">
		<form action="/product/search" method="get">
		    <input type="text" placeholder="상품명 입력 :)" name="keyword">
		    <input type="submit" value="검색">
	    </form>
	    </div>
	    
	    <div align="right" class="dateBox">
		<form action="/product/after" method="get">
		    <input type="date" name="dateAfter">
		    <input type="submit" value="이후 상품 조회">
	    </form>
		</div>
    </div>
	
	<table align="center" border="1">
		<tr>
			<th>상품번호</th>
			<th>상품명</th>
			<th>상품 판매가</th>
			<th>등록일</th>
			<th>제조사</th>
			<th>판매여부</th>
		</tr>
		<tr th:each="product : ${ productList }">
			<td th:text="${ product.productNo }"></td>
			<td th:text="${ product.productName }"></td>
			<td th:text="${ #numbers.formatInteger(product.productPrice, 3, 'COMMA') } + 원"></td>
			<td th:text="${ product.date }"></td>
			<td th:text="${ product.supplierName }"></td>
			<td th:text="${ product.orderableStatus }"></td>
		</tr>
	</table>
	
	<div align="center" id="paging" >
		
		<!-- 맨 앞으로 이동 -->
		<button th:onclick="'location.href=\'/product/search?keyword=' + @{${ keyword }} + '&page=' + @{${paging.startPage}} + '\''">◀◀</button>
		
		<!-- 이전 페이지로 이동 -->
		<button th:onclick="'location.href=\'/product/search?keyword=' + @{${ keyword }} + '&page=' + @{${paging.currentPage - 1}} + '\''"
				th:disabled="${ productList.first }">◀</button>
		
		<!-- 숫자 버튼 -->
		<th:block th:each="page : ${ #numbers.sequence(paging.startPage, paging.endPage)}">
			<button th:onclick="'location.href=\'/product/search?keyword=' + @{${ keyword }} + '&page=' + @{${page}} + '\''"
					th:text="${ page }"
					th:disabled="${ paging.currentPage eq page }">
			</button>
		</th:block>
		
		<!-- 다음 페이지로 이동 -->
		<button th:onclick="'location.href=\'/product/search?keyword=' + @{${ keyword }} + '&page=' + @{${paging.currentPage + 1}} + '\''"
				th:disabled="${ productList.last }">▶</button>
		
		<!-- 맨 끝으로 이동 -->
		<button th:onclick="'location.href=\'/product/search?keyword=' + @{${ keyword }} + '&page=' + @{${paging.endPage}} + '\''">▶▶</button>
	</div>

👉 after.html

	<h1 align="center">🐤 <span th:text="${ dateAfter }"></span> 이후 등록된 상품들 🐤</h1>
	
	<div class="flex">
		<div align="left" class="searchBox">
		<form action="/product/search" method="get">
		    <input type="text" placeholder="상품명 입력 :)" name="keyword">
		    <input type="submit" value="검색">
	    </form>
	    </div>
	    
	    <div align="right" class="dateBox">
		<form action="/product/after" method="get">
		    <input type="date" name="dateAfter">
		    <input type="submit" value="이후 상품 조회">
	    </form>
		</div>
    </div>
    
    <table align="center" border="1">
		<tr>
			<th>상품번호</th>
			<th>상품명</th>
			<th>상품 판매가</th>
			<th>등록일</th>
			<th>제조사</th>
			<th>판매여부</th>
		</tr>
		<tr th:each="product : ${ productList }">
			<td th:text="${ product.productNo }"></td>
			<td th:text="${ product.productName }"></td>
			<td th:text="${ #numbers.formatInteger(product.productPrice, 3, 'COMMA') } + 원"></td>
			<td th:text="${ product.date }"></td>
			<td th:text="${ product.supplierName }"></td>
			<td th:text="${ product.orderableStatus }"></td>
		</tr>
	</table>
	
	<div align="center" id="paging" >
		
		<!-- 맨 앞으로 이동 -->
		<button th:onclick="'location.href=\'/product/after?dateAfter=' + @{${ dateAfter }} + '&page=' + @{${paging.startPage}} + '\''">◀◀</button>
		
		<!-- 이전 페이지로 이동 -->
		<button th:onclick="'location.href=\'/product/after?dateAfter=' + @{${ dateAfter }} + '&page=' + @{${paging.currentPage - 1}} + '\''"
				th:disabled="${ productList.first }">◀</button>
		
		<!-- 숫자 버튼 -->
		<th:block th:each="page : ${ #numbers.sequence(paging.startPage, paging.endPage)}">
			<button th:onclick="'location.href=\'/product/after?dateAfter=' + @{${ dateAfter }} + '&page=' + @{${page}} + '\''"
					th:text="${ page }"
					th:disabled="${ paging.currentPage eq page }">
			</button>
		</th:block>
		
		<!-- 다음 페이지로 이동 -->
		<button th:onclick="'location.href=\'/product/after?dateAfter=' + @{${ dateAfter }} + '&page=' + @{${paging.currentPage + 1}} + '\''"
				th:disabled="${ productList.last }">▶</button>
		
		<!-- 맨 끝으로 이동 -->
		<button th:onclick="'location.href=\'/product/after?dateAfter=' + @{${ dateAfter }} + '&page=' + @{${paging.endPage}} + '\''">▶▶</button>
	</div>

👉 regist.html

	<h3 align="center">신규 상품 등록</h3>
	
	<form align="center" action="/product/regist" method="post">
		<label>상품명 : </label><input type="text" name="productName"><br>
		<label>상품 원가 : </label><input type="number" name="productPrice"><br>
		<label>제조사 : </label>
		<select name="supplierName">
			<option value="SAMSUNG">삼성</option>
			<option value="LG">LG</option>
			<option value="APPLE">Apple</option>
			<option value="PHILIPS">Philips</option>
			<option value="DYSON">Dyson</option>
			<option value="DAEWOO">대우</option>
			<option value="HYUNDAI">현대</option>
		</select><br>
		<label>판매 상태 : </label>
		<select name="orderableStatus">
			<option value="Y">판매가능</option>
			<option value="N">판매불가</option>
		</select><br>
		<input type="submit" value="등록">
	</form>

👉 modify.html

	<h3 align="center">상품 수정</h3>
	
	<form align="center" action="/product/modify" method="post">
		<label>수정할 상품 선택 : </label>
		<select name="productNo" id="productNo"></select><br>
		<label>상품명 : </label>
		<input type="text" name="productName"><br>
		<label>상품 원가 : </label>
		<input type="number" name="productPrice"><br>
		<label>제조사 : </label>
		<select name="supplierName">
			<option value="SAMSUNG">삼성</option>
			<option value="LG">LG</option>
			<option value="APPLE">Apple</option>
			<option value="PHILIPS">Philips</option>
			<option value="DYSON">Dyson</option>
			<option value="DAEWOO">대우</option>
			<option value="HYUNDAI">현대</option>
		</select><br>
		<label>판매 상태 : </label>
		<select name="orderableStatus">
			<option value="Y">판매가능</option>
			<option value="N">판매불가</option>
		</select><br>
		<input type="submit" value="수정">
	</form>
	
	<script>
	/* 비동기 통신(ajax)을 통해 모든 상품 리스트 조회 */
	$(function(){
		$.ajax({
			url : '/product/product',
			success : function(data) {
				console.log(data);
				
				let html = '';
				/* data라는 조회된 배열을 반복하여 합산시키기 */
				for(let index in data) {
					html += `<option value='${data[index].productNo}'>[${data[index].productNo}] ${data[index].productName}</option>`;
					// 조회된 상품번호와 상품명을 화면에 노출시키고 그 상품이 선택(<option>)되면 value는 해당 상품의 코드
				}
				/* 그 값을 <select>에 insert하여 화면에 노출되도록 함 */
				document.querySelector("#productNo").insertAdjacentHTML('beforeend', html);
				
			},
			error : function(xhr) {
				console.log(xhr);
			}
		});
	})
	</script>

👉 modified.html

	<h1 align="center">🐤 수정된 상품 확인 🐤</h1>

    <table align="center" border="1">
		<tr>
			<th>상품번호</th>
			<th>상품명</th>
			<th>상품 판매가</th>
			<th>등록일</th>
			<th>제조사</th>
			<th>판매여부</th>
		</tr>
		<tr>
			<td th:text="${ product.productNo }"></td>
			<td th:text="${ product.productName }"></td>
			<td th:text="${ #numbers.formatInteger(product.productPrice, 3, 'COMMA') } + 원"></td>
			<td th:text="${ product.date }"></td>
			<td th:text="${ product.supplierName }"></td>
			<td th:text="${ product.orderableStatus }"></td>
		</tr>
	</table>


	<script>
	/* 상품 수정 후, 해당 페이지로 redirect 되기 전 alert 띄우기 */
	if(window.location.hash === '#success-modify'){
	    alert('[[${message}]]'); // message 변수는 컨트롤러에서 전달한 Flash Attribute
	}
	</script>

👉 remove.html

	<h3 align="center">상품 삭제</h3>
	
	<form align="center" action="/product/remove" method="post">
		<label>삭제할 상품 선택 : </label>
		<select name="productNo" id="productNo"></select><br>
		<input type="submit" value="삭제">
	</form>

	<script>
		/* 비동기 통신(ajax)을 통해 모든 상품 리스트 조회 */
		$(function(){
			$.ajax({
				url : '/product/product',
				success : function(data) {
					console.log(data);
					
					let html = '';
					/* data라는 조회된 배열을 반복하여 합산시키기 */
					for(let index in data) {
						html += `<option value='${data[index].productNo}'>${data[index].productName}</option>`;
						// 조회된 상품의 이름을 화면에 노출시키고 그 상품이 선택(<option>)되면 value는 해당 상품의 코드
					}
					/* 그 값을 <select>에 insert하여 화면에 노출되도록 함 */
					document.querySelector("#productNo").insertAdjacentHTML('beforeend', html);
					
				},
				error : function(xhr) {
					console.log(xhr);
				}
			});
		})
	</script>

---

👀 Entity

👉 Product

@Entity(name="product")
@Table(name="TBL_PRODUCT")
@SequenceGenerator(
		name="PRODUCT_SEQUENCE_GENERATOR", 	
		sequenceName="SEQ_PRODUCT_NO", 		
		initialValue=1,						
		allocationSize=1				
		)
public class Product {
	
	@Id
	@Column(name="PRODUCT_NO")
	@GeneratedValue(strategy = GenerationType.SEQUENCE, generator="PRODUCT_SEQUENCE_GENERATOR")
	private int productNo;
	
	@Column(name="PRODUCT_NAME", nullable=false)
	private String productName;
	
	@Column(name="PRODUCT_PRICE", nullable=false)
	private int productPrice;
	
	@Column(name="RELEASE_DATE", nullable=false)
	private Date date;
	
	/* enum type을 활용한 필드 */
	@Column(name="SUPPLIER_NAME", nullable=false)
	@Enumerated(EnumType.STRING) // int가 아닌 String 타입으로 DB에 저장할 것
	private SupplierType supplierName;
	
	@Column(name="ORDERABLE_STATUS", nullable=false)
	private String orderableStatus;
    
	/* 기본 셋팅 */    
    
}

👉 SupplierType

public enum SupplierType {

	SAMSUNG, LG, APPLE, PHILIPS, DYSON, DAEWOO, HYUNDAI
}

---

👀 DTO

👉 ProductDTO

public class ProductDTO {
	
	private int productNo;
	private String productName;
	private int productPrice;
	private Date date;
	private SupplierType supplierName;
	private String orderableStatus;
    
    /* 기본 셋팅 */
    
}

---

👀 Controller

👉 MainController

@Controller
public class MainController {

	@GetMapping(value = {"/", "/main"})
	public String main() {
		
		return "main/main";
	}
	
}

👉 ProductController

@Slf4j
@Controller
@RequestMapping("/product")
public class ProductController {

	private final ProductService productService;
	
	public ProductController (ProductService productService) {
		this.productService = productService;
	}
	
	/* 오늘의 상품 */
	@GetMapping("/todays")
	public String todaysPage(Model model) {
		
		List<ProductDTO> productList = productService.findProductList();
		
		Collections.shuffle(productList);
		List<ProductDTO> todaysProductlist = productList.subList(0, 3);
		log.info("todaysProductlist : {}", todaysProductlist);
		
		model.addAttribute("productList", todaysProductlist);
		
		return null;
	}
	
	/* 전체 상품 */
	@GetMapping("/list")
	public String listPage(@PageableDefault Pageable pageable, Model model) {
		
		/* 페이징 처리 */
		Page<ProductDTO> productList = productService.findProductList(pageable);
		PagingButtonInfo paging = Pagenation.getPagingButtonInfo(productList);
		
		model.addAttribute("paging", paging);
		model.addAttribute("productList", productList);
		
		return "product/list";
	}
	
	/* 상품 검색 */
	@GetMapping("/search")
	public String searchProduct(@PageableDefault Pageable pageable, @RequestParam(name="keyword") String keyword, Model model) {
		
		log.info(keyword);
		
		Page<ProductDTO> productList = productService.searchProductList(pageable, keyword);
		PagingButtonInfo paging = Pagenation.getPagingButtonInfo(productList);
		
		model.addAttribute("keyword", keyword);
		model.addAttribute("paging", paging);
		model.addAttribute("productList", productList);
		
		return "product/search";
	}
	
	/* 등록일이 입력된 날짜 이후인 상품 조회 */
	@GetMapping("/after")
	public String searchDateAfterProduct(@PageableDefault Pageable pageable, @RequestParam(name="dateAfter") Date dateAfter, Model model) {
		
		Page<ProductDTO> productList = productService.searchDateAfterProductList(pageable, dateAfter);
		PagingButtonInfo paging = Pagenation.getPagingButtonInfo(productList);

		model.addAttribute("dateAfter", dateAfter);
		model.addAttribute("paging", paging);
		model.addAttribute("productList", productList);
		
		return "product/after";
	}
	
	/* 상품 등록 */
	@GetMapping("/regist")
	public void registPage() {}
	
	@PostMapping("/regist")
	public String registNewProduct(ProductDTO newProduct, RedirectAttributes rttr) {
		
		productService.saveNewProduct(newProduct);
		
		rttr.addFlashAttribute("message", "상품 등록 성공! 등록된 상품을 확인해보세요 🤩");
		
		return "redirect:/product/list#success-regist";
	}
	
	/* 상품 수정 */
	@GetMapping("/modify")
	public void modifyPage() {}
	
	/* 현재 상품 리스트 조회(ajax) */
	@GetMapping(value="product", produces="application/json; charset=UTF-8")
	@ResponseBody
	public List<ProductDTO> findProductList() {
		
		return productService.findProductList();
	}
	
	@PostMapping("/modify")
	public String modifyProduct(ProductDTO product, RedirectAttributes rttr) {
		
		productService.modifyProduct(product);
		
		rttr.addFlashAttribute("message", "상품 수정 성공! 수정된 상품을 확인하세요 😍");
		
		/* 수정된 하나의 상품 페이지로 이동 */
		return "redirect:/product/" + product.getProductNo() + "#success-modify";
		
	}
	
	/* 수정된 하나의 상품을 조회 */
	@GetMapping("/{productNo}")
	public String modifiedPage(@PathVariable int productNo, Model model) {
		
		ProductDTO product = productService.findProductByCode(productNo);
		
		model.addAttribute("product", product);
		
		return "/product/modified";
	}
	
	/* 상품 삭제 */
	@GetMapping("/remove")
	public void removePage() {}
	
	@PostMapping("/remove")
	public String removeProduct(ProductDTO product, RedirectAttributes rttr) {
		
		productService.deleteProduct(product);
		
		rttr.addFlashAttribute("message", "상품 삭제 성공! 👀");
		
		return "redirect:/product/list#success-remove";
	}
	
}

---

👀 Service

👉 ProductService

@Slf4j
@Service
public class ProductService {

	private final ProductRepository productRepository;
	private final ModelMapper modelMapper;
	
	public ProductService(ProductRepository productRepository, ModelMapper modelMapper) {
		this.productRepository = productRepository;
		this.modelMapper = modelMapper;
	}
	
	/* 전체 상품 */
	public List<ProductDTO> findProductList() {
		
		List<Product> productList = productRepository.findAll(Sort.by("productNo"));
		
		return productList.stream().map(menu -> modelMapper.map(menu, ProductDTO.class)).collect(Collectors.toList());
	}
	
	/* 전체 상품 (Paging ver) */
	public Page<ProductDTO> findProductList(Pageable pageable) {
		
		pageable = PageRequest.of(pageable.getPageNumber() <= 0 ? 0 : pageable.getPageNumber() -1, 
				   pageable.getPageSize(),										
				   Sort.by("productNo").descending());
		
		Page<Product> productList = productRepository.findAll(pageable);
		
		return productList.map(product -> modelMapper.map(product, ProductDTO.class));
	}
	
	
	/* 상품 검색 */
	public Page<ProductDTO> searchProductList(Pageable pageable, String keyword) {
		
		pageable = PageRequest.of(pageable.getPageNumber() <= 0 ? 0 : pageable.getPageNumber() -1, 
				   pageable.getPageSize(),										
				   Sort.by("productNo").descending());
		
		Page<Product> productList = productRepository.findProductByContaining(pageable, keyword);
		log.info("productList : {}", productList);
		
		return productList.map(menu -> modelMapper.map(menu, ProductDTO.class));
	}
	
	/* 등록일이 입력된 날짜 이후인 상품 조회 */
	public Page<ProductDTO> searchDateAfterProductList(Pageable pageable, Date dateAfter) {
		
		pageable = PageRequest.of(pageable.getPageNumber() <= 0 ? 0 : pageable.getPageNumber() -1, 
				   pageable.getPageSize(),										
				   Sort.by("date").descending());
		
		Page<Product> productList = productRepository.findByDateAfter(dateAfter, pageable);
		log.info("productList : {}", productList);
		
		return productList.map(menu -> modelMapper.map(menu, ProductDTO.class));
	}
	
	
	/* 상품 등록 */
	@Transactional
	public void saveNewProduct(ProductDTO newProduct) {
		
		/* 등록일 가공 */
		newProduct.setDate(new java.sql.Date(System.currentTimeMillis()));
		
		/* 상품원가 가공 (상품 수수료 & 부가세) */
		int charge = (int) (newProduct.getProductPrice() * 0.1);
		int tax = (int) (newProduct.getProductPrice() * 0.05);
		newProduct.setProductPrice(newProduct.getProductPrice() + charge + tax);
		
		productRepository.save(modelMapper.map(newProduct, Product.class));
		
	}

	/* 상품 수정 */
	@Transactional
	public void modifyProduct(ProductDTO product) {
		
		Product foundProduct = productRepository.findById(product.getProductNo()).orElseThrow(IllegalArgumentException::new);
		
		/* 상품원가 가공 (상품 수수료 & 부가세) */
		int charge = (int) (product.getProductPrice() * 0.1);
		int tax = (int) (product.getProductPrice() * 0.05);
		
		foundProduct.setProductName(product.getProductName());
		foundProduct.setProductPrice(product.getProductPrice() + charge + tax);
		foundProduct.setSupplierName(product.getSupplierName());
		foundProduct.setOrderableStatus(product.getOrderableStatus());
		
	}
	
	/* 수정된 하나의 상품을 조회 */
	public ProductDTO findProductByCode(int productNo) {
		
		Product product = productRepository.findById(productNo).orElseThrow(IllegalArgumentException::new);
		
		return modelMapper.map(product, ProductDTO.class);
	}

	/* 상품 삭제 */
	@Transactional
	public void deleteProduct(ProductDTO product) {
		
		productRepository.deleteById(product.getProductNo());
		
	}

}

---

👀 Repository

👉 ProductRepository

public interface ProductRepository extends JpaRepository<Product, Integer> {

	/* 전달 받은 키워드가 포함된 상품을 조회하는 메소드 */
	@Query("SELECT p FROM product p WHERE p.productName LIKE %:keyword%")
    public Page<Product> findProductByContaining(Pageable pageable, String keyword);

	/* 전달 받은 날짜 이후의 상품을 조회하는 메소드 */
	Page<Product> findByDateAfter(Date dateAfter, Pageable pageable);

}