Servlet增删改查案例经典实现

1、AddpublicclassAddextendsHttpSeivletpublicvoiddoGet(HttpSen4etRequestrequest,HttpSeivletResponseresponse)tluowsSendetException.lOException/编码问题response.setContentType(Htext/htnil;charset=GBKH)y/浏览器显示的编码，默认的是isoresponse.setCliaiacterEncodmgCGBK);/浏览器到数据库取数据时候使用的编码request.setCharacterEncoduig(GBK)y/浏览器

2、到数据库存入数据时候所使用的编码方式必须为post方式才行的/获取所提交表单的值Stimgid=iequest.getParameter(MidM);/严谨的编码：if(HM.equals(id)|id=null)response.sendReduect(n./Mam.htnilH);/System.out.pimtlii(nzzzM);return;)Stimgname=request.getParaineter(Husern);/Stringname=newStrmg(namel.getBytes(nGBKH)y/nISO-8859-rmtuseiage=Integer.parseInt(

3、request.getParameter(HageM);Stimgaddr=request.getParameter(naddiessH);mtusend=Iiiteger.paiseliit(id);/调用dao层的方法进行添加到数据库的操作Personp=newPerson();p.setld(userid);p.setName(name);p.setAge(userage);p.setAddress(addr);IPersoiiDaoperson=newPeisoiiDaonnplQ;person.addPerson(p);/添加过后则重定向，跳向查询全部的页面response.send

4、ReduectCVJsp/selectAir*);/Post方法处理post的请求publicvoiddoPost(HttpSerletRequestrequest,HttpServdetResponseresponse)tluowsSendetException.lOExceptiondoGet(request,response);DeletepublicclassDeleteextendsHttpSendetpublicvoiddoGet(HttpSer4etRequestrequest,HttpSerxdetResponseresponse)tluowsSendetException.l

5、OExceptionIPersoiiDaoperson=newPersoiiDaoImpl();mtid=Integer.parseInt(request.getParameter(nidn).tiim();person.delPersoiiByld(id);response.sendRedirectC/Jsp/selectAH);/重定向查询全部页面“RequestDispatcheidp=icquest.gutRequestDispatcherC/Add/selectAll);转发方式/dp.fbnvard(iequest,response);publicclassDelAllextend

6、sHttpSeivletpublicvoiddoGet(HttpSer4etRequestrequest,HttpSerxdetResponseresponse)tluowsSendetException.lOException获取多个box的值的方法Stimgs=request.getParaineterValues(nlikeM);/?IPersoiiDaoperson=newPeisoiiDaoIinplQ;使用for循环进行删除操作for(hiti=0;is.length;i+)/System.out.printlii(si);mtid=Iiiteger.parseliit(si);循

7、环删除操作person.delPersoiiByld(id);response.sendReduect(,7Add/selectAllH);/跳到查询全部页面)/Post方法处理post的请求publicvoiddoPost(HttpSendetRequestrequest,HttpSeivletResponseresponse)tluowsSendetException.lOExceptiondoGet(request,response);)UpdatepublicclassUpdateHtmlextendsHttpServletpublicvoiddoGet(HttpSen4etReque

8、strequest,HttpSendetResponseresponse)tluowsSendetException.lOException编码问题response.setContentType(ntext/htnil;cliarset=GBKH)y/浏览器显示的编码，默认的是isoresponse.setChaiacteiEncodmgCGBK);/浏览器到数据库取数据时候使用的编码request.setCharacterEncoduig(GBK)y/浏览器到数据库存入数据时候所使用的编码方式PrintWiiterout=response.getWliterQ;/out.print(,+re

9、sponse.getContentType()4-MH);/out.print(H,+response.getCharacterEncodingO+,M);/out.pimt(H,+request.getChaiacterEncoduigO+MH)；获取selectAU上的数据，使用超链接的方式获得的mtid=Iiiteger.paiseIiit(iequest.getPaiameter(HidH).triin();Stimgusername=request.getParameter(nuseinameH).trmiQ;username=newStrmg(username.getBytes(H

10、iso-8859-r,)/,GB2312H);转码/out.pimt(HH+username+HM);mtuseiage=Integer.parseInt(request.getParameter(HageM);Stimgaddr=request.getParameter(naddiessn);out.pimthi(H)；out.pimtlii(nH);out.printingUpdate/TITLE-r);out.printing);out.prmtlii(nH);out.pnnt(修改页面v/hl)/定义表单out.priiitlii(nn);out.prmtlii(n)；out.prmt

