- 判断List是否为空
<if test="null != staffCodeList and staffCodeList.size > 0">
and gui.USER_CODE not in
<foreach collection="staffCodeList" item="staffCode" open="(" separator="," close=")">
#{staffCode}
</foreach>
</if>
- 判断String类型的字段是否为空
<where>
<!-- 判断条件参数是否为空 -->
<if test="orgId != null and orgId != ''">
and user.org_id = #{orgId}
</if>
<!-- 判断条件参数是否为某值 -->
<if test="searchCon == 'cn'">
and opxuser.name like CONCAT(#{searchCon},'%')
</if>
</where>
where用于避免第一个条件为空的情况
3. 判断Long或者Integer类型的字段是否为空
<if test="number != null">
AND bs.number= #{number}
</if