MVC實現(xiàn)增刪改查的小例子精

1、MVC作者：深藍王子SearchList.js p92期學(xué)員信息如<%string sql="select * from stude nt order by id"java.util.List list=sBea n.getSearch(sql;for(lterator it=list.iterator(;it.hasNext(;獲得JavaBean的一個對象jBea n=(com.jq92.bea n. JavaBea ni t. next(;%>%><%id姓名密碼性別年齡操作<%=jBea n.get<%=jBea n.getN&l

2、t;%=jBea n. get Pass<%=jBea n. get<%=jBea n. getmu 刪 除Id( %>ame( %>word( %>Sex( %>Age( %>更 新返回Id:v%=request.getAttnbute(" read only：姓名：v%=request.getAttnbute(":密碼：v%=request.getAttribute(":性別：o >男O >女年齡：v%=request.getAttribute(":V/S panxspan span更 v/spa

3、nxspan spanv/spanxspan sp aS>v/s panxspan span：v/s panxspan span重 v/spanxspan span： v/spanxspan sp aSH/s panxspan span：Up date.js p您要更新的數(shù)據(jù)如查詢Insert.js p92期學(xué)院管理頁面姓名：密碼：性別：O男O女年齡：v/s panxspan span提 v/spanxspan span> v/spanxspan sp ao>v/s panxspan span：v/s panxspan span重 v/spanxspan span> v

4、/spanxspan sp aS>v/s panxspan span：查詢Error.js p 對不起，您 v%=request.getAttribute("error" %失敗Servlet 部分Up date.javap ublic void doPo st(Htt pServletRequest request, Http ServletRes ponse res ponse throws ServletExce pti on, I OExce pti on /獲得前臺表單信息Stri ng sid=request.get Parameter("id&

5、quot;int id=In teger. parse In t(sid;String n ame=request.get Parameter" name"Stri ng p assword=request.get Parameter(” password"Stri ng sex=request.get Parameter("sex"String Sage=request.get Parameter("age"int age=In teger. parse In t(Sage;/圭寸裝到JavaBean對象中去JavaBea

6、 n jBea n=new JavaBea n(;jBea n. setId(id;jBea n. setName( name;jBea n. set Password( password;jBea n. setSex(sex;jBea n. setAge(age;String sql=" up date stude nt set n ame=?,p assword二？,sex二？,age=? where id=?"SqlBea n sBea n=new SqlBea n(;int coun t=sBea n. getU pdate(sql, jBea n;Stri ng

7、url=""if(cou nt>0 url="SearchList.js p"else url="Error.js p"request.setAttribute("error","更新"request.getRequestDis patcher(url.forward(request, res ponse;SearchByld.javap ublic void doPo st(Htt pServletRequest request, Http ServletRes ponse res po

8、nse throws ServletExce pti on, I OExce pti on /獲得idStri ng sid=request.get Parameter("id"int id=In teger. parse In t(sid;Stri ng sql="select * from stude nt where id=?"SqlBea n sBea n=new SqlBea n(;JavaBea n jBea n=sBea n. getSearchById(sql, id;/ID request.setAttribute("id&q

9、uot;, jBea n. getId(;/姓名 request.setAttribute(” name",jBea n.getName(;/密碼 request.setAttributeC' password", jBea n. get Password(;/性別String sex=""Stri ng man二""Stri ng woma n=""if(jBea n. getSex(!=null sex=jBea n. getSex(.trim(;if(sex.equals("男"

10、man="checked"else woma n="checked"request.setAttribute("ma n",ma n;request.setAttribute("woma n",woma n;/年齡 request.setAttribute("age", jBea n.getAge(;/轉(zhuǎn)發(fā) request.getRequestDis patcher("U pdate.js p".forward(request, res ponse;Insertjavap u

11、blic void doPo st(Htt pServletRequest request, Http ServletRes ponse res ponse throws ServletExce pti on, I OExce pti on /獲取前臺頁面信息 string n ame=request.get Parameter name"Stri ng p assword=request.get Parameter(” password"Stri ng sex=request.get Parameter("sex"String Sage=request

12、.get Parameter("age"int age=In teger. parse In t(Sage;/圭寸裝到JavaBean對象中 com.jq92.bea n. JavaBea n jBea n=new com.jq92.bea n. JavaBea n(;jBea n. setName( name;jBea n. set Password( password;jBea n. setSex(sex;jBea n. setAge(age;調(diào)用模型層Stri ng sql="i nsert into stude nt values(?,?,?,?"

13、;SqlBea n sBea n=new SqlBea n(;int coun t=sBea n. get In sert(sql, jBea n;Stri ng url=""if(cou nt>0 url="SearchList.js p"else url="Error.js p"request.setAttribute("error","注 冊"/轉(zhuǎn)發(fā) request.getRequestDis patcher(url.forward(request, res ponse;Delete

14、.javap ublic void doPo st(Htt pServletRequest request, Http ServletRes ponse res ponse throws ServletExce pti on, I OExce pti on /獲得刪除超鏈接傳來的參數(shù)Stri ng sld=request.get Parameter("id"int id=In teger. parse In t(sId;調(diào)用模型層刪除方法Stri ng sql="delete from stude nt where id=?"SqlBea n sBea

15、n=new SqlBea n(;int coun t=sBea n. getDelete(sql, id;Stri ng url=""if(cou nt>0 url="SearchList.js p"else url="Error.js p"request.setAttribute("error","刪除"request.getRequestDis patcher(url.forward(request, res ponse;JavaBea n.java p ackage com.jq92

16、.bea n;p ublic class JavaBea n p rivate int id;p rivate Stri ng n ame;p rivate Stri ng p assword;p rivate Stri ng sex;p rivate int age;p ublic int getAge( retur n age;p ublic void setAge(i nt age this.age = age;p ublic int getld( return id;p ublic void setId(i nt id this.id = id;p ublic String getNa

17、me( return n ame;p ublic void setName(Stri ng n ame this. name = n ame;p ublic String get Password( return p assword;p ublic void set Password(Stn ng p assword this .p assword = p assword;p ublic String getSex( retur n sex;p ublic void setSex(Stri ng sex this.sex = sex;SqlBea n.java p ackage com.jq9

18、2.bea n;import java.sql.C onn ectio n;import java.sql.DriverMa nager;import java.sql. Prep aredStateme nt;import java.sql.ResultSet;import java.sql.SQLExce ptio n;import java.util.ArrayList;import java.util.List;p ublic class SqlBea n Connection con;Prep aredStateme nt pre;ResultSet rs;p ublic SqlBe

19、a n( try Class.forNameC'com.microsoft.jdbc.sqlserver.SQLServerDriver" catch (ClassNotF oun dExce pti on e / TODO自動生成catch塊 e.prin tStackTrace(;try con=DnverMa nager.getC onn ectio n("jdbc:microsoft:sqlserver:/localhost:1433;Database Name=jq92Model2","sa","sa" c

20、atch (SQLExce pti on e / TODO自動生成catch塊 e.prin tStackTrace(;p ublic int getI nsert(Stn ng sqlJavaBea n jBea n int coun t=0;try p re=c on.prep areStateme nt(sql;p re.setStri ng(1,jBea n.getName(;p re.setStri ng(2,jBea n.get Password(;p re.setStri ng(3, jBea n. getSex(;p re.set In t(4, jBea n. getAge(

21、;count=p re.executeU pdate(; catch (SQLExce pti on e II TODO自動生成catch塊 e.prin tStackTrace(;fin ally try p re.close(;con. close(;catch (SQLExce pti on e II TODO自動生成catch塊 e.prin tStackTrace(;retur n count;p ublic int getDelete(Stri ng sql,i nt id int coun t=0;try p re=c on.prep areStateme nt(sql;p re

22、.setl nt(1, id;count=p re.executeU pdate(; catch (SQLExce pti on e II TODO自動生成catch塊 e.prin tStackTrace(;fin ally try p re.close(;con. close(;catch (SQLExce pti on e / TODO自動生成catch塊 e.prin tStackTrace(;retur n count;p ublic JavaBea n getSearchByld(Stn ng sql,i nt idJavaBea n jBea n=new JavaBea n(;t

23、ry p re=c on.prep areStateme nt(sql;p re.setI nt(1, id;rs=p re.executeQuery(;while(rs. next( jBea n.setld(rs.getl nt("id"jBea n.setName(rs.getStri ng(" name"jBea n.set Password(rs.getStri ng(" password"jBea n.setSex(rs.getStri ng("sex"jBea n.setAge(rs.getl nt(

24、"age" catch (SQLExce pti on e II TODO自動生成catch塊 e.prin tStackTrace(;retur n jBea n;p ublic int getU pdate(Stn ng sqlJavaBea n jBea n int coun t=0;try p re=c on.prep areStateme nt(sql;p re.setStri ng(1,jBea n.getName(;p re.setStri ng(2, jBea n.get Password(;p re.setStri ng(3, jBea n. getSex

25、(;p re.set In t(4, jBea n. getAge(;p re.setI nt(5, jBea n. getId(;count=p re.executeU pdate(; catch (SQLExce pti on e / TODO自動生成catch塊 e.prin tStackTrace(;fin ally try p re.close(;con. close(;catch (SQLExce pti on e / TODO自動生成catch塊 e.prin tStackTrace(;retur n count;p ublic List getSearch(Stn ng sql

26、List list=new ArrayList(;/獲得 prepareStatemen對象 try p re=c on.prep areStateme nt(sql;rs=p re.executeQuery(;while(rs. next(JavaBea n jBea n=new JavaBea n(;jBea n.setld(rs.getl nt("id"jBea n.setName(rs.getStri ng(" name"jBea n.set Password(rs.getStri ng(" password"jBea n.s

27、etSex(rs.getStri ng("sex"jBea n.setAge(rs.getl nt("age"list.add(jBea n; catch (SQLExce pti on e II TODO自動生成catch塊 e.prin tStackTrace(;fin ally try p re.close(;con. close(;catch (SQLExce pti on e / TODO自動生成catch塊 e.prin tStackTrace(;return list;Filter過濾器編碼轉(zhuǎn)換 p ackage com.jq92.filt

28、er;import java.io.IOExce pti on;import javax.servlet.Filter;import javax.servlet.FilterCha in;import javax.servlet.FilterC onfig;import javax.servlet.ServletExce pti on;import javax.servlet.ServletRequest;import javax.servlet.ServletRes ponse;p ublic class En cod in gFilter imp leme nts Filter Strin

29、g en cod in g=""p ublic void destroy( / TODO自動生成方法存根 p ublic void doFilter(ServletRequest request, ServletRes ponse res ponse.FilterChai n cha in throws IOExce pti on, ServletExce ptio n / TODO自動生成方法存根 request.setCharacterE ncodi ng(e ncodi ng;cha in. doFilter(request, res ponse;p ublic void in it(FilterC onfig config thro