Question

在jsp页面怎样通过servlet删除一行数据

welcome.jsp 页面：
<a href='delete?id=" + id + "'>delete</a>

servlet为 /delete 的servlet类：
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
String id = request.getParameter("id");
String sql = "DELETE FROM StudentInfo WHERE id='" + id + "'";
DBUtil db = new DBUtil();
db.exeDelete(sql); // 删除执行
response.sendRedirect("welcome.jsp");
}

问题是：为什么报错405 Method Not Allowed
HTTP Status 405 – Method Not Allowed

Type Status Report

Message HTTP method GET is not supported by this URL

Description The method received in the request-line is known by the origin server but not supported by the target resource.

Apache Tomcat/8.5.23

Answer 1

你用数据库id去删除底层sql写法
delete from 表 where id=页面传过来的值

Answer 2

传参数的话就要使用doGet()