int sizeGroup = jrs.getRowCount();
for (int i = 1; i <= sizeGroup; ++i)
{
jrs.absolute(i);
WorkflowGroup workflowGroup =
createGroup(
jrs.getString("vc_uuid"),
jrs.getString("vc_name"),
jrs.getString("vc_description"),
parentGroup);
workflowGroup.setDepartment((WorkflowDepartment)departments.get(jrs.getString("vc_departmentid")));
genGroupTree(workflowGroup);
}
jrs.release();
}
else
{
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try
{
strSQL += " WHERE vc_parent=?";
conn = ConnUtils.getConnection(getStore());
pstmt = conn.prepareStatement(strSQL);
pstmt.setString(1, parentGroup.getName());
rs = pstmt.executeQuery();
while (rs.next())
{
WorkflowGroup workflowGroup =
createGroup(
rs.getString("vc_uuid"),
rs.getString("vc_name"),
rs.getString("vc_description"),
parentGroup);
workflowGroup.setDepartment((WorkflowDepartment)departments.get(rs.getString("vc_departmentid")));
genGroupTree(workflowGroup);
}
}
finally
{