MVC实现增删改查的经典例子.doc

SearchList.jsp 92期学员信息如下 % String sql=select * from student order by id; java.util.List list=sBean.getSearch(sql; for(Iterator it=list.iterator(;it.hasNext(;{ //获得JavaBean的一个对象 jBean=(com.jq92.bean.JavaBeanit.next(; % } % % id 姓名 密码 性别 年龄 操 作 %=jBean.getId( % %=jBean.getName( % %=jBean.getPassword( % %=jBean.getSex( % %=jBean.getAge( % 删除? 更新 返回 Update.jsp 您要更新的数据如下： Id： FORMTEXT %=request.getAttribute( readonly 姓名： FORMTEXT %=request.getAttribute( 密码： FORMTEXT %=request.getAttribute( 性别： 男 女 年龄： FORMTEXT %=request.getAttribute( MACROBUTTON DoFieldClick [/spanspan span更/spanspan span /spanspan span新/spanspan span] MACROBUTTON ResetFormField [/spanspan span重/spanspan span /spanspan span置/spanspan span] 查询 Insert.jsp 92期学院管理页面 姓名： FORMTEXT 密码： FORMTEXT 性别： 男 女 年龄： FORMTEXT MACROBUTTON DoFieldClick [/spanspan span提/spanspan span /spanspan span交/spanspan span] MACROBUTTON ResetFormField [/spanspan span重/spanspan span /spanspan span置/spanspan span] 查询 Error.jsp 对不起，您%=request.getAttribute(error %失败 Servlet部分 Update.java public void doPost(HttpServletRequest request, HttpServletResponse response throws ServletException, IOException { //获得前台表单信息 String sid=request.getParameter(id; int id=Integer.parseInt(sid; String name=request.getParameter(name; String password=request.getParameter(password; String sex=request.getParameter(sex; String Sage=request.getParameter(age; int age=Integer.parseInt(Sage; //封装到JavaBean对象中去 JavaBean jBean=new JavaBean(; jBean.setId(id; jBean.setName(name; jBean.setPassword(password; jBean.setSex(sex; jBean.setAge(age; String sql=update student set name=?,password=?,sex=?,age=? where id=?; SqlBean sBean=new SqlBean(; int count=sBean.getUpdate(sql, jBean; String url=; if(count0{ url=SearchList.jsp; } else{ url=Error.jsp; request.setAttribute(error, 更新; } request.getRequestDispatcher(url.forward(request, response; } SearchById.java public void doPost(HttpServletRequest request, HttpServletResponse response