方式1:
xx.mapper文件
public interface MutiMediaInfoMapper {
/**
* 获取信息列表
*/
List<MutiListVO> selectByUserId(MutiVO mutiVO);
}
xx.mapping文件
<select id="selectByUserId" parameterType="com.readygo.missBang.vo.MutiVO" resultType="com.readygo.missBang.vo.MutiListVO">
SELECT
(SELECT COUNT(1) FROM t_user_collect tuc WHERE tuc.COLLECT_USER_ID = #{userId} AND tuc.COLLECT_SOURCE_ID = '10000000000000001') AS collectionFlag
FROM
t_muti_media_info tmmi
WHERE
tmmi.USE_FLAG = 1
</select>
备注:这种应该是mybatis的官方传参方式
方式2
xx.mapper文件
public interface MutiMediaInfoMapper {
/**
* 获取信息列表
*/
List<MutiListVO> selectByUserId(@Param("mutiVO") MutiVO mutiVO);
}
xx.mapping文件
<select id="selectByUserId" parameterType="com.readygo.missBang.vo.MutiVO" resultType="com.readygo.missBang.vo.MutiListVO">
SELECT
(SELECT COUNT(1) FROM t_user_collect tuc WHERE tuc.COLLECT_USER_ID = #{mutiVO.userId} AND tuc.COLLECT_SOURCE_ID = '10000000000000001') AS collectionFlag
FROM
t_muti_media_info tmmi
WHERE
tmmi.USE_FLAG = 1
</select>
总结:
方式1:xx.mapper直接传对象,xx.mapping直接用 属性 接收。
方式2:xx.mapper传注解对象,xx.mapping用 注解对象.属性 接收。