sql语句foreach

    <!--查询 新户水表信息 -->
    <select id="getWaterMeterStartByMeterCodeNew" parameterType="com.jczb.binhe.oa.model.WaterMeterStartCodeDetail" resultType="com.jczb.binhe.oa.model.UserMeterRelevance">
        select *
        from tw_sfsl_user_meter_relevance
        where meterCode IN
        <foreach collection="param1" index="index" item="item" open="(" separator="," close=")">
            #{item.meterCode}
        </foreach>
        AND recycle = 0
        <if test="param2 != null and param2 != ''">
            AND outUserId != #{param2}
        </if>
    </select>