原因:老师叫自己写。。。
首先把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吧!!!