Using Relation Table
| Previous | Home | Next |
In this approach the relation table is used to manage the relation between obect. Primary key of both objects are used as foreign key in relation table .
Advantages:-
- support one-to-many ,if any time one name has many address then it support it.
Disadvantage:-
- Performance is degraded.
Example:-
In this approach three tables are used
- Table for Batch(id,name)
- Table for Trainer(id,name,fees)
- Table for Relation(batchid,trainerid)
abc.xml
<?xml version='1.0' encoding='UTF-8'?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <!-- Generated by MyEclipse Hibernate Tools. --> <hibernate-mapping> <class name="r4r.Address"> <id name="id" type="int"> <generator class="increment"></generator> </id> <property name="city"></property> <property name="street"></property> </class> <class name="r4r.Person" table="person3"> <id name="id" type="int"> <generator class="increment"> </generator> </id> <property name="name"></property> <join table="addresses"> <key column="personid"> <many-to-one name="address" class="r4r.Address" cascade="all" column="addressid" unique="true"> </many-to-one> </join> </class> </hibernate-mapping>
| Previous | Home | Next |