public BasicDBList GetDBList(String tableName, BasicDBObject query) throws Exception {
// BasicDBObject query = new BasicDBObject();
BasicDBObject emptyRecord = new BasicDBObject();
BasicDBList recordSet = new BasicDBList();
;
DBCursor cursorDoc = null;
DBObject sortSpec = null;
if ((sortSpec != null) && !sortSpec.keySet().isEmpty()) {
// sorting is optional
cursorDoc = store.getColl(tableName).find(query, emptyRecord).sort(sortSpec);
} else if (query != null) {
cursorDoc = store.getColl(tableName).find(query, emptyRecord);
} else {
cursorDoc = store.getColl(tableName).find();
}
recordSet.clear();
int recordCount = 0;
while (cursorDoc.hasNext()) {
BasicDBObject rec = (BasicDBObject) cursorDoc.next();
recordSet.add(rec);
recordCount++;
}
return recordSet;
}
