MyBatis动态 SQL语法IN 语句代码示例

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