예제 #1
0
  public void updateAdmin(Admin admin) throws DBException {
    Session session;
    Transaction tx = null;
    try {
      session = HibernateSessionFactory.currentSession();
      tx = session.beginTransaction();
      session.update(admin);
      tx.commit();
    } catch (HibernateException e) {

      try {
        tx.rollback();

      } catch (HibernateException e1) {
        e1.printStackTrace();
      }
      e.printStackTrace();
      throw new DBException("获取对象失败!");
    } finally {
      try {
        HibernateSessionFactory.closeSession();
      } catch (HibernateException e) {
        e.printStackTrace();
      }
    }
  }
 public void updatePerson(Person person) throws HibernateException {
   Session session = HibernateSessionFactory.currentSession();
   Transaction transaction = session.beginTransaction();
   session.update(person);
   transaction.commit();
   HibernateSessionFactory.closeSession();
 }
 /**
  * Updates a class in database
  *
  * @param c IClass to update
  * @throws HibernateException
  */
 public static void update(IClass c) throws HibernateException {
   Session s = null;
   Transaction tx = null;
   try {
     s = HibernateUtil.currentSession();
     tx = s.beginTransaction();
     s.update(c);
     tx.commit();
   } catch (HibernateException e) {
     e.printStackTrace();
     if (tx != null) tx.rollback();
     throw e;
   } finally {
     HibernateUtil.closeSession();
   }
 }
