I am not able to perform mutual update to my Database table.My Requirement is like this :

Insert IDS UPDate DB Entries ID connectedTo ID connectedTo connectedVia 2 1 --- No Entry ----- 2 3 -- No Entry ----- When ID 1 Comes in to picture (Enties happened to Table)


1 4 1 3 2 1 5 2 4 1 1 2 2 5 1 When ID 3 Comes into picture (Enties happened to Table)


3 4 3 5 1 3 1 ---- 3 2 ----Similarly when ID 4 Comes in to picture


4 9 4 2 3 4 10 4 5 1 4 3 4 2 1 4 1 1 9 4 1 10 4Its basically Updating the mutual connections.No Duplicate entries should happen. Like for example 2 3 and 3 2 are mutually connected and 1 is associated with them so there is no need to insert (3 2 via 1).This is my requirement. Anything possible combinations i have missed please let me know. i will Update.Please help me writing the logic or any example using jdbc and java.


Check Solution