SSH用户权限管理（二）

使用Hibernate逆向工程，将数据库中的四张表逆向成 对象 和 映射表*.hbm.xml

Role.java

public class Role  implements java.io.Serializable {


    // Fields    

     private Integer roleId;
     private String rolename;
     private String roledesc;
     private Set userInfos = new HashSet(0);
     private Set rolerights = new HashSet(0);


    // Constructors

    /** default constructor */
    public Role() {
    }

    
    /** full constructor */
    public Role(String rolename, String roledesc, Set userInfos, Set rolerights) {
        this.rolename = rolename;
        this.roledesc = roledesc;
        this.userInfos = userInfos;
        this.rolerights = rolerights;
    }

   
    // Property accessors

    public Integer getRoleId() {
        return this.roleId;
    }
    
    public void setRoleId(Integer roleId) {
        this.roleId = roleId;
    }

    public String getRolename() {
        return this.rolename;
    }
    
    public void setRolename(String rolename) {
        this.rolename = rolename;
    }

    public String getRoledesc() {
        return this.roledesc;
    }
    
    public void setRoledesc(String roledesc) {
        this.roledesc = roledesc;
    }

    public Set getUserInfos() {
        return this.userInfos;
    }
    
    public void setUserInfos(Set userInfos) {
        this.userInfos = userInfos;
    }

    public Set getRolerights() {
        return this.rolerights;
    }
    
    public void setRolerights(Set rolerights) {
        this.rolerights = rolerights;
    }
   

}

role.hbm.xml

role与rights是多对多的关系。所以在role.hbm.xml中设置<Set>标签

 <!-- role rights多对多 -->
        <set name="rolerights" table="roleright" cascade="all" lazy="false" inverse="true">
            <key>
                <column name="roleId" not-null="true" />
            </key>
            <many-to-many entity-name="com.po.Roleright">
            	<column name="rightId" not-null="true"/>
            </many-to-many>
        </set>

role与user是一对多的关系。所以在role.hbm.xml中设置<Set>标签

 <set name="userInfos" table="userinfo" inverse="true" lazy="false" fetch="select" cascade="delete">
            <key>
                <column name="roleId" not-null="true"/>
            </key>
            <one-to-many class="com.po.UserInfo" />
        </set>

Rights.java

由于rights表中有一个字段是自己引用自己的id，所以在Rights.jsp中修改属性。

public class Rights  implements java.io.Serializable {


    // Fields    

     private Integer rightId;
     private Rights rightParent;
     private String rightname;
    
     private String url;
     private String rightdesc;
     
     //引用自己的表而建的字段
     private Set<Rights> children =  new HashSet<Rights>(0);
     //与role
     private Set<Role> roles = new HashSet<Role>(0);
     
    // Constructors

    /** default constructor */
    public Rights() {
    }

	/** minimal constructor */
    public Rights(String rightname) {
        this.rightname = rightname;
    }
    
    /** full constructor */
    public Rights(Rights rightParent, String rightname,  String url, 
    			String rightdesc, Set<Rights> children, Set<Role> roles) {
        this.rightParent = rightParent;
        this.rightname = rightname;
        this.url = url;
        this.rightdesc = rightdesc;
        this.children = children;
        this.roles = roles;
    }

   
    // Property accessors

    public Integer getRightId() {
        return this.rightId;
    }
    
    public void setRightId(Integer rightId) {
        this.rightId = rightId;
    }

   
    public Rights getRightParent() {
		return rightParent;
	}

	public void setRightParent(Rights rightParent) {
		this.rightParent = rightParent;
	}

	public String getRightname() {
        return this.rightname;
    }
    
    public void setRightname(String rightname) {
        this.rightname = rightname;
    }

    public String getUrl() {
        return this.url;
    }
    
    public void setUrl(String url) {
        this.url = url;
    }

    public String getRightdesc() {
        return this.rightdesc;
    }
    
    public void setRightdesc(String rightdesc) {
        this.rightdesc = rightdesc;
    }

	public Set<Rights> getChildren() {
		return children;
	}

	public void setChildren(Set<Rights> children) {
		this.children = children;
	}

	public Set<Role> getRoles() {
		return roles;
	}

	public void setRoles(Set<Role> roles) {
		this.roles = roles;
	}

    
}

Rights.hbm.xml

自己引用自己的字段，即‘父类’

<many-to-one name="rightParent" class="com.po.Rights" fetch="select">
            <column name="parentId" />
        </many-to-one>

 <!-- 与role  -->
        <set name="roles" table="roleright" inverse="true" lazy="false" cascade="all">
            <key>
                <column name="rightId" not-null="true" />
            </key>
            <many-to-many class="com.po.Role">
            	<column name="roleId" not-null="true"/>
            </many-to-many>
        </set>

 <!-- 与children -->
        <set name="children" inverse="true" lazy="false" cascade="all">
            <key>
                <column name="parentId" />
            </key>
            <one-to-many class="com.po.Rights" />
        </set>

UserInfo.java

public class UserInfo  implements java.io.Serializable {


    // Fields    

     private Integer userId;
     private String userName;
     private String password;
     private String realName;
     private String sex;

     private Role role;

    // Constructors

    /** default constructor */
    public UserInfo() {
    }

	/** minimal constructor */
    public UserInfo(String userName, String password) {
        this.userName = userName;
        this.password = password;
    }
    
    /** full constructor */
    public UserInfo(Role role, String userName, String password, String realName, String sex) {
        this.role = role;
        this.userName = userName;
        this.password = password;
        this.realName = realName;
        this.sex = sex;
    }

   
    // Property accessors

    public Integer getUserId() {
        return this.userId;
    }
    
    public void setUserId(Integer userId) {
        this.userId = userId;
    }

    public Role getRole() {
        return this.role;
    }
    
    public void setRole(Role role) {
        this.role = role;
    }

    public String getUserName() {
        return this.userName;
    }
    
    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getPassword() {
        return this.password;
    }
    
    public void setPassword(String password) {
        this.password = password;
    }

    public String getRealName() {
        return this.realName;
    }
    
    public void setRealName(String realName) {
        this.realName = realName;
    }

    public String getSex() {
        return this.sex;
    }
    
    public void setSex(String sex) {
        this.sex = sex;
    }
  
}

一个用户拥有一个角色，一个角色包含很多用户

<many-to-one name="role" class="com.po.Role" fetch="join" lazy="false">
            <column name="roleId" not-null="false"/>
        </many-to-one>