代码如下
int[] a = {1,2};
List list=userDao.findStudent(a);
Mapper文件如下,其中parameterType可以不写,但是foreach标签中的 collection属性必须为array,如果是集合的话则必须为list,
<select id="findStudent" resultType="Student" >
select * from student
where 1=1
<if test="array != null and array.length != 0">
and nianji in
<foreach collection="array" open="(" separator="," close=")" item="nianji" index="index">
#{nianji}
</foreach>
</if>
</select>
版权声明:本文为zhaozihaowanwowo原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。