将其它参数和数组参数都put到map对象中,该map对象作为语句的参数传入sqlmap。
如下
<select id="getOneWayCall" resultClass="oneWayCall" parameterClass="java.util.Map">
...
<dynamic prepend="where">
<isNotEmpty prepend="and" property="cellid_b">
cellid_b in
<iterate property="cellid_b" conjunction="," open="(" close=")" >
#cellid_b[]#
</iterate>
</isNotEmpty>
</dynamic>
)
...
</select>
如果in 参数传入的是构造好的,,,字符串,则配置sql时可用$代替#
如下
<select id="getOneWayCall" resultClass="oneWayCall" parameterClass="java.util.Map">
...
<dynamic prepend="where">
<isNotEmpty prepend="and" property="cellid_b">
cellid_b in
<iterate property="cellid_b" conjunction="," open="(" close=")" >
#cellid_b[]#
</iterate>
</isNotEmpty>
</dynamic>
)
...
</select>
如果in 参数传入的是构造好的,,,字符串,则配置sql时可用$代替#