根据多个id查询数据

//根据设备多个id获取设备信息

   public List<Devices>  getDevicesAll(@Param("devicesIds") String[] devicesIds);
 




 <select id="getDevicesAll" resultMap="BaseResultMap">
  	select 
  	<include refid="Base_Column_List"/>
  	from sys_devices d 
  	where 
  	d.devices_id  in 
  	<foreach item="devices_id" index="index" collection="devicesIds" 
         	 	open="(" separator="," close=")">
         #{devices_id}
  	</foreach>
	<!-- <where>
  		 <if test="devicesIds != null">
  		 d.devices_id  in 
 		  	<foreach item="item" index="index" collection="array" 
         	 	open="(" separator="," close=")">
         			#{item}
  			</foreach>
		 </if>
  	</where> -->
  </select>

用param标签