isNotNull(数据库字段) appliy(数据库字段 != '')
//mybatis xml in语句拼接 传参时map结构
<if test="map.goodsIdList!= null and map.goodsIdList.size()>0"> AND a.goods_id IN <foreach collection="map.goodsIdList" item="goods" index="index" open="(" close=")" separator=","> #{goods} </foreach> </if>