mybatis批量插入list

<insert id="addBatch" parameterType="java.util.List">
    INSERT ALL
<foreach collection="list" item="item" index="index">
INTO T_ACCOUNT_WATER (
<include refid="selectAllColumnsSql" />
    ) VALUES (
getId_by_seq('SEQ_ACCOUNT_WATER'),
#{item.accountDate, jdbcType=CHAR},
#{item.accountSource, jdbcType=VARCHAR},
#{item.tallyType, jdbcType=VARCHAR},
#{item.expenseFlag, jdbcType=VARCHAR},
#{item.businessType, jdbcType=VARCHAR},
#{item.paymentOrderNo, jdbcType=VARCHAR},
#{item.orderId, jdbcType=VARCHAR},
#{item.voucherNo, jdbcType=VARCHAR},
#{item.drCrFlag, jdbcType=VARCHAR},
#{item.subjectNo, jdbcType=NUMERIC},
#{item.accountNo, jdbcType=NUMERIC},
#{item.drCrAmount, jdbcType=NUMERIC},
#{item.preDrAmount, jdbcType=NUMERIC},
#{item.preCrAmount, jdbcType=NUMERIC},
#{item.drAmount, jdbcType=NUMERIC},
#{item.crAmount, jdbcType=NUMERIC},
#{item.accountAmount, jdbcType=NUMERIC},
#{item.status, jdbcType=VARCHAR},
#{item.operatorId, jdbcType=VARCHAR},
sysdate,
sysdate
)
</foreach>
select 1 from dual
</insert>









<select id="getCodesByRole" resultMap="menuMap">
SELECT
DISTINCT mn.ID,
mn.NAME,
mn.PARENT_NO,
mn.URL,
mn.CODE,
mn.STYLE_CSS,
mn.STATUS,
mn.ORDER_BY
FROM T_MENU mn, T_ROLE_MENU rm WHERE mn.ID = rm.MENU_ID AND rm.ROLE_ID IN
<foreach item="item" collection="rList" open="(" separator="," close=")"> 
  #{item.roleId} 
</foreach>
ORDER BY ORDER_BY Asc
</select>