while (rs.next()) {
String code = rs.getString(CODE);
String name = rs.getString(NAME);
OrganizationalUnit ou =new OrganizationalUnit();
ou.setDescription("");
ou.setLabel(code);
ou.setName(name);
String path = parent.getPath();
if(code != null){
Node<OrganizationalUnit> node = new Node<OrganizationalUnit>(ou, path + S+ ou.getLabel(), parent);
children.add(node);
}
}
rs.close();
pstmt.close();