String fieldName = (String) hmFields.get("name");
//System.out.println("[DEBUG] [CvAtticEJB]: fieldID: " + fieldID);
//System.out.println("[DEBUG] [CvAtticEJB]: fieldName: " + fieldName);
DDNameValue ddname = new DDNameValue(fieldID, fieldName);
vecDDName.addElement(ddname);
selectField = selectField + fieldName;
counter++;
}
cvdl.setSqlQueryToNull();
cvdl.setSqlQuery("Select " + selectField + " from " + recordType + " where " + strWhereClause);
Collection colFieldValues = cvdl.executeQuery();
Iterator iterFieldValues = colFieldValues.iterator();
while (iterFieldValues.hasNext())
{
HashMap hmFieldValue = (HashMap) iterFieldValues.next();
for (int i = 0; i < vecDDName.size(); i++)
{
DDNameValue ddname = (DDNameValue) vecDDName.elementAt(i);
String fieldValue = "";
if (hmFieldValue.get(ddname.getName()) != null)
{
fieldValue = (hmFieldValue.get(ddname.getName())).toString();
}
else
{
fieldValue = "";
}
//System.out.println("[DEBUG] [CvAtticEJB]: transactionID: " + transactionID);
//System.out.println("[DEBUG] [CvAtticEJB]: tableID: " + tableID);
//System.out.println("[DEBUG] [CvAtticEJB]: ddname.getId(): " + ddname.getId());
//System.out.println("[DEBUG] [CvAtticEJB]: fieldValue: " + fieldValue);
cvdl.setSqlQueryToNull();
cvdl.setSql("attic.insertatticdata");
cvdl.setInt(1, transactionID);
cvdl.setInt(2, tableID);
cvdl.setInt(3, ddname.getId());
cvdl.setString(4, fieldValue);
cvdl.executeUpdate();
}
}