interface
/**
* 插入列表
* @param list
* @return
*/
int insertChangeLevelEntitys(@Param("list") List<ChangeLevelEntity> list );
xml
<insert id="insertChangeLevelEntitys" parameterType="ChangeLevelEntity">
insert into XXXXXX.LD_BASE_CHANGE_LEVEL (ID, FIELD_ID, WEIGHT,AUTH_LEVEL, MONEY)
<foreach collection="list" item="item" index="index" separator="union all" >
(SELECT
#{item.id,jdbcType=VARCHAR},
#{item.fieldId,jdbcType=VARCHAR},
#{item.weight,jdbcType=DECIMAL},
#{item.level,jdbcType=VARCHAR},
#{item.money,jdbcType=DECIMAL}
FROM DUAL)
</foreach>
</insert>
注意点
没有==values==
在写表名称时也要将用户名写上