Servlet CRUD-Servlet提供删除功能

通过 SERVLET 实现删除功能

• 提供delete超链
  
  修改HeroLIstServlet，多一个单元格，是一个超链
  超链的href属性指向地址 /deleteHero?id=217(每条不同的记录id不一样)
  可以在左下角的浏览器状态栏里看到
  
• 修改HeroListServlet
  
  为table新增加一列delete,对于每条hero数据，增加一个delete超链
  

  package servlet;
   
  import java.io.IOException;
  import java.util.List;
   
  import javax.servlet.ServletException;
  import javax.servlet.http.HttpServlet;
  import javax.servlet.http.HttpServletRequest;
  import javax.servlet.http.HttpServletResponse;
   
  import bean.Hero;
  import dao.HeroDAO;
   
  public class HeroListServlet extends HttpServlet {
   
      protected void service(HttpServletRequest request, HttpServletResponse response)
              throws ServletException, IOException {
          response.setContentType("text/html; charset=UTF-8");
           
          List<Hero> heros = new HeroDAO().list();
   
          StringBuffer sb = new StringBuffer();
          sb.append("<table align='center' border='1' cellspacing='0'>\r\n");
          sb.append("<tr><td>id</td><td>name</td><td>hp</td><td>damage</td><td>delete</td></tr>\r\n");
   
          String trFormat = "<tr><td>%d</td><td>%s</td><td>%f</td><td>%d</td><td><a href='deleteHero?id=%d'>delete</a></td></tr>\r\n";
   
          for (Hero hero : heros) {
              String tr = String.format(trFormat, hero.getId(), hero.getName(), hero.getHp(), hero.getDamage(),hero.getId());
              sb.append(tr);
          }
   
          sb.append("</table>");
   
          response.getWriter().write(sb.toString());
   
      }
  }

• 配置web.xml
  
  配置web.xml 把/deleteHero指向 HeroDeleteServlet
  

  <?xml version="1.0" encoding="UTF-8"?>
  <web-app>
   
      <servlet>
          <servlet-name>HelloServlet</servlet-name>
          <servlet-class>HelloServlet</servlet-class>
          <load-on-startup>10</load-on-startup>
      </servlet>
   
      <servlet-mapping>
          <servlet-name>HelloServlet</servlet-name>
          <url-pattern>/hello</url-pattern>
      </servlet-mapping>
       
      <servlet>
          <servlet-name>LoginServlet</servlet-name>
          <servlet-class>LoginServlet</servlet-class>
      </servlet>
   
      <servlet-mapping>
          <servlet-name>LoginServlet</servlet-name>
          <url-pattern>/login</url-pattern>
      </servlet-mapping>   
      <servlet>
          <servlet-name>RegisterServlet</servlet-name>
          <servlet-class>RegisterServlet</servlet-class>
      </servlet>
   
      <servlet-mapping>
          <servlet-name>RegisterServlet</servlet-name>
          <url-pattern>/register</url-pattern>
      </servlet-mapping>
       
      <servlet>
          <servlet-name>HeroListServlet</servlet-name>
          <servlet-class>servlet.HeroListServlet</servlet-class>
      </servlet>
   
      <servlet-mapping>
          <servlet-name>HeroListServlet</servlet-name>
          <url-pattern>/listHero</url-pattern>
      </servlet-mapping>   
           
      <servlet>
          <servlet-name>HeroAddServlet</servlet-name>
          <servlet-class>servlet.HeroAddServlet</servlet-class>
      </servlet>
   
      <servlet-mapping>
          <servlet-name>HeroAddServlet</servlet-name>
          <url-pattern>/addHero</url-pattern>
      </servlet-mapping>   
       
      <servlet>
          <servlet-name>HeroDeleteServlet</servlet-name>
          <servlet-class>servlet.HeroDeleteServlet</servlet-class>
      </servlet>
   
      <servlet-mapping>
          <servlet-name>HeroDeleteServlet</servlet-name>
          <url-pattern>/deleteHero</url-pattern>
      </servlet-mapping>   
           
  </web-app>

• 编写HeroDeleteServlet
  
  首先获取参数id
  然后通过HeroDAO根据id，删除该对象
  然后客户端跳转到 /listHero
  

  package servlet;
   
  import java.io.IOException;
   
  import javax.servlet.ServletException;
  import javax.servlet.http.HttpServlet;
  import javax.servlet.http.HttpServletRequest;
  import javax.servlet.http.HttpServletResponse;
   
  import dao.HeroDAO;
   
  public class HeroDeleteServlet extends HttpServlet {
   
      protected void service(HttpServletRequest request, HttpServletResponse response)
              throws ServletException, IOException {
   
          int id = Integer.parseInt(request.getParameter("id"));
           
          new HeroDAO().delete(id);
   
          response.sendRedirect("/listHero");
           
      }
  }

• 测试
  
  重启tomcat,首先访问查询页面

  http://127.0.0.1/listHero

  然后点击删除，可以观察到某条数据被删除了