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

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

2020-07-18 13:53molashaonian Java教程

在使用Mybatis的时候，经常会有各种各样的参数传递，不同类型，不同个数的参数，下面小编通过例子给大家讲解下Mybatis多参数及实体对象传递，一起看看吧

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