public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
PostcodeGroupForm groupForm = (PostcodeGroupForm) form;
Connection conn = null;
try {
conn = DBManager.getConnection();
// conn.setAutoCommit(false);
PostcodeGroup groupData = new PostcodeGroup();
groupData.setGroupName(groupForm.getGroupName());
groupData.setDescription(groupForm.getDescription());
int groupId = SequenceManager.getNextVal(conn, "jxc.seq_postcode_group");
groupData.setId(groupId);
PostCodeSetDAO.insertGroup(conn, groupData);
/*PostcodeSet setData = new PostcodeSet();
setData.setPostcodeGroup(groupData);
for (int i = 0; i < groupForm.getPostcode().length; i ++) {
setData.setPostcode(groupForm.getPostcode()[i]);
setData.setPostFee(groupForm.getPostFee()[i]);
PostCodeSetDAO.insertSet(conn, setData);
}*/
// conn.commit();
} catch (Exception e) {
// conn.rollback();
throw new ServletException("[**an error occured when you create postcode group**]");
} finally {
if (conn != null && !conn.isClosed()) conn.close();
}
return mapping.findForward("success");
}
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
Connection conn = null;
MemberDAO memberDAO = new MemberDAO();
// String member_id = request.getParameter("member_id");
String member_id = "";
try {
conn = DBManager.getConnection();
/** 如果是callcenter系统，从sessin中取出会员信息，如果没有提示登录服务对象 * */
String iscallcenter = request.getParameter("iscallcenter");
if (iscallcenter != null && iscallcenter.equals("1")) {
CallCenterHander hander = new CallCenterHander(request.getSession());
if (hander.isOnService()) {
Member mb = hander.getServicedMember();
member_id = String.valueOf(mb.getID());
} else {
ControlledError ctlErr = new ControlledError();
ctlErr.setErrorTitle("操作错误");
ctlErr.setErrorBody("没有服务对象，请接入服务");
request.setAttribute(Constants.ERROR_KEY, ctlErr);
return mapping.findForward("controlledError");
}
}
String cardId = MemberDAO.getCard_ID(conn, Integer.parseInt(member_id));
request.setAttribute("cardId", cardId);
Collection memberGetMemberCol = memberDAO.MBR_GET_MBR_info(conn, member_id);
request.setAttribute("memberGetMemberCol", memberGetMemberCol);
return mapping.findForward("success");
} catch (SQLException se) {
throw new ServletException(se);
} finally {
try {
conn.close();
} catch (SQLException sqe) {
throw new ServletException(sqe);
}
}
}
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
HttpSession session = request.getSession();
User user = new User();
user = (User) session.getAttribute("user");
Connection conn = null;
CallableStatement cstmt = null;
MemberaddMoney memberaddMoney = new MemberaddMoney();
/*
* 取到所有值复选框的值
*/
String inputid[] = request.getParameterValues("inputid");
try {
conn = DBManager.getConnection();
for (int i = 0; i < inputid.length; i++) {
memberaddMoney.setID(Integer.parseInt(inputid[i]));
memberaddMoney.setMB_ID(0);
memberaddMoney.setORDER_ID(0);
memberaddMoney.setStatus(2);
memberaddMoney.setOPERATOR_ID(Integer.parseInt(user.getId()));
MemberaddMoneyDAO.update(conn, memberaddMoney);
}
return mapping.findForward("success");
} catch (SQLException se) {
throw new ServletException(se);
} finally {
try {
conn.close();
} catch (SQLException sqe) {
throw new ServletException(sqe);
}
}
}
/**
* 查询录入的书香卡
*
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws Exception
*/
public ActionForward query(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
MemberaddMoneyForm myForm = (MemberaddMoneyForm) form;
Connection conn = null;
try {
conn = DBManager.getConnection();
MemberaddMoneyDAO moneyDao = new MemberaddMoneyDAO();
Collection list = moneyDao.findSxkRecordsByCondition(conn, myForm);
request.setAttribute("list", list);
request.setAttribute("memberaddMoneyForm", myForm);
} catch (Exception e) {
throw new ServletException();
} finally {
if (conn != null) {
conn.close();
}
}
return mapping.findForward("query");
}
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
RoleForm rf = (RoleForm) form;
Role role = new Role();
PropertyUtils.copyProperties(role, rf);
Connection conn = null;
System.out.println("role delete 000000");
try {
// DataSource dts = getDataSource(request);
conn = DBManager.getConnection();
// check if the role is in use
conn.setAutoCommit(false);
UserRoleDAO userRoleDao = new UserRoleDAO();
Collection userRoleCol = userRoleDao.find(conn, role);
System.out.println("role delete 111111111");
if (userRoleCol != null && userRoleCol.size() > 0) {
System.out.println("role delete 222222222");
ControlledError ctlErr = new ControlledError();
ctlErr.setErrorTitle("删除角色错误");
ctlErr.setErrorBody("角色正在使用中，不能删除");
request.setAttribute(com.magic.crm.util.Constants.ERROR_KEY, ctlErr);
return mapping.findForward("controlledError");
}
RoleDAO dao = new RoleDAO();
RoleRightDAO roleRightDao = new RoleRightDAO();
roleRightDao.delete(conn, role);
System.out.println("role delete 3333333");
dao.delete(conn, role);
System.out.println("role delete 4444444");
conn.commit();
return mapping.findForward("success");
} catch (SQLException se) {
throw new ServletException(se);
} finally {
try {
conn.close();
} catch (SQLException sqe) {
throw new ServletException(sqe);
}
}
}