课件课后练习代码经典案例

JavaStruts NETCTOSS资费列表显 请Struts2_corejar.zip（Struts2的Jar包）,建议使用struts2.18版本；不要使用拷贝Struts2的Jar包到WEB-INF/lib/下,基本功能jar包5个(2.1.8)。图-<?xmlversion="1.0"encoding="UTF-<web-app"h<filter-><!--/*-</filter-</web->新建页面<%@pagepageEncoding="utf-<form e.action"<inputname="name"type="text"<inputvalue="提交"type="submit"新建页 <%@pagepageEncoding="utf-e,新 packagepublicclasseActionprivateStringpublicStringexecute() System.out.println("name:"+if{returnreturnpublicStringgetName(){returnpublicvoidsetName(Stringname){=在Jsp页面<inputname=”name”type=”text”/>在action中会自动给属性privateStringnamename对应的getterAction中属性privateStringname; <?xmlversion="1.0"encoding="UTF-<!DOCTYPEstruts"-//ApacheSoftwareFoundation//DTDStrutsConfiguration"<packageoworld"extends="struts-<action <result<result 继承的包名，一般继承Su默认提供的u-dfaul包，该包中定义了很多Su2应用必须的组件（比如：器）；该ackae的位置在u-c-ja/u-dfaulm文件中 e.action e.action publicString <result>1）所对应的

图-

图-<?xmlversion="1.0"encoding="UTF-<web-app"h<filter-<filter-><url-pattern>/*</url-pattern><!--/*表示所有的请求都要经过该过滤器</filter-</web-><%@pagepageEncoding="utf-<form e.action"<inputname="name"type="text"<inputvalue="提交"type="submit"<%@pagepageEncoding="utf-e,packagepublicclasseActionprivateStringpublicStringexecute(){System.out.println("name:"+if{returnreturnpublicStringgetName(){returnpublicvoidsetName(Stringname){=<?xmlversion="1.0"encoding="UTF-<!DOCTYPEstruts"-//ApacheSoftwareFoundation//DTDStrutsConfiguration"<packageoworld"extends="struts-<action<result<result直接图- 图-修改<?xmlversion="1.0"encoding="UTF-<!DOCTYPEstruts"-//ApacheSoftwareFoundation//DTDStrutsConfiguration"<packagename=" oworld"extends="struts-default"<action<action</package>图-图-图-CREATETABLE NUMBER(4)CONSTRAINTCOST_ID_PKPRIMARY NOT CHAR(1)CONSTRAINTCHECK(STATUSIN DATEDEFAULTSYSDATE INSERTINTOCOSTVALUES(1,'5.9元套餐',20,5.9,0.4,0,'5.9元20INSERTINTOCOSTVALUES(2,'6.9元套餐',40,6.9,0.3,0,'6.9元40INSERTINTOCOSTVALUES(3,'8.5元套餐',100,8.5,0.2,0,'8.5元100INSERTINTOCOSTVALUES(4,'10.5元套餐',200,10.5,0.1,0,'10.5元200INSERTINTOCOSTVALUES(5,'计时',null,null,0.5,0,'0.5元/时,不使用INSERTINTOCOSTVALUES(6,'包月',null,20,null,0,'每月20 publicclassConnectionUtilsprivatestaticStringprivatestaticStringprivatestaticStringprivatestaticStringprivatestaticThreadLocal<Connection>tl=newstatictryPropertiesprops=newuser=password=url=driver=}catch(Exceptione)thrownewRuntimeException("数据库驱动加载错误", publicstaticConnectionopenConnection()throws{Connectioncon=if(con==null)con=DriverManager.getConnection(url,user,}return}publicstaticvoidcloseConnection()Connectioncon=if(con!=null)try}catch(SQLExceptione) }publicstaticvoidmain(String[]{Connectioncon=}}创建实体类

图-publicclassFeeprivateIntegerid;//资费privateStringfeeName;//资费名称privateIntegerbaseDuration;//包 privateFloatbaseCost;privateFloatunitCostprivateStringstatus//0：开通；1：暂停；privateStringdescr;//资费信息说明privateStringcreateTime;//创建日期privateStringstartTimepublicstaticFeetoFee(ResultSetrs)throws{Feefee=newFee();return publicIntegergetId()return}publicvoidsetId(Integerid)this.id=}publicStringgetFeeName()return}publicvoidsetFeeName(String{this.feeName=}publicIntegergetBaseDuration()return}publicvoidsetBaseDuration(Integer{this.baseDuration=}publicFloatgetBaseCost()return}publicpublicvoidsetBaseCost(FloatbaseCost)this.baseCost=}publicFloatgetUnitCost()return}publicvoid{this.unitCost=}publicStringgetStatus()return}publicvoidstatus)this.status=}publicStringgetDescr()return}publicvoidsetDescr(Stringdescr)this.descr=}publicStringgetCreateTime()return}publicvoidsetCreateTime(String{this.createTime=}publicStringgetStartTime()return publicvoidsetStartTime(StringstartTime)this.startTime=}}publicclassFeeDAOprivatestaticfinalStringfindAll="selectID,NAME,BASE_DURATIOpublicList<Fee>findAll()Connectioncon=PreparedStatementstmt=ResultSetrs=trycon=stmt=rs=List<Fee>list=newwhile(rs.next())Feefee=new return}catch(Exceptione)thrownew}finally{}}publicclassFeeListActionList<Fee>feeList=null;publicList<Fee>getFeeList(){returnpublicvoidsetFeeList(List<Fee>{this.feeList=publicStringFeeDAOfeeDAO=newFeeDAO();feeList=feeDAO.findAll();return"success";<?xmlversion="1.0"encoding="UTF-<!DOCTYPEstruts"-//ApacheSoftwareFoundation//DTDStrutsConfiguration"<packageoworld"extends="struts-default"<action配置<?xmlversion="1.0"encoding="UTF-<web-appversion="2.5"xmlns="h h>></web-拷贝netctoss项目中的样式表和到工程中，放置在如图-8所示的images和styles文件夹<%@pagelanguage="java"pageEncoding="UTF-<%@taglib/jsp/jstl/core"<!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN".<html<metahttp-equiv="Content-Type"content="text/html;charset=utf-<linktype="text/css"rel="stylesheet"media="all"<linktype="text/css"rel="stylesheet"media="all"<!--Logo<div<imgsrc="../images/logo.png"alt="logo"<ahref="#">[<!--Logo<!--导航区域开始--><div<ul <li><ahref="../index.html"<li><ahref="../role/role_list.html"<li><ahref="../admin/admin_list.html"<li><ahref="../fee/fee_list.html"<li><ahref="../account/account_list.html"<li><ahref="../service/service_list.html"<li><ahref="../bill/bill_list.html"<li><ahref="../report/report_list.html"<li><ahref="../user/user_info.html"<li><ahref="../user/user_modi_pwd.html"<!--导航区域结束--><!--主要区域开始--><div<formaction=""<!--排序--><div<input<input<input<inputtype="button"value="增加"class="btn_add"<divid="operate_result_info"<imgsrc="../images/close.png"<div<table<th>资费<thclass="width100">资费名称<th>基本时长<th>基本费用<th>单位费用<th>创建时间<th>开通时间<thclass="width50">状态<th<c:forEachitems="${feeList}"<td>${fee.baseDuration}小时<td>${fee.baseCost}元<td>${fee.unitCost}元/小时<c:iftest="${fee.status==0}"<c:iftest="${fee.status==1}"<c:iftest="${fee.status==2}"<c:iftest="${fee.status!=0&&<inputtype="button"value="启用"<inputtype="button"value="修改"<inputtype="button"value="删除"<p>业务说明：<br/>1、创建资费时，状态为暂停，记载创建时间；<br/>2、暂停状态下，可修改，可删除；<br/>34<!--分页--><div<ahref="#"><ahref="#"<a<a<a<a<ahref="#"><!--主要区域结束--><div<p>[源 公司图-CREATETABLE NUMBER(4)CONSTRAINTCOST_ID_PKPRIMARY NOT CHAR(1)CONSTRAINTCHECK(STATUSIN DATEDEFAULTSYSDATE INSERTINTOCOSTVALUES(1,'5.9元套餐',20,5.9,0.4,0,'5.9元20INSERTINTOCOSTVALUES(2,'6.9元套餐',40,6.9,0.3,0,'6.9元40INSERTINTOCOSTVALUES(3,'8.5元套餐',100,8.5,0.2,0,'8.5元100INSERTINTOCOSTVALUES(4,'10.5元套餐',200,10.5,0.1,0,'10.5元200INSERTINTOCOSTVALUES(5,'计时',null,null,0.5,0,'0.5元/时,不使用INSERTINTOCOSTVALUES(6,'包月',null,20,null,0,'每月20publicclassConnectionUtilsprivatestaticStringprivatestaticStringprivatestaticStringprivatestaticStringprivatestaticThreadLocal<Connection>tl=newstatictryPropertiesprops=newuser=password=url=driver=}catch(Exceptione)thrownewRuntimeException("数据库驱动加载错误", publicstaticConnectionopenConnection()throwsSQLExceptionConnectioncon=if(con==null)con=DriverManager.getConnection(url,user, return publicstaticvoidcloseConnection()Connectioncon=if(con!=null)try}catch(SQLExceptione)}}}publicstaticvoidmain(String[]throwsExceptionConnectioncon=}}publicclassFeeprivateIntegerid;//资费privateStringfeeName;//资费名称privateIntegerbaseDuration;//包 privateFloatbaseCost;privateFloatunitCostprivateStringstatus//0：开通；1：暂停；privateStringdescr;//资费信息说明privateStringcreateTime;//创建日期privateStringstartTime;publicstaticFeetoFee(ResultSetrs)throwsSQLExceptionFeefee=newreturn publicIntegergetId()return publicvoidsetId(Integerid)this.id= publicStringgetFeeName()return publicvoidsetFeeName(StringfeeName)this.feeName= publicIntegergetBaseDuration()return publicvoidsetBaseDuration(IntegerbaseDuration)this.baseDuration=}}publicFloatgetBaseCost()return}publicvoidsetBaseCost(Floatthis.baseCost=}{publicFloatgetUnitCost()return}publicvoidsetUnitCost(Floatthis.unitCost=}{publicStringgetStatus()return}publicvoidsetStatus(Stringthis.status=}{publicStringgetDescr()return}publicvoidsetDescr(Stringdescr)this.descr=}publicStringgetCreateTime(){returncreateTime; publicvoidsetCreateTime(StringcreateTime)this.createTime= publicStringgetStartTime()return}publicvoidsetStartTime(StringstartTime)this.startTime=}}publicclassFeeDAOprivatestaticfinalStringfindAll="selectID,NAME,BASE_DURATIOpublicList<Fee>findAll()Connectioncon=PreparedStatementstmt=ResultSetrs=trycon=stmt=rs=List<Fee>list=newwhile(rs.next())Feefee=newreturn}catch(Exception{thrownew}publicclassFeeListActionList<Fee>feeList=null;publicList<Fee>getFeeList(){return}publicvoidsetFeeList(List<Fee>feeList){this.feeList=feeList;}publicStringFeeDAOfeeDAO=newFeeDAO();feeList=feeDAO.findAll();return"success";}}<?xmlversion="1.0"encoding="UTF-<!DOCTYPEstruts"-//ApacheSoftwareFoundation//DTDStrutsConfiguration"<packageoworld"extends="struts-default"<action<?xmlversion="1.0"encoding="UTF-<web-appversion="2.5"xmlns="h h<filter->></web-<%@pagelanguage="java"pageEncoding="UTF-<%@taglib/jsp/jstl/core"<!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN".<html<metahttp-equiv="Content-Type"content="text/html;charset=utf-<linktype="text/css"rel="stylesheet"media="all"<linktype="text/css"rel="stylesheet"media="all"<!--Logo<div<imgsrc="../images/logo.png"alt="logo"<ahref="#">[<!--Logo<!--导航区域开始--><div<ul <li><ahref="../index.html"<li><ahref="../role/role_list.html"<li><ahref="../admin/admin_list.html"<li><ahref="../fee/fee_list.html"<li><a