MyBatis Mapper文件动态sql语句

<!-- 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>