<select id="selectProvinceByStoreNumber" parameterType="java.util.List" resultType="cn.smb.web.store.model.StoreEntity"> SELECT province, storeNumber FROM store where storeNumber in <foreach collection="list" index="index" item="item" open="(" separator="," close=")"> #{item} </foreach> </select>
collection传的值
item就是每次循环取出来的对象;
separator 用什么分割;
close 以什么结尾