MyBatis-返回List类型参数。
Mapper.java
public interface StorageMapper extends BaseMapper<Storage> { List<Integer> getStorageIdByChannelId(List<Integer> channelIds); }
mapper.xml
<select id="getStorageIdByChannelId" resultType="java.lang.String">
select
storage_id
from
res_storage
<where>
<if test="#{0} != null and #{0}.size() != 0">
channel_id in
<foreach item="tempId" collection="list" open="(" separator="," close=")">
#{tempId}
</foreach>
</if>
</where>
</select>
resultType设置成String,myBatis会自动将结果转成List集合。