ibatis 传递参数类型为Map<String,Object> 并且map的value有String 也有数组或者List的时候
<select id="getshopInfoByCondition" parameterClass="java.util.Map" resultClass="java.lang.String">
SELECT *
FROM (SELECT A.*, ROWNUM RN
FROM (
select SHOP_NO
from tbl_shop
where SELL_CTGY IN
<iterate close=")" open="(" conjunction="," property="car_ctgy">
<![CDATA[
#car_ctgy[]#
]]>
</iterate>
) A
<![CDATA[ WHERE ROWNUM < #end_index# ]]>
)
<![CDATA[ WHERE RN >= #start_index# ]]>
</select>
单独传数组的时候 不用写parameterClass iterate标签里也不用加property属性 数组名也不需要写在迭代内 像下面一样直接迭代
<select id="shopCount"