mybatis mapper.xml 配置文件多表级联查询返回值映射问题
<resultMap id="BaseResultMap2" type="LossesAre"><id column="lossesare_id" property="id" jdbcType="INTEGER" />
<result column="lossesare_roomconfigid" property="roomconfigid" jdbcType="INTEGER" />
<result column="lossesare_shouldpay" property="shouldpay" jdbcType="DOUBLE" />
<result column="lossesare_pay" property="pay" jdbcType="DOUBLE" />
<result column="lossesare_paystatus" property="paystatus" jdbcType="INTEGER" />
<result column="lossesare_createdby" property="createdby" jdbcType="INTEGER" />
<result column="lossesare_createdtime" property="createdtime" jdbcType="TIMESTAMP" />
<result column="lossesare_createdby" property="createdby" jdbcType="INTEGER" />
<association property="supplier" javaType="Supplier" resultMap="com.mogo.mapper.SupplierMapper.BaseResultMap1" columnPrefix="supplier_" />
1
<association property="flats" javaType="Flats">
<id column="flats_id" property="id" jdbcType="INTEGER" />
<result column="flats_flatsnum" property="flatsnum" jdbcType="VARCHAR" />
<result column="flats_floornum" property="floornum" jdbcType="INTEGER" />
<association property="community" javaType="Community" resultMap="com.mogo.mapper.CommunityMapper.BaseResultMap" columnPrefix="community_" />
<association property="building" javaType="Building" resultMap="com.mogo.mapper.BuildingMapper.BaseResultMap" columnPrefix="building_" />
</association>
<association property="room" javaType="Room" resultMap="com.mogo.mapper.RoomMapper.BaseResultMapRoom" columnPrefix="room_"/>
<association property="product" javaType="Product" resultMap="com.mogo.mapper.ProductMapper.BaseResultMap1" columnPrefix="product_"/>
<association property="purchaseAmtShould" javaType="PurchaseAmtShould">
<id column="pash_id" property="id" jdbcType="INTEGER"/>
<association property="purchaseOrder" javaType="PurchaseOrder" >
<id column="purchaseorder_id" property="id" jdbcType="INTEGER" />
<result column="purchaseorder_ordercode" property="ordercode" jdbcType="VARCHAR" />
<association property="creator" javaType="Employee" resultMap="com.mogo.mapper.EmployeeMapper.BaseResultMapBase" columnPrefix="purchasecreated_" />
</association>
</association>
2
</resultMap>
针对1，如果没有在<association> 内部自定义元素，则需要注明 resultMap的值，相反的，如果针对2，在<association>内部又自定义了返回值列字段，就无需在注明resultMap，不然的话，Mybatis返回值会对应不上这个对象，特此记录!
页:
[1]