MyBatis常用语法

2020-06-15  本文已影响0人  KevinL水杉

SELECT下WHERE的foreach

<select id="getListByActivityBeNotBeRelation"
resultType="com.ifchange.assessment.entity.ActivityEvaluationRelation">
        SELECT
        <include refid="FULL_COLUMNS"/>
        FROM activity_evaluation_relation
        WHERE `is_deleted`='N'
        <if test="activityID != null">AND `activity_id` = #{activityId}</if>
        <if test="beTestStaffID != null">AND `be_test_staff_id` = #{be_test_staff_id}</if>
        <if test="status != null">AND `status` = #{status}</if>
        <if test="testStaffIds.size() > 0">
            AND `test_staff_id` IN
            <foreach collection="testStaffIds" item="testStaffId" index="index" open="(" close=")" separator=",">
                #{testStaffId}
            </foreach>
        </if>
    </select>

INSERT下VALUES的foreach

<insert id="multiInsert">
        INSERT INTO
        activity_report_be_test(`activity_id`,`be_test_staff_id`,`reports`,`attach`)
        VALUES
        <foreach collection="activityReportBeTestList" item="activityReportBeTest" separator=",">
            (#{activityReportBeTest.activityId},
            #{activityReportBeTest.beTestStaffId},
            #{activityReportBeTest.reports},
            #{activityReportBeTest.attach})
        </foreach>
    </insert>
上一篇 下一篇

猜你喜欢

热点阅读