Two Objects

[losintikfos]

Hi Guys,

I have two Objects, Customer and Sites. I want to go through each objects list and select element values that can be found on the two objects.

for example:

Collection<String> inBothTables = new ArrayList<String>(SiteName);
Collection<String> notInBothTables = new ArrayList<String>(inBothTables);
if (inBothTables.retainAll(compName)) {
System.out.println("Direct: " + inBothTables);
				
} 
if (notInBothTables.removeAll(inBothTables)) {
				
System.out.println("Operator: " + notInBothTables);
}

This prints values that appears on both elements and those that donot.

I want to go furhter to do something like this:

If value can be found inBothTables {
  //PRINT I AM FOUND ON THIS I CAN NOW BE USE FOR SOMETHING
}else if value can be found in notInBothTables{
//PRINT I AM FOUND ON HERE I CAN  BE USE FOR SOMETHING
}

Do anyone know how to go about this?

[emceenugget]

It's hard to understand what the problem is. You already have a Collection for items "in both tables" and a Collection for items "not in both tables". Why do you need if-statements?

[losintikfos]

I have to insert different values to a database table base on the condition. for example:

If value can be found inBothTbles{
//INSERT A TO TABLE
}
else if Value isNotInBothTable{
//INSERT B TO TABLE
}

I have a method which does the insert to the database, all i want now is to have a comon variable decribing whether to insert A or B which can be passed to the query. I am having a tuff time with the condition statement.

Hope this helps.

[emceenugget]

I'm assuming that your two Collection objects from the first chunk of code correctly contain what is "in both tables" and "not in both tables" to be used in your second chunk of code. Correct me if I'm wrong.

If this is true, can't you just dump the contents of both Collection objects? Are you needing to traverse through the items in each list? If so, you need to use get an Iterator from each Collection and read up on how to use it.

Sorry if I'm not understanding, I'm not too sure what your code is trying to do.