AdminProductDeleteAction
package net.macaronics.web.admin.controller; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.logging.log4j.LogManager; import org.apache.logging.log4j.Logger; import net.macaronics.web.admin.controller.dao.AdminProductDAO; import net.macaronics.web.controll.action.Action; public class AdminProductDeleteAction implements Action { private static Logger logger =LogManager.getLogger(AdminProductDeleteAction.class); @Override public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String url="MacaronicsServlet?command=admin_product_list&pageNum="; //페이지를 유지 하기위한 처리 작업 String pageNum="1"; if(request.getParameter("pageNum")!=null){ pageNum=request.getParameter("pageNum"); } url +=pageNum; logger.info("url , {}, request.getParameter() - {}", url, request.getParameter("pageNum")); int pseq=Integer.parseInt(request.getParameter("pseq")); AdminProductDAO dao =AdminProductDAO.getInstance(); dao.deleteProudct(pseq); response.sendRedirect(url); } }
//상품 삭제 public void deleteProudct(int pseq){ try{ sqlSession=MybatisService.getFactory().openSession(); sqlSession.delete("adminProduct.deleteProudct", pseq); }catch(Exception e){ e.printStackTrace(); }finally{ sqlSession.commit(); MybatisService.sessionClose(sqlSession); } }
<delete id="deleteProudct"> delete from TBL_PRODUCT where pseq=#{pseq} </delete>
제작 : macaronics.net - Developer Jun Ho Choi
소스 : https://github.com/braverokmc79/jsp_sin
${request.getContextPath() } 처리를 안한 부분이 있으므로
루트 설정( http://macaronics.net/index.php/m01/jsp/view/1352) 및 server.xml 에서 DB 컨넥션 설정은 필수 설정이다.
댓글 ( 4)
댓글 남기기