要实现的功能,点击删除就能删除学生信息
web.xml的配置:
删除链接:
servlet代码:
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import bean.CrtlSql;//这是实现数据库连接的类
public class DeleteStuServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public DeleteStuServlet() {
super();
}
public void destroy() {
super.destroy();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
CrtlSql con=new CrtlSql();
String stu_id=request.getParameter("stu_id");
String sql="delete from student where stu_id='"+stu_id+"'";
con.con();//数据库连接
con.update(sql);
response.sendRedirect("ifram/stu_info.jsp");
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request,response);
}
public void init() throws ServletException {
}
}