File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Database in table problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Database in table problem" Watch "Database in table problem" New topic

Database in table problem

Roldan Baldo
Ranch Hand

Joined: Aug 11, 2009
Posts: 99
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
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
> 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

Joined: Oct 13, 2005
Posts: 41879
This question would sit better on our databases forum. Moving thread.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 31798

If you have a cascade delete set, deleting the parent row will delete the children.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Database in table problem