非空校验已是编码最基础的能力, 如果不判断直接取值各种类型错误防不胜防。
下面就罗列下数据库级别一般非空校验
<if test="whereMap.proId!=null and whereMap.proId.size>0">
and tg.id in
<foreach collection="whereMap.proId" item="pid" index="index" open="(" close=")" separator=",">
#{pid}
</foreach>
</if>
<if test="whereMap.userName!=nulll and whereMap.userName!=''">
and tu.name like concate("%",#{whereMap.userName},"%")
</if>