<selectid="getListByCourseIds"resultMap="CourseFavoritesResult">
select <includerefid="edu_course_favorites_columns"/>
from edu_course_favorites
where edu_course_favorites.course_id in
<foreachcollection="list"item="item"separator=","open="("close=")">
#{item}
</foreach></select>
根据id串查询<select id="getListByCourseIds" resultMap="CourseFavoritesResult"> select <include refid="edu_course_favorites_columns"/> from edu_course_favorites where edu_course_favorites.course_id in <foreach collection="list" item="item" s