Java代码
String [] mobiles={'111','222'};
map.put("mobiles", mobiles);
getSqlMapClientTemplate().queryForLit("query", map);
xml部分
<select id="query" resultMap="A5StaffApplyInfo_result" parameterClass="map">
SELECT * form table_name
where 1= 1
<isNotEmpty prepend="and" property="mobiles">
a.mobile in
<iterate property="mobiles" open="(" close=")" conjunction=",">
#mobiles[]#
</iterate>
</isNotEmpty>
</select>