今天使用单表查省市区三级数据联动,发现mybatis嵌套映射时,第二级的children(也就是第三级 区级别)死活映射不出来数据。
原始配置:
<resultMap id="AreaResultMap" type="com.jz.own.dev.entity.DevDatadicDetail">
<id column="id" jdbcType="CHAR" property="id" />
<result column="sort" jdbcType="VARCHAR" property="sort" />
<result column="label" jdbcType="VARCHAR" property="label" />
<result column="val" jdbcType="VARCHAR" property="val" />
<result column="pid" jdbcType="VARCHAR" property="pid" />
<result column="order_number" jdbcType="INTEGER" property="orderNumber" />
<result column="del" jdbcType="CHAR" property="del" />
<collection property="children" ofType="com.jz.own.dev.entity.DevDatadicDetail" resultMap="BaseAreaMap" columnPrefix="c_">
<collection property="children" ofType="com.jz.own.dev.entity.DevDatadicDetail" resultMap="BaseAreaMap" columnPrefix="c2_">
</collection>
</collection>
</resultMap>
愿因是columnPrefix会使每个子标签内的column属性前面加上对应的前缀,使第二级的children属性对应的collection标签内的column也被加上了前缀(虽然没有指定出来),导致字段不匹配从而无法映射到对象中。
修改后:
<resultMap id="AreaResultMap" type="com.jz.own.dev.entity.DevDatadicDetail">
<id column="id" jdbcType="CHAR" property="id" />
<result column="sort" jdbcType="VARCHAR" property="sort" />
<result column="label" jdbcType="VARCHAR" property="label" />
<result column="val" jdbcType="VARCHAR" property="val" />
<result column="pid" jdbcType="VARCHAR" property="pid" />
<result column="order_number" jdbcType="INTEGER" property="orderNumber" />
<result column="del" jdbcType="CHAR" property="del" />
<collection property="children" ofType="com.jz.own.dev.entity.DevDatadicDetail">
<id column="c_id" jdbcType="CHAR" property="id" />
<result column="c_sort" jdbcType="VARCHAR" property="sort" />
<result column="c_label" jdbcType="VARCHAR" property="label" />
<result column="c_val" jdbcType="VARCHAR" property="val" />
<result column="c_pid" jdbcType="VARCHAR" property="pid" />
<result column="c_order_number" jdbcType="INTEGER" property="orderNumber" />
<result column="c_del" jdbcType="CHAR" property="del" />
<collection property="children" ofType="com.jz.own.dev.entity.DevDatadicDetail" resultMap="BaseAreaMap" columnPrefix="c2_">
</collection>
</collection>
</resultMap>