[BACK] 글 삭제하기 (Spring MyBatis)

[👩🏻‍💻소스코드]

 

[BACK]

[tripboard.xml]

<!-- 6. 글 삭제하기 -->
<delete id="delete" parameterType="String">
 delete from tripboard where num=#{num}
</delete>

 

[sqlMapBoardDAO.java]

public class SqlMapBoardDAO extends SqlSessionDaoSupport implements BoardDAO  {

	@Override
	public void delete (String num) throws DataAccessException{
		getSqlSession().delete("delete",num);
	}

 

[BoardDAO.java]

public interface BoardDAO {
//6.글 삭제하기
	public void delete (String num) throws DataAccessException;

 

[DeleteAction.java]

package Board;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.Controller;

public class DeleteAction implements Controller {

	BoardDAO dao;

	public void setDao(BoardDAO dao) {
		this.dao=dao;
		System.out.println("delete에서 setDao 호출:" +dao);
	}
	@Override
	public ModelAndView handleRequest(HttpServletRequest request,
									  HttpServletResponse response) throws Exception {
		// TODO Auto-generated method stub


		String num=request.getParameter("num");

		System.out.println("삭제하려는 글번호: "+num);
		System.out.println("DeleteAction 실행중");
		dao.delete(num);

		ModelAndView mav= new ModelAndView();
		mav.setViewName("redirect:/list.do");

		return mav;
	}

}

---

 

[💬설명]

 

📢 삭제는 과정으로만 진행되기 때문에 따로 jsp 파일을 만들지 않았음!

 

---

[💻결과]

 

 

⬇

2번 글 삭제됨