在网上看到的这个标签,限于本人不甚了解,求大神指教,感激不尽
<select id="checkCodeIsRepetition" resultType="ReportDisplayInfo" parameterType="java.util.List">
select <include refid="reportDisplayInfo" />
from BR_ReportDisplayInfo
where REPORTDISPALYCODE in
<foreach collection="reportDisplayinfoCodes" index="index" item="codeList" separator=" OR REPORTDISPALYCODE IN " >
<foreach collection="codeList" index="index" item="info" open="(" separator="," close=")">
#{info.displayCode}
</foreach>
</foreach>
</select>
图呢?
SELECT * FROM ls_lock_set WHERE lockId In('02121233398','02121243180') OR lockId IN ('02121229943','02121240488')
– 生活这把杀猪刀 5年前