<?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.zs.testmybatisplus.mapper.ChildMapper"><!-- id: 当前命名空间中的一个唯一标识,用于标识一个结果映射
type: 类的完全限定名, 或者一个类型别名--><resultMap id="c_r" type="com.zs.testmybatisplus.entity.Child"><!-- id 和 result 元素都将一个列的值映射到一个简单数据类型(String,int,double, Date 等)的属性或字段
id 元素对应的属性会被标记为对象的标识符。 这样可以提高整体的性能,尤其是进行缓存和嵌套结果映射(也就是连接映射)的时候--><!-- column: 数据库中的列名,或者是列的别名。
property: 实体类的属性--><id property="id" column="id"/><result property="name" column="name"/><result property="laoHanId" column="lao_han_id"/><result property="laoMaId" column="lao_ma_id"/><!--嵌套 Select 查询:通过执行另外一个 SQL 映射语句来加载期望的复杂类型。--><!--2:====> Preparing: SELECT * FROM man WHERE id=?--><association property="laoHan" column="lao_han_id"
select="com.zs.testmybatisplus.mapper.ManMapper.selectById"/><!--3:====> Preparing: SELECT id,name,lao_gong_id FROM woman WHERE id=?--><association property="laoMa" column="lao_ma_id"
select="com.zs.testmybatisplus.mapper.WomanMapper.selectById"/></resultMap><!--1:==> Preparing: select * from child where id =?--><select id="selectLinkById" resultMap="c_r">
select *
from child
where id = #{id}</select></mapper>
<?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.zs.testmybatisplus.mapper.WomanMapper"><resultMap id="w_r" type="com.zs.testmybatisplus.entity.Woman"><id property="id" column="id"/><result property="name" column="name"/><result property="laoGongId" column="lao_gong_id"/><!--2:====> Preparing: SELECT * FROM man WHERE id=?====> Parameters:1(Long)--><association property="laoGong" column="lao_gong_id"
select="com.zs.testmybatisplus.mapper.ManMapper.selectById"/><!--3:====> Preparing: select * from child where lao_ma_id =?====> Parameters:1(Long)--><collection property="waWa" column="id"
select="com.zs.testmybatisplus.mapper.ChildMapper.selectByLaoMaId"/></resultMap><!--1:==> Preparing: select * from woman where id =?==> Parameters:1(Long)--><select id="selectLinkById" resultMap="w_r">
select *
from woman
where id = #{id}</select></mapper>
<?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.zs.testmybatisplus.mapper.ManMapper"><resultMap id="m_b" type="com.zs.testmybatisplus.entity.Man"><id property="id" column="id"/><result property="name" column="name"/><result property="laoPoId" column="lao_po_id"/></resultMap><resultMap id="m_r" type="com.zs.testmybatisplus.entity.Man"extends="m_b"><!--2:====> Preparing: SELECT id,name,lao_gong_id FROM woman WHERE id=?====> Parameters:1(Long)--><!-- select 它会从 column 属性指定的列中检索数据,作为参数传递给目标 select 语句--><association property="laoPo" column="lao_po_id"
select="com.zs.testmybatisplus.mapper.WomanMapper.selectById"/><!--3:====> Preparing: select * from child where lao_han_id =?====> Parameters:2(Long)--><collection property="waWa" column="id"
select="com.zs.testmybatisplus.mapper.ChildMapper.selectByLaoHanId"/></resultMap><!--1:==> Preparing: select * from man where id =?==> Parameters:2(Long)--><select id="selectLinkById" resultMap="m_r">
select *
from man
where id = #{id}</select></mapper>