关于ibatis传递多个参数（急）

[freshman_java]

测试方法：
public List getAllModelNode(String pid,String mids){
Map map = new HashMap();
map.put("mids", mids);
map.put("pid", pid); List list = null;
List nodeList = new ArrayList();
try {
list = sqlMapClient.queryForList("selectAllModelNode",map);
System.out.println(list.size());
for(int i=0;i<list.size();i++){
T_Model tm = (T_Model)list.get(i);
List childList = getAllModelNode(tm.getMODEL_ID(),mids);
tm.setList(childList);
nodeList.add(tm);
}
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println(nodeList.size());
return nodeList;
}
xml配置
<select id="selectAllModelNode" parameterClass="java.util.Map" resultClass="Model">
select * from T_Model
where model_id in (#mids#)
and f_model_id = #pid#
and useable_flag = 1
order by display_order asc </select>
测试方法调用
List list = new ModelDaoImpl4Ibatis().getAllModelNode("0","1,2,3,5,6,7,8,9")
求解：mids作为以","分隔的字符串参数传递进去，是不是ibatis不支持？还是？如何解决？

[TKD03072010]

友情帮顶！

[Inhibitory]

多参数，要么用Map，要么用Bean

[chenzhaohui555]

如果相传字符串sql的话：(#mids#)改为($mids$)
如果想传集合或者数组的话：

<select id="selectAllModelNode" parameterClass="java.util.Map" resultClass="Model">
select * from T_Model 
where model_id in (
<iterate conjunction="," property="mids">
    #mids#
</iterate>
)
and f_model_id = #pid#
and useable_flag = 1
order by display_order asc </select>

#mids#为集合或者数组

[xianaofei]

报什么错误啊 List list = new ModelDaoImpl4Ibatis().getAllModelNode("0","1,2,3,5,6,7,8,9")

你用正常的参数试试 啊能通过

[devin_jia]

<!-- 分页查询表所有属性 -->
	<select id="selectPageAll" parameterType="Ele" resultType="Users">
		select t1.* from (select rownum as recnum, t2.* from(select * from
		employee
		<where>
			<if test="usName!=null">
				And name=#{usName}
			</if>
			<if test="usAge!=null">
				And age=#{usAge}
			</if>
			<if test="usEmail!=null">
				And email=#{usEmail}
			</if>
		</where>
		order by id) t2 )t1 where t1.recnum>=#{pageStart} and
		t1.recnum<=#{pageEnd}

	</select>

我的xml
用bean
不知道你那个正确不？

[金子般的心_LAF]

3楼正解

[javaors]

楼主想一想，肯定不可以啊

SQL语句最后会变为：
select * from T_Model
where model_id in ('1,2,3,4,5,6')
and f_model_id = 0
and useable_flag = 1
order by display_order asc

这种当然差不多结果。

3楼的楼主可以尝试下。