In a relational database in a many-to-many relationship, a row in table X can have more than one matching row in table Y, a row in table Y can have more than one matching row in table X.
In Object oriented programming, one instance of entity refers to multiple instances of another entity and an instance of that another entity refers to multiple instances of the other entity in the relation called many-to-many relation.
In this tutorial used the relationship between Engineering Branch and Subjects that are having each Engineering branch in a semester. In an Engineering college each Branch have many Subjects and each Subject may appear in many Engineering branch semester.
many-to-many Tables structure in Database :
what is join table?
A join table is a table in database that represents the multiple references of one or more table . In other words a join table is used to refer multiple records of one or more tables by using foreign key constraints. Below image illustrates more about many-to-many association.
Subject.java mapping :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
/** * The persistent class for the Subject database table. * */ @Entity public class Subject implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue(strategy=GenerationType.AUTO) @Column(name="SUBJECT_ID") private int subjectId; @Column(name="SUBJECT_DESC") private String subjectDesc; @Column(name="SUBJECT_NAME") private String subjectName; //Setters and getters |
Branch.java mapping :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
/** * The persistent class for the BRANCH database table. * */ @Entity public class Branch implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue(strategy=GenerationType.AUTO) @Column(name="BRANCH_ID") private int branchId; @Column(name="BRANCH_NAME") private String branchName; @Column(name="BRANCH_SHORT_NAME") private String branchShortName; private String description; //Uni-directional many-to-many association to Subject @ManyToMany(cascade={CascadeType.ALL}) @JoinTable(name="BRANCH_SUBJECT", joinColumns=@JoinColumn(name="BRANCH_ID"), inverseJoinColumns=@JoinColumn(name="SUBJECT_ID"))//@JoinTable is used to map Join table in database private List<Subject> subjects; //Setters and getters |
@JoinTable
-
-
@JoinTable Used in the mapping of associations. It is specified on the owning side of an association.
- @JoinTable can be used with embeddable types as well.
-
When a join table is used in mapping a relationship with an embeddable class on the owning side of the relationship, the containing entity rather than the embeddable class is considered the owner of the relationship.
-
Key points to understand associations
many-to-many association testing
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 |
/** * JPA Many-To-Many UniDirectional * */ public class App { public static void main( String[] args ) { EntityManagerFactory emf = null; EntityManager entityManager = null; EntityTransaction transaction = null; try{ emf = Persistence.createEntityManagerFactory("jbd-pu"); entityManager = emf.createEntityManager(); transaction = entityManager.getTransaction(); transaction.begin(); Branch branch1 = getBranch1();//CSE Branch in Engineering Branch branch2 = getBranch2();//IT Branch in Engineering branch1.setSubjects(new ArrayList()); branch1.addSubject(getSubject1());//Software Engineering branch1.addSubject(getSubject2());//Distributed System branch2.setSubjects(new ArrayList()); branch2.addSubject(getSubject1());//Software Engineering branch2.addSubject(getSubject3());//Business Analysis and Optimization entityManager.persist(branch1); entityManager.persist(branch2); transaction.commit(); }catch(Exception e){ transaction.rollback(); e.printStackTrace(); }finally{ entityManager.close(); emf.close(); } } private static Subject getSubject1(){ Subject subject = new Subject(); subject.setSubjectName("Software Engineering"); subject.setSubjectDesc("Apply key aspects of software engineering processes for the development of a complex software system"); return subject; } private static Subject getSubject2(){ Subject subject = new Subject(); subject.setSubjectName("Distributed System"); subject.setSubjectDesc("Explore recent advances in distributed computing systems"); return subject; } private static Subject getSubject3(){ Subject subject = new Subject(); subject.setSubjectName("Business Analysis and Optimization"); subject.setSubjectDesc("understand the Internal and external factors that impact the business strategy"); return subject; } private static Branch getBranch1(){ Branch branch = new Branch(); branch.setBranchName("Computer Science and Engineering"); branch.setBranchShortName("CSE"); branch.setDescription("CSE department offers courses under ambitious curricula in computer science and computer engineering.."); return branch; } private static Branch getBranch2(){ Branch branch = new Branch(); branch.setBranchName("Information Technology"); branch.setBranchShortName("IT"); branch.setDescription("IT is the business side of computers - usually dealing with databases, business, and accounting"); return branch; } } |
Console Output :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
INFO - HHH000400: Using dialect: org.hibernate.dialect.MySQLInnoDBDialect INFO - HHH000397: Using ASTQueryTranslatorFactory Hibernate: insert into Branch (BRANCH_NAME, BRANCH_SHORT_NAME, description) values (?, ?, ?) Hibernate: insert into Subject (SUBJECT_DESC, SUBJECT_NAME) values (?, ?) Hibernate: insert into Subject (SUBJECT_DESC, SUBJECT_NAME) values (?, ?) Hibernate: insert into Branch (BRANCH_NAME, BRANCH_SHORT_NAME, description) values (?, ?, ?) Hibernate: insert into Subject (SUBJECT_DESC, SUBJECT_NAME) values (?, ?) Hibernate: insert into Subject (SUBJECT_DESC, SUBJECT_NAME) values (?, ?) Hibernate: insert into BRANCH_SUBJECT (BRANCH_ID, SUBJECT_ID) values (?, ?) Hibernate: insert into BRANCH_SUBJECT (BRANCH_ID, SUBJECT_ID) values (?, ?) Hibernate: insert into BRANCH_SUBJECT (BRANCH_ID, SUBJECT_ID) values (?, ?) Hibernate: insert into BRANCH_SUBJECT (BRANCH_ID, SUBJECT_ID) values (?, ?) INFO - HHH000030: Cleaning up connection pool [jdbc:mysql://localhost:3306/jpa_JBD] |
台彩賓果賓果
Howdy would you mind stating which blog platform you’re using? I’m planning to start my own blog in the near future but I’m having a difficult time making a decision between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because yo…
賓果賓果app
Normally I do not read article on blogs, but I wish to say that this write-up very pressured me to try and do so! Your writing style has been surprised me. Thank you, very great post.
數字賓果賓果
This website is mostly a walk-through for the entire info you wished about this and didn know who to ask. Glimpse here, and youl positively uncover it.
賓果賓果必勝法
This web page is really a walk-by means of for the entire info you needed about this and didn know who to ask. Glimpse here, and also youl undoubtedly uncover it.
超級賓果賓果
Keep functioning ,terrific job!
賓果賓果怎麼玩
Hi, Neat post. There is a problem with your website in internet explorer, would test this?IE still is the market leader and a big portion of people will miss your fantastic writing because of this problem.
hey, Thank you so much for sharing your views and sharing us about this issue, this IE issue we never came across, we will test this site in IE, Thank you!!!.