Hi ibatiser,
Just a simple question on the general practice of
implementing many-to-many relationship in ibatis.
I have a category object that can have many item,
an item can belong to many category, hence
many-to-many relationship. So I introduced an
association class named CategorizedItem between
them.
Now what's the standard or prefered way of
implementing this as below,
1. Add CategorizedItem to ArryList of Category,
then call CategoryDao.saveCategory( category.getCategorizedItems()
);
where category.getCategorizedItems()
simply return the ArrayList of CategorizedItem.
Within CategoryDao.saveCategory(), CategorizedItem and Item will then be
saved to database
or
2. Add Item to ArryList of Category, then call
CategoryDao.saveCategory( category.getItemsList() );
where category.getItemsList()
simply return the ArrayList of Item.
Within CategoryDao.saveCategory(), CategorizedItem and Item will be
saved to database
Currently I am going with approach 1. but I suddenly think why shud user
handle or know about the association class
CategorizedItem explicitly by adding CategorizedItem to ArryList of
Category?
I can't help thinking maybe I am making a big mistake in my design and
shud go with approach 2 instead.
Any advice wud be greatly appreciated
Thanks,
Samuel |
- many-to-many relationship practice Dodo