JSP 글 삭제 기능 만들기

VIEW - board_content_view.jsp와 동일

MODEL

    public void board_delete(String bId) {
        Connection con = null;
        PreparedStatement pstmt = null;
        try {
            String query =  "delete from board where bId = ?";
            Class.forName(driver);
            con=DriverManager.getConnection(url, user, password);
            pstmt = con.prepareStatement(query);
            pstmt.setInt(1, Integer.parseInt(bId));
            pstmt.executeUpdate();
        } catch(Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if(pstmt != null) pstmt.close();
                if(con != null) con.close();
                } catch (Exception e2) {
                    e2.printStackTrace();
                }
            }
        }

COMMAND 

package com.javalec.ex.command;
 
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
import com.javalec.ex.dao.*;
 
public class BDeleteCommand implements BCommand {
    
    public void execute(HttpServletRequest requset,HttpServletResponse respone) {
        String bId = requset.getParameter("bId");
        BDao dao = new BDao();
        
        dao.board_delete(bId);
    }
 
}
 

CONTROLLER

        }if(con.equals("/board_delete.do")) {
            command = new BDeleteCommand();
            command.execute(request, response);
            viewPage = "board_list.do";