请求一打开修改页面
代码书写顺序
--DAO
--Action
--struts.xml
--JSP
请求二提交表单
代码书写顺序
--DAO
--Action
--struts.xml
--JSP
struts.xml
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);
}