资费的修改(struts2+jsp)

请求一打开修改页面
代码书写顺序
--DAO
--Action
--struts.xml
--JSP

请求二提交表单
代码书写顺序
--DAO
--Action
--struts.xml
--JSP

DAO：

public Cost findById(Integer id) throws DAOException {
	
	if(id == null){
		return null;
	}
	String sql = "select * from cost where id=?";
	Connection con = DBUtil.getConnection();
	try {
		PreparedStatement ps = con.prepareStatement(sql);
		ps.setObject(1, id);
		ResultSet rs = ps.executeQuery();
		if(rs.next()){
			Cost cost = createCost(rs);
			return cost;
		}
	} catch (SQLException e) {
		e.printStackTrace();
		throw new DAOException("用id查询资费信息失败", e);
	} finally{
		DBUtil.close(con);
	}
	
	return null;
}

public void Update(Cost cost) throws DAOException {
	if(cost==null){
		return;
	}
	String sql = "update cost set name=?,base_duration=?,base_cost=?, " +
			"unit_cost=?, descr=?, cost_type=? where id=?";
	Connection con = DBUtil.getConnection();
	
	try {
		PreparedStatement ps = con.prepareStatement(sql);
		ps.setObject(1, cost.getName());
		ps.setObject(2, cost.getBaseDuration());
		ps.setObject(3, cost.getBaseCost());
		ps.setObject(4, cost.getUnitCost());
		ps.setObject(5, cost.getDescr());
		ps.setObject(6, cost.getCostType());
		ps.setObject(7, cost.getId());
		ps.executeUpdate();
	} catch (SQLException e) {
		e.printStackTrace();
		throw new DAOException("更新资费数据失败",e);
	}finally{
		DBUtil.close(con);
	}
	
}

Action:
public class ToUpdateCostAction {
	public String execute(){
		ICostDAO dao = DAOFactory.getCostDAO();
		try {
			cost = dao.findById(id);
		} catch (DAOException e) {
			e.printStackTrace();
			return "error";
		}
		
		return "success";
	}
	
	
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public Cost getCost() {
		return cost;
	}
	public void setCost(Cost cost) {
		this.cost = cost;
	}
	//input
	private Integer id;
	//output
	private Cost cost;
}

public class UpdateCostAction {
	
	public String execute(){
		ICostDAO dao = DAOFactory.getCostDAO();
		
		try {
			dao.Update(cost);
		} catch (DAOException e) {
			e.printStackTrace();
			return "error";
		}
		
		return "success";
	}
	
	
	public Cost getCost() {
		return cost;
	}

	public void setCost(Cost cost) {
		this.cost = cost;
	}

	//output
	private Cost cost;
}

struts.xml

<!-- 打开修改页面 -->
<action name="toUpdateCost" class="netctoss.action.ToUpdateCostAction">
	<result name="success">
		/WEB-INF/cost/updateCost.jsp
	</result>
</action>
<!-- 保存修改 -->
<action name="updateCost" class="netctoss.action.UpdateCostAction">
	<result name="success" type="redirectAction">
		findCost
	</result>
</action>

Jsp:

<!--findCost.jsp点修改-->
<input type="button" value="修改" class="btn_modify" οnclick="location.href='toUpdateCost?id=<s:property value="id"/>';" />

<!--updateCost.jsp用到了ui标签-->
 <form action="updateCost" method="post" class="main_form">
	<div class="text_info clearfix"><span>资费ID：</span></div>
	<div class="input_info"><s:textfield name="cost.id" cssClass="readonly" readonly="true"/></div>
	<div class="text_info clearfix"><span>资费名称：</span></div>
	<div class="input_info">
	    <s:textfield name="cost.name" cssClass="width300"/>
	    <span class="required">*</span>
	    <div class="validate_msg_short">50长度的字母、数字、汉字和下划线的组合</div>
	</div>
	<div class="text_info clearfix"><span>资费类型：</span></div>
	<div class="input_info fee_type">
		<s:radio name="cost.costType" list="#{'1':'包月','2':'套餐','3':'记时'}" οnclick="feeTypeChange(this.value);"/>
	</div>
	<div class="text_info clearfix"><span>基本时长：</span></div>
	<div class="input_info">
	    <s:textfield name="cost.baseDuration" cssClass="width100" />
	    <span class="info">小时</span>
	    <span class="required">*</span>
	    <div class="validate_msg_long">1-600之间的整数</div>
	</div>
	<div class="text_info clearfix"><span>基本费用：</span></div>
	<div class="input_info">
	    <s:textfield name="cost.baseCost" cssClass="width100" />
	    <span class="info">元</span>
	    <span class="required">*</span>
	    <div class="validate_msg_long">0-99999.99之间的数值</div>
	</div>
	<div class="text_info clearfix"><span>单位费用：</span></div>
	<div class="input_info">
	    <s:textfield name="cost.unitCost" cssClass="width100" />
	    <span class="info">元/小时</span>
	    <span class="required">*</span>
	    <div class="validate_msg_long">0-99999.99之间的数值</div>
	</div>   
	<div class="text_info clearfix"><span>资费说明：</span></div>
	<div class="input_info_high">
	    <s:textarea name="cost.descr" cssClass="width300 height70"/>
	    <div class="validate_msg_short">100长度的字母、数字、汉字和下划线的组合</div>
	</div>                    
	<div class="button_info clearfix">
	    <input type="submit" value="保存" class="btn_save"  οnclick="showResult();" />
	    <input type="button" value="取消" class="btn_save" />
	</div>
    </form>
<!--javascript-->
 function showResult() {
	showResultDiv(true);
	window.setTimeout("showResultDiv(false);", 3000);
    }