daily 2017 8 10 mybatis动态sql之集合类型的test判断 - wtdig/study GitHub Wiki

select

*

from student

where status = 'NEW'

and is_deleted = 'n'

<if test="null != jobIds and jobIds.size > 0">

and id not in

<foreach collection="jobIds" open="(" close=")" separator="," item="ids">

#{ids,jdbcType=BIGINT}

</foreach>

</if>