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>