public CourseDAOFactoryImpl(String jdbcDriver, String jdbcURL) throws MyDAOException {
    this.jdbcDriver = jdbcDriver;
    this.jdbcURL = jdbcURL;

    try {
      BeanTable<Course> table =
          BeanTable.getSQLInstance(Course.class, "fanc_course", jdbcDriver, jdbcURL);
      if (!table.exists()) {
        table.create("courseName");
      }
      factory = table.getFactory();
    } catch (BeanFactoryException e) {
      throw new MyDAOException(e);
    }
  }
  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;
  }
Esempio n. 3
0
 public CommunityDAO(String jdbcDriver, String jdbcURL, UserDAO userDAO) throws DAOException {
   try {
     BeanTable<Community> communityTable =
         BeanTable.getSQLInstance(
             Community.class, "team17_community", jdbcDriver, jdbcURL, userDAO.getFactory());
     if (!communityTable.exists()) communityTable.create("name");
     communityTable.setIdleConnectionCleanup(true);
     factory = communityTable.getFactory();
   } catch (BeanFactoryException e) {
     throw new DAOException(e);
   }
 }
Esempio n. 4
0
  public UserDAO() throws DAOException {
    try {
      BeanTable<UserBean> userTable = BeanTable.getInstance(UserBean.class, "onCampusUsers");

      if (!userTable.exists()) userTable.create("userID");

      // Long running web apps need to clean up idle database connections.
      // So we can tell each BeanTable to clean them up.  (You would only notice
      // a problem after leaving your web app running for several hours.)
      userTable.setIdleConnectionCleanup(true);

      // Get a BeanFactory which the actions will use to read and write rows of the "user" table
      factory = userTable.getFactory();
    } catch (BeanFactoryException e) {
      throw new DAOException(e);
    }
  }
Esempio n. 5
0
  public EventDAO() throws DAOException {
    try {
      // Get a BeanTable to create the "photo" table
      BeanTable<EventBean> eventTable = BeanTable.getInstance(EventBean.class, "events");

      if (!eventTable.exists()) eventTable.create("eventid");

      // Long running web apps need to clean up idle database connections.
      // So we can tell each BeanTable to clean them up.  (You would only notice
      // a problem after leaving your web app running for several hours.)
      eventTable.setIdleConnectionCleanup(true);

      // Get a BeanFactory which the actions will use to read and write
      // rows of the "photo" table
      factory = eventTable.getFactory();
    } catch (BeanFactoryException e) {
      throw new DAOException(e);
    }
  }