【mybatis】

1、mybatis中的if–else

<choose>
       <when test="null !=is_zj and ''!=is_zj">
          and a.is_zj = "1" 
       </when>
        <when test="null !=is_deal and ''!=is_deal">
          and a.is_deal = "1" 
       </when>
       <otherwise>
          and (a.is_zj = "1" or a.is_deal ="1")
       </otherwise>
     </choose>

2、mybatis中的if

<if test="null ==is_zj and ''==is_zj and null ==is_deal and ''==is_deal">
			and (a.is_zj = "1" or a.is_deal ="1")
		</if>
		<if test="null !=is_zj and ''!=is_zj and null ==is_deal and ''==is_deal">
			and a.is_zj = "1" 
		</if>
		<if test="null ==is_zj and ''==is_zj and null !=is_deal and ''!=is_deal">
			and a.is_deal = "1" 
		</if>

3、if else

<!-- 正确的，稳定，推荐使用 -->  
<if test="newsImage != null and newsImage == '1'.toString()">  
    <![CDATA[ and len(newsImage) > 0 ]]>  
</if>  

4、