主表
附表(图片中间表)
需求:分页查询 查询出来分页对象 对象里面有一个参数是多张照片 要把这个照片放到对应的vo里面的List集合
方法1:
service层:
Dao层:
mapper:
<mapper namespace="com.cdls.carp.business.dao.TodayCheckDao">
<!-- 可根据自己的需求,是否要使用 -->
<resultMap type="com.cdls.carp.business.vo.TodayCheckListVO" id="todayCheckMap">
<result property="id" column="id"/>
<result property="projectId" column="project_id"/>
<result property="checkPeopleId" column="check_people_id"/>
<result property="createDate" column="create_date"/>
<result property="roadState" column="road_state"/>
<result property="siteClean" column="site_clean"/>
<result property="rinseDevice" column="rinse_device"/>
<result property="sprayDevice" column="spray_device"/>
<result property="fogGun" column="fog_gun"/>
<result property="soilCheck" column="soil_check"/>
<result property="description" column="description"/>
<result property="state" column="state"/>
<collection property="imageUrl" column="id" ofType="string" javaType="ArrayList"
select="com.cdls.carp.business.dao.TodayCheckImageDao.findByUid">
</collection>
</resultMap>
<select id="projectPage" resultMap="todayCheckMap" >
SELECT *
FROM b_today_check AS btc
WHERE
btc.visible = 1
<if test="projectId != null and projectId != ''">
and btc.project_id = #{projectId}
</if>
</select>
副表Dao层
副表mapper:
<mapper namespace="com.cdls.carp.business.dao.TodayCheckImageDao">
<!-- 可根据自己的需求,是否要使用 -->
<resultMap type="com.cdls.carp.business.entity.TodayCheckImageEntity" id="todayCheckImageMap">
<result property="id" column="id"/>
<result property="imageUrl" column="image_url"/>
<result property="typeCode" column="type_code"/>
<result property="todayCheckId" column="today_check_id"/>
</resultMap>
<select id="findByUid" resultType="string">
select image_url from b_today_check_image where today_check_id=#{id}
</select>
</mapper>
方法二:
主表Mapper层:
注意vo对象泛型定义为vo对象
总结:方法1是可以准确的传递一个List集合的图片,方法2是整体把副表对象传输过去,区别就不放出来了 可以自己去试试