Question

ibatis.传递参数类型为ArrayList，需要在ibatis的SQLMap中进行下列操作。

首先从DB中查询出一个值赋给变量aa，然后再ibatis中遍历参数List，用aa与List中的值比较，相等执行插入SQL，否则执行update SQL,小弟对ibatis一知半解，请高手指点一二.

Answer 1

遍历参数
<iterate property="list" open="" close="" conjunction="">
<isEqual property="list[]" compareValue="aa">
insert
</isEqual>
<isNotEqual property="list[]" compareValue="aa">
update
</isNotEqual>
</iterate>

Answer 2

<select id="checksame" resultClass="java.lang.Integer" parameterClass="java.util.Map" >
select count(schoolid)
from school
<dynamic prepend="WHERE">
<isNotEmpty prepend="AND" property="other1">
(other1 = #other1#)
</isNotEmpty>
<isNotEmpty prepend="AND" property="schoolcode">
(schoolcode = #schoolcode#)
</isNotEmpty>
<isNotEmpty prepend="AND" property="isuse">
(isuse = #isuse#)
</isNotEmpty>
<isNotEmpty prepend="AND" property="schooladdress">
(schooladdress = #schooladdress#)
</isNotEmpty>
<isNotEmpty prepend="AND" property="schoolid">
(schoolid <![CDATA[ <> ]]> #schoolid#)
</isNotEmpty>
</dynamic>
</select>
大概是这样的结构，
不用dynamic也行，
直接把返回的集合改下，
要先在sqlmap-config中定义
然后where中大概这样：
where user like #user
and #bigage
and...#smallage