예제 #4
0
  public ActionForward perform(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response) {
    // Extract attributes we will need
    ActionErrors errors = this.getActionErrors(request.getSession());
    Logger log = Logger.getLogger(EditCustPartyAction.class.getName());
    Locale locale = getLocale(request);
    MessageResources messages = getResources();
    String action = request.getParameter("action");
    String openType = request.getParameter("openType");

    log.info("action=" + action);
    try {
      String PartyId = request.getParameter("PartyId");
      String description = request.getParameter("description");
      // String ParentpartyId = request.getParameter("ParentpartyId");
      String address = request.getParameter("address");
      String postcode = request.getParameter("postcode");
      String telecode = request.getParameter("telecode");
      String note = request.getParameter("note");
      String role = request.getParameter("role");
      String ChineseName = request.getParameter("ChineseName");
      String AccountId = request.getParameter("AccountId");
      String IndustryId = request.getParameter("IndustryId");
      String t2code = request.getParameter("t2code");
      String AccountCode = request.getParameter("AccountCode");
      String CustPartyTypeId = "PARTY_GROUP";

      if (address == null) address = "";
      if (postcode == null) postcode = "";
      if (telecode == null) telecode = "";
      if (note == null) note = "";
      if (role == null) role = "";
      if (ChineseName == null) ChineseName = "";
      if (AccountId == null) AccountId = "0";
      if (IndustryId == null) IndustryId = "0";
      if (t2code == null) t2code = "";
      if (AccountCode == null) AccountCode = "";

      net.sf.hibernate.Session hs = Hibernate2Session.currentSession();
      Transaction tx = null;
      if (action == null) action = "view";

      if (!isTokenValid(request)) {
        if (action.equals("create") || action.equals("update")) {
          action = "view";
        }
      }
      saveToken(request);

      if (action.equals("view")) {
        log.info(action);
        CustomerProfile CustParty = null;
        if (!((PartyId == null) || (PartyId.length() < 1)))
          CustParty = (CustomerProfile) hs.load(CustomerProfile.class, PartyId);

        request.setAttribute("CustParty", CustParty);

        if ("dialogView".equals(openType)) {
          return (mapping.findForward("dialogView"));
        } else {
          return (mapping.findForward("view"));
        }
      }
      if (action.equals("create")) {

        if ((PartyId == null) || (PartyId.length() < 1)) {
          CustomerService cs = new CustomerService();
          PartyId = cs.getCustomerNo(hs);
        }
        if ((description == null) || (description.length() < 1))
          actionDebug.addGlobalError(errors, "error.context.required");

        if (!errors.empty()) {
          saveErrors(request, errors);
          return (new ActionForward(mapping.getInput()));
        }
        try {
          tx = hs.beginTransaction();

          CustomerProfile CustParty = new CustomerProfile();
          CustParty.setPartyId(PartyId);
          CustParty.setDescription(description);
          CustParty.setAddress(address);
          CustParty.setPostCode(postcode);
          CustParty.setTeleCode(telecode);
          CustParty.setNote(note);
          CustParty.setType("C");
          CustParty.setChineseName(ChineseName);
          CustParty.setAccountCode(AccountCode);
          Industry ind = (Industry) hs.load(Industry.class, new Long(IndustryId));
          CustParty.setIndustry(ind);
          CustomerAccount acc =
              (CustomerAccount) hs.load(CustomerAccount.class, new Long(AccountId));
          CustParty.setAccount(acc);
          CustT2Code T2C = (CustT2Code) hs.load(CustT2Code.class, t2code);
          CustParty.setT2Code(T2C);

          PartyType CustPartyType = (PartyType) hs.load(PartyType.class, CustPartyTypeId);
          CustParty.setPartyType(CustPartyType);

          Set mset = CustParty.getPartyRoles();
          if (mset == null) {
            mset = new HashSet();
          }
          mset.add((RoleType) hs.load(RoleType.class, role));
          CustParty.setPartyRoles(mset);

          hs.save(CustParty);
          hs.flush();
          tx.commit();

          // edit prospect Company
          String prospectCompanyId = request.getParameter("prospectCompanyId");
          if (prospectCompanyId != null
              && !prospectCompanyId.equals("")
              && !prospectCompanyId.equals("null")) {
            tx = hs.beginTransaction();
            com.aof.component.prm.bid.ProspectCompany prospect =
                (com.aof.component.prm.bid.ProspectCompany)
                    hs.load(
                        com.aof.component.prm.bid.ProspectCompany.class,
                        new Long(prospectCompanyId));

            prospect.setName(description);
            prospect.setAddress(address);
            prospect.setPostCode(postcode);
            prospect.setTeleNo(telecode);
            prospect.setChineseName(ChineseName);
            prospect.setIndustry(IndustryId);
            prospect.setCustomerGroup(AccountId);
            prospect.setStatus("Existing");

            hs.update(prospect);
            hs.flush();
            tx.commit();
          }

          request.setAttribute("CustParty", CustParty);
          log.info("go to >>>>>>>>>>>>>>>>. view forward");
        } catch (Exception e) {
          e.printStackTrace();
        }

        if ("dialogView".equals(openType)) {
          return (mapping.findForward("dialogView"));
        } else {
          return (mapping.findForward("view"));
        }
      }

      if (action.equals("update")) {
        if ((PartyId == null) || (PartyId.length() < 1))
          actionDebug.addGlobalError(errors, "error.context.required");

        if (!errors.empty()) {
          saveErrors(request, errors);
          return (new ActionForward(mapping.getInput()));
        }

        tx = hs.beginTransaction();
        CustomerProfile CustParty = (CustomerProfile) hs.load(CustomerProfile.class, PartyId);

        CustParty.setDescription(description);
        CustParty.setAddress(address);
        CustParty.setPostCode(postcode);
        CustParty.setTeleCode(telecode);
        CustParty.setNote(note);

        CustParty.setChineseName(ChineseName);
        Industry ind = (Industry) hs.load(Industry.class, new Long(IndustryId));
        CustParty.setIndustry(ind);
        CustomerAccount acc = (CustomerAccount) hs.load(CustomerAccount.class, new Long(AccountId));
        CustParty.setAccount(acc);
        CustT2Code T2C = (CustT2Code) hs.load(CustT2Code.class, t2code);
        CustParty.setT2Code(T2C);
        CustParty.setAccountCode(AccountCode);
        hs.update(CustParty);
        tx.commit();

        request.setAttribute("CustParty", CustParty);
        if ("dialogView".equals(openType)) {
          return (mapping.findForward("dialogView"));
        } else {
          return (mapping.findForward("view"));
        }
      }

      if (action.equals("delete")) {
        if ((PartyId == null) || (PartyId.length() < 1))
          actionDebug.addGlobalError(errors, "error.context.required");
        if (!errors.empty()) {
          saveErrors(request, errors);
          return (new ActionForward(mapping.getInput()));
        }

        tx = hs.beginTransaction();
        CustomerProfile CustParty = (CustomerProfile) hs.load(CustomerProfile.class, PartyId);
        log.info("PartyId=" + CustParty.getPartyId());
        hs.delete(CustParty);
        tx.commit();

        return (mapping.findForward("after_delete"));
      }
      if (!errors.empty()) {
        saveErrors(request, errors);
        return (new ActionForward(mapping.getInput()));
      }
      if ("dialogView".equals(openType)) {
        return (mapping.findForward("dialogView"));
      } else {
        return (mapping.findForward("view"));
      }
    } catch (Exception e) {
      e.printStackTrace();
      log.error(e.getMessage());

      // cannot delete due to the database constraints
      if (action.equals("delete")) {
        request.setAttribute("errorSign", "Cannot delete the record !");
      }

      if ("dialogView".equals(openType)) {
        return (mapping.findForward("dialogView"));
      } else {
        return (mapping.findForward("view"));
      }
    } finally {
      try {
        Hibernate2Session.closeSession();
      } catch (HibernateException e1) {
        log.error(e1.getMessage());
        e1.printStackTrace();
      } catch (SQLException e1) {
        log.error(e1.getMessage());
        e1.printStackTrace();
      }
    }
  }
