mybatis 多表关联配置

最新推荐文章于 2023-03-01 14:34:28 发布

hw120219

最新推荐文章于 2023-03-01 14:34:28 发布

阅读量377

点赞数

分类专栏： mybatis 文章标签： mybaitis

本文链接：https://blog.csdn.net/hw120219/article/details/54317544

版权

mybatis 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

mybatis 一对多用标签，一对一用标签，下面演示DistributionTrafficRelation实体与OrderTraffic一对一，同时OrderTraffic与Member一对多

<resultMap id="RM_DistributionTrafficRelation_ALL" type="com.zyyw.pscq.modules.dispatch.entity.DistributionTrafficRelation" extends="RM_DistributionTrafficRelation">
                <association property="traffic" javaType="com.zyyw.pscq.modules.dispatch.entity.OrderTraffic">
                    <result property="id" column="dot.id" jdbcType="VARCHAR"/>
                    <result property="companyId" column="dot.company_id" jdbcType="VARCHAR"/>
                    <result property="remarks" column="dot.remarks" jdbcType="VARCHAR"/>
                    <result property="trafficNo" column="dot.traffic_no" jdbcType="VARCHAR"/>
                    <association property="vehicle" javaType="com.zyyw.pscq.modules.device.vehicle.entity.Vehicle">
                        <result property="id" column="v.id" jdbcType="VARCHAR" />
                        <result property="companyId" column="v.company_id" jdbcType="VARCHAR"/>
                        <result property="vehicleType" column="v.vehicle_type" jdbcType="INTEGER"/>
                        <result property="code" column="v.code" jdbcType="VARCHAR"/>
                    </association>
                    <collection property="members" ofType="com.zyyw.pscq.modules.team.entity.Member">
                        <result property="id" column="m.id" jdbcType="VARCHAR" />
                        <result property="name" column="m.name" jdbcType="VARCHAR" />
                        <result property="birthday" column="m.birthday" jdbcType="TIMESTAMP" />
                        <result property="gender" column="m.gender" jdbcType="CHAR" />
                        <result property="phone" column="m.phone" jdbcType="BIGINT" />
                    </collection>
                </association>
                <association property="distribute" javaType="com.zyyw.pscq.modules.dispatch.entity.OrderDistribute">
                    <result property="id" column="dod.id" jdbcType="VARCHAR"/>
                    <result property="enumId" column="dod.enum_id" jdbcType="VARCHAR"/>
                    <result property="remarks" column="dod.remarks" jdbcType="VARCHAR"/>
                </association>
    </resultMap>