<if test="bab214!=null and bab214 != '' ">
<if test="bab214== '1'.toString()">
<![CDATA[and a.bab214=#{bab214}]]>
</if>
<if test="bab214== '0'.toString()">
<![CDATA[and (a.bab214<>1 or a.bab214 is null)]]>
</if>
</if>
<if test="BRL001!=null and BRL001!='' ">
<![CDATA[and t.BRL001=#{BRL001}]]>
</if>
<if test="BRL002!=null and BRL002 != '' ">
<![CDATA[and t.BRL002 like '%'||#{BRL002}||'%']]>
</if>
最新
select id,bookName,author,publisher,donor,status,createDate,lastUpdate from book <where> <if test="bookName!=null"> bookName like CONCAT('%','${bookName}','%' ) </if> <if test="author!=null"> and author like CONCAT('%','${author}','%' ) </if>
