MyBatis（四） 删除单条数据

删除单条数据

list.jsp

<td><a href="#">修改</a>   a href="${basePath}DeleteOneServlet.action?id=${message.id}">删除</a></td>

DeleteOneServlet.java

package com.example.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 com.example.service.MaintainService;/** * 单条删除控制层 *  * @author Jeremy_Lin * */@SuppressWarnings("serial")public class DeleteOneServlet extends HttpServlet {@Overrideprotected 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);}@Overrideprotected void doPost(HttpServletRequest req, HttpServletResponse resp)throws ServletException, IOException {this.doGet(req, resp);}}

MaintainService.java

package com.example.service;import com.example.dao.MessageDao;/** * 维护相关的业务功能 *  * 稍微复杂一点的逻辑都丢这里 *  * @author Jeremy_Lin * */public class MaintainService {/** * 单条删除 */public void deleteOne(String id) {if (id != null && !"".equals(id.trim())) {MessageDao messageDao = new MessageDao();messageDao.deleteOne(Integer.valueOf(id));}}}

MessageDao.java

/** * 单条删除 * @param id */public void deleteOne(int id) {DBAccess dbAccess = new DBAccess();SqlSession sqlSession = null;try {sqlSession = dbAccess.getSqlSession();// 通过sqlSession执行SQL语句      namespace.id// 只能传递一个变量sqlSession.delete("Message.deleteOne", id);sqlSession.commit();} catch (IOException e) { // 在Dao层处理异常e.printStackTrace();} finally {if (sqlSession != null) {sqlSession.close();}}}

Message.xml

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

代码：点击打开链接