Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

auto insert/update/delete

 
liliya woland
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
I want to be able access in .jsp pages my parent table and do auto insert/update/delete for my newly made child table. For this, I used

ALTER TABLE child_tbl ADD FOREIGN KEY (id_in_child) REFERENCES parent_tbl (id_in_parent) ON DELETE CASCADE ON UPDATE CASCADE;

So, does it mean at this point I wont have to open a separate connection, create a separate Statement, do insert/update/delete separately for each table - ie. only parent table is referenced in a .jsp page and the same operation done on a parent table will also automaticaly be on a child table?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic