SpringMVC前端字段多选查询（sql in 关键字）

1、jsp

<div class="col-md-3">
	<sys:codeselectmul name="pdjg" optionsList="${gfunc:getSysCode('pdjg') }" cssClass="bs-select form-control"></sys:codeselectmul>
</div>		

2、controller

//前端以“字段1,字段2,...”字符串传送到后端
public String getDataList(Data_U record, Model model) {
	//将多选字段添加入Map中，方便mybatis查询
	record.addPara("pdjg",record.getPdjg());
	...
}


public Map<String, Object[]> params = new HashMap<String,Object[]>();
public void addPara(String fieldName, String values){
	if(values != null && values.length() > 0){
		String[] lst = values.split(",");
		params.put(fieldName, lst);
	}
 }

3、dao

public List<Data_U> getDataList(Page<Data_U> page, @Param("record")Data_U record);

4、mapper

<if test="record.pdjg != null"> 
   AND PDJG in 
    <foreach item="item" index="index" collection="record.params.pdjg" 
         open="(" separator="," close=")">
         #{item}
    </foreach> 
</if>