今天用到查询参数是一个不定元素个数的数组如int[]、String[]
在写select查询的parameterType的时候发现,如果parameterType是一个数组的话,要么配置语句中不写这个参数类型
即如下:
<select id="getMemberListById" resultType="java.util.HashMap" >
select id,member_name from member_info where dealer_level in
<foreach collection="array" item="id" open="(" separator="," close=")">
#{id}
</foreach>
order by id
</select>
要么配置语句中把参数类型parameterType写成java.util.List也可以如下
<select id="getMemberListById" resultType="java.util.HashMap" parameterType="java.util.List" >
select id,member_name from member_info where dealer_level in
<foreach collection="array" item="id" open="(" separator="," close=")">
#{id}
</foreach>
order by id
</select>
如果参数数组元素是整数也可以写成
<select id="getMemberListById" resultType="java.util.HashMap" parameterType="Integer[]" >
select id,member_name from member_info where dealer_level in
<foreach collection="array" item="id" open="(" separator="," close=")">
#{id}
</foreach>
order by id
</select>
还可以写成
<select id="getMemberListById" resultType="java.util.HashMap" parameterType="int[]" >
select id,member_name from member_info where dealer_level in
<foreach collection="array" item="id" open="(" separator="," close=")">
#{id}
</foreach>
order by id
</select>
但是不能写成String[]的,这会报错 Could not resolve type alias 'string[]'. Cannot find class: string[]
如果传入的参数整体是个Map<String,Object>的时候,Map里面既有数组对象元素,又有其他类型参数的时候怎么写呢?
如:参数的整体是 Map<String,Object> param=new HashMap<String,Object>
String[] str={"aaa","bbb",ccc","ddd"};
param.put("a",str); /*把数组添加到Map参数param中以a为键*/
param.put("b","testb") /*把字符串添加到Map参数param中以b为键*/
查询的sql应该是如下形式
<select id="getTest" resultType="java.util.HashMap" parameterType="java.util.HashMap" >
SELECT * FROM test where filed_a = #{b} and filed_b in
<foreach collection="a" item="itema" open="(" separator="," close=")">
#{itema}
</foreach>
</select>
参数的整体类型是java.util.HashMap这个是没什么疑问的。需要注意的是foreach循环的collection直接写map中数组对象的键(测试中为a)即可