mybatis多参数传递(其中包括数组)
mapper接口
public void batchDelete(@Param(value = "activityId") Integer activityId, @Param(value = "userIds") Integer[] userIds);
mapper.xml的配置
<insert id="batchDelete"> delete from T_ACT_USERS where ACTIVITY_ID = #{activityId} and USER_ID in <foreach collection="userIds" item="item" index="index" open="(" separator="," close=")"> #{item} </foreach> </insert>