List<Test> selectById(List<Integer> id);

<select id="selectById" parameterType="java.util.List"
    resultMap="BaseResultMap">
    select * from test
    where status = 'A'
    and id in
    <foreach collection="list" index="index" item="item" open="("
        separator="," close=")">
        #{item}
    </foreach>
</select>