protected abstract Object resultToObject(ResultSet result) throws Exception;
	
	protected Iterator resultToIterator(ResultSet result) {
		return new ResultSetIterator(result);
	}



	protected class ResultSetIterator implements Iterator {
	
		private ResultSet resultSet;
		private Object next;
	
		public ResultSetIterator(ResultSet result) {
			this.resultSet = result;
		}
	
		public boolean hasNext() {
			try {
				if (next == null) {
					if (!resultSet.next()) {
						return false;
					}
					next = resultToObject(resultSet);
				}
				return true;
			} catch (Exception e) {
				return false;
			}
		}
	
		public Object next() {
			if (!hasNext()) {
				throw new NoSuchElementException();
			}
			Object returnValue = next;
			next = null;
			return returnValue;
		}
	
		public void remove() {
			throw new UnsupportedOperationException("No remove allowed");
		}
	
	}

public class DatabaseObjectIterator implements Iterator {

    private long [] elements;
    private int currentIndex = -1;
    private Object nextElement = null;

    private DatabaseObjectFactory objectFactory;

    public DatabaseObjectIterator(int type, long [] elements,
            final Object extraObject)
    {
        this.elements = elements;

        // Load the appropriate proxy factory depending on the type of object
        // that we're iterating through.
        switch (type) {
            // FORUM
            case JiveGlobals.FORUM:
                // Create an objectFactory to load forums.
                this.objectFactory = new DatabaseObjectFactory() {
                    ForumFactory factory = (ForumFactory)extraObject;

                    public Object loadObject(long id) {
                        try {
                            Forum forum = factory.getForum(id);
                            return forum;
                        }
                        catch (ForumNotFoundException mnfe) { }
                        catch (UnauthorizedException ue) { }
                        return null;
                    }
                };
                break;
            // Otherwise, an invalid value was passed in so throw an exception.
            default:
                throw new IllegalArgumentException("Illegal type specified");
        }
    }

    /<strong>
     * Returns true if there are more elements in the iteration.
     *
     * @return true if the iterator has more elements.
     */
    public boolean hasNext() {
        // If we are at the end of the list, there can't be any more elements
        // to iterate through.
        if (currentIndex+1 >= elements.length && nextElement == null) {
            return false;
        }
        // Otherwise, see if nextElement is null. If so, try to load the next
        // element to make sure it exists.
        if (nextElement == null) {
            nextElement = getNextElement();
            if (nextElement == null) {
                return false;
            }
        }
        return true;
    }

    /</strong>
     * Returns the next element.
     *
     * @return the next element.
     * @throws NoSuchElementException if there are no more elements.
     */
    public Object next() throws java.util.NoSuchElementException {
        Object element = null;
        if (nextElement != null) {
            element = nextElement;
            nextElement = null;
        }
        else {
            element = getNextElement();
            if (element == null) {
                throw new java.util.NoSuchElementException();
            }
        }
        return element;
    }

    /<strong>
     * Not supported for security reasons.
     */
    public void remove() throws UnsupportedOperationException {
        throw new UnsupportedOperationException();
    }

    /</strong>
     * Returns the next available element, or null if there are no more
     * elements to return.
     *
     * @return the next available element.
     */
    public Object getNextElement() {
        while (currentIndex+1 < elements.length) {
            currentIndex++;
            Object element = objectFactory.loadObject(elements[currentIndex]);
            if (element != null) {
                return element;
            }
        }
        return null;
    }
}

/<strong>
 * An interface for loading Jive database objects.
 */
interface DatabaseObjectFactory {

    /</strong>
     * Returns the object associated with <code>id</code> or null if the
     * object could not be loaded.
     *
     * @param id the id of the object to load.
     * @return the object specified by <code>id</code> or null if it could not
     *      be loaded.
     */
    public Object loadObject(long id);
}

            try {
                con = ConnectionManager.getConnection();
                pstmt = con.prepareStatement(GET_FORUMS);
                ResultSet rs = pstmt.executeQuery();
                while (rs.next()) {
                    forumList.add(rs.getLong(1));
                }
            }