<!--查询 新户水表信息 -->
<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>
sql语句foreach
最新推荐文章于 2024-06-12 22:34:57 发布