xml 代码
- CREATE TABLE GROUP
- (
- GROUP_ID int not null ,
- NAME varchar(50) not null,
- PRIMARY KEY(GORUP_ID)
- );
- CREATE TABLE ROLE(
- ROLE_ID int not null,
- NAME varchar(50) not null,
- PRIMARY KEY (ROLE_ID)
- );
- CREATE TABLE GROUP_ROLE(
- GROUP_ID int not null,
- ROLE_ID int not null,
- PRIMARY KEY (GROUP_ID,ROLE_ID),
- FOREIGN KEY (GROUP_ID) REFERENCES GROUP(GROUP_ID),
- FOREIGN KEY (ROLE_ID) REFERENECES ROLE(ROLE_ID)
- )
xml 代码
- <hibernate-mapping package="com.wangtong.hibernate.many2many.pojo">
- <class name="Group" table="GROUP">
- <id name="id" column="GROUP_ID" unsaved-value="0">
- <generator class="increment"/>
- </id>
- <property name="name" type="string"/>
- <set name="roles" table="GROUP_ROLE" cascade="save-update">
- <key column="group_id"/>
- <many-to-many class="Role" column="ROLE_ID"/>
- </set>
- </class>
- </hibernate-mapping>
java 代码
- public class Group {
- private int id;
- private String name;
- private Set roles = new HashSet();
- public int getId() {
- return id;
- }
- public void setId(int id) {
- this.id = id;
- }
- public String getName() {
- return name;
- }
- public void setName(String name) {
- this.name = name;
- }
- public Set getRoles() {
- return roles;
- }
- public void setRoles(Set roles) {
- this.roles = roles;
- }
- }
xml 代码
- <hibernate-mapping package="com.wangtong.hibernate.many2many.pojo">
- <class name="Role" table="ROLE">
- <id name="id" column="role_id" unsaved-value="0">
- <generator class="increment"/>
- </id>
- <property name="name" type="string"/>
- <set name="groups" table="GROUP_ROLE" inverse="true" cascade="save-update">
- <key column="role_id"/>
- <many-to-many class="Group" column="GROUP_ID"/>
- </set>
- </class>
- </hibernate-mapping>
java 代码
- public class Role {
- private int id;
- private String name;
- private Set groups = new HashSet();
- public Set getGroups() {
- return groups;
- }
- public void setGroups(Set groups) {
- this.groups = groups;
- }
- public int getId() {
- return id;
- }
- public void setId(int id) {
- this.id = id;
- }
- public String getName() {
- return name;
- }
- public void setName(String name) {
- this.name = name;
- }
- }