![ibatis 常用标签 ibatis 常用标签](https://image.shishitao.com:8440/aHR0cHM6Ly9ia3FzaW1nLmlrYWZhbi5jb20vdXBsb2FkL2NoYXRncHQtcy5wbmc%2FIQ%3D%3D.png?!?w=700&webp=1)
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>
示例