Here, we will create a different scenario for a better understanding of the relationship. We will take a look at the use of both one-to-many and many-to-one relationships in a single example.
Now, we will create a relationship between actor and movie tables, where one actor is associated with one movie, but one movie can be associated with multiple actors.
We will create the classes and tables for Movie
and Actor
.
Use the following script to create the tables if you are not using hbm2dll=create|update
:
Use the following script to create the movie
table:
CREATE TABLE `movie` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) )
Use the following script to create the actor
table:
CREATE TABLE `actor` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `actorname` varchar(255) DEFAULT NULL, `movie_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK_MOVIE_ID` (`movie_id...