Question

Mybatis查询实例，sql中的in在Mybatis中怎么写

Answer 1

<select id="findByIdsMap" resultMap="BaseResultMap">  
 Select *
 from tb1 where ID in  
 <foreach item="item" index="index" collection="list" open="(" separator="," close=")">  
  #{item}
 </foreach>  
</select>

<select id="findByIdsMap" resultMap="BaseResultMap">  
select * 
from tb1 where ID in  
    <foreach item="item" index="index" collection="array" open="(" separator="," close=")">  
     #{item}  
    </foreach>  
</select>

根据参数类型进行选择

Answer 2

select * from table where id in
<foreach collection="list" item="table" open="(" close=")" separator=",">
#{table}
</foreach>

自己理解一下，不懂再问