亚洲综合网在线,一本毛片,国产精品麻豆a在线播放

在使用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>