<insert id="xxx" parameterType="java.util.List">
INSERT INTO tabelName(
reason,
status
)
VALUES
<foreach collection="list" item="item" index="index" separator=",">
(
#{item.xxx,jdbcType=VARCHAR},
#{item.xxx,jdbcType=INTEGER}
)
</foreach>
</insert>
<select id="xxx" resultType="java.util.Map">
SELECT *
FROM tabelName
WHERE
status=1
and id IN
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</select>