<select id="findCars" resultMap="BaseResultMap" parameterType="java.util.Map">
select
ID, COLOR, USER_ID
from table_car
where USER_ID = #{userId} AND ID IN
<foreach collection="carIds" index="index" item="carId" open="(" separator="," close=")">
#{carId}
</foreach>
</select>
例如
map.put("carIds",list);
collection:选map中对应的key,也就是carIds
item:就是这个种的每一项,自己取个名字,比如carId,然后和下面的#{carId}对应起来就行。