单条删除步骤
(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只负责和数据库进行交互。