mybatis 中入参为对象中的list类型的属性

其中入参的实体属性

    private List<String> deptCodes;

 

主要看一下下面xml 参数 deptCodes

 

  <select id="queryByCondition" parameterType="com.alibaba.gov.revisal.execute.condition.SolutionAuthPageCondition"  resultMap="BaseResultMap">

    select
    <include refid="Base_Column_List" />
    from aaaa
    where 1=1
<!--    <if test="deptCode != null">
      and dept_code = #{deptCode}
    </if>-->
    <if test="authCode != null">
      and aucode = #{authCode}
    </if>
    <if test="status != null">
      and status = #{status}
    </if>
    <if test="name != null">
      and name like concat('%',#{name},'%')
    </if>
    <if test="gmtCreateStart != null">
      and start_time &gt;= #{gmtCreateStart}
    </if>
    <if test="gmtCreateEnd != null">
      and end_time &lt;= #{gmtCreateEnd}
    </if>
    <if test="deptCodes !=null  and deptCodes.size()>0">
      and dept_code in
      <foreach collection="deptCodes" item="item"  index="index" open="("  separator="," close=")">
        #{item}
      </foreach>
    </if>
    order by gmt_modified desc
    <if test="startNum != null and pageSize !=null">
      limit #{startNum},#{pageSize}
    </if>
  </select>