mybatis根据条件批量查询

  <!-- 根据条件批量查询 -->
  <select id="selectBySeatNum" parameterType="java.util.List" resultType="com.wap.platform.seat.entry.Seat">
   select
    <include refid="Base_Column_List" />
    from pf_seat where seat_num in
    <foreach item="item" index="index" collection="list" open="(" separator="," close=")">
             #{item}
    </foreach>
  </select>