mybatis中批量执行update语句

Dao层写法

    /**
     * 批量更新
     * @param list 集合
     * @return 执行结果
     */
    int updateBatch(@Param("list") List<SysUser> list);

Oracle的sql语句

UPDATE SYS_USER A
SET A.NAME= 
	CASE A.ID
		WHEN '101' THEN '101test'
		WHEN '102' THEN '102test'
		WHEN '103' THEN '103test'
		WHEN '104' THEN '104test'
	END
,SET A.AGE= 
	CASE A.ID
		WHEN '101' THEN 12
		WHEN '102' THEN 25
		WHEN '103' THEN 15
		WHEN '104' THEN 10
	END
WHERE
	A.ID IN ('101', '102', '103', '104')

Mybatis的xml写法

	<update id="updateBatch" parameterType="java.util.List">
		UPDATE SYS_USER A
		SET A.NAME=
		<foreach collection="list" item="item" index="index"
				 separator=" " open="CASE A.ID" close="end">
		WHEN #{item.id} THEN #{item.name}
		</foreach>
		,SET A.AGE=
		<foreach collection="list" item="item" index="index"
				 separator=" " open="CASE A.ID" close="end">
		WHEN #{item.id} THEN #{item.age}
		</foreach>
		WHERE A.ID IN
		<foreach collection="list" index="index" item="item"
				 separator="," open="(" close=")">
			#{item.id}
		</foreach>
	</update>