prepend:自动在前面加上;自动新手;自动预;自动前置
property:属性
compareValue:指定的常数,值
//判断不相等: <isNotEqual prepend=" and " property="name" compareValue="intnumber"> ===条件=== </isNotEqual> //判断相等: <isEqual prepend="and" property="name" compareValue="value"> ===条件=== < /isEqual> 或 <isEqual prepend="and" property="name" compareProperty="value"> ===条件=== < /isEqual> //判断是否为空或null: <isEmpty prepend="and" property="name"> ===条件=== </isEmpty> <isNull prepend="and" property="name"> ===条件=== </isNull> //判断不为空或不为null: <isNotEmpty prepend="and" property="name"> ===条件=== </isNotEmpty> <isNotNull prepend="and" property="name"> ===条件=== </isNotNull>
示例
注意:
在iBATIS中
isEmpty判断参数是否为Null或者空,满足其中一个条件则其true
isNotEmpty相反,当参数既不为Null也不为空是其为true
而:isNull、isNotNull,只判断是否为null
判断之后做相对应的表达式操作
灵活运用:
select * from gr_xx where 1=1 <isNotNull prepend="and" property="name"> bzhm=#name# </isNotNull> update gr_xx <isNotNull prepend="set" property="xm"> xm=#xm# </isNotNull> <isNotNull prepend="," property="bzhm"> bzhm=#bzhm# </isNotNull>
示例