public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
VipChildForm vipChildForm = (VipChildForm) form;
SmsVipManager.initialize();
if (VipChildForm.CREATE.equalsIgnoreCase(vipChildForm.getFormType())) {
return doCreateVipChild(mapping, form, request, response);
} else if (VipChildForm.UPDATE.equalsIgnoreCase(vipChildForm.getFormType())) {
return doUpdateVipChild(mapping, form, request, response);
} else {
request.setAttribute("message", "系統參數錯誤，請回報系統管理人員。錯誤類別：" + this.getClass());
return mapping.findForward(MESSAGE);
}
}
private ActionForward doCreateVipChild(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response) {
VipChildForm vipChildForm = (VipChildForm) form;
boolean isCreateSuccess = false;
try {
// SmsVipManager.initialize();
// SmsVipManager.beginTransaction();
// SmsVipManager.setAutoCloseSession(false);
int id = SmsVipManager.retrieveUserIdByName(vipChildForm.getUsername());
if (id == 0) {
request.setAttribute(
"message", "無法搜尋到使用者名稱為： " + vipChildForm.getUsername() + " 之使用者! 以致無法完成相關資料建檔");
return mapping.findForward(MESSAGE);
}
vipChildForm.setVipChildName(Tool.encodeISO88591ToBig5(vipChildForm.getVipChildName()));
isCreateSuccess =
SmsVipManager.createChildByUserId(
id,
vipChildForm.getVipChildName(),
DateUtil.getSqlDateFromString(vipChildForm.getVipChildBirthday(), pattern),
vipChildForm.getVipChildSex());
log(
AccountManager.currentUser(request)
+ " update vip child "
+ vipChildForm.getVipChildName()
+ "; result: "
+ isCreateSuccess);
// SmsVipManager.endTransaction();
} catch (Exception e) {
e.printStackTrace();
isCreateSuccess = false;
// SmsVipManager.rollbackTransaction();
request.setAttribute("message", "錯誤代碼：" + e.getMessage());
} finally {
}
/** let jsp page can submit form with an id */
request.setAttribute("username", vipChildForm.getUsername());
if (isCreateSuccess) return mapping.findForward(SUCCESS);
else {
request.setAttribute(
"message",
"無法新增孩童資料，姓名："
+ vipChildForm.getVipChildName()
+ "生日："
+ vipChildForm.getVipChildBirthday()
+ "，請確認關鍵字'姓名'無重複，謝謝！"
+ (request.getAttribute("message") != null ? request.getAttribute("message") : ""));
return mapping.findForward(MESSAGE);
}
}
private ActionForward doUpdateVipChild(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response) {
VipChildForm vipChildForm = (VipChildForm) form;
boolean isUpdateSuccess = false;
try {
SmsVipManager.initialize();
SmsVipManager.beginTransaction();
int id = SmsVipManager.retrieveUserIdByName(vipChildForm.getUsername());
if (id == 0) {
request.setAttribute(
"message", "無法搜尋到使用者名稱為： " + vipChildForm.getUsername() + " 之使用者! 以致無法完成相關資料建檔");
return mapping.findForward(MESSAGE);
}
vipChildForm.setVipChildName(Tool.encodeISO88591ToBig5(vipChildForm.getVipChildName()));
isUpdateSuccess =
SmsVipManager.updateChildByUserIdAndChildName(
vipChildForm.getUsername(),
vipChildForm.getIdx(),
vipChildForm.getVipChildName(),
DateUtil.getSqlDateFromString(vipChildForm.getVipChildBirthday(), pattern),
vipChildForm.getVipChildSex());
System.out.println(
AccountManager.currentUser(request)
+ " update vip child "
+ vipChildForm.getVipChildName()
+ "; result: "
+ isUpdateSuccess);
SmsVipManager.endTransaction();
} catch (Exception e) {
e.printStackTrace();
isUpdateSuccess = false;
SmsVipManager.rollbackTransaction();
request.setAttribute("message", "Un-catched Exception!");
}
/** let jsp page can submit form with an id */
request.setAttribute("username", vipChildForm.getUsername());
if (isUpdateSuccess) {
String path = mapping.findForward(SUCCESS).getPath() + "&name=" + vipChildForm.getUsername();
ActionForward af = new ActionForward(path);
return af;
} else {
request.setAttribute(
"message",
"無法新增孩童資料，姓名："
+ vipChildForm.getVipChildName()
+ "生日："
+ vipChildForm.getVipChildBirthday()
+ "，請確認關鍵字'姓名'無重複，謝謝！");
return mapping.findForward(MESSAGE);
}
}