ibatis中入参为List的处理方式
??? <select id="getCategories" parameterresultclose=")" conjunction=",">
??? ??? ??? ??? #paramList[]#
??? ??? ??? </iterate>??? ??? ??? ??? ??? ??? ??? ???
??? ??? </dynamic>
??? </select>
在iterate标签中,不能写property="paramList",会报错:Error getting ordinal list from JavaBean
不建议这种方式,因为当paramList.size()==0的时候,sql语句错误:SELECT * FROM category?? WHERE??????? catid in
?List paramList = new ArrayList();
????? paramList.add("FISH");
????? paramList.add("DOGS");
????? paramList.add("BIRDS");
?<iterate? open="(" close=")" conjunction=",">
??? ??? #paramList1[]#
</iterate>???
参数签名不一致也能正常执行。