sql.xml where ids in的写法

 <if test="iSurfaceTypeArray != null">
            AND b.i_SurfaceType in    <!-- 根据外观检查查询 -->
            <foreach collection="iSurfaceTypeArray" item="iSurfaceType" index="index" open="(" close=")" separator=",">
                '${iSurfaceType}'
            </foreach>
        </if>