This code snippet creates and abstract indexed collection handler. This enables you to use Commons DBUtils to return a result from a database as a CQEngine indexed collection.

AbstractIndexedCollectionHandler

public abstract class AbstractIndexedCollectionHandler<T> implements ResultSetHandler<IndexedCollection<T>> {
	
	public IndexedCollection<T> handle(ResultSet rs) throws SQLException {
		IndexedCollection<T> rows = CQEngine.newInstance();
		while (rs.next()) {
			rows.add(this.handleRow(rs));
		}
		return rows;
	}

	protected abstract T handleRow(ResultSet rs) throws SQLException;
}