mybatis choose(when, otherwise)标签
<choose>
<when test="search_type==0">
and (a.is_new=1 or a.is_tese=1)
</when>
<otherwise>
and a.commodity_type_id = #{search_type}
</otherwise>
</choose>
<choose>
<when test="search_type==0">
and (a.is_new=1 or a.is_tese=1)
</when>
<otherwise>
and a.commodity_type_id = #{search_type}
</otherwise>
</choose>