--角色继承关系表
create table SNOICS_RI  (
   RI_PARE_ROLEID       VARCHAR2(32)                    not null,
   RI_CHILD_ROLEID      VARCHAR2(32)                    not null,
   constraint PK_SNOICS_RI primary key (RI_PARE_ROLEID, RI_CHILD_ROLEID)
);

--角色表
create table SNOICS_ROLE  (
   ROLE_ID              VARCHAR2(32)                    not null,
   ROLE_NAME            VARCHAR2(32)                    not null,
   ROLE_FORBID          VARCHAR2(1),
   ROLE_DESCRIPT        VARCHAR2(500),
   constraint PK_SNOICS_ROLE primary key (ROLE_ID)
);

角色资料存放在SNOICS_ROLE中
角色之间可以继承，而且可以多重继承,
角色的继承关系存放在SNOICS_RI

可以使用SNOICS_ROLE自己到自己的多对多的关系来进行配置

-----------------------------------------------------------------------------------------------------
POJO:

package com.snoics.cmp.security.dao.spring.hibernate.pojo;

import java.io.Serializable;
import java.util.Set;

public class RolePOJO implements Serializable {
 private static final long serialVersionUID = -4776193447586778294L;
 private String roleid;
 private String rolename;
 private String roleforbid;
 private String roledescript;
 
 private Set user;
 private Set rolePermission;
 private Set roleP;
 private Set roleC;

 /**
  * @return Returns the roleC.
  */
 public Set getRoleC() {
  return roleC;
 }

 /**
  * @param roleC The roleC to set.
  */
 public void setRoleC(Set roleC) {
  this.roleC = roleC;
 }

 /**
  * @return Returns the roleP.
  */
 public Set getRoleP() {
  return roleP;
 }

 /**
  * @param roleP The roleP to set.
  */
 public void setRoleP(Set roleP) {
  this.roleP = roleP;
 }

 /**
  * @return Returns the rolePermission.
  */
 public Set getRolePermission() {
  return rolePermission;
 }

 /**
  * @param rolePermission The rolePermission to set.
  */
 public void setRolePermission(Set rolePermission) {
  this.rolePermission = rolePermission;
 }

 /**
  * @return Returns the user.
  */
 public Set getUser() {
  return user;
 }

 /**
  * @param user The user to set.
  */
 public void setUser(Set user) {
  this.user = user;
 }

 /**
  * @return Returns the roledescript.
  */
 public String getRoledescript() {
  return roledescript;
 }

 /**
  * @param roledescript The roledescript to set.
  */
 public void setRoledescript(String roledescript) {
  this.roledescript = roledescript;
 }

 /**
  * @return Returns the roleforbid.
  */
 public String getRoleforbid() {
  return roleforbid;
 }

 /**
  * @param roleforbid The roleforbid to set.
  */
 public void setRoleforbid(String roleforbid) {
  this.roleforbid = roleforbid;
 }

 /**
  * @return Returns the roleid.
  */
 public String getRoleid() {
  return roleid;
 }

 /**
  * @param roleid The roleid to set.
  */
 public void setRoleid(String roleid) {
  this.roleid = roleid;
 }

 /**
  * @return Returns the rolename.
  */
 public String getRolename() {
  return rolename;
 }

 /**
  * @param rolename The rolename to set.
  */
 public void setRolename(String rolename) {
  this.rolename = rolename;
 }
}

-----------------------------------------------------------------------------------------------------
role.hbm.xml中的继承关系部分的配置

  <set name="roleP" table="SNOICS_RI" cascade="all" inverse="false" lazy="true">
       <key column="RI_CHILD_ROLEID"/>
      <many-to-many column="RI_PARE_ROLEID" class="com.snoics.cmp.security.dao.spring.hibernate.pojo.RolePOJO"/>
  </set>
  <set name="roleC" table="SNOICS_RI" cascade="all" inverse="false" lazy="true">
     <key column="RI_PARE_ROLEID"/>
     <many-to-many column="RI_CHILD_ROLEID" class="com.snoics.cmp.security.dao.spring.hibernate.pojo.RolePOJO"/>
  </set>