Hibernate多对多配置示例

用户与角色示例

    一个用户可能对应着不同的角色，一个角色也对应着不同的用户

表结构

user表

 CREATE TABLE `sys_user` (
  `user_id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `user_code` varchar(32) NOT NULL COMMENT '用户账号',
  `user_name` varchar(64) NOT NULL COMMENT '用户名称',
  `user_password` varchar(32) NOT NULL COMMENT '用户密码',
  `user_state` char(1) NOT NULL COMMENT '1:正常,0:暂停',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

role表 

CREATE TABLE `sys_role` (
  `role_id` bigint(32) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(32) NOT NULL COMMENT '角色名称',
  `role_memo` varchar(128) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

类代码

User类

package com.itykd.domain;
import java.util.HashSet;
import java.util.Set;

public class User {
	private Long user_id;
	private String user_code;
	private String user_name;
	private String user_password;
	private String user_state;
	//设置多对多关系：表示一个用户选择多个角色
	private Set<Role> roles = new HashSet<>();
	public User() {
		super();
		// TODO Auto-generated constructor stub
	}
	public Long getUser_id() {
		return user_id;
	}
	public void setUser_id(Long user_id) {
		this.user_id = user_id;
	}
	public String getUser_code() {
		return user_code;
	}
	public void setUser_code(String user_code) {
		this.user_code = user_code;
	}
	public String getUser_name() {
		return user_name;
	}
	public void setUser_name(String user_name) {
		this.user_name = user_name;
	}
	public String getUser_password() {
		return user_password;
	}
	public void setUser_password(String user_password) {
		this.user_password = user_password;
	}
	public String getUser_state() {
		return user_state;
	}
	public void setUser_state(String user_state) {
		this.user_state = user_state;
	}
	public Set<Role> getRoles() {
		return roles;
	}
	public void setRoles(Set<Role> roles) {
		this.roles = roles;
	}
	
}

Role类

package com.itykd.domain;

import java.util.HashSet;
import java.util.Set;
public class Role {
    private Long role_id;
    private String role_name;
    private String role_memo;
    private Set<User> users = new HashSet<>();
	public Role() {
		super();
		// TODO Auto-generated constructor stub
	}
	public Long getRole_id() {
		return role_id;
	}
	public void setRole_id(Long role_id) {
		this.role_id = role_id;
	}
	public String getRole_name() {
		return role_name;
	}
	public void setRole_name(String role_name) {
		this.role_name = role_name;
	}
	public String getRole_memo() {
		return role_memo;
	}
	public void setRole_memo(String role_memo) {
		this.role_memo = role_memo;
	}
	public Set<User> getUsers() {
		return users;
	}
	public void setUsers(Set<User> users) {
		this.users = users;
	}
    
    
}

mapper.hbm.xml的配置

User.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="com.itykd.domain.User" table="sys_user">
        <id name="user_id" column="user_id">
            <generator class="native" />
        </id>
        <property name="user_code" column="user_code"></property>
        <property name="user_name" column="user_name"></property>
        <property name="user_password" column="user_password"></property>
        <property name="user_state" column="user_state"></property>
        <set name="roles" table="sys_user_role" cascade="save-update">
            <key>
                <column name="user_id" />
            </key>
            <many-to-many class="com.itykd.domain.Role" column="role_id"/>
        </set>
    </class>
</hibernate-mapping>

Role.hbm.xml 

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="com.itykd.domain.Role" table="sys_role">
        <id name="role_id" column="role_id">
            <generator class="native"/>
        </id>
        <property name="role_name" column="role_name"></property>
        <property name="role_memo" column="role_memo"></property>
        <set name="users" table="sys_user_role" inverse="true">
            <key>
                <column name="role_id"/>
            </key>
            <many-to-many class="com.itykd.domain.User" column="user_id"/>        
        </set>
    </class>
</hibernate-mapping>

注意当多对多的时候，通常由被动一方放弃主键维护，用户通常主动选择角色，而角色则被动被用户选择，因此在Role.hbm.xml文件中的set标签中设置inverse="true"（放弃主键维护）。

代码实例

package com.itykd.util;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class HibernateUtils {
	public static final Configuration HIBERNATE_CONFIGURATION;
	public static final SessionFactory SESSION_FACTORY;
	
	static {
		HIBERNATE_CONFIGURATION = new Configuration().configure();
		SESSION_FACTORY = HIBERNATE_CONFIGURATION.buildSessionFactory();
	}
	public static Session openSession() {
		return SESSION_FACTORY.openSession();
	}
	public static Session getCurrentSession() {
		return SESSION_FACTORY.getCurrentSession();
	}
	
}

package com.itykd.demo;

import org.hibernate.Session;
import org.hibernate.Transaction;
import org.junit.Test;

import com.itykd.domain.Customer;
import com.itykd.domain.LinkMan;
import com.itykd.domain.Role;
import com.itykd.domain.User;
import com.itykd.util.HibernateUtils;

public class HibernateDemo{
    @Test
 public void manyToManyCascadeTestDemo() {
    	Session session = HibernateUtils.getCurrentSession();
    	Transaction tx = session.beginTransaction();
    	//创建两个用户两个角色
    	User user1 = new User();
    	user1.setUser_name("Jordan");
    	User user2 = new User();
    	user2.setUser_name("Pippen");
    	Role role1 = new Role();
    	role1.setRole_name("son");
    	Role role2 = new Role();
    	role2.setRole_name("student");
    	user1.getRoles().add(role1);
    	user1.getRoles().add(role2);
    	user2.getRoles().add(role1);
    	session.save(user1);
    	session.save(user2);
        tx.commit();
    }
}