How to update mutual entries in DB?
Posted
by
Sthita
on Stack Overflow
See other posts from Stack Overflow
or by Sthita
Published on 2013-10-18T09:52:33Z
Indexed on
2013/10/18
9:53 UTC
Read the original article
Hit count: 146
I am not able to perform mutual update to my Database. 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 4
Its 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). I think 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.
© Stack Overflow or respective owner