mybatis oracle 多对多 返回结果list中包含list

 /**
     * mapper方法定义  查询视频参与人列表
     * @param list
     * @param videoStatus
     * @return
     */
    public List<VideoRecordNameModel> selectVideoRecordName(@Param("list")List<String> list, @Param("videoStatus")int videoStatus);
 <resultMap id="VideoRecordNameResultMap" type="com.paic.icore.agr.farmer.farmerinfo.model.VideoRecordNameModel">
    <result column="VIDEO_BASE_ID" property="videoBaseId" jdbcType="VARCHAR"/>
    <collection property="nameList" ofType="java.lang.String" javaType="java.util.ArrayList">
      <result column="USER_NAME"></result>
    </collection>
  </resultMap>
<select id="selectVideoRecordName" resultMap="VideoRecordNameResultMap" parameterType="java.util.List">
    select
    r.VIDEO_BASE_ID,
    r.USER_NAME
    from AIMS_VIDEO_RECORD r
    where r.VIDEO_BASE_ID in
    <foreach collection="list" index="index" item="item" open="(" separator="," close=")">
        #{item}
    </foreach>
    <if test="videoStatus == 1">
      and (r.STATUS = 0 or r.STATUS = 1 or r.STATUS = 2)
    </if>
    <if test="videoStatus == 2">
    and r.STATUS = 1 or r.STATUS = 2
  </if>
  </select>
public class VideoRecordNameModel implements Serializable {
    private String videoBaseId;
    /**
     * 邀请人列表
     */
    private List<String> nameList = new ArrayList<String>();
    private int userStatus;
    public int getUserStatus() {
        return userStatus;
    }

    public void setUserStatus(int userStatus) {
        this.userStatus = userStatus;
    }

    public List<String> getNameList() {
        return nameList;
    }

    public void setNameList(List<String> nameList) {
        this.nameList = nameList;
    }

    public String getVideoBaseId() {
        return videoBaseId;
    }

    public void setVideoBaseId(String videoBaseId) {
        this.videoBaseId = videoBaseId;
    }
}
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值