mybatis使用foreach查询

    <select>
    <include refid="Base_Column_List" />
    from router
    where management_id = #{managementId,jdbcType=INTEGER} and department_id = #{departmentId,jdbcType=INTEGER} and
    id in 
    <foreach collection="routerIds" index="index" item="item" open="(" separator="," close=")">
      #{item.routerId,jdbcType=INTEGER}
    </foreach>
    </select>