11、lii(Hn+nH+HID号码：+HM+MH+“(inputtype=textreadonly=ti-uename=idlvalue=H+id+/+y/tr)；out.prmtlii(Hn+”vtd+姓名：+H+MM+“(inputtype=textname=namelvalue=n+username+/”+HH+HM);out.prmtlii(Hn+nH+年龄：+H+MM+“(inputtype=textname=agelvalue=H+useiage+/*+HH+HM);获取的addrSuingselect=MselectedH;自己的方法如下：if(addr.equals(nshaiig

12、haiM)out.prmtlii(Hn+nH+”住址：+H+MM+“selectname=addiess+”huainanhefeibeijingshanghaiH+MH+Hn+“)；elseif(addr.equals(,huainanH)out.prmtlii(MH+Hn+”住址：+M+nn+”selectname=address+”huainanhefeibeijingshanghaiH+-+H+y/tr”)；elseif(addr.equals(Hbeijing,)out.prmtln(HH+Hn+”住址：+Mn+HH+“selectname=，ddiess+”huauianhefei

13、beijmgshanghaiH+,rM+M+M);elseif(addr.equals(,hefei,)out.pnntlnCvtr+MH+”住址：+HH+“selectnaine=,addressn,+nhuainanhefeibeijiiigshanghaiH+HH+,rH+HH);老师的方法/*out.piiiitlii(HH);Stimgsl=Hhuamanif(addi.equals(nshaiighaiM)sl+=nselected=selected,sl+=,shanghaiH;out.prmtlii(sl);Suings2=Hoptionname=beijmgH;/huaina

14、nif(addr.equals(nbeijmgn)s2+=nselected=selected,)s2+=,beijmgH;out.prmthi(s2);out.prmthi(nH);*/out.prmtlii(,n+“inputtype=submitvahie=”提交+H+H+inputtype=Tesetvalue=重置+HH+);out.printing,r);out.printingH);out.printing/center”)；out.pimthi(HH);out.pimthi(HH);out.flushQ;out.closeQ;)publicvoiddoPost(HttpSerx

15、detRequestrequest,HttpSeivletResponseresponse)tluowsSendetException.lOExceptiondoGet(request,response);)publicclassUpdateextendsHttpServletpublicvoiddoGet(HttpSer4etRequestrequest,HttpSeivletResponseresponse)tluowsSendetException.lOException/编码问题response.setContentType(ntext/htnil;cliarset=GBKH)y/浏览

16、器显示的编码，默认的是isoresponse.setCliaiacteiEncodmg(GBK);/浏览器到数据库取数据时候使用的编码request.setCharacterEncoduig(GBK)y/浏览器到数据库存入数据时候所使用的编码方式必须为post方式才行的/获取修改页上的值mtuserid=Iiiteger.paiseIiit(request.getPaiaiiieter(Hid1H);Suingname=request.getParainetei(Hname1H);mtage=Integer.parseIiit(request.getPaiametei(Hage1H);Suin

17、gaddress=request.getPaiameter(naddiessH);/dao层IPeisoiiDaoperson=newPeisoiiDaonnplQ;Personp=newPerson();p.setld(userld);p.setName(name);IPeisoiiDaoperson=newPersoiiDaoUnplQ;list=person.seiAllPerson();request.setAttiibute(HlistnJist);equest.getRequustDispatcheC./SelAll.jsp),fdrwaid(】equest,response);publicvoiddoPost(HttpSerxdetRequestrequest,HttpSeivletResponseresponse)tluowsSendetException.lOExceptiondoGet(request,response);selectAH.jsptit1eJsp+Servlet+