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

最新推荐文章于 2024-01-12 14:25:17 发布

_Rick

最新推荐文章于 2024-01-12 14:25:17 发布

阅读量500

点赞数

分类专栏： MVC

本文链接：https://blog.csdn.net/weixin_44718300/article/details/89045127

版权

MVC 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

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

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

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

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

NO01:修改list.jsp


<td>
<a href="#">更新</a> <a href="#" onclick="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);

}