Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database in table problem

 
Roldan Baldo
Ranch Hand
Posts: 99
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Scenario:
i have a table name children, fields are (PK,IDnumber,nameOfChild) - idnumber there is a foreign key.
for example idnumber = 222, which has 3 children. named lets say a,b,c so this is the table look like
children
PK IDnumber nameOfChild
1 222 a
2 222 b
3 222 c

in java i make a class Children with fields pk,idnumber,name

when i fetch it to the database, it looks like this
List<Chidlren> children = <e.g. the database will return the Children classes of IDnumber = 222>
now we have 3 classes, the children size is 3;
the problem is, when i edit the children making the children of 222 to 2? (e.g. a & b only because c is mistakenly inputted).
(remember that it is now in the database the a,b,c)

> will i delete the idnumber = 222 in the database, table name children?(e.g a,b,c) and add back the 2? is this correct or is there any better idea in doing
this.
> how will i tell the table named children that i want to delete the child c? (not the sql on deleting) i mean the approach to tell the database.

 
Campbell Ritchie
Sheriff
Pie
Posts: 47293
52
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This question would sit better on our databases forum. Moving thread.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Roldan,
If you have a cascade delete set, deleting the parent row will delete the children.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic