mybatis多参数传递(包括数组)
mapper接口的方法:
public void batchDelete(@Param(value = "activityId") Integer activityId, @Param(value = "userIds") Integer[] userIds);
mapper.xml的配置:
<delete 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> </delete>