/* (non-Javadoc)
* @see org.xooof.xooofoscope.dao.IUserDAO#fetchAll()
*/
public SUserArrayList fetchAll() throws DAOException {
SUser user = null;
SUserArrayList userList = new SUserArrayList();
PreparedStatement statement = null;
ResultSet result;
Connection connection = DAOHelper.getDBConnection();
try {
try {
statement = connection.prepareStatement(FETCHALL_QRY);
result = statement.executeQuery();
while (result.next()) {
user = new SUser();
user.setObjId(result.getString("id"));
user.setObjClass(SUser.class.getName());
user.setName(result.getString("name"));
userList.add(user);
}
} catch (SQLException exc) {
throw new UserDAOException(exc.getMessage());
} //End catch IOException