在写select查询的parameterType的时候发现,如果parameterType是一个数组的话,配置语句中不写这个参数类型
<delete id="delRecord" >
DELETE FROM W_BR_PAY_RECORD
WHERE
ID in
<foreach collection="array" item="id" index="index" open="(" separator="," close=")">
#{id}
</foreach>
</delete>
要么配置语句中把参数类型parameterType写成java.util.List也可以如下
<delete id="delRecord" parameterType="java.util.List">
DELETE FROM W_BR_PAY_RECORD
WHERE
ID in
<foreach collection="array" item="id" index="index" open="(" separator="," close=")">
#{id}
</foreach>
</delete>
如果参数数组元素是整数也可以写成
<delete id="delRecord" parameterType="Integer[]" >
DELETE FROM W_BR_PAY_RECORD
WHERE
ID in
<foreach collection="array" item="id" index="index" open="(" separator="," close=")">
#{id}
</foreach>
</delete>
**或者**
<delete id="delRecord" parameterType="Int[]" >
DELETE FROM W_BR_PAY_RECORD
WHERE
ID in
<foreach collection="array" item="id" index="index" open="(" separator="," close=")">
#{id}
</foreach>
</delete>
如果参数map集合也可以写成
<delete id="delRecord" parameterType="java.util.HashMap" >
DELETE FROM W_BR_PAY_RECORD
WHERE
ID in
<foreach collection="array" item="id" index="index" open="(" separator="," close=")">
#{id}
</foreach>
</delete>
或者
<delete id="delRecord" parameterType="java.util.Map" >
DELETE FROM W_BR_PAY_RECORD
WHERE
ID in
<foreach collection="array" item="id" index="index" open="(" separator="," close=")">
#{id}
</foreach>
</delete>