List list ={1,2,3} String s=""; for(int i=0;i<list.size();i++){ s+=",'"+list.get(i)+"'"; } s=s.subtring(1); 结果是s='1','2','3'
使用$参数名$就可以了,$符号会原样输出参数如select * form userInfo where id in ($ids$) ids="1,32,25" 即为select * from userInfo where id in (1,32,25) 如果id为字符串类型,你在组装ids字符串时对应加上单引号为ids="'1','32','25'";
<isNotEmpty prepend="and" property="result">
<![CDATA[ SITENO in ]]>
<iterate property="result" conjunction="," open="(" close=")">
#result[]#
</iterate>
</isNotEmpty>
</dynamic>
String s="";
for(int i=0;i<list.size();i++){
s+=",'"+list.get(i)+"'";
}
s=s.subtring(1);
结果是s='1','2','3'