Mybatis中的xml文件resultMap引用其他文件的resultMap

被引用xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.demo.mymall.mbg.mapper.UmsRoleMapper">
  <resultMap id="BaseResultMap" type="com.demo.mymall.mbg.model.UmsRole">
    <id column="id" jdbcType="BIGINT" property="id" />
    <result column="name" jdbcType="VARCHAR" property="name" />
    <result column="description" jdbcType="VARCHAR" property="description" />
    <result column="admin_count" jdbcType="INTEGER" property="adminCount" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="status" jdbcType="INTEGER" property="status" />
    <result column="sort" jdbcType="INTEGER" property="sort" />
  </resultMap>
  <!--省略其他sql -->
<mapper>

其中<mapper namespace="com.demo.mymall.mbg.mapper.UmsRoleMapper">  和 resultMap id="BaseResultMap"

在引用文件中我们需要指定被引用文件的namespace+resultMap

引用文件

<!--获得用户角色-->
    <select id="getRoleList" resultMap="com.demo.mymall.mbg.mapper.UmsRoleMapper.BaseResultMap">
        select r.*
        from ums_admin_role_relation ar left join ums_role r on ar.role_id = r.id
        where ar.admin_id = #{adminId}
    </select>

关键属性resultMap="com.demo.mymall.mbg.mapper.UmsRoleMapper.BaseResultMap"

即被引用文件的namespace+resultMap 

而不是被引用文件的路径

  • 2
    点赞
  • 7
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
什么是MyBatis?............................................................................................................. 5 入门................................................................................................................................. 5 从XML构建SqlSessionFactory .............................................................................. 5 不使用XML构建SqlSessionFactory........................................................................... 6 从SqlSessionFactory获取SqlSession....................................................................... 6 探究已映射的SQL语句 ............................................................................................ 7 命名空间的一点注释 .......................................................................................... 8 范围和生命周期 ........................................................................................................ 8 SqlSessionFactoryBuilder ..................................................................................... 8 SqlSessionFactory................................................................................................ 9 SqlSession .......................................................................................................... 9 Mapper实例 ....................................................................................................... 9 XML映射配置文件 ........................................................................................................ 10 properties................................................................................................................. 10 Settings ....................................................................................................................11 typeAliases .............................................................................................................. 12 typeHandlers ............................................................................................................ 13 objectFactory ........................................................................................................... 14 plugins .................................................................................................................... 15 environments............................................................................................................ 16 transactionManager ............................................................................................ 17 dataSsource....................................................................................................... 17 mappers ................................................................................................................... 19 SQL映射的XML文件 ................................................................................................... 19 select....................................................................................................................... 20 insert,update,delete .............................................................................................. 21 sql........................................................................................................................... 23 Parameters ............................................................................................................... 24 resultMap ................................................................................................................ 25 高级结果映射................................................................................................... 27 id,result.......................................................................................................... 29 支持的JDBC类型 ............................................................................................ 30 构造方法.......................................................................................................... 30 关联................................................................................................................. 31 集合................................................................................................................. 34 鉴别器 ............................................................................................................. 36 缓存........................................................................................................................ 38 使用自定义缓存 ............................................................................................... 38 参照缓存................................................................................................................. 39 动态SQL ................................................................................................................ 39 if ..................................................................................................................... 40 choose, when, otherwise ..................................................................................... 40

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值