課件課后練習代碼經(jīng)典案例

SERVLET&JSP員工管理——TCP/IP員工管理——TCP/IPTCP/IPMonitor相當于一個服務器。1)“Customize”選項選擇你需要的模板（此處我需要HTMLBasicTem打開TCP/IP<bodystyle="font-<formaction="add":<input薪水:<input:<input1.4<inputtype="submit"value=publicpublicclassAddEmpServletextendspublicvoidservice(HttpServletRequestrequest,HttpServletResponseresponse)throwsStringname=request.getParameter("name");doublesalary=Double.parseDouble(<?xmlversion="1.0"encoding="UTF-<web-app" >>intage=10.System.oSystem.out.println("salary:"+System.out.println("age:"+}}<bodystyle="font-<formaction="add"method="get"或者改為post:<input薪水:<input:<input<inputtype="submit"value=<?xmlversion="1.0"encoding="UTF-<web-app" packageimportimportimportimportimportimportimportimportimportimportpublicclassAddEmpServletextendspublicvoidservice(HttpServletRequestHttpServletResponsethrowsStringname=doublesalary=intage=System.out.println("name:"+System.out.println("salary:"+System.out.println("age:"+ } >><metahttp-equiv="content-type"content="text/html;charset=utf-8">

<bodystyle="font-<formaction="add":<input薪水:<input:<input<inputtype="submit"value=packageimportimportimportimportimportimportimportimportimportimportpublicclassAddEmpServletextendspublicvoidservice(HttpServletRequestHttpServletResponsethrowsStringname=doublesalary=intage=System.out.println("name:"+System.out.println("salary:"+System.out.println("age:"+PrintWriterout=}}<?xml<?xmlversion="1.0"encoding="UTF-<web-app"h></servlet->3.4注意：勾選“ConfiguretheMySQLServernow”（默認createtableidbigintprimarykeyauto_increment, --主鍵自增長namevarchar(50)unique, --mysql沒有varchar2salarydouble,ageintcreatetableidbigintprimarykeyauto_increment,usernamevarchar(50)unique,nameagegendarchar(1),birthdaydate,salarydouble,--info--＂b,, ＂b,,15p心1ioe1ass的杠呵S勻"lgtextendSHttpsemleti p心 S虹V扛汜(H七七pservle江也屯est亞平 throwsSm”LetEx己eption,:IOlption{ 22工equ色stsetcha.racterEn,oodin,g(11utf-811);,St工ingn皿芒＝re于正江getPa工，血eter{＇Ina立“');doublesal扛y=D0心leparseDOtible.EequestgetP扛礎ete士("sa1a巧”)), =工nteg釭.p&rseint(立KE比江，getPar.amete以Syst.emout.p立nt1n(＂nan也”+nan“jSyst足玄m.out.p工in.tln.("sa.la.工滬 +salary)syst礎，out.p過n仁 +,ct中已II數(shù)據(jù)co皿ectionconn=t巧y(Class.forNam釵"com.my:sq1.j心c.Drconn=DriverMan.getConnec巨39“3屯:>c:my:sql/loca.lhost330,6/jdl109,士01230123456789012444444444455-5E工epamedStat己心ntp工ep=conn.p工epareStatem.enp工ep.sets七工i.ng(1,n皿0)p工ep.setint(l, ；p工ep.exe叩比心p心ato(工令sponse.setiConten七屯于rrte歡／html;cha工set=utf-P丘比如.ite工out=response.g·et工ite工0out.println("<bodystyle="font-<formaction="add":<input薪水:<input:<input<inputtype="submit"value= publicclassAddEmpServletextendsHttpServlet{02.publicvoidservice(HttpServletRequestHttpServletResponsethrowsStringname=doublesalary=intage=System.out.println("name:"+System.out.println("salary:"+System.out.println("age:"+age); Connectionconn=tryconn=PreparedStatementprep"insertintot_emp(name,salary,age)"prep.setString(1,prep.setDouble(2,prep.setInt(3,PrintWriterout=try}catch(SQLExceptione){}}}}}<metahttp-equiv="Content-<title>Inserttitle<bodystyle="font-<ahref="addEmp.html">重試"<ahref='list'>"}catch(Exceptione)//step1//step2thrownew50.inally{<?xmlversion="1.0"encoding="UTF-<web-app <!--方式1--><!--方式--packageimportimportjava.io.PrintWriter;importimportimportimportimportimportimportimportimportpublicclassListEmpServletextendspublicvoidservice(HttpServletRequestHttpServletResponsethrows Connectionconn=tryconnStatementstatResultSetrst="select*fromt_emp");PrintWriterout"<tableborder='1'""width='60%'""cellpadding='0'"out.println("<tr>""<td>id</td>" </td>""<td>薪水</td>" longidStringnamedoublesalaryintage+id+"</td><td>+name++salary+"+age+}"<ahref='addEmp.html'>"}catch(Exceptione)thrownew}finally{try}catch(SQLExceptione)}}}}}publicpublicclassAddEmpServletextendspublicvoidservice(HttpServletRequestHttpServletResponsethrowsStringname=doublesalary=intage=System.out.println("name:"+System.out.println("salary:"+System.out.println("age:"+age); Connectionconn=try

conn=PreparedStatementprep"insertintot_emp(name,salary,age)"prep.setString(1,prep.setDouble(2,prep.setInt(3,PrintWriterout="<ahref='list'>"try}catch(SQLExceptione){}}}}}package}catch(Exceptione)//step1//step2thrownew53.inally{importimportimportimportimportimportimportimportimportimportimportpublicclassListEmpServletextendspublicvoidservice(HttpServletRequestHttpServletResponsethrows Connectionconn=tryconnStatementstatResultSetrst="select*fromt_emp");PrintWriterout"<tableborder='1'""width='60%'""cellpadding='0'"out.println("<tr>""<td>id</td>" </td>""<td>薪水</