Action中:
ArrayList nameList = new ArrayList();
String names = request.getParameter("names"); //取到需要进行比较的参数
if (names != null && !names.equals("")) {
String[] name_ids = names.split(",");
for(int i=0; i<name_ids.length; i++) {
nameList.add(name_ids[i]); //放入list中
}
}
然后 , nameList作为对象属性放入对象中.
xml文件中加入:
<isNotEmpty property="nameList" prepend="and">
T.NUMBER in
<iterate property="nameList" open="(" close=")" conjunction=",">
#nameList[]#
</iterate>
</isNotEmpty>
即可完成sql中 number in(**,**,**,**)的功能 !