mybatis中判断list不为空，并且遍历list的SQL语句

    <if test="statusList != null and statusList.size()>0" >
      and user.status in 
      <foreach collection="statusList" item="item" open="(" close=")" separator="," >
        #{item}
      </foreach>
    </if>   

注：上述statusList类型为List<T>