ibatis要select * from table1 where id in (1,2,3,34,213,……)
<select></select>里的parameterClass要是List<int>
这整个select结点要怎么写?我这么写怎么不行?
<select id="GetsBySeqnos" resultMap="AResult" parameterClass="System.Collections.Generic.List`1[[System.Int32]]">
<![CDATA[
select
*
from table1
where SEQNO IN
]]>
<iterate open="(" conjunction="," close=")">
#value[]#
</iterate>
</select>
<select></select>里的parameterClass要是List<int>
这整个select结点要怎么写?我这么写怎么不行?
<select id="GetsBySeqnos" resultMap="AResult" parameterClass="System.Collections.Generic.List`1[[System.Int32]]">
<![CDATA[
select
*
from table1
where SEQNO IN
]]>
<iterate open="(" conjunction="," close=")">
#value[]#
</iterate>
</select>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货