基于Struts+Hibernate的Web项目权限设计(2)

设计好数据的表结构后，使用Middlegen-Hibernate工具很方便的生成hibernate的映射文件（Middlegen-Hibernate工具的使用方法不在这里介绍，可以到网上找找，很多的）：

Middlegen-Hibernate启动后的界面如下：

 

生成后的映射文件具体内容如下

 

Labpermission.hbm.xml

 

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

   

<hibernate-mapping>

<!--

    Created by the Middlegen Hibernate plugin

 

    http://boss.bekk.no/boss/middlegen/

    http://hibernate.sourceforge.net/

-->

 

<class

    name="cn.**.common.entity.LabPermission"

    table="LAB_PERMISSION"

>

 

 

    <id

        name="permissionId"

        type="java.lang.String"

        column="PERMISSION_ID"

    >

        <generator class="assigned" />

    </id>

 

    <property

        name="permissionName"

        type="java.lang.String"

        column="PERMISSION_NAME"

        not-null="true"

        length="100"

    />

    <property

        name="permissionDesc"

        type="java.lang.String"

        column="PERMISSION_DESC"

        length="200"

    />

 

    <!-- associations -->

    <!-- bi-directional one-to-many association to LabRolepermission -->

    <set

        name="labRolepermissions"

        lazy="true"

        inverse="true"

    >

        <key>

            <column name="PERMISSION_ID" />

        </key>

        <one-to-many

            class="cn.**.common.entity.LabRolepermission"

        />

    </set>

 

</class>

</hibernate-mapping>

 

 

labRole.hbm.xml

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

   

<hibernate-mapping>

<!--

    Created by the Middlegen Hibernate plugin

 

    http://boss.bekk.no/boss/middlegen/

    http://hibernate.sourceforge.net/

-->

 

<class

    name="cn.**.common.entity.LabRole"

    table="LAB_ROLE"

>

 

 

    <id

        name="roleId"

        type="int"

        column="ROLE_ID"

    >

        <generator class="sequence">

            <param name="sequence">LAB_ROLE_S</param>

        </generator>

    </id>

 

    <property

        name="roleName"

        type="java.lang.String"

        column="ROLE_NAME"

        length="20"

        not-null="true"

    />

    <property

        name="roleDesc"

        type="java.lang.String"

        column="ROLE_DESC"

        length="100"

    />

 

    <!-- associations -->

    <!-- bi-directional one-to-many association to LabRolepermission -->

    <set

        name="labRolepermissions"

        lazy="true"

        inverse="true"

    >

        <key>

            <column name="ROLE_ID" />

        </key>

        <one-to-many

            class="cn.**.common.entity.LabRolepermission"

        />

    </set>

    <!-- bi-directional one-to-many association to LabGrouprole -->

    <set

        name="labGrouproles"

        lazy="true"

        inverse="true"

    >

        <key>

            <column name="ROLE_ID" />

        </key>

        <one-to-many

            class="cn.**.common.entity.LabGrouprole"

        />

    </set>

 

</class>

</hibernate-mapping>

 

 

LabRolepermission.hbm.xml

 

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

   

<hibernate-mapping>

<!--

    Created by the Middlegen Hibernate plugin

 

    http://boss.bekk.no/boss/middlegen/

    http://hibernate.sourceforge.net/

-->

 

<class

    name="cn.**.common.entity.LabRolepermission"

    table="LAB_ROLEPERMISSION"

>

 

 

    <composite-id name="comp_id" class="cn.**.common.entity.LabRolepermissionPK">

        <!-- bi-directional many-to-one association to LabRole -->

        <key-many-to-one

        name="labRole"

            class="cn.**.common.entity.LabRole"

        >

        <column name="ROLE_ID" />

        </key-many-to-one>

        <!-- bi-directional many-to-one association to LabPermission -->

        <key-many-to-one

        name="labPermission"

            class="cn.**.common.entity.LabPermission"

        >

        <column name="PERMISSION_ID" />

        </key-many-to-one>

    </composite-id>   

 

 

    <!-- associations -->

 

</class>

</hibernate-mapping>

 

LabGroup.hbm.xml

 

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

   

<hibernate-mapping>

<!--

    Created by the Middlegen Hibernate plugin

 

    http://boss.bekk.no/boss/middlegen/

    http://hibernate.sourceforge.net/

-->

 

<class

    name="cn.**.common.entity.LabGroup"

    table="LAB_GROUP"

>

 

 

    <id

        name="groupId"

        type="int"

        column="GROUP_ID"

    >

        <generator class="sequence">

            <param name="sequence">LAB_GROUP_S</param>

        </generator>

    </id>

 

    <property

        name="groupName"

        type="java.lang.String"

        column="GROUP_NAME"

        length="20"

        not-null="true"

    />

    <property

        name="groupDesc"

        type="java.lang.String"

        column="GROUP_DESC"

        length="100"

    />

 

    <!-- associations -->

    <!-- bi-directional one-to-many association to LabGrouprole -->

    <set

        name="labGrouproles"

        lazy="true"

        inverse="true"

    >

        <key>

            <column name="GROUP_ID" />

        </key>

        <one-to-many

            class="cn.**.common.entity.LabGrouprole"

        />

    </set>

    <!-- bi-directional one-to-many association to LabUsergroup -->

    <set

        name="labUsergroups"

        lazy="true"

        inverse="true"

    >

        <key>

            <column name="GROUP_ID" />

        </key>

        <one-to-many

            class="cn.**.common.entity.LabUsergroup"

        />

    </set>

 

</class>

</hibernate-mapping>

 

 

LabUsergroup.hbm.xml

 

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

   

<hibernate-mapping>

<!--

    Created by the Middlegen Hibernate plugin

 

    http://boss.bekk.no/boss/middlegen/

    http://hibernate.sourceforge.net/

-->

 

<class

    name="cn.**.common.entity.LabUsergroup"

    table="LAB_USERGROUP"

>

 

 

    <composite-id name="comp_id" class="cn.**.common.entity.LabUsergroupPK">

        <key-property

            name="userId"

            column="USER_ID"

            type="java.lang.String"

            length="20"

        />

        <!-- bi-directional many-to-one association to LabGroup -->

        <key-many-to-one

        name="labGroup"

            class="cn.**.common.entity.LabGroup"

        >

        <column name="GROUP_ID" />

        </key-many-to-one>

    </composite-id>   

   

    <property

        name="userType"

        type="int"

        column="USER_TYPE"

        not-null="true"

        length="10"

    />

 

    <!-- associations -->

 

</class>

</hibernate-mapping>

 

然后根据上面的数据映射文件使用hibernate-extensions工具生成实体类文件，此过程不在熬述。

（未完待续…….）