Mybatis根据数组或者List查询List结果

数组参数

//接口方法
ArrayList<User> selectByIds(Integer [] ids);

//xml映射文件
<select id="selectByIds" resultMap="BaseResultMap">
    select
    *
    from user where id in
    <foreach item="item" collection="array" open="(" separator="," close=")">
        #{item}
    </foreach>
</select>

List参数

//接口方法
ArrayList<User> selectByIds(List<Integer> ids);

//xml映射文件
<select id="selectByIds" resultMap="BaseResultMap">
    select  
    <include refid="Base_Column_List" />
    from user where id in
    <foreach item="item" index="index" collection="list" open="(" separator="," close=")">
        #{item}
    </foreach>
</select>