Mybatis 常用SQL语句
- **条件判断
<isNotEmpty property="isValid">
<isEqual property="isValid" compareValue="Y" prepend="and">
and a.IS_VALID != 'N'
</isEqual>
<isEqual property="isValid" compareValue="N" prepend="and">
and a.IS_VALID = 'N'
</isEqual>
</isNotEmpty>