MyBatis框架使用问题
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>