<isPropertyAvailable>?屬性是存在
<isNotPropertyAvailable>?屬性不存在
<isNull>?屬性值是null
<isEmpty>?判斷Collection.size<1或String.length()<1
<isEqual>?等于
<isNotEqual>?不等于
<isGreaterThan>?大于
<isGreaterEqual>?大于等于
<isLessThan>?小于
<isLessEqual>?小于等于、

?

?<select id="selectAllProducts" parameterClass="Product" resultMap="ProductResult">
???? select id,note from Product
???????<dynamic prepend="WHERE">
???????<!-- isNotNull判斷參數是否存在,Integer類型 -->
????????????<isNotNull property="id">
????????????????<!-- isGreaterThan判斷參數是否大于compareValue,isGreaterEquals是大于等于 -->
????????????????<isGreaterThan prepend=" and " property="id" compareValue="0">
???????????????? id = #id#
????????????????</isGreaterThan>
????????????</isNotNull>
????????????<!-- isNotEmpty判斷字串不為空,isEmpty可以判斷字串為空 -->
????????????<isNotEmpty prepend=" and " property="note">
????????????<!-- 模糊查詢不能用#,#在是用prepareStatement的?插入參數,$是文本替換 -->
???????????? note like '%$note$%'
????????????</isNotEmpty>
????????</dynamic>
??</select>
??
用Map傳參數
??
??<select id="selectAllProducts" parameterClass="java.util.HashMap" resultMap="ProductResult">
???? select id,note from Product
???????<dynamic prepend="WHERE">
???????<!-- isPropertyAvailable判斷屬性是否有效 -->
??????????<isPropertyAvailable property="id">
????????????<isNotNull property="id">
????????????????<!-- isLessThan判斷參數是否小于compareValue,isLessEquals是小于等于 -->
????????????????<isLessThan prepend=" and " property="id" compareValue="10">
???????????????? id = #id#
????????????????</isLessThan>
????????????</isNotNull>
??????????</isPropertyAvailable>
????????</dynamic>
??</select>

轉載于:https://www.cnblogs.com/liaomin416100569/archive/2010/03/04/9331950.html

總結

以上是生活随笔為你收集整理的ibatis常用的集中判断语句的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。