mysql语句如下:
UPDATE attendee_table a SET state=2 WHERE a.id IN(1,3,5)
mybatis的mapper如下：
int updateStateByIDs(@Param("ids") String[] ids, @Param("state") Integer state);
mybatis的mapper.xml文件如下：
<update id="updateStateByIDs">
UPDATE attendee_table a SET state=#{state,jdbcType=TINYINT} WHERE a.id IN
<foreach item="item" index="index" collection="ids" open="(" separator="," close=")">
#{item}
</foreach>
</update>