<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>