用户表userdb
用户权限表popedom
权限列表treeuserdb.hbm.xml:
<set name="popedoms" inverse="true" lazy="false">
<key>
<column name="userid" not-null="true" />
</key>
<one-to-many class="com.zjm.study.vo.Popedom" />
</set>popedom.hbm.xml:
<many-to-one name="userdb" class="com.zjm.study.vo.Userdb" fetch="select">
<column name="userid" not-null="true" />
</many-to-one>
<many-to-one name="tree" class="com.zjm.study.vo.Tree" lazy="false" fetch="select">
<column name="childID" not-null="true" />
</many-to-one>tree.hbm.xml:
<set name="popedoms" inverse="true">
<key>
<column name="childID" not-null="true" />
</key>
<one-to-many class="com.zjm.study.vo.Popedom" />
</set>查出用户时,就要得到他的权限(tree),上面的配置可以得到,但是如何排序呢?对取出来的tree排序
order-by要加在哪里?
用户权限表popedom
权限列表treeuserdb.hbm.xml:
<set name="popedoms" inverse="true" lazy="false">
<key>
<column name="userid" not-null="true" />
</key>
<one-to-many class="com.zjm.study.vo.Popedom" />
</set>popedom.hbm.xml:
<many-to-one name="userdb" class="com.zjm.study.vo.Userdb" fetch="select">
<column name="userid" not-null="true" />
</many-to-one>
<many-to-one name="tree" class="com.zjm.study.vo.Tree" lazy="false" fetch="select">
<column name="childID" not-null="true" />
</many-to-one>tree.hbm.xml:
<set name="popedoms" inverse="true">
<key>
<column name="childID" not-null="true" />
</key>
<one-to-many class="com.zjm.study.vo.Popedom" />
</set>查出用户时,就要得到他的权限(tree),上面的配置可以得到,但是如何排序呢?对取出来的tree排序
order-by要加在哪里?
如果对你的权限进行排序的话 order-by加在userdb.hbm.xml中就可以了
tree表,存储着所有权限,表结构:
create table tree
(
int id,
varchar text
)id1,权限1
id2,权限2
id3,权限3
popedom表是用户拥有的权限
create table popedom
(
int userid,//关联用户表id
int childid//关联tree表id
)