<select id="getres" parameterType="java.util.List"
            resultType="……RiskFeature">
        select
        *
        from
        f
        where g.is_deleted=0
        <if test="items != null and items.size()>0">
            and f.source_hive_info in
            <foreach collection="items" index="index" item="item" open="(" separator="," close=")">
                #{item}
            </foreach>
        </if>
        <if test="items == null or  items.size()==0">
          limit 10
        </if>
    </select>