java代码:
public class DoctorParam {
一、bean
/** 医生状态 */
private String status;
/** 医生状态数组 **/
private List<Integer> statusList;
public List<Integer> getStatusList() {
return statusList;
}
public void setStatusList(List<Integer> statusList) {
this.statusList = statusList;
}
public String getStatus() {
return status;
}
public void setStatus(String status) {
this.status = status;
}
二、组装参数
// 校验医生状态
if(json.containsKey("status")){
String status = json.getString("status");
condition.setStatus(status);
String [] str= status.split(",");
List<Integer> statusList = new ArrayList<Integer>();
for(int i = 0;i<str.length;i++){
Integer statusInt = new Integer(str[i]);
statusList.add(statusInt);
}
condition.setStatusList(statusList);
}
三、sqlMap文件
<if test="statusList != null">
AND p.`status` in
<foreach item="item" index="index" collection="statusList" open="("
separator="," close=")">
#{item}
</foreach>
</if>
}