Mybatis实现用户所对应资源的查询

最新推荐文章于 2022-04-05 17:34:33 发布

zhcntmm

最新推荐文章于 2022-04-05 17:34:33 发布

阅读量746

点赞数

分类专栏：永无止尽技术人生文章标签： mybatis

本文链接：https://blog.csdn.net/zhcntmm/article/details/47788279

版权

永无止尽技术人生专栏收录该内容

4 篇文章 0 订阅

订阅专栏

思路：用户->角色->资源，思路很简单，最主要的就是配置关联关系。

根据用户查所对应资源的resultMap的配置：

 <resultMap type="org.imu.pms.object.pojo.UserCustom" id="userRolesResultMap">
		<id column="id" property="id" />
		<result column="username" property="username" />
		<result column="password" property="password" />
		<result column="realname" property="realname" />
		<result column="phone" property="phone" />
		<result column="email" property="email" />
		<result column="type" property="type" />
		<collection property="roles" ofType="org.imu.pms.object.pojo.RoleCustom">
			<id column="role_id" property="id" />
			<result column="role_name" property="name" />
			<result column="description" property="description" />
			<result column="create_time" property="createTime" />
			<result column="update_time" property="updateTime" />
			<collection property="resources"  column="role_id" ofType="org.imu.pms.object.po.Resource;" select="org.imu.pms.mapper.ResourceMapper.selectResourcesByRole">
			    <id column="id" property="id"/>
			    <result column="name" property="name"/>
			    <result column="description" property="description"/>
			    <result column="url" property="url"/>
			    <result column="icon" property="icon"/>
			    <result column="pid" property="pid"/>
			</collection>
		</collection>
	</resultMap>