黑马程序员Java web之删除功能的实现

原因：老师叫自己写。。。

首先把href写好

<a href="/brand-demo/deleteServlet?id=${brand.id}">删除</a>

编写BrandMapper（记得提前打开数据库哈）

//    删除语句
    @Delete("delete from tb_brand where id= #{id}")
    void deleteById(int id);

在BrandService添加方法（我知道很多人可能少了commit()提交事务而报错）

public void deleteById(int id){
        SqlSession session = factory.openSession();
        BrandMapper mapper = session.getMapper(BrandMapper.class);

        mapper.deleteById(id);
        session.commit();
        session.close();
    }

之后编写DeleteServlet（可能你们叫DeleteByIdServlet）“ / ” 不要少哈

@WebServlet("/deleteServlet")
public class DeleteServlet extends HttpServlet {
    private BrandService service = new BrandService();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//        接受id
        String id = req.getParameter("id");
        service.deleteById(Integer.parseInt(id));
        req.getRequestDispatcher("/selectAllServlet").forward(req,resp);
    }
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req,resp);
    }
}

OK，大功告成！去run吧！！！