Пример #1
0
  public void create(EventBean newEvent) throws DAOException {
    try {
      Transaction.begin();
      EventBean dbEvent = factory.create();
      factory.copyInto(newEvent, dbEvent);
      Transaction.commit();

    } catch (RollbackException e) {
      throw new DAOException(e);
    } finally {
      if (Transaction.isActive()) Transaction.rollback();
    }
  }
Пример #2
0
 public EventBean lookup(int id) throws DAOException {
   try {
     return factory.lookup(id);
   } catch (RollbackException e) {
     throw new DAOException(e);
   }
 }
Пример #3
0
 public void create(UserBean user) throws DAOException {
   String origID = user.getUserID();
   try {
     Transaction.begin();
     user.setUserID(user.getUserID().toLowerCase());
     UserBean dBUser = factory.create(user.getUserID());
     factory.copyInto(user, dBUser);
     Transaction.commit();
   } catch (DuplicateKeyException e) {
     throw new DAOException("UserID: " + user.getUserID() + "already exists.");
   } catch (RollbackException e) {
     throw new DAOException(e);
   } finally {
     if (Transaction.isActive()) Transaction.rollback();
   }
 }
Пример #4
0
 public synchronized Course lookup(String courseName) throws MyDAOException {
   try {
     return factory.lookup(courseName);
   } catch (RollbackException e) {
     throw new MyDAOException(e);
   }
 }
Пример #5
0
  public void create(Community community) throws DAOException {
    try {
      Transaction.begin();
      Community dbcommunity = factory.create(community.getName());
      factory.copyInto(community, dbcommunity);

      Transaction.commit();

    } catch (DuplicateKeyException e) {
      throw new DAOException("Community named " + community.getName() + " already exists.");
    } catch (RollbackException e) {
      throw new DAOException(e);
    } finally {
      if (Transaction.isActive()) Transaction.rollback();
    }
  }
Пример #6
0
 public UserBean lookup(String userID) throws DAOException {
   try {
     return factory.lookup(userID);
   } catch (RollbackException e) {
     throw new DAOException(e);
   }
 }
Пример #7
0
 public EventBean[] getEventsByLocation(int id) {
   try {
     EventBean[] list = factory.match(MatchArg.equals("locationid", id));
     return list;
   } catch (RollbackException e) {
     throw new DAOException(e);
   }
 }
Пример #8
0
 public Community lookup(String name) throws DAOException {
   try {
     Community comm = factory.lookup(name);
     return comm;
   } catch (RollbackException e) {
     throw new DAOException(e);
   }
 }
Пример #9
0
  public synchronized List<Note> getSelectedCourseNotesList(String courseSelected)
      throws MyDAOException {
    BeanFactory<Note> factory;
    ArrayList<Note> al = new ArrayList<Note>();
    try {
      BeanTable<Note> table =
          BeanTable.getSQLInstance(Note.class, "fanc_note", jdbcDriver, jdbcURL);

      factory = table.getFactory();
      al =
          new ArrayList(
              Arrays.asList(factory.match(MatchArg.equals("courseName", courseSelected))));
    } catch (RollbackException e) {
      throw new MyDAOException(e);
    }

    return al;
  }
Пример #10
0
 public EventBean[] getAllEvents() throws DAOException {
   try {
     EventBean[] list = factory.match();
     Arrays.sort(list);
     return list;
   } catch (RollbackException e) {
     throw new DAOException(e);
   }
 }
Пример #11
0
 public Community[] getCommunityByMovie(String rM) throws DAOException {
   try {
     Community[] result = factory.match(MatchArg.contains("relatedMovie", rM));
     return result;
   } catch (RollbackException e) {
     // TODO Auto-generated catch block
     throw new DAOException(e);
   }
 }
Пример #12
0
  public EventBean[] getMyEvents(String userid) throws DAOException {
    try {

      EventBean[] list = factory.match(MatchArg.equals("userid", userid));
      Arrays.sort(list);
      return list;
    } catch (RollbackException e) {
      throw new DAOException(e);
    }
  }
Пример #13
0
  public void delete(int id, String owner) throws DAOException {
    try {
      Transaction.begin();
      EventBean p = factory.lookup(id);

      if (p == null) {
        throw new DAOException("Event does not exist: id=" + id);
      }

      if (!owner.equals(p.getUserId())) {
        throw new DAOException("Event not owned by " + owner);
      }
      factory.delete(id);
      Transaction.commit();
    } catch (RollbackException e) {
      throw new DAOException(e);
    } finally {
      if (Transaction.isActive()) Transaction.rollback();
    }
  }
Пример #14
0
 public Community[] search(String key) throws DAOException {
   try {
     Community[] oResults = factory.match(MatchArg.containsIgnoreCase("name", key));
     List<Community> list = Arrays.asList(oResults);
     Collections.sort(list, Community.REVERSE_TIMEORDER);
     Community[] results = (Community[]) list.toArray();
     return results;
   } catch (RollbackException e) {
     throw new DAOException(e);
   }
 }
Пример #15
0
 public Community[] getAllCommunities() throws DAOException {
   try {
     Community[] oResults = factory.match();
     List<Community> list = Arrays.asList(oResults);
     Collections.sort(list, Community.REVERSE_TIMEORDER);
     Community[] results = (Community[]) list.toArray();
     return results;
   } catch (RollbackException e) {
     throw new DAOException(e);
   }
 }
Пример #16
0
 public void updateUserCount(int x, String name) throws DAOException {
   try {
     Transaction.begin();
     Community comm = factory.lookup(name);
     comm.setUserCount(comm.getUserCount() + x);
     Transaction.commit();
   } catch (RollbackException e) {
     throw new DAOException(e);
   } finally {
     if (Transaction.isActive()) Transaction.rollback();
   }
 }
Пример #17
0
 @Override
 public synchronized List<String> getAllCourses() throws MyDAOException {
   try {
     Course[] courseArrList = factory.match();
     ArrayList<String> al = new ArrayList<String>();
     for (Course course : courseArrList) {
       al.add(course.getCourseName());
     }
     return al;
   } catch (RollbackException e) {
     throw new MyDAOException(e);
   }
 }
Пример #18
0
 @Override
 public synchronized Course createCourse(String courseName, String createdBy)
     throws MyDAOException {
   try {
     Transaction.begin();
     Course newCourse = factory.create(courseName);
     newCourse.setCreatedBy(createdBy);
     Transaction.commit();
     return newCourse;
   } catch (DuplicateKeyException e) {
     throw new MyDAOException("A course with this name already exists.");
   } catch (RollbackException e) {
     throw new MyDAOException(e);
   }
 }
Пример #19
0
  public void setEvent(int eventid, String userid) throws DAOException {
    try {
      Transaction.begin();
      UserBean dbUser = factory.lookup(userid);

      if (dbUser == null) {
        throw new DAOException("User " + userid + " no longer exists");
      }

      dbUser.seteventAttendingID(eventid);
      Transaction.commit();
    } catch (RollbackException e) {
      throw new DAOException(e);
    } finally {
      if (Transaction.isActive()) Transaction.rollback();
    }
  }