Mybatis多参数及实体对象传递实例讲解

 public list<lifetouchrelease> findofficelist(@param("lifetouchrelease") lifetouchrelease lifetouchrelease,
      @param("advertisementid") string advertisementid, @param("officename") string officename,
      @param("isonline") integer isonline);
  <select id="findofficelist" resulttype="lifetouchrelease">
    select 
      <include refid="lifetouchreleasecolumns"/>
    from lifetouch_release a
    <include refid="lifetouchreleasejoins"/>
    <where>
      <if test="lifetouchrelease.typeidentification > 0">
        and a.type_identification = #{lifetouchrelease.typeidentification}
      </if>
      <if test="lifetouchrelease.category != null andlifetouchrelease.category.id != null and lifetouchrelease.category.id != ''">
        and a.release_type_id = #{lifetouchrelease.category.id}
      </if>
      and a.office_id is not null 
      and a.advertisement_id like '%${advertisementid}%' 
      and (select name from sys_office where id=a.office_id) like '%${officename}%'
      <if test="isonline != null">
        and a.del_flag = #{isonline}
      </if>
    </where>
    <choose>
      <when test="lifetouchrelease.page !=null andlifetouchrelease.page.orderby != null and lifetouchrelease.page.orderby != ''">
        order by ${lifetouchrelease.page.orderby}
      </when>
      <otherwise>
        order by a.update_date desc
      </otherwise>
    </choose>
  </select>