isNotEmpty isNotNull

[size=medium]ibatis ： isNotEmpty：过滤空串""和空null

isNotNull: 只过滤空null

php ： isset:过滤null和未定义

isEmpty：过滤false、空串""、null

Exp
<select id="getWorkDutyDesp" parameterClass="java.util.Map" resultClass="java.util.HashMap">
SELECT LPM.WORK_TYPE "workType",
LPM.DESCRIPTION "description"
FROM L_PM_WORK_TYPE_TBL LPM
WHERE LPM.IS_VALID = 'Y'
[color=red]<!-- 判断Null和“”空字符串 -->[/color]
<isNotEmpty prepend="AND" property="workType">
LPM.WORK_TYPE=#workType#
</isNotEmpty>
[color=olive]<!-- 只判断null -->[/color]
<isNotNull prepend="AND" property="workType1">
LPM.WORK_TYPE=#workType1#
</isNotNull>
</select>[/size]