关于mybatis的批量处理xml映射方法

myabtis的批量插入一般写法

<insert id="insertBatch" parameterType="java.util.List">

        insert into attachment_table (account,password,nickname)

        values

        <foreach collection="list" item="item" index="index" separator=",">

            (

                #{item.account,jdbcType=VARCHAR},

                #{item.password,jdbcType=VARCHAR},

                #{item.nickname,jdbcType=VARCHAR}

            )

        </foreach>

</insert>

mybatis的批量修改一般写法

<update id="updateBatch" parameterType="java.util.List">

    update attachment_table

    <trim prefix="set" suffixOverrides=",">

        <trim prefix="account =case" suffix="end,">

            <foreach collection="list" item="item" index="index">

              when id=#{item.id} then #{item.account }

            </foreach>

        </trim>

        <trim prefix="password=case" suffix="end,">

            <foreach collection="list" item="item" index="index">

              when id=#{item.id} then #{item.password}

            </foreach>

        </trim>

        <trim prefix="nickname =case" suffix="end,">

            <foreach collection="list" item="item" index="index">

              when id=#{item.id} then #{item.nickname}

            </foreach>

        </trim>

    </trim>

    where id in

    <foreach collection="list" index="index" item="item"

            separator="," open="(" close=")">

      #{item.id,jdbcType=BIGINT}

    </foreach>

  </update>

mybatis批量查询一般写法

<select id="findList" parameterType="java.util.List">

        select

        from attachment_table

        <where>

            1=1

            and id in

            <foreach collection="list" item="item" open="(" separator="," close=")">

                #{item,jdbcType=BIGINT}

            </foreach>

        </where>

</select>