正确的写法:
<if test='finished=="1" and businessInfoId!=null and businessInfoId!="" '>
and u.finished = 1 and f.business_info_id = #{businessInfoId}
</if>
错误的写法:
<if test="finished=='1' and businessInfoId!=null and businessInfoId!='' ">
and u.finished = 1 and f.business_info_id = #{businessInfoId}
</if>
记住第一个单引号一定要到外面。
<if test='finished=="1" and businessInfoId!=null and businessInfoId!="" '>
and u.finished = 1 and f.business_info_id = #{businessInfoId}
</if>
错误的写法:
<if test="finished=='1' and businessInfoId!=null and businessInfoId!='' ">
and u.finished = 1 and f.business_info_id = #{businessInfoId}
</if>
记住第一个单引号一定要到外面。