<!-- insert动态添加语句 -->
<insert id="add" useGeneratedKeys="true" keyProperty="likeId" parameterType="cc.domain.AudioLike">
insert into ${tableName}
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="audioId != null">
audio_id,
</if>
<if test="userId != null">
user_id,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="audioId != null">
#{audioId},
</if>
<if test="userId != null">
#{userId},
</if>
</trim>
</insert>
<!-- update动态修改语句 -->
<update id="updateOperateNum" parameterType="cc.domain.UserAudioOperateDTO">
UPDATE ${tableName}
<trim prefix="set" suffixOverrides=",">
<if test="likeNum != null">like_num = #{likeNum},</if>
<if test="collectionNum != null">collection_num = #{collectionNum},</if>
<if test="commentNum != null">comment_num = #{commentNum},</if>
</trim>
where id = #{audioId}
</update>
<!-- select in foreach语句 -->
<select id="selectListBatchAttrIds" resultType="cc.domain.GlobalAttr">
select <include refid="Base_Column_List"></include>
from ${tableName} where attr_id in
<foreach item="item" index="index" collection="attrIdList" open="(" separator="," close=")" >
#{item}
</foreach>
</select>
<!-- insert foreach语句 -->
<insert id="addBatch" parameterType="Object">
insert into ${tableName} (user_id, subscribe_type, order_id, transaction_id, start_time, end_time, create_time) values
<foreach collection="subscribeList" separator="," item="subscribe">
(#{subscribe.userId}, #{subscribe.subscribeType}, #{subscribe.orderId}, #{subscribe.transactionId}, #{subscribe.startTime}, #{subscribe.endTime}, #{subscribe.createTime})
</foreach>
</insert>
MyBatis Mapper文件动态sql语句
最新推荐文章于 2024-07-17 04:40:46 发布