1103 JSP - (Funweb) 장바구니 삭제

BasketFrontController

else if(command.equals("/BaksetDeleteAction.ba")) {   //. 있으면 호출 못함.
    System.out.println(" C : /BasketDeleteAction.ba 호출");
    System.out.println(" C : [패턴2] ");

    //BasketDeleteAction() 객체
    action = new BasketDeleteAction();
    try {
        forward = action.execute(request, response);
    } catch (Exception e) {
        e.printStackTrace();
    }

}

 

Action 생성

public class BasketDeleteAction implements Action {

	@Override
	public ActionForward execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
		System.out.println("BasketDeleteAction_execute 호출");
		
		//세션값 제어
		
		HttpSession session = request.getSession();
		
		//전달 정보 저장 (b_num)
		int b_num = Integer.parseInt(request.getParameter("b_num"));
		

		//DAO - 장바구니 삭제 메서드 
		BasketDAO dao = new BasketDAO();
		int result = dao.deleteBasket(b_num);
		
		if(result == 1) {
			System.out.println("M : 장바구니 삭제 완료 ");
		}
		//forward (BasketList.ba)
		ActionForward forward = new ActionForward();
		forward.setPath("./BasketList.ba");
		forward.setRedirect(true);
		return forward;

	}
}

 

dao 객체 생성 

//장바구니 삭제 - deleteBasket(b_num)
public void deleteBasket(int b_num) {
    int result = -1;
    try {
        con = getConnection();
        sql = "delete from itwill_basket where b_num=?";
        pstmt = con.prepareStatement(sql);
        pstmt.setInt(1, b_num);
        result = pstmt.executeUpdate();

        System.out.println(" DAO : " + b_num + "번 장바구니 삭제 완료");
        System.out.println(" DAO : 상품삭제 완료 ");
    } catch (Exception e) {
        e.printStackTrace();
    }finally {
        closeDB();

    }
    return result;
}