MVC学生管理系统-阶段III（删除学生信息）

项目源码 ：https://download.****.net/download/weixin_44718300/11091042

前期准备，主体框架，学生列表显示  请看阶段一文章

添加学生信息  请看阶段二文章

本文是对阶段一的增加部分，不建议跳跃查看

NO01:修改list.jsp

<td>
<a href="#">更新</a> <a href="#" οnclick="doDelete(${stu.sid})">删除</a>
</td>

<script type="text/javascript">
		function doDelete(sid) {
			var flag = confirm("是否确认删除？"+sid);
			if(flag){
				window.location.href="DeleteServlet?sid="+sid;
			}
		}
	</script>

NO02:创建DeleteSerclet

public class DeleteServlet extends HttpServlet {

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

		try {
			int sid = Integer.parseInt(request.getParameter("sid"));
			System.out.println(sid);
			StudentService service = new StudentServiceImpl();
			service.delete(sid);

			request.getRequestDispatcher("StudentListServlet").forward(request, response);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}

}

NO03:创建service和dao

这及各类比较简单参考添加完成即可不再赘述

@Override

public void delete(Integer sid) throws SQLException {

QueryRunner runner = new QueryRunner(JDBCUtil.getDataSouce());

runner.update("delete  from stu where sid = ?",sid);

}