mybatis 批量操作

mybatis批量其实就是一个用mysql句柄拼sql的过程：

批量更新：

<update id="updateBatch" parameterType="java.util.List">        UPDATE test set        <foreach collection="list" item="item" index="index"            separator=" " open="FSEQ = CASE" close="end,">            WHEN FID = #{item.fid} then #{item.fseq,jdbcType=NUMERIC}        </foreach>        <foreach collection="list" item="item" index="index"            separator=" " open="FPARENTID = CASE" close="end,">            WHEN FID = #{item.fid} then #{item.fparentId,jdbcType=VARCHAR}        </foreach>        <foreach collection="list" item="item" index="index"            separator=" " open="CFPURORDERUNITID = CASE" close="end">            WHEN FID = #{item.fid} then #{item.cfpurOrderUnitId,jdbcType=NUMERIC}        </foreach>        WHERE FID IN (        <foreach collection="list" item="item" index="index"            separator=",">            #{item.fid}        </foreach>        )    </update>

批量查询：

<select id="queryByids" resultMap="BaseResultMap" parameterType="java.util.List">        select        fid,fseq,fparentId,cfpurOrderUnitId        from test        <where>            id in (            <foreach collection="list" item="item" index="index"                separator=",">                #{item.id}            </foreach>            );        </where></select>