public int getPublicIPVmNumber(List<Integer> orderList, Date date) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("orderList", orderList); ---MAP中对应的KEY,VALUE的设置
map.put("date", date);
Integer getPublicIPVmNumberCount = (Integer) sqlMapClientTemplate .queryForObject("getPublicIPVmNumber", map);
}
// IBATIS 配置
<!-- 直接迭代和有集合、其他参数的迭代的区别是在迭代里面加property属性 -->
<select id="getPublicIPVmNumber" resultClass="int" parameterClass="java.util.Map">
<![CDATA[
SELECT SUM(vmNumber) FROM VMOrder WHERE STARTDATE <= #date# AND ENDDATE >= #date# AND id in
]]>
<iterate property="orderList" conjunction="," close=")" open="(">
#orderList[]#
</iterate>
</select>