@Param - mapper와 연결
<update id="doUpdate"> UPDATE coffee_menu SET coffee = #{coffee}, kind = #{kind}, price = CAST(#{price} as INTEGER) WHERE no = CAST(#{no} as INTEGER) </update>@Mapper public interface MenuDao { void doUpdate(@Param("no") String no, @Param("coffee") String coffee, @Param("kind") String kind, @Param("price") String price); }
@RequestParam - url 파라미터 연결(http://~~~?no=1)
// 메뉴 수정 @GetMapping("/menu_up") public String doUpdate(@RequestParam("no") String strNo, Model model) { ....... }
@PathVariable - url (http://~~~/no/1)
@PostMapping("/menu_up/{no}") public String doUpdate(@PathVariable("no") String no) { ........ }