<resultMapid="permissionGroupResultMap"type="cn.kx59.admin.entity.PermissionGroup"><idcolumn="id"property="id"jdbcType="INTEGER"/><resultcolumn="name"property="name"jdbcType="VARCHAR"/><resultcolumn="decipher"property="decipher"jdbcType="VARCHAR"/><resultcolumn="create_time"property="createTime"jdbcType="TIMESTAMP"/><!-- 一个权限组 对应多个权限--><collectionproperty="permissionArrayList"ofType="cn.kx59.admin.entity.Permission"><idcolumn="id"property="id"jdbcType="INTEGER"/><resultcolumn="url"property="url"jdbcType="VARCHAR"/><resultcolumn="name"property="name"jdbcType="VARCHAR"/><resultcolumn="explain"property="explain"jdbcType="VARCHAR"/><resultcolumn="decipher"property="decipher"jdbcType="VARCHAR"/><resultcolumn="create_time"property="createTime"jdbcType="TIMESTAMP"/></collection></resultMap><!--查询所有的权限组以及权限组包含的权限--><selectid="selectAllPermissionGroupAndPermission"resultMap="permissionGroupResultMap"> SELECT *
FROM [QPWebDB].[dbo].[permission_group] pg
left join [QPWebDB].[dbo].[permission_permission_group] ppg on pg.id=ppg.permission_group_id
left join [QPWebDB].[dbo].[permission] p on p.permission_id=ppg.permission_id
</select>
<resultMapid="permissionGroupResultMap"type="cn.kx59.admin.entity.PermissionGroup"><idcolumn="id"property="id"jdbcType="INTEGER"/><resultcolumn="name"property="name"jdbcType="VARCHAR"/><resultcolumn="decipher"property="decipher"jdbcType="VARCHAR"/><resultcolumn="create_time"property="createTime"jdbcType="TIMESTAMP"/><!-- 一个权限组 对应多个权限--><collectionproperty="permissionArrayList"ofType="cn.kx59.admin.entity.Permission"><idcolumn="p_id"property="id"jdbcType="INTEGER"/><resultcolumn="url"property="url"jdbcType="VARCHAR"/><resultcolumn="name"property="name"jdbcType="VARCHAR"/><resultcolumn="explain"property="explain"jdbcType="VARCHAR"/><resultcolumn="decipher"property="decipher"jdbcType="VARCHAR"/><resultcolumn="create_time"property="createTime"jdbcType="TIMESTAMP"/></collection></resultMap><!--查询所有的权限组以及权限组包含的权限--><selectid="selectAllPermissionGroupAndPermission"resultMap="permissionGroupResultMap"> SELECT pg.*,
p.id p_id,
p.url,
p.name,
p.explain,
p.decipher,
p.create_time
FROM [QPWebDB].[dbo].[permission_group] pg
left join [QPWebDB].[dbo].[permission_permission_group] ppg on pg.id=ppg.permission_group_id
left join [QPWebDB].[dbo].[permission] p on p.id=ppg.permission_id
</select>