今天开发一个普通的查询接口,看网上的教程被小坑了一把,特此留意
SELECT channelId, name
FROM channel
WHERE userId = #{userId,jdbcType=VARCHAR} AND status='Y' AND channelId in
<foreach item="channelIds" index="index" collection="channelIds" open="(" separator="," close=")">
#{channelIds}
</foreach>