mybatis 批量查询

List

<!-- 判断当前数据是否被预定 -->
 <select id="isOrdered" parameterType="java.util.List" resultType="java.lang.Integer">
  SELECT count(1)
  FROM place WHERE
  <foreach collection="list" item="item" index="index" separator="or">
  (
  <if test="item.shopId">shopId = #{item.shopId}</if>
  <if test="item.sportId">AND sportId = #{item.sportId}</if>
  <if test="item.exptCsTm">AND exptCsTm = #{item.exptCsTm}</if>
  <if test="item.placeId">AND placeId = #{item.placeId}</if>
  <if test="item.rowId">AND timeId = #{item.rowId}</if>
  AND orderSt = '1'
  )
  </foreach>
 </select>

Array

<!-- 批量获取文章信息 -->
 <select id="getArticleBatch" resultType="IsForumArticleBean">
  select id, articleTitle
  from forum_article
  where id in
  <foreach collection="array" item="item" index="index" open="(" separator="," close=")">
  #{item}
  </foreach>
 </select>