需求说明:前台下拉框为多选,还有一些文本框的查询条件,这些参数需要传到后台作为查询条件查询。

代码示例:

 java:


public DataObject[] queryOcsProcess(DataObject entity,PageCond pageCond){   
Map<String,Object> condition=new HashMap<String,Object>();
condition.put("planTypeCode", entity.getString("planTypeCode"));
String planStatus = entity.getString("planStatus");
if(planStatus !=null && !"".equals(planStatus)){
String[] arr = planStatus.split(",");
List<String> planList = new ArrayList<String>(arr.length);
for (int i = 0; i < arr.length; i++) {
planList.add(arr[i]);
}
condition.put("planStatus", planList);
}
DataObject[] result = getDASTemplate().queryByNamedSqlWithPage(DataObject.class, "queryOcsProcess.selOcsProcess", pageCond, condition);
return result;
}

命名SQL:


<isNotNull prepend="and" property="planStatus">    
r.plan_status in
<iterate property="planStatus" open="(" conjunction="," close=")">
#planStatus[]#
</iterate>
</isNotNull>

在参照网上的示例写出如上完美代码后,控制台一直报错:ParameterObject or property was not a Collection, Array or Iterator.


一直不明白上面的还有哪里有问题,使用了重启大法后,完美地查出了数据。