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

1、 SearchList.jsp 92期学员信息如下 % % id 姓名 密码 性别 年龄操 作 删除 更新 返回 Update.jsp 您要更新的数据如下： Id： 姓名： 密码： 性别： 女 年龄： 更 新 重 置 查询 Insert.jsp 92期学院管理页面姓名密码性别 年龄： 提 交 重 置 查询 Error.jsp 对不起，您失败 Servlet部分 Update.java public void doPost(HttpServletRequest request, HttpServletResponse response throws ServletException, IOExc

2、eption /获得前台表单信息 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

3、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

4、; else url=Error.jsp; request.setAttribute(error, 更新; request.getRequestDispatcher(url.forward(request, response; SearchById.java public void doPost(HttpServletRequest request, HttpServletResponse response throws ServletException, IOException /获得id String sid=request.getParameter(id; int id=Integer.

5、parseInt(sid; String sql=select * from student where id=?; SqlBean sBean=new SqlBean(; JavaBean jBean=sBean.getSearchById(sql, id; /ID request.setAttribute(id, jBean.getId(; /姓名 request.setAttribute(name,jBean.getName(; /密码 request.setAttribute(password, jBean.getPassword(; /性别 String sex=; String m

6、an=; String woman=; if(jBean.getSex(!=null sex=jBean.getSex(.trim(; if(sex.equals(男 man=checked; else woman=checked; request.setAttribute(man,man; request.setAttribute(woman,woman; /年龄 request.setAttribute(age, jBean.getAge(; /转发 request.getRequestDispatcher(Update.jsp.forward(request, response; Ins

7、ert.java public void doPost(HttpServletRequest request, HttpServletResponse response throws ServletException, IOException /获取前台页面信息 String name=request.getParameter(name; String password=request.getParameter(password; String sex=request.getParameter(sex; String Sage=request.getParameter(age; int age

8、=Integer.parseInt(Sage; /封装到JavaBean对象中 com.jq92.bean.JavaBean jBean=new com.jq92.bean.JavaBean(; jBean.setName(name; jBean.setPassword(password; jBean.setSex(sex; jBean.setAge(age; /调用模型层 String sql=insert into student values(?,?,?,?; SqlBean sBean=new SqlBean(; int count=sBean.getInsert(sql, jBean

9、; String url=; if(count0 url=SearchList.jsp; else url=Error.jsp; request.setAttribute(error,注册; /转发 request.getRequestDispatcher(url.forward(request, response; Delete.java public void doPost(HttpServletRequest request, HttpServletResponse response throws ServletException, IOException /获得删除超链接传来的参数 S

10、tring sId=request.getParameter(id; int id=Integer.parseInt(sId; /调用模型层删除方法 String sql=delete from student where id=?; SqlBean sBean=new SqlBean(; int count=sBean.getDelete(sql, id; String url=; if(count0 url=SearchList.jsp; else url=Error.jsp; request.setAttribute(error, 删除; request.getRequestDispat

11、cher(url.forward(request, response; JavaBean.java package com.jq92.bean; public class JavaBean private int id; private String name; private String password; private String sex; private int age; public int getAge( return age; public void setAge(int age this.age = age; public int getId( return id; pub

12、lic void setId(int id this.id = id; public String getName( return name; public void setName(String name = name; public String getPassword( return password; public void setPassword(String password this.password = password; public String getSex( return sex; public void setSex(String sex this

13、.sex = sex; SqlBean.java package com.jq92.bean; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; public class SqlBean Connection con; PreparedState

14、ment pre; ResultSet rs; public SqlBean( try Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver; catch (ClassNotFoundException e / TODO 自动生成 catch 块 e.printStackTrace(; try con=DriverManager.getConnection(jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=jq92Model2,sa,sa; catch (SQLExcept

15、ion e / TODO 自动生成 catch 块 e.printStackTrace(; public int getInsert(String sql,JavaBean jBean int count=0; try pre=con.prepareStatement(sql; pre.setString(1,jBean.getName(; pre.setString(2,jBean.getPassword(; pre.setString(3, jBean.getSex(; pre.setInt(4, jBean.getAge(; count=pre.executeUpdate(; catch

16、 (SQLException e / TODO 自动生成 catch 块 e.printStackTrace(; finally try pre.close(; con.close(; catch (SQLException e / TODO 自动生成 catch 块 e.printStackTrace(; return count; public int getDelete(String sql,int id int count=0; try pre=con.prepareStatement(sql; pre.setInt(1, id; count=pre.executeUpdate(; c

17、atch (SQLException e / TODO 自动生成 catch 块 e.printStackTrace(; finally try pre.close(; con.close(; catch (SQLException e / TODO 自动生成 catch 块 e.printStackTrace(; return count; public JavaBean getSearchById(String sql,int id JavaBean jBean=new JavaBean(; try pre=con.prepareStatement(sql; pre.setInt(1, i

18、d; rs=pre.executeQuery(; while(rs.next( jBean.setId(rs.getInt(id; jBean.setName(rs.getString(name; jBean.setPassword(rs.getString(password; jBean.setSex(rs.getString(sex; jBean.setAge(rs.getInt(age; catch (SQLException e / TODO 自动生成 catch 块 e.printStackTrace(; return jBean; public int getUpdate(Stri

19、ng sql,JavaBean jBean int count=0; try pre=con.prepareStatement(sql; pre.setString(1,jBean.getName(; pre.setString(2, jBean.getPassword(; pre.setString(3, jBean.getSex(; pre.setInt(4, jBean.getAge(; pre.setInt(5, jBean.getId(; count=pre.executeUpdate(; catch (SQLException e / TODO 自动生成 catch 块 e.pri

20、ntStackTrace(; finally try pre.close(; con.close(; catch (SQLException e / TODO 自动生成 catch 块 e.printStackTrace(; return count; public List getSearch(String sql List list=new ArrayList(; /获得prepareStatement对象 try pre=con.prepareStatement(sql; rs=pre.executeQuery(; while(rs.next( JavaBean jBean=new Ja

21、vaBean(; jBean.setId(rs.getInt(id; jBean.setName(rs.getString(name; jBean.setPassword(rs.getString(password; jBean.setSex(rs.getString(sex; jBean.setAge(rs.getInt(age; list.add(jBean; catch (SQLException e / TODO 自动生成 catch 块 e.printStackTrace(; finally try pre.close(; con.close(; catch (SQLExceptio

22、n e / TODO 自动生成 catch 块 e.printStackTrace(; return list; Filter过滤器编码转换 package com.jq92.filter; import java.io.IOException; import javax.servlet.Filter; import javax.servlet.FilterChain; import javax.servlet.FilterConfig; import javax.servlet.ServletException; import javax.servlet.ServletRequest; im

23、port javax.servlet.ServletResponse; public class EncodingFilter implements Filter String encoding=; public void destroy( / TODO 自动生成方法存根 public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain throws IOException, ServletException / TODO 自动生成方法存根 request.setCharacterEncoding(encoding; chain.doFilter(request, response; public void init(FilterConfig config throws ServletException / TODO 自动生成方法存根 encoding=config.getInitParameter(encoding; web.xml xmlns=http:/j