小任班长的博客 mybatis 查询 xml list参数
mybatis 查询 xml list参数；
<select id="getByIds" resultType="string" parameterType="java.util.List">
SELECT a.FENLEINAME from Tab a where a.id in (select b.pid from TB
b where b.id in
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
)
</select>
