Mybatis学习笔记（三）-----删除记录

单条删除步骤

（1）在message.xml编写相关的delete标签。

    <delete id="deleteOne" parameterType="int">
       delete form MESSAGE where ID = #{_parameter}
    </delete>

（2）在MessageDao中编写相关的delete方法。

/**MessageDao.java*/
public void deleteOne(int id) {
    DBAccess dbAcess = new DBAccess();
    SqlSession sqlSession = null;
    // DAO层处理异常
    try {
      sqlSession = dbAcess.getSqlSession();
      // 通过sqlSession执行SQL语句
      sqlSession.selectList("Message.deleteOne", id);
    } catch (IOException e) {
      e.printStackTrace();
    } finally {
      if (sqlSession != null) {
        sqlSession.close();
      }
    }
  }

（3）新建Service去调用DAO的delete方法。

为了避免过多的service，可将改动表的操作归为“维护service”。

/**MaintainService.java*/
  public void deleteOne(String id) {
    if (id != null && "".equals(id.trim())) {
      MessageDao messageDao = new MessageDao();
      messageDao.deleteOne(Integer.valueOf(id));
    }
  }

（4）编写相关的Servlet，接收删除请求。

/**DeleteOneServlet.java*/
public class DeleteOneServlet extends HttpServlet {
  @Override
  protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    // 设置编码
    req.setCharacterEncoding("UTF-8");
    // 接收页面的值
    String id = req.getParameter("id");
    MaintainService maintainService = new MaintainService();
    maintainService.deleteOne(id);
    // 向页面跳转
    req.getRequestDispatcher("/List.action").forward(req, resp);
  }

  @Override
  protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    // TODO Auto-generated method stub
    this.doGet(req, resp);
  }
}

（5）修改web.xml，增加映射和配置servlet。

    <servlet>
        <servlet-name>DeleteOneServlet</servlet-name>
        <servlet-class>com.shen.servlet.DeleteOneServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>DeleteOneServlet</servlet-name>
        <url-pattern>/DeleteOneServlet.action</url-pattern>
    </servlet-mapping>

批量删除

基本步骤和上面类似。

（1）在message.xml编写相关的delete标签。

    <delete id="deleteBatch" parameterType="java.util.List">
       delete from message where ID in(
       <foreach collection="list" item="item" separator=",">
           #{item},
       </foreach>
       )
    </delete>

其中使用了foreach进行循环，其中一个字段separator帮助分隔，避免造成前或后多一个分隔符的现象。

（2）在MessageDao中编写相关的deleteBatch方法。

  public void deleteBatch(List<Integer> idList) {
    DBAccess dbAcess = new DBAccess();
    SqlSession sqlSession = null;
    // DAO层处理异常
    try {
      sqlSession = dbAcess.getSqlSession();
      // 通过sqlSession执行SQL语句
      sqlSession.delete("Message.deleteBatch", idList);
      sqlSession.commit();
    } catch (IOException e) {
      e.printStackTrace();
    } finally {
      if (sqlSession != null) {
        sqlSession.close();
      }
    }
  }

（3）新建Service去调用DAO的delete方法。

  public void deleteBatch(String[] idList) {
    MessageDao messageDao = new MessageDao();
    List<Integer> idList2=new ArrayList<Integer>();
    for (String id : idList) {
      idList2.add(Integer.valueOf(id));
    }
    messageDao.deleteBatch(idList2);
  }

（4）编写相关的Servlet，接收删除请求。

public class DeleteBatchServlet extends HttpServlet {
  @Override
  protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    // 设置编码
    req.setCharacterEncoding("UTF-8");
    // 接收页面的值
    String[] idList = req.getParameterValues("id");
    MaintainService maintainService = new MaintainService();
    maintainService.deleteBatch(idList);
    // 向页面跳转
    req.getRequestDispatcher("/List.action").forward(req, resp);
  }

  @Override
  protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
    // TODO Auto-generated method stub
    this.doGet(req, resp);
  }
}

（5）修改web.xml，增加映射和配置servlet。

    <servlet>
        <servlet-name>DeleteBatchServlet</servlet-name>
        <servlet-class>com.shen.servlet.DeleteBatchServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>DeleteBatchServlet</servlet-name>
        <url-pattern>/DeleteBatchServlet.action</url-pattern>
    </servlet-mapping>

简述一下DAO/service/servlet功能

Servlet只负责接收原始值，传递值，调用service。
service负责处理数据，调用DAO。
DAO只负责和数据库进行交互。