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 컨넥션 설정은 필수 설정이다.