예제 #5
0
  public ActionForward list4Add(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response)
      throws Exception {

    //	Logger log = Logger.getLogger(EditPreSaleProjectAction.class.getName());
    String action = request.getParameter("formAction");
    //	log.info("action=" + action);

    String strDate = request.getParameter("date");
    Date date = UtilDateTime.toDate2(strDate + " 00:00:00.000");
    String room = request.getParameter("room");

    if (action == null) {
      action = "view";
    }

    try {
      Session hs = Hibernate2Session.currentSession();
      Transaction tx = null;

      if (action.equals("create")) {

        String personId = request.getParameter("iPerson");
        String startTime = request.getParameter("iStartTime");
        String endTime = request.getParameter("iEndTime");

        BookingRoomVO tmpValue = new BookingRoomVO();
        UserLogin person = new UserLogin();

        tmpValue.setBookingDate(date);
        tmpValue.setRoom(room);
        tmpValue.setStartTime(startTime);
        tmpValue.setEndTime(endTime);

        tx = hs.beginTransaction();

        person = (UserLogin) hs.load(person.getClass(), personId);
        tmpValue.setPerson(person);
        hs.save(tmpValue);

        hs.flush();
        tx.commit();
      }

      if (action.equals("remove")) {

        Long id = Long.valueOf(request.getParameter("bookingId"));

        tx = hs.beginTransaction();

        BookingRoomVO tmpValue = (BookingRoomVO) hs.load(BookingRoomVO.class, id);
        hs.delete(tmpValue);

        hs.flush();
        tx.commit();
      }

      if (action.equals("update")) {

        String bookingId[] = request.getParameterValues("bookingId");
        String startTime[] = request.getParameterValues("startTime");
        String endTime[] = request.getParameterValues("endTime");

        BookingRoomVO tmpValue = new BookingRoomVO();

        tx = hs.beginTransaction();

        int rowSize = java.lang.reflect.Array.getLength(bookingId);
        for (int i = 0; i < rowSize; i++) {
          Long id = null;
          if (bookingId[i] != null && bookingId[i].length() > 0) {
            id = Long.valueOf(bookingId[i]);
            tmpValue = (BookingRoomVO) hs.load(BookingRoomVO.class, id);
            tmpValue.setStartTime(startTime[i]);
            tmpValue.setEndTime(endTime[i]);
            hs.update(tmpValue);
          }
        }
        tx.commit();
        hs.flush();
      }

      if (action.equals("view")
          || action.equals("create")
          || action.equals("remove")
          || action.equals("update")) {

        request.setAttribute("dateAdd", strDate);
        request.setAttribute("roomAdd", room);

        tx = hs.beginTransaction();
        List valueList = null;

        Query query =
            hs.createQuery(
                "from BookingRoomVO as br where br.room=? and br.bookingDate=? order by br.startTime");
        query.setString(0, room);
        query.setDate(1, date);
        valueList = query.list();

        request.setAttribute("valueList", valueList);
        hs.flush();
        tx.commit();
      }
    } catch (Exception e) {
      e.printStackTrace();
      //	log.error(e.getMessage());
      return (mapping.findForward("view"));
    } finally {
      try {
        Hibernate2Session.closeSession();
      } catch (HibernateException e1) {
        //		log.error(e1.getMessage());
        e1.printStackTrace();
      } catch (SQLException e1) {
        //		log.error(e1.getMessage());
        e1.printStackTrace();
      }
    }
    return mapping.findForward("list4Add-success");
  }
  /**
   * Updates the persistent object in the database.
   *
   * @param obj The object to be updated.
   * @param session The session in which the object is saved.
   * @throws DAOException
   * @throws HibernateException Exception thrown during hibernate operations.
   */
  public void update(
      Object obj,
      SessionDataBean sessionDataBean,
      boolean isAuditable,
      boolean isSecureUpdate,
      boolean hasObjectLevelPrivilege)
      throws DAOException, UserNotAuthorizedException {

    boolean isAuthorized = true;
    try {
      if (isSecureUpdate) {
        if (null != sessionDataBean) {
          if (!(obj instanceof AbstractDomainObject) || !hasObjectLevelPrivilege) {
            isAuthorized =
                SecurityManager.getInstance(this.getClass())
                    .isAuthorized(
                        sessionDataBean.getUserName(),
                        obj.getClass().getName(),
                        Permissions.UPDATE);
            Logger.out.debug(
                " User's Authorization to update " + obj.getClass().getName() + " " + isAuthorized);
          } else {
            isAuthorized =
                SecurityManager.getInstance(this.getClass())
                    .isAuthorized(
                        sessionDataBean.getUserName(),
                        obj.getClass().getName() + "_" + ((AbstractDomainObject) obj).getId(),
                        Permissions.UPDATE);
            Logger.out.debug(
                " User's Authorization to update " + obj.getClass().getName() + " " + isAuthorized);
          }
        } else {
          isAuthorized = false;
          Logger.out.debug(
              " User's Authorization to update "
                  + obj.getClass().getName()
                  + "_"
                  + ((AbstractDomainObject) obj).getId()
                  + " "
                  + isAuthorized);
        }
      }

      if (isAuthorized) {
        session.update(obj);
        //                Object oldObj = retrieve(obj.getClass().getName(),
        // ((Auditable)obj).getId());
        //                if (obj instanceof Auditable && isAuditable)
        //                auditManager.compare((Auditable) obj, (Auditable)oldObj, "UPDATE");
        isUpdated = true;

      } else {
        throw new UserNotAuthorizedException("Not Authorized to update");
      }
    } catch (HibernateException hibExp) {
      // Logger.out.error(hibExp.getMessage(), hibExp);
      // throw new DAOException("Error in update", hibExp);
      throw handleError("", hibExp);
    }
    //        catch (AuditException hibExp)
    //        {
    //            throw handleError("", hibExp);
    //        }
    catch (SMException smex) {
      // Logger.out.error(smex.getMessage(), smex);
      // throw new DAOException("Error in update", smex);
      throw handleError("", smex);
    }
  }