String billState = null;
String assignToName = "";
User assignedTo = null;
while (it.hasNext()) {
Object[] row = (Object[]) it.next();
AccountVO accountVO = new AccountVO();
name = (String) row[0];
officePhone = (String) row[1];
email = (String) row[2];
billStreet = (String) row[3];
billCity = (String) row[4];
billState = (String) row[5];
assignedTo = (User) row[6];
accountVO.setName(CommonUtil.fromNullToEmpty(name));
accountVO.setOffice_phone(CommonUtil.fromNullToEmpty(officePhone));
accountVO.setEmail(CommonUtil.fromNullToEmpty(email));
accountVO.setBill_street(CommonUtil.fromNullToEmpty(billStreet));
accountVO.setBill_city(CommonUtil.fromNullToEmpty(billCity));
accountVO.setBill_state(CommonUtil.fromNullToEmpty(billState));
assignToName = "";
if (assignedTo != null) {
assignToName = CommonUtil.fromNullToEmpty(assignedTo.getName());
}
accountVO.setAssigned_to(assignToName);
list.add(accountVO);
}
map = new HashMap<String, Object>();
}